View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 05187 | Bug reports | Installation | public | 2011-05-20 21:38 | 2011-05-21 23:21 |
| Reporter | joe_p | Assigned To | c_schmitz | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | duplicate | ||
| Product Version | 1.91 | ||||
| Summary | 05187: SQL commands failing - object "t" | ||||
| Description | I installed the newest LimeSurvey release (1.91) on our development site and got the SQL command failures listed below. From the installation page: SQL command failed: ALTER TABLE t ADD [usesleft] int NOT NULL DEFAULT '1' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "t" because it does not exist or you do not have permissions. SQL command failed: UPDATE t SET usesleft=0 WHERE completed<>'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 't'. SQL command failed: ALTER TABLE t ADD [usesleft] int NOT NULL DEFAULT '1' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "t" because it does not exist or you do not have permissions. SQL command failed: UPDATE t SET usesleft=0 WHERE completed<>'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 't'. SQL command failed: ALTER TABLE t ADD [usesleft] int NOT NULL DEFAULT '1' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "t" because it does not exist or you do not have permissions. SQL command failed: UPDATE t SET usesleft=0 WHERE completed<>'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 't'. SQL command failed: ALTER TABLE t ADD [usesleft] int NOT NULL DEFAULT '1' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "t" because it does not exist or you do not have permissions. SQL command failed: UPDATE t SET usesleft=0 WHERE completed<>'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 't'. SQL command failed: ALTER TABLE t ADD [usesleft] int NOT NULL DEFAULT '1' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "t" because it does not exist or you do not have permissions. SQL command failed: UPDATE t SET usesleft=0 WHERE completed<>'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 't'. SQL command failed: ALTER TABLE t ADD [usesleft] int NOT NULL DEFAULT '1' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "t" because it does not exist or you do not have permissions. SQL command failed: UPDATE t SET usesleft=0 WHERE completed<>'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 't'. SQL command failed: ALTER TABLE t ADD [usesleft] int NOT NULL DEFAULT '1' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "t" because it does not exist or you do not have permissions. SQL command failed: UPDATE t SET usesleft=0 WHERE completed<>'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 't'. SQL command failed: ALTER TABLE t ADD [usesleft] int NOT NULL DEFAULT '1' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "t" because it does not exist or you do not have permissions. SQL command failed: UPDATE t SET usesleft=0 WHERE completed<>'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 't'. SQL command failed: ALTER TABLE t ADD [usesleft] int NOT NULL DEFAULT '1' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "t" because it does not exist or you do not have permissions. SQL command failed: UPDATE t SET usesleft=0 WHERE completed<>'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 't'. SQL command failed: ALTER TABLE t ADD [usesleft] int NOT NULL DEFAULT '1' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "t" because it does not exist or you do not have permissions. SQL command failed: UPDATE t SET usesleft=0 WHERE completed<>'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 't'. SQL command failed: ALTER TABLE t ADD [usesleft] int NOT NULL DEFAULT '1' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "t" because it does not exist or you do not have permissions. SQL command failed: UPDATE t SET usesleft=0 WHERE completed<>'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 't'. SQL command failed: ALTER TABLE t ADD [usesleft] int NOT NULL DEFAULT '1' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "t" because it does not exist or you do not have permissions. SQL command failed: UPDATE t SET usesleft=0 WHERE completed<>'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 't'. Database update finished (2011-05-20 14:15:26) Database has been successfully upgraded to version 145 | ||||
| Tags | No tags attached. | ||||
| Bug heat | 0 | ||||
| Complete LimeSurvey version number (& build) | 10089 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Firefox | ||||
| Database type & version | SQL Server 10.0.4000 | ||||
| Server OS (if known) | Windows Server 2008 R2 | ||||
| Webserver software & version (if known) | IIS 7.5.7600.16385 | ||||
| PHP Version | PHP Version 5.2.13 | ||||
