09673: Last step in install fails with - The table "{{settings_global}}" for active record class "SettingGlobal" cannot be found in the

This issue affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update
09673	Bug reports	Installation	public	2015-06-09 22:46	2015-06-12 13:00

Reporter	adamllcg	Assigned To	c_schmitz
Priority	high	Severity	crash
Status	closed	Resolution	won't fix
Product Version	2.05+

Summary	09673: Last step in install fails with - The table "{{settings_global}}" for active record class "SettingGlobal" cannot be found in the
Description	Installation proceeds normally. Upon completion of the last step it errors out with: Could not add optional settings: exception 'CDbException' with message 'The table "{{users}}" for active record class "User" cannot be found in the database.' in D:\home\site\wwwroot\Limesurvey205\framework\db\ar\CActiveRecord.php:2362 Stack trace: #0 D:\home\site\wwwroot\Limesurvey205\framework\db\ar\CActiveRecord.php(411): CActiveRecordMetaData>__ construct(Object(User)) #1 D:\home\site\wwwroot\Limesurvey205\framework\db\ar\CActiveRecord.php(677): CActiveRecord> getMetaData() #2 D:\home\site\wwwroot\Limesurvey205\application\models\LSActiveRecord.php(27): CActiveRecord> hasAttribute('created') #3 D:\home\site\wwwroot\Limesurvey205\framework\db\ar\CActiveRecord.php(396): LSActiveRecord> behaviors() #4 D:\home\site\wwwroot\Limesurvey205\application\models\User.php(33): CActiveRecord::model('User') #5 D:\home\site\wwwroot\Limesurvey205\application\controllers\InstallerController.php(646): User::model() #6 D:\home\site\wwwroot\Limesurvey205\application\controllers\InstallerController.php(83): InstallerController> stepOptionalConfiguration() #7 D:\home\site\wwwroot\Limesurvey205\framework\web\CWebApplication.php(282): InstallerController> run('optional') #8 D:\home\site\wwwroot\Limesurvey205\framework\web\CWebApplication.php(141): CWebApplication> runController('installer/optio...') #9 D:\home\site\wwwroot\Limesurvey205\framework\base\CApplication.php(180): CWebApplication> processRequest() #10 D:\home\site\wwwroot\Limesurvey205\index.php(200): CApplication> run() #11 {main}. If the site is reloaded, index.php throws the same error except with a different class/table name. The table "{{settings_global}}" for active record class "SettingGlobal" cannot be found in the database.
Steps To Reproduce	Try registering for a free account through Microsoft Azure's cloud platform. https://azure.microsoft.com/en-us/ Upload the package files and perform a install. Proceed install through steps 1-6. The error occurs on the last step.
Additional Information	DB was created successfully. Issue occurs with or without table name prefix. temp folder is writable.
Tags	No tags attached.
Attached Files	Limesurvey.zip (684,833 bytes)

Bug heat	6
Complete LimeSurvey version number (& build)	150520
I will donate to the project if issue is resolved	Yes
Browser	Chrome
Database type & version	Microsoft Azure SQL (~SQL Server 2012 equivalent)
Server OS (if known)	Windows NT RD00155D51D9C6 6.2 build 9200 (Windows Server 2012 Datacenter Edition) i586
Webserver software & version (if known)	Microsoft-IIS/8.0
PHP Version	5.4.38
Git branch / Pull Request URL

User List	There are no users monitoring this issue.

Mazi 2015-06-10 09:05 updater ~32310	Does the attached ZIP file contain the current DB after the partly successful installation?

adamllcg 2015-06-10 18:10 reporter ~32312	No, the zip file contains printouts of stack traces and phpinfo output. Using the zray tool I can see all exceptions thrown. Due to the nature of azure SQL Server most of the sys schema or tools are not available. CDbCommand failed to execute the SQL statement: SQLSTATE[42S02]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'sys.extended_properties'.. The SQL statement executed was: SELECT t1.*, columnproperty(object_id(t1.table_schema+'.'+t1.table_name), t1.column_name, 'IsIdentity') AS IsIdentity, CONVERT(VARCHAR, t2.value) AS Comment FROM [INFORMATION_SCHEMA].[COLUMNS] AS t1 LEFT OUTER JOIN sys.extended_properties AS t2 ON t1.ORDINAL_POSITION = t2.minor_id AND object_name(t2.major_id) = t1.TABLE_NAME AND t2.class=1 AND t2.class_desc='OBJECT_OR_COLUMN' AND t2.name='MS_Description' WHERE t1.TABLE_NAME='lime2_plugins' AND t1.TABLE_SCHEMA='dbo'Show

Mazi 2015-06-10 21:02 updater ~32315	Carsten, a not supported DB schema?

c_schmitz 2015-06-12 13:00 administrator ~32329	Onviously this is not compatible to MS Azure SQL - sorry.

Date Modified	Username	Field	Change
2015-06-09 22:46	adamllcg	New Issue
2015-06-09 22:46	adamllcg	File Added: Limesurvey.zip
2015-06-10 09:05	Mazi	Note Added: 32310
2015-06-10 09:05	Mazi	Assigned To	=> Mazi
2015-06-10 09:05	Mazi	Status	new => feedback
2015-06-10 18:10	adamllcg	Note Added: 32312
2015-06-10 18:10	adamllcg	Status	feedback => assigned
2015-06-10 21:01	Mazi	Assigned To	Mazi => c_schmitz
2015-06-10 21:02	Mazi	Note Added: 32315
2015-06-12 13:00	c_schmitz	Note Added: 32329
2015-06-12 13:00	c_schmitz	Status	assigned => closed
2015-06-12 13:00	c_schmitz	Resolution	open => won't fix

View Issue Details

Users monitoring this issue

Activities

Issue History