Forums / General Questions / who's online error (bug?)

who's online error (bug?)

Locked

Views: 859

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
29 Mar 2007, 11:01 PM
#1
mikeyg avatar

mikeyg

Totally Zenned

Join Date:
May 2005
Posts:
515
Plugin Contributions:
0

who's online error (bug?)

I am getting this error message when coming back from my payment gateway:

1406 Data too long for column 'last_page_url' at row 1
in:
[insert into fmwhos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url, host_address, user_agent)

I have tried to change the field to text in the MYSQL database but it will not let me. I get error 1170

Is this a bug and is there a fix?

Thanks

MG

30 Mar 2007, 12:09 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: who's online error (bug?)

You cannot change it to TEXT as there is an index on the field ...

You can try removing the index for the last_page_url then try a TEXT field type to see what is triggering this error ...

Any idea what the URL is that is being attempted to be added to the whos_online table that is so long?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!