xXDesertRoseXx Posted November 30, 2005 Share Posted November 30, 2005 The following is an error message I found when logging into the Admin Center - 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 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 Does anyone have any idea what I could be doing wrong or perhaps how to fix this problem? I would greatly appreciate any help. Rose The strong survive BUT the best succeed !! 1064 - You have an error in your SQL syntax Link to comment Share on other sites More sharing options...
benny1111 Posted December 12, 2005 Share Posted December 12, 2005 The following is an error message I found when logging into the Admin Center - 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 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 Does anyone have any idea what I could be doing wrong or perhaps how to fix this problem? I would greatly appreciate any help. Link to comment Share on other sites More sharing options...
benny1111 Posted December 12, 2005 Share Posted December 12, 2005 I have exactly the same error when accessing the newsletter function in admin, suspect it may be the mysql version running on my host (Dream host) I don't have a solution but hopefully some kind soul will assist Link to comment Share on other sites More sharing options...
xXDesertRoseXx Posted December 14, 2005 Author Share Posted December 14, 2005 I have exactly the same error when accessing the newsletter function in admin, suspect it may be the mysql version running on my host (Dream host)I don't have a solution but hopefully some kind soul will assist I found the solution to my problem follow the link on my signature Rose The strong survive BUT the best succeed !! 1064 - You have an error in your SQL syntax Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.