Mysql upgrade prob

[beeonline]

Hi

Since my isp upgraded mysql up to version 4.1.11-standard I have various syntax issues with one new store.

 

Im running on mysql 3.23.55-nt localy on my desk top with no probs. All my other clients sites are running on a server with mysql version 4.0.24-standard with no problem also.

 

The syntax error messages im getting in admin are:

Specials 

 

Products Products Price Status Action 

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 '-10, 10' at line 1

 

select p.products_id, pd.products_name, p.products_price, s.specials_id, s.specials_new_products_price, s.specials_date_added, s.specials_last_modified, s.expires_date, s.date_status_change, s.status from products p, specials s, products_description pd where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = s.products_id order by pd.products_name limit -10, 10

 

Products Expected 

 

Products Date Expected Action 

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 '-10, 10' at line 1

 

select pd.products_id, pd.products_name, p.products_date_available from products_description pd, products p where p.products_id = pd.products_id and p.products_date_available != '' and pd.language_id = '1' order by p.products_date_available DESC limit -10, 10

 

[TEP STOP]

 

Reviews 

 

Products Rating Date Added Action 

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 '-10, 10' at line 1

 

 

Banner Manager 

 

Banners Groups Displays / Clicks Status Action 

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 '-10, 10' 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 -10, 10

 

[TEP STOP]

Newsletter Manager 

 

Newsletters Size Module Sent Status Action 

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 '-10, 10' at line 1

 

select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -10, 10

 

[TEP STOP]

 

Any help with this one please

Thanks Malc

[AlanR]

See: http://www.oscommerce.com/community/bugs,1605