05180: Database Upgrade fails from 1.90x to 1.91+ stable - even more errors than mssql_n driver.

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

05180	Bug reports	Installation	public	2011-05-19 15:58	2011-06-05 22:59

Reporter	emilus	Assigned To	c_schmitz
Priority	high	Severity	partial_block
Status	closed	Resolution	fixed
Product Version	1.91
Fixed in Version	1.91+

Summary	05180: Database Upgrade fails from 1.90x to 1.91+ stable - even more errors than mssql_n driver.
Description	Manual upgrade and subsequent database upgrade run from limesurvey emits errors
Steps To Reproduce	Do the manual upgrade. on activating Limesurvey (/admin/admin.php) the upgrade starts Observe output in Additonal information Note: database is approached with full privileges. Same behaviour roughly goes up for mssql_n driver as reported earlier. mssql_odbc also emits errors.
Additional Information	The LimeSurvey database is being upgraded (2011-05-19 16:03:27) . Please be patient... Moving user templates to new location at D:\Topshare_5400\limesurvey\upload\templates... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . SQL command failed: ALTER TABLE [lime_answers] DROP CONSTRAINT Reason: SQLState: 42000 Error Code: 102 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'CONSTRAINT'. SQL command failed: ALTER TABLE [lime_answers] DROP COLUMN [default_value] Reason: SQLState: 42000 Error Code: 5074 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]The object 'DF__lime_answdefau07F6335A' is dependent on column 'default_value'. SQLState: 42000 Error Code: 4922 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]ALTER TABLE DROP COLUMN default_value failed because one or more objects access this column. SQL command failed: ALTER TABLE [lime_questions] DROP CONSTRAINT Reason: SQLState: 42000 Error Code: 102 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'CONSTRAINT'. SQL command failed: ALTER TABLE [lime_questions] DROP COLUMN lid Reason: SQLState: 42000 Error Code: 5074 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]The object 'DF__lime_questilid32E0915F' is dependent on column 'lid'. SQLState: 42000 Error Code: 4922 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]ALTER TABLE DROP COLUMN lid failed because one or more objects access this column. SQL command failed: ALTER TABLE [lime_questions] DROP CONSTRAINT Reason: SQLState: 42000 Error Code: 102 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'CONSTRAINT'. SQL command failed: ALTER TABLE [lime_questions] DROP COLUMN lid1 Reason: SQLState: 42000 Error Code: 5074 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]The object 'DF__lime_questlid133D4B598' is dependent on column 'lid1'. SQLState: 42000 Error Code: 4922 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]ALTER TABLE DROP COLUMN lid1 failed because one or more objects access this column. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: SQLState: 42S02 Error Code: 4902 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the object "l" because it does not exist or you do not have permissions. SQL command failed: UPDATE l SET usesleft=0 WHERE completed<>'N' Reason: SQLState: 42S02 Error Code: 208 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'l'. SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: SQLState: 42S02 Error Code: 4902 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the object "l" because it does not exist or you do not have permissions. SQL command failed: UPDATE l SET usesleft=0 WHERE completed<>'N' Reason: SQLState: 42S02 Error Code: 208 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'l'. SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: SQLState: 42S02 Error Code: 4902 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot find the object "l" because it does not exist or you do not have permissions. SQL command failed: UPDATE l SET usesleft=0 WHERE completed<>'N' Reason: SQLState: 42S02 Error Code: 208 Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'l'. . Database update finished (2011-05-19 16:03:38) Database has been successfully upgraded to version 145 Back to main menu
Tags	No tags attached.

Bug heat	10
Complete LimeSurvey version number (& build)	10062
I will donate to the project if issue is resolved	No
Browser	FF
Database type & version	Sql server 2005, latest mssql native client,
Server OS (if known)	windows server 2003
Webserver software & version (if known)	iis 6
PHP Version	5.2.13.

User List	There are no users monitoring this issue.

c_schmitz 2011-05-25 11:52 administrator ~15096 Last edited: 2011-06-03 10:32	The first block of errors are non-critical and can be ignored - I cannot reproduce these with MSSQL 2008 either so I guess it is some MSSQL 2003 specific issue. The second block of errors is fixed in rev 10119 and only happened if there were any token tables.

c_schmitz 2011-05-25 11:55 administrator ~15097	I assumed you used mssql_odbc as driver, right? I will have to install MSSQL server 2003 (omg, what a mess) to find out about the first lot of errors.

c_schmitz 2011-06-02 12:30 administrator ~15247	emilius?

emilus 2011-06-02 21:59 reporter ~15266	Sorry for the communication delay! from the top of my head (I am home) - I tried mssql_native and later on mssl_odbc. All drivers failed. I got a workaround for this by installing a fresh database schema - and used mssql_n driver for that. Then I compared by diffing the schemas. It pretty much boiled down to one missing column in -i believe- lime_surveys that I added manually. I need to check for specifics and wil get back to you on that next week. We tested the patched schema with existing surveys and it seems to go ok. Cheers and again, sorry for the delay. -Emile

c_schmitz 2011-06-05 22:59 administrator ~15312	New 1.91+ version released

Date Modified	Username	Field	Change
2011-05-19 15:58	emilus	New Issue
2011-05-19 17:22	c_schmitz	Assigned To	=> c_schmitz
2011-05-19 17:22	c_schmitz	Status	new => assigned
2011-05-21 23:21	c_schmitz	Relationship added	has duplicate 05187
2011-05-25 11:52	c_schmitz	Note Added: 15096
2011-05-25 11:55	c_schmitz	Note Added: 15097
2011-05-25 11:55	c_schmitz	Status	assigned => feedback
2011-06-02 12:30	c_schmitz	Note Added: 15247
2011-06-02 21:59	emilus	Note Added: 15266
2011-06-02 21:59	emilus	Status	feedback => assigned
2011-06-03 10:32	c_schmitz	Note Edited: 15096
2011-06-04 23:44	c_schmitz	Status	assigned => resolved
2011-06-04 23:44	c_schmitz	Fixed in Version	=> 1.91+
2011-06-04 23:44	c_schmitz	Resolution	open => fixed
2011-06-05 22:59	c_schmitz	Note Added: 15312
2011-06-05 22:59	c_schmitz	Status	resolved => closed

View Issue Details

Relationships

Users monitoring this issue

Activities

Issue History