[Edit: FIXED, see post #7 below]
I've upgraded from 4.10 to 4.11, and I get an error when showing or attempting to edit any of my CMS posts.
However, if I cut and paste the above query (in bold) into phpMyAdmin, it returns a table with the post comments as expected.
CMS posts with comments disabled are fine.
Forum posts are fine.
So my site is partially broken, but just the CMS. I don't want to roll back as the forums have been active, and the CMS does not get a lot of traffic, so any suggestions would be appreciated.
I've upgraded from 4.10 to 4.11, and I get an error when showing or attempting to edit any of my CMS posts.
Database error in vBulletin 4.1.11:
Invalid SQL:
SELECT post.postid, post.visible, post.dateline FROM vbmb_post AS post
INNER JOIN vbmb_cms_nodeinfo AS info ON info.associatedthreadid = post.threadid
AND post.dateline > info.creationdate WHERE info.nodeid=129 AND post.parentid != 0 AND post.visible = 1
ORDER BY post.dateline ASC;
/**get_comments- vbcms**/;
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 ';
/**get_comments- vbcms**/' at line 4
Error Number : 1064
Request Date : Wednesday, February 29th 2012 @ 09:55:21 PM
Error Date : Wednesday, February 29th 2012 @ 09:55:21 PM
Script : http://metabunk.org/content/129/edit
Referrer : http://metabunk.org/admincp/cms_cont...in.php?do=list
IP Address :
Username : Mick
Classname : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.8
Invalid SQL:
SELECT post.postid, post.visible, post.dateline FROM vbmb_post AS post
INNER JOIN vbmb_cms_nodeinfo AS info ON info.associatedthreadid = post.threadid
AND post.dateline > info.creationdate WHERE info.nodeid=129 AND post.parentid != 0 AND post.visible = 1
ORDER BY post.dateline ASC;
/**get_comments- vbcms**/;
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 ';
/**get_comments- vbcms**/' at line 4
Error Number : 1064
Request Date : Wednesday, February 29th 2012 @ 09:55:21 PM
Error Date : Wednesday, February 29th 2012 @ 09:55:21 PM
Script : http://metabunk.org/content/129/edit
Referrer : http://metabunk.org/admincp/cms_cont...in.php?do=list
IP Address :
Username : Mick
Classname : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.8
CMS posts with comments disabled are fine.
Forum posts are fine.
So my site is partially broken, but just the CMS. I don't want to roll back as the forums have been active, and the CMS does not get a lot of traffic, so any suggestions would be appreciated.
Server Type | Linux | Users to Moderate | 0 [View] |
Web Server | Apache v2.2.8 | Threads to Moderate | 0 [View] |
PHP | 5.2.4-2ubuntu5.17 | Posts to Moderate | 0 [View] |
PHP Max Post Size | 8.00 MB | Attachments to Moderate | 0 [View] |
PHP Maximum Upload Size | 16.00 MB | Events to Moderate | 0 [View] |
PHP Memory Limit | 64.00 MB | ||
MySQL Version | 5.0.51a-3ubuntu5.8 | ||
MySQL Packet Size | 16.00 MB |
Comment