Hello, I recently upgraded to MySQL 5.1.63 and now I am having the following problem when I try to create a new thread:
MySQL Error : 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 'ORDER BY a.contentid, a.displayorder' at line 19
Error Number : 1064
Request Date : Saturday, September 8th 2012 @ 02:19:00 PM
Error Date : Saturday, September 8th 2012 @ 02:19:00 PM
Script : http://www.deguate.com/foros/newthre...=newthread&f=2
Referrer : http://www.deguate.com/foros/forumdi...Amor-y-Amistad
IP Address : 190.148.182.193
Username : admin
Classname : vB_Database
MySQL Version : 5.1.63-cll
And when I try to access an existing thread:
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 'AND whoread.dateline > 1313267986' at line 9
Error Number : 1064
Request Date : Saturday, September 8th 2012 @ 02:17:55 PM
Error Date : Saturday, September 8th 2012 @ 02:17:55 PM
Script : http://www.deguate.com/foros/showthr...8sexualidad%29
Referrer : http://www.deguate.com/foros/forumdi...?31-Sexualidad
IP Address : 190.148.182.193
I already tried the Repair/Optimize tool in the admin but nothing changed. Can someone please tell me how to correct this issue.
Thank you.
MySQL Error : 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 'ORDER BY a.contentid, a.displayorder' at line 19
Error Number : 1064
Request Date : Saturday, September 8th 2012 @ 02:19:00 PM
Error Date : Saturday, September 8th 2012 @ 02:19:00 PM
Script : http://www.deguate.com/foros/newthre...=newthread&f=2
Referrer : http://www.deguate.com/foros/forumdi...Amor-y-Amistad
IP Address : 190.148.182.193
Username : admin
Classname : vB_Database
MySQL Version : 5.1.63-cll
And when I try to access an existing thread:
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 'AND whoread.dateline > 1313267986' at line 9
Error Number : 1064
Request Date : Saturday, September 8th 2012 @ 02:17:55 PM
Error Date : Saturday, September 8th 2012 @ 02:17:55 PM
Script : http://www.deguate.com/foros/showthr...8sexualidad%29
Referrer : http://www.deguate.com/foros/forumdi...?31-Sexualidad
IP Address : 190.148.182.193
I already tried the Repair/Optimize tool in the admin but nothing changed. Can someone please tell me how to correct this issue.
Thank you.
Comment