Issue: Database error on new install

Issue Tools
- View Changes

October 31, 2009 4:56 PM

Hostboard

Junior Member

Database error on new install

Just upgraded one site and no problems. Purchase a new premium subscription for another site went to install and boom...

Code:

Database error in vBulletin 3.8.4:

Invalid SQL:

	ALTER TABLE mmvault_category
	DROP INDEX title,
	ADD INDEX categoryid (categoryid);

MySQL Error   : Duplicate key name 'categoryid'
Error Number  : 1061
Request Date  : Saturday, October 31st 2009 @ 01:53:23 PM
Error Date    : Saturday, October 31st 2009 @ 01:53:23 PM
Script        : http://www.MyDomain.org/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.MyDomain.org/forums/admincp/plugin.php?do=productadd
IP Address    : 75.60.109.195
Username      : MyUSerID
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.33-community-log

Issue Details

Issue Number 925

Issue Type Bug

Project VaultWiki 3.x Series

Category Categories

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 2.5.6

Fixed Version 2.5.7

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)

November 1, 2009 1:11 AM

pegasus

VaultWiki Team

Thanks. The installer is supposed to ignore the error if it occurs. You should be able to download the latest version again and re-import.

Reply

This petition for a change to Awaiting Feedback was accepted

November 1, 2009 12:41 PM

Hostboard

Junior Member

Nope downloaded: ces_spec_cat_2-0-3.zip at 12:39pm EST 11.01.09

Uploaded all the files, imported the XML and boom it went again

Code:

Database error in vBulletin 3.8.4:

Invalid SQL:

	ALTER TABLE mmvault_category
	ADD COLUMN title_lower VARCHAR(255) NOT NULL DEFAULT '',
	DROP INDEX undupify,
	ADD INDEX title_lower (title_lower);

MySQL Error   : Can't DROP 'undupify'; check that column/key exists
Error Number  : 1091
Request Date  : Sunday, November 1st 2009 @ 09:38:17 AM
Error Date    : Sunday, November 1st 2009 @ 09:38:17 AM
Script        : http://www.MyDomain.org/forums/admincp/plugin.php?do=productimport
Referrer      : http://www.MyDomain.org/forums/admincp/plugin.php?do=productadd
IP Address    : 75.60.109.195
Username      : MyID
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.33-community-log

November 1, 2009 12:56 PM

pegasus

VaultWiki Team

Looks like there was hardly any error suppression on anything... so I've added it.

Download again. All you should have to do is import the XML.

Reply
This petition for a change to Fixed was accepted
November 1, 2009 1:15 PM

Hostboard

Junior Member

That did the trick.

Thank you!

+ Reply

All times are GMT -4. The time now is 8:37 AM.

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 on new install

Issue Tools