SQL errors :-(

[Guest]

:'( Please help...

 

My installation is doing something like this to 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 '-10, 10' at line 1

select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -10, 10

 

 

I used installation from TemplateMonster. Do you have any idea, what's wrong?

 

:(

[ComicWisdom]

:'( Please help...

 

My installation is doing something like this to 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 '-10, 10' at line 1

select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc limit -10, 10

I used installation from TemplateMonster. Do you have any idea, what's wrong?

 

:(

 

 

This is caused by a bug in osCommerce. I've come across a couple of posts refering to line "limit -10, 10" but can't find the correct one now.

 

Try this, if it doesn't work try some searches. Otherwise come back, I know there are a few people here who will be able to put their finger right on it.

 

http://www.oscommerce.com/forums/index.php?sho...mp;#entry697026