1406 Data too long for column "last_page_url" at row 1

[time4fishing]

I am using Paypal Website Standard and it is working great until the transaction is complete and I hit the return to site button. Then I get 1406 error. I' on Zen Cart 1.3.7. I'm no expert. Any ideas? TIA.

My site is www.Time4fishing.com/store...

[DrByte]

That issue was fixed in v1.3.8. It'd be worth upgrading to 1.3.8a at some point.

In the meantime, you can work around it by running this SQL update in the Admin->Tools->Install SQL Patch tool:

alter table whos_online drop index idx_last_page_url_zen;
alter table whos_online change last_page_url   last_page_url text NOT NULL;

[time4fishing]

Thanks very much, it worked great...