Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Deleted all Manufacturers now I cannot Add any New Ones


Guest

Recommended Posts

I deleted all of the manufacturers and now I cannot add any new ones in Admin. I get the following error messages in Admin:

 

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 help would be greatly appreciated:)

 

Thanks,

Tom

Link to comment
Share on other sites

Try following the patches link in my signature block and seach for "limit -20, 20"

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...