Fatal DB Error causing inability to move threads/forums
After installing vaultwiki i am now unable to move threads from forum to forum, regardless of whether the thread/forum is a part of the wiki. if i disable vaultwiki it works. when attempting to move threads i receive the following error
Code:
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT postid, thread.threadid, firstpostid
FROM post AS post
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
WHERE post.id IN (70);
MySQL Error : Unknown column 'post.id' in 'where clause'
Error Number : 1054
Request Date : Wednesday, August 26th 2009 @ 08:35:25 PM
Error Date : Wednesday, August 26th 2009 @ 08:35:25 PM
Script : http://majorcommand.com/boards/postings.php?do=domovethread&t=75
Referrer : http://majorcommand.com/boards/postings.php?t=75&pollid=
IP Address : 99.252.200.243
Username : Badorties
Classname : vB_Database_MySQLi
MySQL Version : 5.0.22
if it helps, i have vaultwiki as well as categories installed.
noticeably different is the calling script, this one being postings.php, whereas 797 references inlinemod.php. not sure if the fix action is correct however, as i cant locate the inlinemod_start plugin you reference
You're right. While the cause of the bug is the same, because it occurs on a different page the fix is going to be different. In AdminCP > Plugins & Products > Plugin Manager, locate the plugin for product "CES VaultWiki" at hook location "threadmanage_start", and click "Edit".
There were a number of plugins that were modified in 2.5.1 but that were never added to the package due to our server's sync issue described in the other thread. At this time, I'm not aware of any other locations that were changed that would now result in "fatal" errors.
this brought a new bug for me, the move actually works but throws another fatal error
Code:
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT bookid, threadid
FROM vault_book
WHERE top_bookid IN (75);
MySQL Error : Unknown column 'top_bookid' in 'where clause'
Error Number : 1054
Request Date : Thursday, August 27th 2009 @ 01:01:26 PM
Error Date : Thursday, August 27th 2009 @ 01:01:26 PM
Script : http://majorcommand.com/boards/postings.php?do=domovethread&t=75
Referrer : http://majorcommand.com/boards/postings.php?t=75&pollid=
IP Address : 67.172.167.177
Username : na641
Classname : vB_Database_MySQLi
MySQL Version : 5.0.22
I have checked and this column is added by both the install script and the upgrade script, so this seems almost impossible to me (unless the upgrade script didn't successfully run step 1 from 2.5.0 to 2.5.1).
You can add this field manually by running the following database query:
Code:
ALTER TABLE vault_book
ADD COLUMN top_bookid INT(10) UNSIGNED NOT NULL DEFAULT '0',
ADD INDEX top_bookid (top_bookid)
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.