1064 - You have an error in your SQL syntax

[Mr Penguin]

Hi there!

 

This is an AWESOME shopping cart... I am so thankful to have found it!! I have ran into one bug though, and I'm hoping somebody here can give me an idea of what went wrong.

 

I was deleting the default manufacturers, and all of a sudden, about 2/3rds through the list of manufacturers... I get this error...

 

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]

 

Everything else is working just fine, and it was installed smoothly via my hosting company's nice little manager / control interface.

 

Any help would be greatly appreciated! :thumbsup:

 

Thank you!!

 

Robert

[Mr Penguin]

Hi there!

 

This is an AWESOME shopping cart... I am so thankful to have found it!! I have ran into one bug though, and I'm hoping somebody here can give me an idea of what went wrong.

 

I was deleting the default manufacturers, and all of a sudden, about 2/3rds through the list of manufacturers... I get this error...

Everything else is working just fine, and it was installed smoothly via my hosting company's nice little manager / control interface.

 

Any help would be greatly appreciated! :thumbsup:

 

Thank you!!

 

Robert

 

Guys, I think I figured it out... I reinstalled the cart, and tried it again, and I paid a little closer attention this time... the coding faults out when you delete the last manufacturer... you have to leave at LEAST one manufacturer or else it locks up.

 

Could this be a bug? o:)

[Mr Penguin]

Ahhh, the same is true with Reviews as well... and I didn't even delete any reviews on purpose, I was only deleting the manufacturers (leaving the last one this time), and it happened to remove the only product that had a review, and uh... now I got the same error with the reviews system... it is telling me...

 

 

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 reviews_id, products_id, date_added, last_modified, reviews_rating from reviews order by date_added DESC limit -20, 20

[Guest]

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

 

fix at the end of the page

[joelm]

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

 

fix at the end of the page

 

 

Eheh... Thank you... this solved my life :)

[Mr Penguin]

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

 

fix at the end of the page

 

Bingo! It worked! Thank you!!!!!!!! B)