1064 - You have an error in your SQL syntax;

[Guest]

Hi, I have this problem

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

 

followed by

 

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

 

[TEP STOP]

 

I am running on MySQL 4.1.13a

 

Heeellp! :'( :'(

[jenso]

Hi, I have this problem

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

 

followed by

 

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

 

[TEP STOP]

 

I am running on MySQL 4.1.13a

 

Heeellp! :'( :'(

 

I guess you made some kind of change to the file.

Look closely at the changes you made.

Most likely you have missed some kind of ; or so at the end of the line.

[Jack_mcs]

Hi, I have this problem

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

 

followed by

 

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

 

[TEP STOP]

 

I am running on MySQL 4.1.13a

 

Heeellp! :'( :'(

Go to the above menu, Community->Downloads, adn download the latest update of oscommerce. Either install all of the patches (recommended) or just the one that applies to this problem.

 

Jack

[Guest]

thanks It´s works.. :)

[Guest]

thanks It´work´s :)