PDA

View Full Version : Another upgrade error



Jon P
Mon 12th Feb '01, 11:08pm
On step 4 it says:


vBulletin Install Script

(Note: Please be patient as some parts of this may take quite some time.)

Creating table access

Altering access table

Creating table admin log

Creating table announcement

Creating table attachment

Creating table avatar

Creating table bbcode

Creating table calendar_events

Creating table custom avatar

Creating table forum

Creating table forum permission

Creating table icon

Creating table moderator

Creating table poll

Creating table pollvote

Creating table post

Creating table private message

Creating table profile field

Creating table replacement

Creating table replacement set

Creating table search

Creating table search index

Altering search index table

Creating table session

Creating table setting

Creating table setting group

Creating table smilie

Creating table style

Creating table subscribed forum

Creating table subscribed thread

Creating table template

Creating table template set

Creating table thread

Creating table thread rate

Creating table user

Altering user table

Creating table userfield

Creating table usergroup

Creating table user title

Creating table word

Altering word table

The script reported errors in the installation of the tables. Only continue if you are sure that they are not serious.

The errors were:

Error number: 1050

Error description: Table 'word' already exists

Next step -->




When I go to the next step it says:


vBulletin Install Script

(Note: Please be patient as some parts of this may take quite some time.)

Adding bbcode data

There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.


And the source includes:


<!-- INSERT INTO bbcode VALUES (1,'b','&lt;b&gt;\\4&lt;/b&gt;','Bold','The [b] tag allows you to write text bold',0) -->


<!-- Database error in vBulletin Installer: Invalid SQL: INSERT INTO bbcode VALUES (1,'b','<b>\\4</b>','Bold','The [b] tag allows you to write text bold',0)
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
Date: Monday 12th of February 2001 11:05:13 PM
Script: /v2/admin/install1.php?step=5
Referer: http://forums.dricasworld.com/v2/admin/install1.php?step=4
-->


My database currently runs fine with the 1.1.5 version, although parts of the database are possibly corrupt (had to re-add a user this morning who's posts no longer showed his name and showed him as registering in 1969). I repaired all the tables and tried the upgrade again, receiving the exact same errors posted above.

Mike Sullivan
Mon 12th Feb '01, 11:11pm
Empty all tables from your db and try again.

Jon P
Mon 12th Feb '01, 11:17pm
I did do a successful clean install before trying the upgrade. But I don't want a clean install (keeping current posts and users is a necessity). If database corruption is the problem I guess I'll be going through the database .txt dump looking for where things go wrong.

Mike Sullivan
Mon 12th Feb '01, 11:19pm
See, you're confusing me -- you're talking about upgrading, but your problem came from the install script.

Jon P
Tue 13th Feb '01, 9:09am
That was that problem! Thanks for slapping me back into shape. :) I was running install1.php instead of upgrade1.php. Just upgraded successfully on my test board. Looks great so far, well worth the wait!