Issue: Rebuilt namspace encountered error message

Issue Tools
- View Changes

November 25, 2009 12:37 PM

stev

Regular Member

Rebuilt namspace encountered error message

What causes this and how do I fix it?

THANKS

Code:

Database error in vBulletin 3.8.4:

Invalid SQL:

					UPDATE vault_protect
					SET title_lower = CASE protectid
						
WHEN  THEN 'ti_u_s_ti_u_thu'
					END
					WHERE protectid IN ();

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 'THEN 'ti_u_s_ti_u_thu'
					END
					WHERE protectid IN ()' at line 4
Error Number  : 1064
Request Date  : Wednesday, November 25th 2009 @ 11:33:44 AM
Error Date    : Wednesday, November 25th 2009 @ 11:33:44 AM
Script        : forum/admincp/vaultwiki_namespace.php?do=rebuild&namespaceid=6
Referrer      : forum/admincp/vaultwiki_namespace.php?do=modify
Classname     : vB_Database
MySQL Version : 5.0.85-community-log

Issue Details

Issue Number 960

Issue Type Bug

Project VaultWiki 3.x Series

Category Admin Panel

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 2.5.7

Fixed Version 2.5.7

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

November 25, 2009 3:09 PM
pegasus

VaultWiki Team
Fixed in the current ZIP. This occurs if none of the pages in the namespace are "protected".

In admincp/vaultwiki_namespace.php, find:

Code:

if ($thread['protectid'])

Replace with:

Code:

if (!$thread['protectid'])
Reply
November 25, 2009 4:09 PM

stev

Regular Member

So by downloading new version and install new zip (overriding the old one), I also could fix this?

Reply
November 26, 2009 2:01 AM

pegasus

VaultWiki Team

You just have to overwrite the file mentioned above, or make the edit mentioned above.

Reply

+ Reply

All times are GMT -4. The time now is 5:32 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: Rebuilt namspace encountered error message

Issue Tools