Removed all Manufacturers now get an 1064 error

[sentinal_pda]

HI there, i am new to this oscommerce site config, i have been going throught the site getting to know it.

 

I came to add some of my own items so i started to remove all sample data through the admin site.

 

I removed all the Manufacturers so i could add my own and i now get this error

 

Manufacturers

 

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 most greatfull, i have no experiance with mySql or PHP!

 

Thanks

[Guest]

HI there, i am new to this oscommerce site config, i have been going throught the site getting to know it.

 

I came to add some of my own items so i started to remove all sample data through the admin site.

 

I removed all the Manufacturers so i could add my own and i now get this error

 

Manufacturers 

 

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 most greatfull, i have no experiance with mySql or PHP!

 

Thanks

<{POST_SNAPBACK}>

 

 

well you didnt say when and where you get that error but basically that query is crapping out because you have no manufacturers. can you add a manufacturer and see if it goes away?

 

also, i assume you just deleted the manufacturers records and not the fields or tables? :huh:

[sentinal_pda]

well you didnt say when and where you get that error but basically that query is crapping out because you have no manufacturers. can you add a manufacturer and see if it goes away?

 

also, i assume you just deleted the manufacturers records and not the fields or tables?? :huh:

<{POST_SNAPBACK}>

 

 

Hi, thanks for your quick repsonse. I get the error in the admin site, when i click on "Catalog" then "Manufacturers", i deleted sample data throught the admin site not thorugh mySql. the menu does not appear to allow me to add any new Manufacturers!

 

Thanks

 

Sentinal

[Guest]

Hi, thanks for your quick repsonse. I get the error in the admin site, when i click on "Catalog" then "Manufacturers", i deleted sample data throught the admin site not thorugh mySql. the menu does not appear to allow me to add any new Manufacturers!

 

Thanks

 

Sentinal

<{POST_SNAPBACK}>

 

is the manuf. table still there if you check with phpmyadmin?

[sentinal_pda]

is the manuf. table still there if you check with phpmyadmin?

<{POST_SNAPBACK}>

 

Just downloaded phpmyadmin, yeah the table is still there, when i browse the table it is blank!

[♥Vger]

Go to phpMyAdmin for your website and import the oscommerce.sql file again (comes with the installation files). Then, before you delete all Manufacturers add some of your own. Then you should be able to go ahead and delete the demo ones.

 

Vger

[sentinal_pda]

Go to phpMyAdmin for your website and import the oscommerce.sql file again (comes with the installation files).  Then, before you delete all Manufacturers add some of your own.  Then you should be able to go ahead and delete the demo ones.

 

Vger

<{POST_SNAPBACK}>

 

 

Hi thanks for your help people!

 

after seeing phpmyadmin, lookin around it i found that you can insert rows to tables so i inserted a row in to the manufa... table and refreshed the page in the admin site, and the error has disapeared.

 

...would this be a simple fix to stop the error apreaing???

[Guest]

Just downloaded phpmyadmin, yeah the table is still there, when i browse the table it is blank!

<{POST_SNAPBACK}>

 

blank as in no fields or no data or both?

 

you will need to reload that table. not a big deal.