View Issue Details

IDProjectCategoryView StatusLast Update
0011811mantisbtupgradepublic2010-10-01 04:41
Reportertiv Assigned Toatrol  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionduplicate 
PlatformWindowsOSWindows Server 2008 R2OS Version6.1.7600
Product Version1.2.0 
Summary0011811: Error when upgrading from 1.1.8 to 1.2.0 (IIS + PHP + MSSQL)
Description

Hi!

I have a problem when trying to upgrade my Mantis from 1.1.8 to 1.2.0.
Configuration:
1 Server: WS2008R2: IIS 7.5 FastCGI + PHP 5.2.12 - Сайт
2 Server: WS2008R2: SQL 2005 SP3 - База

When I try to upgrade i see this:

Installing Database

Create database if it does not exist GOOD

Checking Database Server Version
Running mssql version Microsoft SQL Server Yukon - 9.00.4035 GOOD

Attempting to connect to database as user GOOD

Schema CreateTableSQL ( mantis_config_table ) BAD
CREATE TABLE mantis_config_table ( config_id VARCHAR(64) NOT NULL, project_id INT DEFAULT 0 NOT NULL, user_id INT DEFAULT 0 NOT NULL, access_reqd INT DEFAULT 0, type INT DEFAULT 90, value TEXT NOT NULL, PRIMARY KEY (config_id, project_id, user_id) )

There is already an object named 'mantis_config_table' in the database.
By a mistake it swears that the table mantis_config_table already exists, but I would think it swore on all existing tables in base, is simple this table is created by the first, IMHO.

Прошу помочь разобраться с данной проблемой.

Additional Information

All procedures are doing with administrative/root privileges.

TagsNo tags attached.

Relationships

duplicate of 0011784 closedgrangeway Upgrade 1.1.8 to 1.2.0 failed --> MSSQL database schema issue 

Activities

tomkraw1

tomkraw1

2010-04-21 02:13

reporter   ~0025176

It looks like this issue <a href="http://www.mantisbt.org/bugs/view.php?id=11784"> 11784</a>.