Database corupt?

[chalkie]

On a new install I deleted all the samples and started anew. I deleted all the sample manufacturers and now I've got an error -

 

 

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

 

Do I need to start with a new sample database or can this be fixed?

[Simplyeasier]

On a new install I deleted all the samples and started anew. I deleted all the sample manufacturers and now I've got an error -

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 

 

Do I need to start with a new sample database or can this be fixed?

<{POST_SNAPBACK}>

 

Not a corruption - rather a code problem

 

read this for a solution

 

http://www.oscommerce.com/forums/index.php?showtopic=144095

 

Charles

[chalkie]

wow! Brilliant. Thank you very much. I've been tearing my hair out over that one.

Thanks Charles