PHP error suppression command?

[G-man]

And step 5:

Altering announcement table

Creating moderator table

Merging old moderators


Warning: 0 is not a MySQL result index in ./db_mysql.php on line 120

Warning: 0 is not a MySQL result index in ./db_mysql.php on line 120

Next step -->


Then it errors out at step 9

[G-man]

The saga continues...

[Freddie Bingham]

We don't have an answer for this problem at the moment.

[dunefreak]

Is there a problem with the script and vservers as I cannot upgrade. I am doing it on a test board so I am not as concerned, but would like to figure it out. The following is the tech e-mail sent.

Database error in vBulletin Upgrade: Invalid SQL: CREATE TABLE privatemessage (
privatemessageid INT UNSIGNED NOT NULL AUTO_INCREMENT,
folderid SMALLINT NOT NULL,
userid INT UNSIGNED NOT NULL,
touserid INT UNSIGNED NOT NULL,
fromuserid INT UNSIGNED NOT NULL,
title CHAR(250) NOT NULL,
message MEDIUMTEXT NOT NULL,
dateline INT UNSIGNED NOT NULL,
   showsignature SMALLINT NOT NULL,
iconid SMALLINT UNSIGNED NOT NULL,
messageread SMALLINT NOT NULL,
PRIMARY KEY (privatemessageid)
)
mysql error: Table 'privatemessage' already exists
mysql error number: 1050
Date: Thursday 15th of February 2001 09:12:10 AM
Script: /test/admin/upgrade1.php?step=2
Referer: [url]http://www.offroadbb.com/test/admin/upgrade1.php[/url]

[Freddie Bingham]

Your error is showing that the table 'privatemessage' already exists and can't be created. 'privatemessage' is a new table to version 2.0 so I would have to think you tried to run the upgrade script more than once. What happens if you do a database restore and then try the upgrade script. That is the error we need.

[G-man]

Dunefreak,
I have been down this road before. Do a data and structure dump to your local harddrive using your vadmin tools and then ftp that dumb in ASCII to your vserver root. In the Vadmin drop the test database you are working on then create a new database of the same name. In telnet type the following:

mysql yourtestdatabase < nameofyourdump.sql

Using this process you will be able to keep recreating your test database and keep trying the upgrade script and any variations of the upgrade script until it works.

Also I highly encourage you place the error suppression lines in like Freddie said. This should get you to where I am right now and as soon as the Beta team figures a workaround we can go the rest of the way.

Hope this helps,

G-man

[dunefreak]

It was a blank database as I just used it to test template changes. Should I just go in and delete the tables that it says already exist.