Issue: Installation: database errors

Issue Tools
- View Changes

May 15, 2010 11:16 PM

russbo

New Member

Installation: database errors

no "drop if exist" mysql tables on install

I'm in a bit of a conundrum here, my install hangs at second step, because there was a database listing already present. Now I'm in an install loop, where every time I try to run the install over, I have to search through the database to remove all vestiges of the previous attempts, otherwise it hangs at step two.

I cannot uninstall the product to clear out all database mentions of vault wiki, as it is not fully installed.

I do not know exactly where all of the vault wiki tables are. I'm surprised that you don't have a drop table option if exists on your install package.

Are there any mysql commands that I can use to purge the database of ALL of the vault wiki tables, so that I can do a clean, uninterrupted install??? I did not have vault wiki installed before, not sure why it hung up on step two, but it did. and now I can't find all the mentions of vault wiki in the database, other than:

Altering usergroup table
# Altering forum table
# Altering forumpermission table
# Altering poll table
# Altering post table
# Altering bbcode table
Altering session table

Any help would be greatly appreciated. I'm really looking forward to getting this installed on my forums.

rich

Issue Details

Issue Number 1569

Issue Type Bug

Project VaultWiki 3.x Series

Category Install / Upgrade

Status Fixed

Priority 4 - Warnings / Script Errors

Affected Version 3.0.0 RC 3

Fixed Version 3.0.0

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)

May 15, 2010 11:54 PM
pegasus

VaultWiki Team
It doesn't look like you missed anything. Step 1 uses CREATE TABLE IF NOT EXISTS. There is no such thing as ADD COLUMN/INDEX IF NOT EXISTS, which tends to cause the most problems. If your thread table already has an index on the firstpostid column, this might be causing the problem. In that case, open your vault/install/mysql-alter.php file and delete:

Code:

###### THREAD ###### vw_alter_table('thread', " " . (!VAULT_40X_COMPAT ? "ADD COLUMN vault_description VARCHAR(200) NOT NULL DEFAULT ''," : "") . " ADD INDEX firstpostid (firstpostid) ");

For the future, should you ever run into something like this again: when the install hangs at any step, you should not have to start the whole process over, just undo enough to get back to the beginning of the current step.
Reply

May 16, 2010 12:16 AM

russbo

New Member

Code:

Database error in vBulletin 4.0.3:

Invalid SQL:

			ALTER TABLE usergroup
			
	ADD COLUMN specialpage_permissions INT(3) NOT NULL DEFAULT '0',
	ADD COLUMN vault_misc INT(1) UNSIGNED NOT NULL DEFAULT '0',
	ADD COLUMN vault_permissions INT(11) UNSIGNED NOT NULL DEFAULT '0';

MySQL Error   : Duplicate column name 'specialpage_permissions'
Error Number  : 1060
Request Date  : Sunday, May 16th 2010 @ 12:14:47 AM
Error Date    : Sunday, May 16th 2010 @ 12:14:47 AM
Script        : http://forum.russbo.com/vault/install/install.php?step=2
Referrer      : http://forum.russbo.com/vault/install/install.php?step=1
IP Address    : 69.34.98.147
Username      : doc
Classname     : vB_Database
MySQL Version : 4.1.22-standard

Thanks.

I guess I need to take out those tables again, from previous attempts. I think it was the firstpostid thing in Thread that was causing the most problem.

Any simple way of taking out all the databases so I can start fresh?

May 16, 2010 12:34 AM

pegasus

VaultWiki Team

I am looking into rewriting the ALTER portions of the installer/upgrader to check against the tables. It should suppress the most common errors, and will probably be implemented in the Gold release.

Reply
May 16, 2010 1:07 AM

russbo

New Member

Yea, well if you have a failed install on the mysql part, it's a nightmare going through the databases taking out what's been created, so you can make it install.

A list of the tables created would be helpful, if you have them.

Reply
May 16, 2010 1:12 AM

pegasus

VaultWiki Team

All of the tables created are in: vault/install/mysql-create.php
You don't really need to delete those, since IF EXISTS is used.

What you need to be concerned with removing is the added columns.
All of the columns added to existing tables are in: vault/install/mysql-alter.php

Reply
May 16, 2010 1:16 AM

russbo

New Member

Got through the database stuff. Took some time clearing out the database so that the step would proceed.
Here's the tables that have to be pruned for the install to take place:

# Altering usergroup table
# Altering forum table
# Altering forumpermission table
# Altering poll table
# Altering post table
# Altering bbcode table
session
user
thread firstpostid stuff, where ever it is.

I think I got it now....

Thanks!

Reply
May 16, 2010 2:35 AM

russbo

New Member

Originally Posted by pegasus

All of the tables created are in: vault/install/mysql-create.php
You don't really need to delete those, since IF EXISTS is used.

Pegasus, not sure that works correctly. I had to go into the database and delete the tables, each time I tried step two, otherwise it would hang.

I did get it all installed. Wow. What a thing you guys created. I'm impressed. Very professional. Just a note, the creation of the default forum would not go via the namespace manager for lack of a forum ID; I had to create a forum after turning the wiki off, and assigning it to the default namespace. Subsequent forum creation occurred with no problems.

Thanks for your time. Greatly appreciate your help.

rich

Reply
May 17, 2010 11:55 AM

pegasus

VaultWiki Team

"Fixed" for the next build by using the dbalter class which checks column/index existence before attempting an add/drop.

Reply

+ Reply

All times are GMT -4. The time now is 12:58 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: Installation: database errors

Issue Tools