View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
08884Bug reportsInstallationpublic2014-04-04 10:26
Reportersprouse Assigned Toc_schmitz  
PrioritynormalSeverityblock 
Status closedResolutionunable to reproduce 
Product Version2.05+ 
Summary08884: The table "{{settings_global}}" for active record class "SettingGlobal" cannot be found in the database.
Description

After installation on debian MySQL apache2 php5 all requirements met I get the following error. Tried this multiple time with same results.

The database was successfully created and populated.

TagsNo tags attached.
Attached Files
limesurvey.sql (26,206 bytes)
Bug heat4
Complete LimeSurvey version number (& build)1088-limesurvey205plus-build
I will donate to the project if issue is resolvedNo
BrowserIE11
Database type & versionMySQL 5.5
Server OS (if known)Debian 7
Webserver software & version (if known)apache2
PHP Version5
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-03-21 08:46

administrator   ~29469

1088-limesurvey205plus-build is not a valid build. Where did you get that one?
The error usually shows that the database was not correctly installed or the configured DB settings are wrong.

sprouse

sprouse

2014-03-21 12:02

reporter   ~29482

I got it from here http://www.limesurvey.org/en/stable-release/finish/25-latest-stable-release/1088-limesurvey205plus-build140320-tar-gz

c_schmitz

c_schmitz

2014-03-21 12:28

administrator   ~29484

Ah, so the build number is 140320. Anyway, I cannot reproduce this at all.
Did you check if the database is properly populated and did you check the contents of /application/config/config.php if the database credentials match? Does the database user have the necessary permissions?

sprouse

sprouse

2014-03-21 14:05

reporter   ~29490

as far as I can tell the db was created ok. The installer said it created and I created it using root. I've looked at the db online and there are many tables. What I failed to tell you was that the wizard error'd out immediately after creating the Admin user process. I can restart and run through the install again and provide that error message if helpful.

c_schmitz

c_schmitz

2014-03-21 14:56

administrator   ~29491

Last edited: 2014-03-21 14:57

Please do - and check the contents of /application/config/config.php

sprouse

sprouse

2014-03-21 15:00

reporter   ~29493

here is the error

Internal Server Error

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

An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

c_schmitz

c_schmitz

2014-03-21 15:09

administrator   ~29494

Well, the table users is obviously there (as I can see in your db dump).

As it works here I think it may be a bug in your PHP version, to be precise, the mysql Db driver and/or caching. YOu could try updating your PHP version.
I don't think it is a LimeSurvey error as other PHP/MySQL users have no problems so it must be something with your system.

As said, try updating to the latest 5.5.x version.

sprouse

sprouse

2014-03-22 13:20

reporter   ~29500

I installed version 992-limesurvey192plus-build120919-zip and it works fine. just fyi.

c_schmitz

c_schmitz

2014-03-22 14:45

administrator   ~29501

Yes. LimeSurvey 1.92 uses a different database driver. One more reason for being a bug in the DB driver.

c_schmitz

c_schmitz

2014-04-04 10:26

administrator   ~29673

2.05+ Build 140404 released.

Issue History

Date Modified Username Field Change
2014-03-21 02:54 sprouse New Issue
2014-03-21 08:46 c_schmitz Note Added: 29469
2014-03-21 08:46 c_schmitz Assigned To => c_schmitz
2014-03-21 08:46 c_schmitz Status new => feedback
2014-03-21 12:02 sprouse Note Added: 29482
2014-03-21 12:02 sprouse Status feedback => assigned
2014-03-21 12:28 c_schmitz Note Added: 29484
2014-03-21 12:28 c_schmitz Status assigned => feedback
2014-03-21 14:05 sprouse Note Added: 29490
2014-03-21 14:05 sprouse Status feedback => assigned
2014-03-21 14:05 sprouse File Added: limesurvey.sql
2014-03-21 14:56 c_schmitz Note Added: 29491
2014-03-21 14:57 c_schmitz Note Edited: 29491
2014-03-21 14:57 c_schmitz Status assigned => feedback
2014-03-21 15:00 sprouse Note Added: 29493
2014-03-21 15:00 sprouse Status feedback => assigned
2014-03-21 15:09 c_schmitz Note Added: 29494
2014-03-21 15:09 c_schmitz Status assigned => resolved
2014-03-21 15:09 c_schmitz Resolution open => unable to reproduce
2014-03-22 13:20 sprouse Note Added: 29500
2014-03-22 13:20 sprouse Status resolved => feedback
2014-03-22 13:20 sprouse Resolution unable to reproduce => reopened
2014-03-22 14:45 c_schmitz Note Added: 29501
2014-03-22 14:45 c_schmitz Status feedback => resolved
2014-03-22 14:45 c_schmitz Resolution reopened => unable to reproduce
2014-04-04 10:26 c_schmitz Note Added: 29673
2014-04-04 10:26 c_schmitz Status resolved => closed