View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
05027Bug reportsInstallationpublic2011-03-13 01:322011-04-11 11:30
Reportermedicnick Assigned Toc_schmitz  
PriorityurgentSeveritycrash 
Status closedResolutionfixed 
Product Version1.91RC4 
Fixed in Version1.91RC6 
Summary05027: Install script errors
Description

Using the /admin/install method to update to RC4 I got a page full of errors:
. . . . . . . . . . . . . . . . .
Warning: Invalid argument supplied for foreach() in E:{PATH}\htdocs\limesurvey\classes\adodb\adodb-lib.inc.php on line 806

Notice: Uninitialized string offset: -1 in E:{PATH}\htdocs\limesurvey\common_functions.php on line 5443
...........
(truncated hundreds of this)
. . . . . . . . .
SQL command failed: ALTER TABLE [lime_surveys] ALTER COLUMN [anonymized] char(1) NOT NULL default 'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'default'.

SQL command failed: CREATE TABLE [lime_failed_login_attempts] ( [id] int(11) NOT NULL AUTO_INCREMENT, [ip] varchar(37) NOT NULL, [last_attempt] varchar(20) NOT NULL, [number_attempts] int(11) NOT NULL, PRIMARY KEY ([id]) ) Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'AUTO_INCREMENT'.
.

(odbc_mssql): select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE')) AND name like 'lime_tokens%'

(odbc_mssql): ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1'

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "l" because it does not exist or you do not have permissions., SQL state S0002 in SQLExecDirect in E:\web\priorihealt\htdocs\limesurvey\classes\adodb\drivers\adodb-odbc.inc.php on line 530
S0002: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "l" because it does not exist or you do not have permissions.

SQL command failed: ALTER TABLE l ADD [usesleft] int NOT NULL DEFAULT '1' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot find the object "l" because it does not exist or you do not have permissions.

(odbc_mssql): UPDATE l SET usesleft=0 WHERE completed<>'N'

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'l'., SQL state S0002 in SQLExecDirect in E:\web\priorihealt\htdocs\limesurvey\classes\adodb\drivers\adodb-odbc.inc.php on line 530
S0002: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'l'.

SQL command failed: UPDATE l SET usesleft=0 WHERE completed<>'N' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'l'.

(odbc_mssql): UPDATE [lime_settings_global] SET stg_value='145' WHERE stg_name='DBVersion'

.

Steps To Reproduce

As described, direct install method.

Additional Information

I did not know how to troubleshoot the adodb errors.

I manually altered the SQL as follows to successfully make the changes:
ALTER TABLE [lime_surveys]
ALTER COLUMN [anonymized] char(1) SET NOT NULL DEFAULT 'N'

and

CREATE TABLE [lime_failed_login_attempts]
(
[id] int NOT NULL IDENTITY,
[ip] varchar(37) NOT NULL,
[last_attempt] varchar(20) NOT NULL,
[number_attempts] int NOT NULL,
PRIMARY KEY ([id]) )

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)9797
I will donate to the project if issue is resolvedNo
BrowserIE8 and Chrome
Database type & versionMSSQL 2008
Server OS (if known)Win
Webserver software & version (if known)IIS7
PHP Version5.2.5

Users monitoring this issue

There are no users monitoring this issue.

Activities

medicnick

medicnick

2011-03-13 08:00

reporter   ~14425

I decided to create a new db instance and reinstall from a fresh download. Not sure how/why but the build number is lower with a later build date. This error did not reoccur.
Mazi

Mazi

2011-03-21 00:51

updater   ~14488

So you are not able to reproduce this issue anymore?
medicnick

medicnick

2011-03-21 21:57

reporter   ~14499

Since I fixed the MSSQL scripting for a manual database update I am unable to duplicate the previous conditions in order to duplicate.
c_schmitz

c_schmitz

2011-04-11 11:30

administrator   ~14759

1.91RC6 released.

Issue History

Date Modified Username Field Change
2011-03-13 01:32 medicnick New Issue
2011-03-13 08:00 medicnick Note Added: 14425
2011-03-21 00:51 Mazi Note Added: 14488
2011-03-21 00:51 Mazi Assigned To => c_schmitz
2011-03-21 00:51 Mazi Status new => feedback
2011-03-21 21:57 medicnick Note Added: 14499
2011-03-21 21:57 medicnick Status feedback => assigned
2011-03-29 16:35 c_schmitz Status assigned => resolved
2011-03-29 16:35 c_schmitz Fixed in Version => 1.91RC6
2011-03-29 16:35 c_schmitz Resolution open => fixed
2011-04-11 11:30 c_schmitz Note Added: 14759
2011-04-11 11:30 c_schmitz Status resolved => closed