Admin area ERRORS - V-URGENT

[Guest]

Hi Guys,

 

I have a seris or errors in admin

 

When I click on 'specials' I get -

 

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

 

Also when I try to configure taxes I get -

 

Tax Rates

 

Priority Tax Class Zone Tax Rate 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 '-4, 4' at line 1

 

select r.tax_rates_id, z.geo_zone_id, z.geo_zone_name, tc.tax_class_title, tc.tax_class_id, r.tax_priority, r.tax_rate, r.tax_description, r.date_added, r.last_modified from tax_class tc, tax_rates r left join geo_zones z on r.tax_zone_id = z.geo_zone_id where r.tax_class_id = tc.tax_class_id limit -4, 4

 

[TEP STOP]

 

 

What do I need to do to fix this? I need to finish for a deadline in 24hrs, please please help!

[dropdeadred]

Did you go check out the file and the line where the error is? Did you change that recently?

[Guest]

Did you go check out the file and the line where the error is? Did you change that recently?

 

NO, I wouldnt even know what to look for :blush:

[Guest]

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

fix at the end of the page

[Guest]

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

fix at the end of the page

 

 

Hi

 

Thanks enigma1, thats worked a treat!