View Issue Details

This issue affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
05176Bug reportsInstallationpublic2011-05-18 22:39
Reporteremilus Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionwon't fix 
Product Version1.91 
Summary05176: Upgrading from 1.90x to 1.91+ stable emits SQL errors on described configuration
Description

After doing a manual upgrade, the initial database script emits a bunch of errors

Steps To Reproduce
  • Upgrade manually
  • Limesurvey starts upgrading after requesting /admin/admin.php & go
  • Emits error list (see additional information)
  • Concludes with stating that the database is upgraded to 145, regardless of errors
Additional Information

Listing:

The LimeSurvey database is being upgraded (2011-05-18 11:08:19) . Please be patient...

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: 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: Invalid object name 'l'.
.

Database update finished (2011-05-18 11:08:54)

Database has been successfully upgraded to version 145

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)10089
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & versionMSSQL Server 2005, driver mssql_n
Server OS (if known)Windows Server 2003
Webserver software & version (if known)IIS V6
PHP Version5.2
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2011-05-18 22:38

administrator   ~15054

Last edited: 2011-05-18 22:39

mssql_n is an experimental driver and basically is obsolete. Restore the database from your original backup, then use either the mssql_odbc or mssqlnative driver.

Issue History

Date Modified Username Field Change
2011-05-18 11:19 emilus New Issue
2011-05-18 22:38 c_schmitz Note Added: 15054
2011-05-18 22:39 c_schmitz Note Edited: 15054
2011-05-18 22:39 c_schmitz Status new => closed
2011-05-18 22:39 c_schmitz Assigned To => c_schmitz
2011-05-18 22:39 c_schmitz Resolution open => won't fix