"Specials" admin broken

[aspiringarts]

After I tried to delete my last Special, in preparation to add new ones for Valentine's Day, I got this weird error:

 

Specials

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 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 -20, 20

[TEP STOP]

 

This is really yucky, especially since I don't know SQL syntax or how to fix it. Can anyone please help me? It was working fine right until that point.

 

Thanks much,

Susan

[Rob123]

I'm not sure what caused your problem but a quick solution to your problem is to use phpmyadmin.

 

Run this to see if you have any specials

select * from specials;

 

Run this to delete all of your specials

delete from specials;

As with all advice, please backup first.

 

HTH,

Robert

[aspiringarts]

Robert, thank you. I followed your advice, but the error still remains. I had looked at the table to see if there were any records remaining in it previously, and it seemed they were all gone. The select command found nothing, so obviously deleting them did nothing too. Ah well! It was worth a try.

 

But I really do want to get the specials working ASAP for V-day. Are there any other suggestions? Files I could copy up here to look at? mySQL found nothing wrong in the database. Wish I knew more about this.

[Rob123]

It appears that your host recently upgraded the version of PHP.

 

This bug report looks suspiciously familiar...

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

 

HTH,

Robert

[aspiringarts]

It appears that your host recently upgraded the version of PHP.

 

This bug report looks suspiciously familiar...

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

 

HTH,

Robert

<{POST_SNAPBACK}>

 

Thanks so much, Robert. I'll try these fixes and get back to this thread about whether or not it worked. But it does look like the same thing. I was afraid it was something obscure and random like that.

 

Susan

[aspiringarts]

It worked! Woo hoo! Thanks so much, Robert!

 

Susan