Issue: Wanted Category DB error

Issue Tools
- View Changes

July 29, 2009 9:28 AM

mickknutson mickknutson is offline

Regular Member

Wanted Category DB error

I clicked on:

http://www.blincmagazine.com/forum/w...ntedcategories

and got:

Code:

Database error in vBulletin 3.8.2:

Invalid SQL:

		SELECT COUNT(DISTINCT(title_lower)) AS rowcount
		FROM vault_link AS link
		LEFT JOIN vault_protect AS protect ON (link.title_lower = protect.title_lower AND link.namespace = protect.namespaceid AND protect.options = 4)
		WHERE namespace = 6
			AND link.targetid = 0
			AND templateusage = 1
			AND protectid IS NULL;

MySQL Error   : Column 'title_lower' in field list is ambiguous
Error Number  : 1052
Request Date  : Wednesday, July 29th 2009 @ 06:27:24 AM
Error Date    : Wednesday, July 29th 2009 @ 06:27:24 AM
Script        : http://www.blincmagazine.com/forum/wiki/Special:Wantedcategories
Referrer      : http://www.blincmagazine.com/forum/wiki/Special:Specialpages
IP Address    : 198.140.4.205
Username      : mknutson
Classname     : vB_Database
MySQL Version : 5.0.45

Issue Details

Issue Number 740

Issue Type Bug

Project VaultWiki 3.x Series

Category Categories

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 2.5.0

Fixed Version 2.5.1

Milestone VaultWiki 3.0.0

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

August 18, 2009 6:08 AM

Jella

Regular Member

Thanks for fixing this.

I don't know what a TRUNCATE command or any command is and never run anything in the database, don't know how to... I don't think the database crashed, only the issues after the Wiki upgrade which seem to be all fixed now.

I received the SPECIALS error emails with that problem...

could this have caused it?

Code:

Invalid SQL:

               SELECT COUNT(DISTINCT(title_lower)) AS rowcount
               FROM vault_link AS link
               LEFT JOIN vault_protect AS protect ON (link.title_lower = protect.title_lower AND link.namespace = protect.namespaceid AND protect.options = 4)
               WHERE namespace = 6
                       AND link.targetid = 0
                       AND templateusage = 0
                       AND protect.protectid IS NULL;

MySQL Error   : Column 'title_lower' in field list is ambiguous
Error Number  : 1052
Request Date  : Thursday, August 13th 2009 @ 07:24:08 PM
Error Date    : Thursday, August 13th 2009 @ 07:24:09 PM
Script        : http://tvlampforum.com/showwiki.php?lampwiki=Special:Wantedpages
Referrer      : http://tvlampforum.com/showwiki.php?lampwiki=Special:Specialpages
IP Address    : 98.229.127.230
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.81-community

August 19, 2009 4:37 AM

pegasus

VaultWiki Team

This error would not have caused the type of data loss you incurred. I can't see any way this would happen on that scale. Hopefully, this was an isolated incident, perhaps relating to your recent vBulletin upgrade issues.

Time will tell.

Reply
August 19, 2009 8:54 AM

Jella

Regular Member

Thank you again. I will not update the Forbidden Jiki, I'd have a heart attack. There must be close to 1000 wikis' and books with 70 or more chapters... I can't handle any issues as you know.

Is it safe (I mean my site won't crash) staying with 2.3 patch level 1 wiki. It operates fine.

I will not be updating my sites to vbulletin 4 even though I will keep up my supscriptions... unless I have a database corrution that will force me to do it, I have too many hacks running that would need upgrading if in fact the coders upgrade them. I know the major ones will like vbexperience etc...

Reply
August 19, 2009 4:52 PM

pegasus

VaultWiki Team

It is safe to stay with 2.3. That said, we are no longer developing that branch, and you will miss out on any new features or bug fixes. If it works for you, and you can deal without the new features, stick with 2.3.

Even if you didn't usually have issues upgrading, I would highly recommend doing frequent database backups. This way you're not stuck with lost data should you decide to finally upgrade and there is a problem.

Reply

+ Reply

All times are GMT -4. The time now is 5:52 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: Wanted Category DB error

Issue Tools