View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0006014mantisbtadministrationpublic2005-07-26 08:142011-10-31 07:12
Reporterxbromy2 Assigned Tothraxisp  
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionno change required 
Product Version1.0.0rc1 
Summary0006014: 0.19.2 Update Database MySQL doesn't work
Description

I've unpacked the 1.0.0rc1 made a copy of my 0.19.2 database and configured the database in config_inc.php. Now i opend the new mantis in browser and got to admin/install.php there i set the user / pass / database and click on the Install / Upgrade Button. -> Then there is this error:

BAD
CREATE TABLE mantis_bug_file_table ( id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, bug_id INTEGER UNSIGNED NOT NULL DEFAULT 0, title VARCHAR(250) NOT NULL DEFAULT '', description VARCHAR(250) NOT NULL DEFAULT '', diskfile VARCHAR(250) NOT NULL DEFAULT '', filename VARCHAR(250) NOT NULL DEFAULT '', folder VARCHAR(250) NOT NULL DEFAULT '', filesize INTEGER NOT NULL DEFAULT 0, file_type VARCHAR(250) NOT NULL DEFAULT '', date_added DATETIME NOT NULL DEFAULT '1970-01-01 00:00:01', content LONGBLOB NOT NULL, PRIMARY KEY (id) )TYPE=MyISAM
Table 'mantis_bug_file_table' already exists

TagsNo tags attached.

Relationships

related to 0013450 closeddregad upgrade failure 
child of 0005460 closedvboctor Critical Issues to Fix for Mantis 1.0.0 Release 

Activities

thraxisp

thraxisp

2005-07-26 08:48

reporter   ~0010965

For pre-1.0.0 installations, you need to use the "admin/upgrade.php" process as indicated on the login page. The use of "install.php" only works starting with new installations.
xbromy2

xbromy2

2005-07-26 09:23

reporter   ~0010966

the upgrade.php redirects me to the install.php ...
xbromy2

xbromy2

2005-07-26 09:38

reporter   ~0010967

this is the line for the redirect:
upgarde.php
Line40: header( "Refresh: 0;url=install.php" );
romanrm

romanrm

2005-11-21 01:23

reporter   ~0011640

Last edited: 2005-11-21 01:23

I confirm this. With our 0.19.2 installation, upgrade.php simply redirects to install.php, which does not work since it tries to create already existing tables.

Please also check issue 0006340, which seems to be a duplicate of this one.
thraxisp

thraxisp

2005-12-14 17:49

reporter   ~0011797

Had this database ever been used with any of the alphas or rcs before? This would account for the redirection to the install page.
thraxisp

thraxisp

2005-12-18 09:31

reporter   ~0011815

I believe that this (the redirection to install.php for an existing database) was resolved in rc2. Can you verify this?
Ted Wilson

Ted Wilson

2006-02-14 22:51

reporter   ~0012152

Last edited: 2006-02-15 13:09

This is still happening in the final 1.0.0 release.

Upgrading from version 0.19.1

Tried running the UPGRADE.PHP script, but it just redirects me to the INSTALL.PHP where I get the same error.

Anybody have a solution?? A script to update the database?
Ted Wilson

Ted Wilson

2006-02-15 13:05

reporter   ~0012155

Just to clarify my situation:

I am moving to a new ISP, so I installed Mantis v1.0.0 on the new server.

I exported the database from the old server (v0.19.1) and imported it to the new server.

I changed the config PHP file on the new server.

Ran the install.php and get the "BAD CREATE TABLE mantis_bug_file_table" error.

Re-imported the old database into the new database b/c I didn't know if part of the update has taken place or not.

Ran the upgrade.php, which brought me back to the install.php, but ran it again anyway and got the same error.

Surely someone must have a solution for this??
thraxisp

thraxisp

2006-02-15 13:53

reporter   ~0012157

Once you run install.php, you can't go back...

I'd try the following:
1) erase then reload your old database.
2) run the upgrade.php script.
Ted Wilson

Ted Wilson

2006-02-15 14:14

reporter   ~0012158

That did it. I figured since my old database SQL had DROP statements it wasn't necessary.

I dropped all tables in my database, reimported the old database, and ran the upgrade.php and that worked.

I'm back in business. I will gladly pay the $10 bounty thraxisp if you tell me how to go about it.
thraxisp

thraxisp

2006-02-18 20:00

reporter   ~0012188

Original problem resolved in ~ 1.0.0rc3. User upgraded manually.