Results 1 to 2 of 2
  1. #1
    Join Date
    May 2005
    Posts
    532
    Plugin Contributions
    0

    Default 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

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default 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: v1.5.5]
    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!

 

 

Similar Threads

  1. Replies: 3
    Last Post: 17 Jul 2012, 07:15 AM
  2. [Not a bug] Who's Online problem?
    By jrafuse in forum Bug Reports
    Replies: 1
    Last Post: 30 Mar 2008, 01:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR