Last_Page_URL (whos_online) Can't view products

[Twister]

Something is wrong here that prevents products from being viewed when clickek on from the main page.
Any clues? The column length is 64 and the data is less than 1/2 that length.


1406 - Data too long for column 'last_page_url' at row 6

update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '127.0.0.1', time_last_click = '1176979252', last_page_url = '/catalog/product_info.php?products_id=1&osCsid=c8pnl3pkk3gs 1jrvsp1t0k9v97' where session_id = 'c8pnl3pkk3gs1jrvsp1t0k9v97'

[TEP STOP]

when the qry is inserted into mySQL it sees the URL as a continous string:

SQL query:
UPDATE whos_online SET customer_id = '0',
full_name = 'Guest',
ip_address = '127.0.0.1',
time_last_click = '1176979252',
last_page_url = '/catalog/product_info.php?products_id=1&osCsid=c8pnl3pkk3gs 1jrvsp1t0k9v97' WHERE session_id = 'c8pnl3pkk3gs1jrvsp1t0k9v97'
MySQL said:
#1406 - Data too long for column 'last_page_url' at row 6

[michael_s]

How about some debug info... mysql version?

This is a mysql issue, not and osCMax issue. Just google the error for more info.

Here are some fixes:
osCommerce: Bug Reports)

[alfapaulo]

Open your PHPMyadmin.

Choose your database (tipically not "information schema", not "mysql" and not "test").

Choose your table whos_online from the left side.
Choose your field in the middle of the screen last_page_url (place a Tick in the box in front).
Choose the Pencil (to edit) and change the varchar(64) to varchar(256).

Hit Save and you should be done!