Mysql errors with 4.1.11

[DVBHardware]

On my local test machine I have Mysql 4.0.21 with no OSC errors, On my live server, which must have been upgraded recently to 4.1.11.

 

I know get an error in the banner manager

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1

 

select banners_id, banners_title, banners_image, banners_group, status, expires_date, expires_impressions, date_status_change, date_scheduled, date_added from banners order by banners_title, banners_group limit -20, 20

 

[TEP STOP]

 

The only thing I see different is the new Collation (latin1_swedish_ci)

 

Anybody have any direction for me, I also get a simmilar error in the Return systems Mod.

 

Jimmy

[karmapool]

I had the same problem,

 

to fix it I just got rid of the Collation feild. i think the phpmyadmin version or mysql version was automatically adding it. I had to mess around with the options in the phpmyadmin when i was makeing a copy of my database.

 

hope this helps

 

Billy Z

[DVBHardware]

I had the same problem,

 

to fix it I just got rid of the Collation feild. i think the phpmyadmin version or mysql version was automatically adding it. I had to mess around with the options in the phpmyadmin when i was makeing a copy of my database.

 

hope this helps

 

Billy Z

<{POST_SNAPBACK}>

 

I was going to try that on my local machine but I could not figure out how to delete it.

can you point me to the delete it

 

Thanks

[♥yesudo]

http://blogs.oscommerce.com/yesudo/index.p...owentry&eid=306

[DVBHardware]

Thank you , perfect!!!