Issue: Database error in naming category

Issue Tools
- View Changes

August 27, 2009 12:02 AM

tommythejoat tommythejoat is offline

Regular Member

Database error in naming category

Have not spoken to user looks like "-" may be bad character

Code:

Database error in vBulletin 3.8.4: 

Invalid SQL: 

                        UPDATE vault_category 
                        SET categoryid = 54010 
                        WHERE title_lower = 'floor+clocks'; 

MySQL Error   : Duplicate entry '54010-54151' for key 2 
Error Number  : 1062 
Request Date  : Wednesday, August 26th 2009 @ 09:49:54 PM 
Error Date    : Wednesday, August 26th 2009 @ 09:49:55 PM 
Script        : http://mb.nawcc.org/showwiki.php?title=Category:Long-case+clocks&do=edit 
Referrer      : http://mb.nawcc.org/showwiki.php?title=Category:Long-case+clocks&do=edit 
IP Address    : 58.6.130.220 
Username      : Richard Watkins 
Classname     : vB_Database 
MySQL Version :

Issue Details

Issue Number 801

Issue Type Bug

Project VaultWiki 3.x Series

Category Categories

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 2.5.1

Fixed Version 2.5.2

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 27, 2009 1:11 AM
pegasus

VaultWiki Team
Run the following database query:

Code:

ALTER TABLE vault_category DROP INDEX undupify
Reply

+ Reply

All times are GMT -4. The time now is 9:15 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 in naming category

Issue Tools