Error 1064 after deleting manufacturers

[Lizzy_b100]

Hi,

 

I was in the admin side deleting the default manufacturers that come with the installation. I was about 3 thirds through when I suddenly got this error

 

Manufacturers

 

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

 

select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from manufacturers order by manufacturers_name limit -20, 20

 

[TEP STOP]

 

 

Any advice please?

 

Thanks

Liz

[smithygotlost]

Before You Deleted Did You Take The Products Out That Could Be Using That Manufacturer ??

 

Mike

[smithygotlost]

Before You Deleted Did You Take The Products Out That Could Be Using That Manufacturer ??

 

Mike

[Lizzy_b100]

Hi Mike,

 

I dont think i did...

 

I deleted them afterwards.....

 

Liz

 

PS very new to this game!