Issue: database error, new install

Issue Tools
- View Changes

April 14, 2009 6:48 AM

iMav

New Member

database error, new install

I create forums for all the namespaces, and then when I try to modify a related forum (for the "default" namespace") to be a "wiki", I get the following error:

Code:

Database error in vBulletin 3.8.2:

Invalid SQL:

		SELECT thread.threadid, thread.title, forum.forumid, thread.prefixid
			post.pagetext, post.userid, post.dateline
		FROM thread AS thread
		LEFT JOIN post AS post ON (thread.firstpostid = post.postid)
		LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
		WHERE thread.forumid IN (29)
		ORDER BY thread.dateline DESC;

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 '.pagetext, post.userid, post.dateline
		FROM thread AS thread
		LEFT JOIN post A' at line 2
Error Number  : 1064
Request Date  : Tuesday, April 14th 2009 @ 05:17:36 AM
Error Date    : Tuesday, April 14th 2009 @ 05:17:36 AM
Script        : http://geekhack.org/admincp/forum.php?do=update
Referrer      : http://geekhack.org/admincp/forum.php?do=edit&forumid=29
IP Address    : 63.97.176.127
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.4

Issue Details

Issue Number 501

Issue Type Bug

Project VaultWiki 3.x Series

Category Admin Panel

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 2.2.2

Fixed Version 2.2.2

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

April 14, 2009 12:25 PM

pegasus

VaultWiki Team

Thanks. You can fix this by editing vault/special_plugins_data.php. Find:

PHP Code:

SELECT thread.threadid, thread.title, forum.forumid, thread.prefixid

Replace with:

PHP Code:

SELECT thread.threadid, thread.title, forum.forumid, thread.prefixid,

Fixed in the current ZIP.

Reply

April 15, 2009 1:52 AM

iMav

New Member

Awesome, that fixed the issue.

However, now I get the following when kicking back and forth between the main article and discussion tabs:

Code:

Database error in vBulletin 3.8.2:

Invalid SQL:
;

MySQL Error   : Query was empty
Error Number  : 1065
Request Date  : Wednesday, April 15th 2009 @ 12:50:14 AM
Error Date    : Wednesday, April 15th 2009 @ 12:50:14 AM
Script        : http://geekhack.org/showwiki.php?t=5658&do=talk
Referrer      : http://geekhack.org/showwiki.php?t=5658
IP Address    : 63.97.176.127
Username      : iMav
Classname     : vB_Database
MySQL Version : 5.0.51a-3ubuntu5.4

This is emailed to me. The end user is presented with a 404 error.

April 15, 2009 11:03 AM

pegasus

VaultWiki Team

Please see this issue for the solution: http://www.crackedeggstudios.com/pro...hp?issueid=500

Reply

+ Reply

All times are GMT -4. The time now is 5:40 PM.

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.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: database error, new install

Issue Tools