View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0008808mantisbtupgradepublic2008-01-24 13:542008-01-27 09:07
Reporterpierreact Assigned To 
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionno change required 
Platformi386OSFreeBSDOS Version6.2
Product Version1.1.0 
Summary0008808: Couldn't finish successfully and upgrade
Description

Upgrade from 1.0.7 to 1.1.0
The issue happens in the basic upgrade set.

"Drop votes column of mantis_bug_table 0.17-jf-8 ERROR: Can't DROP 'votes'; check that column/key exists"

This stops everything...
Now, when I did try to use mantis, I couldn't add a bug report, the issue was the following: APPLICATION ERROR 0000401

Tell me if I can do anything to help... I use mysql 5.1.22

TagsNo tags attached.

Activities

giallu

giallu

2008-01-24 15:13

reporter   ~0016796

What version were you starting from and what page did you use to upgrade?
giallu

giallu

2008-01-24 15:13

reporter   ~0016797

oops sorry. starting version is there... obviously I can't read :)
pierreact

pierreact

2008-01-24 15:18

reporter   ~0016799

This happens to me too :)
I did it using admin/upgrade.php
giallu

giallu

2008-01-24 17:09

reporter   ~0016804

Please run admin/install.php instead.

upgrade.php was the old script covering 0.x to 1.0 upgrades
pierreact

pierreact

2008-01-24 17:20

reporter   ~0016805

Allright, then, may I suggest that you guys explain this in this link: "WARNING: The database structure may be out of date. Please upgrade here before logging in." from the login page after an upgrade ? It's there right away after installing the version 1.1.1 (login_page.php)

Thank you.

Things are that even when using install.php, I get the following error:
Schema CreateTableSQL ( mantis_config_table )

BAD
CREATE TABLE mantis_config_table ( config_id VARCHAR(64) NOT NULL, project_id INTEGER NOT NULL DEFAULT 0, user_id INTEGER NOT NULL DEFAULT 0, access_reqd INTEGER DEFAULT 0, type INTEGER DEFAULT 90, value LONGTEXT NOT NULL, PRIMARY KEY (config_id, project_id, user_id) )TYPE=MyISAM
Table 'mantis_config_table' already exists

Well, of course the table exists... It's an upgrade...
pierreact

pierreact

2008-01-26 08:42

reporter   ~0016823

No idea ?
pierreact

pierreact

2008-01-26 09:32

reporter   ~0016826

Guess I should set this bug as resolved and open an other for the other issue... sounds logical.

Thanks a lot for your help giallu
giallu

giallu

2008-01-27 09:07

reporter   ~0016840

well. yes, albeit I am afraid this problem originate from running the install.php script after upgrade.php.

I will try to have a look but right now my resources are a bit limited.