MySQL Error with Convert Legacy Code to BB-Code for Mediawiki
After initiating the option to Convert Legacy Code to BB-Code for Mediawiki and setting the limit to 50, I get the following SQL error:
Code:
Database error in vBulletin 3.7.6:
Invalid SQL:
SELECT post.postid, post.pagetext, thread.forumid, thread.title,
thread.firstpostid, thread.threadid,
post.userid, user.usergroupid, user.membergroupids
FROM vb3_thread AS thread
LEFT JOIN vb3_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb3_user AS user ON (post.userid = user.userid)
WHERE thread.threadid IN ()
GROUP BY thread.threadid
ORDER BY post.postid DESC
LIMIT 50,50;
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 ')
GROUP BY thread.threadid
ORDER BY post.postid DESC
LIMIT 50,50' at line 7
Error Number : 1064
Request Date : Thursday, April 9th 2009 @ 11:18:28 AM
Error Date : Thursday, April 9th 2009 @ 11:18:29 AM
Script : hxxp://www.mysite.com/forum/admincp/vaultwiki.php?do=convert&startat=50&pp=50
Referrer : hxxp://www.mysite.com/forum/admincp/vaultwiki.php?do=convert
IP Address : ????????
Username : ???????
Classname : vB_Database
MySQL Version : 5.0.67-community
According to my understanding, the MySQL error would only occur when it has reached the end of all articles that need processing. Fixed for the next build.
As for the ", this is a problem where HTML is disabled in the converted article's forum, yet it was at least partially enabled in MediaWiki. Since it does not actually parse the article, the " is left behind and becomes fair game for htmlspecialchars_uni().
To fix this, in vault/special_class_bbcode.php, find:
PHP Code:
if (!$do_html AND !$vault->parser['fake_tag_list'])
Replace with:
PHP Code:
if (!$do_html AND !$vault->parser['fake_tag_list'] AND !$vault->parser['converted_text'])
Getting this error with Legacy Codes enabled after running the Convert Tool:
Code:
Warning: vB_WikiCodeParser::require_once([path]/vault/special_legacy_1.php) [vb-wikicodeparser.require-once]: failed to open stream: No such file or directory in [path]/vault/special_class_bbcode.php on line 455
Fatal error: vB_WikiCodeParser::require_once() [function.require]: Failed opening required '/home/mysite/public_html/forum/vault/special_legacy_1.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mysite/public_html/forum/vault/special_class_bbcode.php on line 455
To add to that, the Settings, after the above is set, show all three options, Disabled, Nuwiki, Mediawiki all are not selected, not sure how it's possible, but none are.
This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.