View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
13709Bug reportsInstallationpublic2018-05-25 01:592018-05-29 20:15
ReporterJohn_K Assigned To 
PrioritynoneSeverityminor 
Status closedResolutionno change required 
Product Version3.8.x 
Summary13709: CDbException-The table "{{settings_global}}" for active record class "SettingGlobal" cannot be found
Description

Hi, Am getting this error when I try to install LS 3.8.1 on Windows.
Can you pls assist?
ErrorMain: Full attached.
CDbException
The table "{{settings_global}}" for active record class "SettingGlobal" cannot be found in the database.
G:\Apache24\htdocs\limesurvey\framework\db\ar\CActiveRecord.php(2390)

Steps To Reproduce

1)Download stable release LS 3.8.1 on May 24.
2)Extract to folder \Apache24\htdocs\
3)Edit limesurvey\admin\index.php -($config_file = $config_folder . 'config-sample-sqlsrv.php';)
4)Start installer: https://Mysite.org:/limesurvey/admin/admin.php
--Then LS displays this error.

TagsNo tags attached.
Attached Files
CDbException-table {{settings_global}} for active record class SettingGlobal cannot be found in the database.docx (18,381 bytes)
Bug heat4
Complete LimeSurvey version number (& build)limesurvey3.8.1+180524
I will donate to the project if issue is resolvedNo
BrowserMS Edge, Chrome, IE 11
Database type & versionMS SQL Server 2014 SP1(64bit)
Server OS (if known)Windows Server 2012 r2(64bit)
Webserver software & version (if known)Apache 2.4.33(64bit)
PHP VersionPHP 7.2.5(64bit)

Users monitoring this issue

There are no users monitoring this issue.

Activities

ollehar

ollehar

2018-05-25 10:36

administrator   ~47808

Your installation procedure seems incorrect. You cannot use the config file before you've gone through the installer script.
ollehar

ollehar

2018-05-25 10:36

administrator   ~47809

https://manual.limesurvey.org/Installation_-_LimeSurvey_CE
John_K

John_K

2018-05-25 18:40

reporter   ~47854

Hi olle,
Thank U for ur reply. However based on the step outlined in ur link, I get this 'connection string-failed to open DB' error msg.
Pls advice/
JK
CDbException
CDbConnection failed to open the DB connection: SQLSTATE[08001]: [Microsoft][ODBC Driver 17 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2].
G:\Apache24\htdocs\limesurvey\framework\db\CDbConnection.php(399)

387 throw new CDbException('CDbConnection.connectionString cannot be empty.');
398 {
399 throw new CDbException('CDbConnection failed to open the DB connection: '.
ollehar

ollehar

2018-05-28 10:04

administrator   ~47868

You have to remove the old, incorrect, config.php file first.
John_K

John_K

2018-05-29 20:15

reporter   ~47902

Thank U Olle, I successfully installed LS 3.8.1 after deleting the config file.
(I was following the successful steps I did in LS3.7.2 for 3.8.1) Thanks for ur guidance. JK

Issue History

Date Modified Username Field Change
2018-05-25 01:59 John_K New Issue
2018-05-25 01:59 John_K File Added: CDbException-table {{settings_global}} for active record class SettingGlobal cannot be found in the database.docx
2018-05-25 10:36 ollehar Note Added: 47808
2018-05-25 10:36 ollehar Status new => closed
2018-05-25 10:36 ollehar Resolution open => no change required
2018-05-25 10:36 ollehar Note Added: 47809
2018-05-25 18:40 John_K Note Added: 47854
2018-05-28 10:04 ollehar Note Added: 47868
2018-05-29 20:15 John_K Note Added: 47902