View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05176 | Bug reports | Installation | public | 2011-05-18 11:19 | 2011-05-18 22:39 |
| Reporter | emilus | Assigned To | c_schmitz | ||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | won't fix | ||
| Product Version | 1.91 | ||||
| Summary | 05176: 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 |
| ||||
| Additional Information | Listing:The LimeSurvey database is being upgraded (2011-05-18 11:08:19) . Please be patient... . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 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 | ||||
| Tags | No tags attached. | ||||
| Bug heat | 2 | ||||
| Complete LimeSurvey version number (& build) | 10089 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Firefox | ||||
| Database type & version | MSSQL Server 2005, driver mssql_n | ||||
| Server OS (if known) | Windows Server 2003 | ||||
| Webserver software & version (if known) | IIS V6 | ||||
| PHP Version | 5.2 | ||||
| Git branch / Pull Request URL | |||||
| 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 |