View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 16
IDProjectCategoryView StatusDate SubmittedLast Update
08627Bug reportsInstallationpublic2014-01-29 23:192014-02-27 12:07
Reporteradolfocorreia Assigned Toc_schmitz  
PriorityhighSeverityblock 
Status closedResolutionunable to reproduce 
Product Version2.05+ 
Summary08627: Installation crashes on Optional settings page
Description

When running the installation procedure I get the following error when I click "Next" in the "Optional settings" screen (/index.php?r=installer/optional):

Could not add optional settings: exception 'CDbException' with message 'The table "{{users}}" for active record class "User" cannot be found in the database.' in E:\Aplicacoes\LimeSurvey\site\framework\db\ar\CActiveRecord.php:2362
Stack trace:
#0 E:\Aplicacoes\LimeSurvey\site\framework\db\ar\CActiveRecord.php(411): CActiveRecordMetaData->construct(Object(User))
#1 E:\Aplicacoes\LimeSurvey\site\framework\db\ar\CActiveRecord.php(79): CActiveRecord->getMetaData()
#2 E:\Aplicacoes\LimeSurvey\site\application\controllers\InstallerController.php(635): CActiveRecord->construct()
#3 E:\Aplicacoes\LimeSurvey\site\application\controllers\InstallerController.php(82): InstallerController->stepOptionalConfiguration()
#4 E:\Aplicacoes\LimeSurvey\site\framework\web\CWebApplication.php(282): InstallerController->run('optional')
#5 E:\Aplicacoes\LimeSurvey\site\framework\web\CWebApplication.php(141): CWebApplication->runController ('installer/optio...')
#6 E:\Aplicacoes\LimeSurvey\site\framework\base\CApplication.php(180): CWebApplication->processRequest()
#7 E:\Aplicacoes\LimeSurvey\site\index.php(190): CApplication->run()
#8 {main}.

The installation procedure is not completed. After this error, when I try to access the application (at http://mydomain.com/limesurvey) I get the error:

The table "{{settings_global}}" for active record class "SettingGlobal" cannot be found in the database.

And if I try to run the installation procedure again I get the same error as above.

I am using Windows Server 2008 R2, IIS 7.5, PHP 5.4.24 and SQL Server 2008 R2. LimeSurvey version: 205plus-build140125. I managed to install the application in version 192plus-build120919, though.

Even though the message say that it could not find the table "{{users}}", there is a table "lime_users" in the database.

Steps To Reproduce

Click "Next" in the Optional settings page during installation.

TagsNo tags attached.
Attached Files
bugReport.zip (42,937 bytes)
Bug heat16
Complete LimeSurvey version number (& build)build140125
I will donate to the project if issue is resolvedNo
BrowserInternet Explorer 8
Database type & versionSQL Server 2008 R2
Server OS (if known)Windows Server 2008 R2
Webserver software & version (if known)IIS 7.5
PHP Version5.4.24

Relationships

Relationship GraphDependency Graph
has duplicate 08778 closedc_schmitz 2.05+ install crashes 

Users monitoring this issue

adolfocorreia

Activities

adolfocorreia

adolfocorreia

2014-01-29 23:24

reporter   ~28266

The table "lime_settings_global" also exists in the database.
c_schmitz

c_schmitz

2014-01-31 13:51

administrator   ~28315

{{settings_global}} is an alias for lime_settings_global

If you say it exists then it would not error out as missing.

I think you are mistakenly using the wrong database.
Clean out your database(s), then try again.

adolfocorreia

adolfocorreia

2014-01-31 14:47

reporter   ~28324

This error happened when I was performing a new installation. The database was clean (no tables) in the beginning. It managed to create all the tables during installation, but in the last step it was not able to find the tables it had just created. When I try to access the application afterwards, it still cannot find the tables. Maybe it is writing the database configuration in the wrong place?
adolfocorreia

adolfocorreia

2014-01-31 14:52

reporter   ~28325

I checked the file /application/config/config.php and the database settings are there.
c_schmitz

c_schmitz

2014-01-31 15:19

administrator   ~28327

Maybe a permission issue? Did you login with the particular DB user and checked if the user can see the tables?
adolfocorreia

adolfocorreia

2014-01-31 15:52

reporter   ~28330

The DBA team only gave me one database user, which I used to check if the tables were created on the database. This user has full permissions on the database (including create and drop tables, select etc.). Furthermore, I managed to install LimeSurvey v1.92 using the same machine (Windows Server 2008 R2, IIS 7.5 and PHP 5.4.24) and setup (same IIS web app, same database user and config etc.).
c_schmitz

c_schmitz

2014-02-02 22:50

administrator   ~28410

What DB driver is set in config.php in the ConnectionString? I assume sqlsrv?
c_schmitz

c_schmitz

2014-02-03 09:51

administrator   ~28428

I am sorry but I cannot reproduce this here using the same configuration. I can only assume it is some server issue. Without having direct access to this system it is impossible for me to tell what's going on. Maybe your database driver is outdated or something. Anyway, I am sure it is not a bug in LimeSurvey.
adolfocorreia

adolfocorreia

2014-02-03 15:30

reporter   ~28446

This may be a database driver problem indeed. Following the installation instructions, I used the driver php_pdo_sqlsrv_54_nts.dll with LS v2.05. Later, when installing LS v1.92, I had to change to the driver php_sqlsrv_54_nts.dll (no PDO). I am not sure, but I think v1.92 is not compatible with the PDO driver. I will try the installation again using different drivers. In the meantime, can you confirm if version 2.05 requires the use of a PDO compatible SQL Server driver?
adolfocorreia

adolfocorreia

2014-02-03 15:35

reporter   ~28447

In v2.05 the connectionString begins with "sqlsrv:" as you assumed. In v1.92 the $databasetype parameter in config.php is 'mssqlnative'.
c_schmitz

c_schmitz

2014-02-03 16:07

administrator   ~28451

Yes, LimeSurvey 2.05 needs the PDO driver - I am running the same driver here, works just fine (though I am using php_pdo_sqlsrv_54_ts.dll here).
c_schmitz

c_schmitz

2014-02-04 13:32

administrator   ~28497

Version 2.05+ Build 140204 released

Issue History

Date Modified Username Field Change
2014-01-29 23:19 adolfocorreia New Issue
2014-01-29 23:19 adolfocorreia File Added: bugReport.zip
2014-01-29 23:24 adolfocorreia Note Added: 28266
2014-01-29 23:25 adolfocorreia Issue Monitored: adolfocorreia
2014-01-31 13:51 c_schmitz Note Added: 28315
2014-01-31 13:51 c_schmitz Assigned To => c_schmitz
2014-01-31 13:51 c_schmitz Status new => feedback
2014-01-31 14:47 adolfocorreia Note Added: 28324
2014-01-31 14:47 adolfocorreia Status feedback => assigned
2014-01-31 14:52 adolfocorreia Note Added: 28325
2014-01-31 15:19 c_schmitz Note Added: 28327
2014-01-31 15:52 adolfocorreia Note Added: 28330
2014-02-02 22:50 c_schmitz Note Added: 28410
2014-02-03 09:51 c_schmitz Note Added: 28428
2014-02-03 09:51 c_schmitz Status assigned => closed
2014-02-03 09:51 c_schmitz Resolution open => unable to reproduce
2014-02-03 15:30 adolfocorreia Note Added: 28446
2014-02-03 15:30 adolfocorreia Status closed => feedback
2014-02-03 15:30 adolfocorreia Resolution unable to reproduce => reopened
2014-02-03 15:35 adolfocorreia Note Added: 28447
2014-02-03 15:35 adolfocorreia Status feedback => assigned
2014-02-03 16:07 c_schmitz Note Added: 28451
2014-02-03 16:07 c_schmitz Status assigned => resolved
2014-02-03 16:07 c_schmitz Resolution reopened => unable to reproduce
2014-02-04 13:32 c_schmitz Note Added: 28497
2014-02-04 13:32 c_schmitz Status resolved => closed
2014-02-27 12:07 c_schmitz Relationship added has duplicate 08778
2021-08-02 23:20 guest Bug heat 12 => 16