11943: Error during Installation - Right after admin user creation

This issue affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update
11943	Bug reports	Installation	public	2016-11-22 19:43	2016-11-23 10:30

Reporter	jansch2015	Assigned To	c_schmitz
Priority	none	Severity	block
Status	closed	Resolution	unable to reproduce
Product Version	2.55.x

Summary	11943: Error during Installation - Right after admin user creation
Description	Installation does not work. (See debugging info attached, Debug-Mode 2) Database has been created successfully including tables in database. (database is being created by LimeSurvey installation) But after setting the initial password for the administrator the attached exception occurs.
Steps To Reproduce	Download and unpack limesurvey ZIP. Changing permission to 777 of the following directories: upload/ tmp/ application/config/ Using "root" as database user. (letting create database by installation setup)
Additional Information	System Information: LimeSurvey Version: Release 161118 (2.56.1) MySQL Version: 5.5.52 PHP Version: 5.6.27-0+deb8u1 Linux: Linux raspberrypi 4.4.21+ #911 Thu Sep 15 14:17:52 BST 2016 armv6l Webserver: Apache 2
Tags	No tags attached.
Attached Files	Exception.htm (14,092 bytes) <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"><head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Exception</title> <style type="text/css"> /<![CDATA[/ html,body,div,span,applet,object,iframe,h1,h2,h3,h4,h5,h6,p,blockquote,pre,a,abbr,acronym,address,big,cite,code,del,dfn,em,font,img,ins,kbd,q,s,samp,small,strike,strong,sub,sup,tt,var,b,u,i,center,dl,dt,dd,ol,ul,li,fieldset,form,label,legend,table,caption,tbody,tfoot,thead,tr,th,td{border:0;outline:0;font-size:100%;vertical-align:baseline;background:transparent;margin:0;padding:0;} body{line-height:1;} ol,ul{list-style:none;} blockquote,q{quotes:none;} blockquote:before,blockquote:after,q:before,q:after{content:none;} :focus{outline:0;} ins{text-decoration:none;} del{text-decoration:line-through;} table{border-collapse:collapse;border-spacing:0;} body { font: normal 9pt "Verdana"; color: #000; background: #fff; } h1 { font: normal 18pt "Verdana"; color: #f00; margin-bottom: .5em; } h2 { font: normal 14pt "Verdana"; color: #800000; margin-bottom: .5em; } h3 { font: bold 11pt "Verdana"; } pre { font: normal 11pt Menlo, Consolas, "Lucida Console", Monospace; } pre span.error { display: block; background: #fce3e3; } pre span.ln { color: #999; padding-right: 0.5em; border-right: 1px solid #ccc; } pre span.error-ln { font-weight: bold; } .container { margin: 1em 4em; } .version { color: gray; font-size: 8pt; border-top: 1px solid #aaa; padding-top: 1em; margin-bottom: 1em; } .message { color: #000; padding: 1em; font-size: 11pt; background: #f3f3f3; -webkit-border-radius: 10px; -moz-border-radius: 10px; border-radius: 10px; margin-bottom: 1em; line-height: 160%; } .source { margin-bottom: 1em; } .code pre { background-color: #ffe; margin: 0.5em 0; padding: 0.5em; line-height: 125%; border: 1px solid #eee; } .source .file { margin-bottom: 1em; font-weight: bold; } .traces { margin: 2em 0; } .trace { margin: 0.5em 0; padding: 0.5em; } .trace.app { border: 1px dashed #c00; } .trace .number { text-align: right; width: 2em; padding: 0.5em; } .trace .content { padding: 0.5em; } .trace .plus, .trace .minus { display:inline; vertical-align:middle; text-align:center; border:1px solid #000; color:#000; font-size:10px; line-height:10px; margin:0; padding:0 1px; width:10px; height:10px; } .trace.collapsed .minus, .trace.expanded .plus, .trace.collapsed pre { display: none; } .trace-file { cursor: pointer; padding: 0.2em; } .trace-file:hover { background: #f0ffff; } /]]>/ </style> </head> <body> <div class="container"> <h1>Exception</h1> <p class="message"> Could not add optional settings: exception 'CDbException' with message 'The table "{{users}}" for active record class "User" cannot be found in the database.' in /var/www/html/limesurvey/framework/db/ar/CActiveRecord.php:2387<br> Stack trace:<br> #0 /var/www/html/limesurvey/framework/db/ar/CActiveRecord.php(411): CActiveRecordMetaData->__construct(Object(User))<br> #1 /var/www/html/limesurvey/framework/db/ar/CActiveRecord.php(680): CActiveRecord->getMetaData()<br> #2 /var/www/html/limesurvey/application/models/LSActiveRecord.php(29): CActiveRecord->hasAttribute('created')<br> #3 /var/www/html/limesurvey/framework/db/ar/CActiveRecord.php(396): LSActiveRecord->behaviors()<br> #4 /var/www/html/limesurvey/application/models/User.php(33): CActiveRecord::model('User')<br> #5 /var/www/html/limesurvey/application/controllers/InstallerController.php(659): User::model()<br> #6 /var/www/html/limesurvey/application/controllers/InstallerController.php(83): InstallerController->stepOptionalConfiguration()<br> #7 /var/www/html/limesurvey/framework/web/CWebApplication.php(282): InstallerController->run('optional')<br> #8 /var/www/html/limesurvey/framework/web/CWebApplication.php(141): CWebApplication->runController('installer/optio...')<br> #9 /var/www/html/limesurvey/framework/base/CApplication.php(185): CWebApplication->processRequest()<br> #10 /var/www/html/limesurvey/index.php(214): CApplication->run()<br> #11 {main}. </p> <div class="source"> <p class="file">/var/www/html/limesurvey/application/controllers/InstallerController.php(692)</p> <div class="code"><pre><span class="ln">680</span> $permission->permission='superadmin'; <span class="ln">681</span> $permission->read_p=1; <span class="ln">682</span> $permission->save(); <span class="ln">683</span> // Save global settings <span class="ln">684</span> $this->connection->createCommand()->insert("{{settings_global}}", array('stg_name' => 'SessionName', 'stg_value' => self::_getRandomString())); <span class="ln">685</span> $this->connection->createCommand()->insert("{{settings_global}}", array('stg_name' => 'sitename', 'stg_value' => $sSiteName)); <span class="ln">686</span> $this->connection->createCommand()->insert("{{settings_global}}", array('stg_name' => 'siteadminname', 'stg_value' => $sAdminRealName)); <span class="ln">687</span> $this->connection->createCommand()->insert("{{settings_global}}", array('stg_name' => 'siteadminemail', 'stg_value' => $sAdminEmail)); <span class="ln">688</span> $this->connection->createCommand()->insert("{{settings_global}}", array('stg_name' => 'siteadminbounce', 'stg_value' => $sAdminEmail)); <span class="ln">689</span> $this->connection->createCommand()->insert("{{settings_global}}", array('stg_name' => 'defaultlang', 'stg_value' => $sSiteLanguage)); <span class="ln">690</span> // only continue if we're error free otherwise setup is broken. <span class="ln">691</span> } catch (Exception $e) { <span class="error"><span class="ln error-ln">692</span> throw new Exception(sprintf('Could not add optional settings: %s.', $e)); </span><span class="ln">693</span> } <span class="ln">694</span> <span class="ln">695</span> Yii::app()->session['deletedirectories'] = true; <span class="ln">696</span> <span class="ln">697</span> $aData['title'] = gT("Success!"); <span class="ln">698</span> $aData['descp'] = gT("LimeSurvey has been installed successfully."); <span class="ln">699</span> $aData['classesForStep'] = array('off','off','off','off','off','off'); <span class="ln">700</span> $aData['progressValue'] = 100; <span class="ln">701</span> $aData['user'] = $sAdminUserName; <span class="ln">702</span> if($sDefaultAdminPassword==$sAdminPassword){ <span class="ln">703</span> $aData['pwd'] = $sAdminPassword; <span class="ln">704</span> }else{ </pre></div> </div> <div class="traces"> <h2>Stack Trace</h2> <table style="width:100%;"> <tbody><tr class="trace app expanded"> <td class="number"> #0 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /var/www/html/limesurvey/application/controllers/InstallerController.php(83): <strong>InstallerController</strong>-><strong>stepOptionalConfiguration</strong>() </div> <div class="code"><pre><span class="ln">78</span> case 'populatedb': <span class="ln">79</span> $this->stepPopulateDb(); <span class="ln">80</span> break; <span class="ln">81</span> <span class="ln">82</span> case 'optional': <span class="error"><span class="ln error-ln">83</span> $this->stepOptionalConfiguration(); </span><span class="ln">84</span> break; <span class="ln">85</span> <span class="ln">86</span> case 'index' : <span class="ln">87</span> default : <span class="ln">88</span> $this->redirect(array('installer/welcome')); </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #1 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /var/www/html/limesurvey/framework/web/CWebApplication.php(282): <strong>InstallerController</strong>-><strong>run</strong>("optional") </div> <div class="code"><pre><span class="ln">277</span> { <span class="ln">278</span> list($controller,$actionID)=$ca; <span class="ln">279</span> $oldController=$this->_controller; <span class="ln">280</span> $this->_controller=$controller; <span class="ln">281</span> $controller->init(); <span class="error"><span class="ln error-ln">282</span> $controller->run($actionID); </span><span class="ln">283</span> $this->_controller=$oldController; <span class="ln">284</span> } <span class="ln">285</span> else <span class="ln">286</span> throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', <span class="ln">287</span> array('{route}'=>$route===''?$this->defaultController:$route))); </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #2 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /var/www/html/limesurvey/framework/web/CWebApplication.php(141): <strong>CWebApplication</strong>-><strong>runController</strong>("installer/optional") </div> <div class="code"><pre><span class="ln">136</span> foreach(array_splice($this->catchAllRequest,1) as $name=>$value) <span class="ln">137</span> $_GET[$name]=$value; <span class="ln">138</span> } <span class="ln">139</span> else <span class="ln">140</span> $route=$this->getUrlManager()->parseUrl($this->getRequest()); <span class="error"><span class="ln error-ln">141</span> $this->runController($route); </span><span class="ln">142</span> } <span class="ln">143</span> <span class="ln">144</span> /** <span class="ln">145</span> * Registers the core application components. <span class="ln">146</span> * This method overrides the parent implementation by registering additional core components. </pre></div> </td> </tr> <tr class="trace core collapsed"> <td class="number"> #3 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /var/www/html/limesurvey/framework/base/CApplication.php(185): <strong>CWebApplication</strong>-><strong>processRequest</strong>() </div> <div class="code"><pre><span class="ln">180</span> public function run() <span class="ln">181</span> { <span class="ln">182</span> if($this->hasEventHandler('onBeginRequest')) <span class="ln">183</span> $this->onBeginRequest(new CEvent($this)); <span class="ln">184</span> register_shutdown_function(array($this,'end'),0,false); <span class="error"><span class="ln error-ln">185</span> $this->processRequest(); </span><span class="ln">186</span> if($this->hasEventHandler('onEndRequest')) <span class="ln">187</span> $this->onEndRequest(new CEvent($this)); <span class="ln">188</span> } <span class="ln">189</span> <span class="ln">190</span> /** </pre></div> </td> </tr> <tr class="trace app expanded"> <td class="number"> #4 </td> <td class="content"> <div class="trace-file"> <div class="plus">+</div> <div class="minus">–</div>  /var/www/html/limesurvey/index.php(214): <strong>CApplication</strong>-><strong>run</strong>() </div> <div class="code"><pre><span class="ln">209</span> die (sprintf('%s should be writable by the webserver (766 or 776).', $sDefaultRuntimePath)); <span class="ln">210</span> } <span class="ln">211</span> } <span class="ln">212</span> <span class="ln">213</span> Yii::$enableIncludePath = false; <span class="error"><span class="ln error-ln">214</span> Yii::createApplication('LSYii_Application', $config)->run(); </span><span class="ln">215</span> <span class="ln">216</span> /* End of file index.php / <span class="ln">217</span> / Location: ./index.php / </pre></div> </td> </tr> </tbody></table> </div> <div class="version"> 2016-11-22 19:22:45 Apache/2.4.10 (Raspbian) <a href="http://www.yiiframework.com/">Yii Framework</a>/1.1.17 </div> </div> <script type="text/javascript"> /<![CDATA[/ var traceReg = new RegExp("(^\|\\s)trace-file(\\s\|$)"); var collapsedReg = new RegExp("(^\|\\s)collapsed(\\s\|$)"); var e = document.getElementsByTagName("div"); for(var j=0,len=e.length;j<len;j++){ if(traceReg.test(e[j].className)){ e[j].onclick = function(){ var trace = this.parentNode.parentNode; if(collapsedReg.test(trace.className)) trace.className = trace.className.replace("collapsed", "expanded"); else trace.className = trace.className.replace("expanded", "collapsed"); } } } /]]>*/ </script> </body></html> Exception.htm (14,092 bytes)

Bug heat	6
Complete LimeSurvey version number (& build)	2.56.1 161118
I will donate to the project if issue is resolved	No
Browser	Firefox (probably irrelevant)
Database type & version	MySQL 5.5.52
Server OS (if known)	Linux raspberrypi 4.4.21+ #911 Thu Sep 15 14:17:52 BST 2016 armv6l
Webserver software & version (if known)	Apache/2.4.10 (Raspbian)
PHP Version	5.6.27

User List	There are no users monitoring this issue.

DenisChenu 2016-11-23 00:56 developer ~42163	Did you try to install it before with just updating "prefix" for database ? And removed config.php ?

jansch2015 2016-11-23 08:14 reporter ~42166	Yes. Tried reinstalling 3 times, removed entire directory every time and deleted database.

DenisChenu 2016-11-23 08:50 developer ~42167 Last edited: 2016-11-23 08:51	https://bugs.limesurvey.org/view.php?id=8958 Try, before a new install rm -Rf /tmp/runtime/* [EDIT] sorry : don't see the 'rm entire directory'

c_schmitz 2016-11-23 09:09 administrator ~42168	I don't see how that is related to 08958 ?

DenisChenu 2016-11-23 09:13 developer ~42169	Near same error: Internal server error : Could not add optional settings: exception 'CDbException' One with Integrity constraint violation: (user table) and other one with The table "{{users}}" for active record class "User" User table. Unsure, but seems to be near.

c_schmitz 2016-11-23 09:15 administrator ~42170 Last edited: 2016-11-23 09:16	Unlikely, also most likely a system configuration issue, otherwise we had lots of people complaining. @jansch2015, when you get the error, can you check the contents of your database? Are there any tables? If yes, what tables? Also post the contents of the /application/config/config.php file (without passwords) please.

DenisChenu 2016-11-23 09:19 developer ~42171	PS : can not reproduce even with reinstall a second time with a new prefix with 2.56.1 - 161118

jansch2015 2016-11-23 10:14 reporter ~42179	I just tried it again... and of course today it worked perfectly fine :) I swear, I followed EXACTLY THE SAME PROCEDURE!!! I have no idea why i'ts working now. Nothing has changed since yesterday. Anyway, problem solved. I am amazed by the quick support I got here. Thank you! PS: @c_schmitz to answer your question: The database and tables were created successfully yesterday. I checked that.

c_schmitz 2016-11-23 10:30 administrator ~42183	OK, thank you for the feedback.

Date Modified	Username	Field	Change
2016-11-22 19:43	jansch2015	New Issue
2016-11-22 19:43	jansch2015	File Added: Exception.htm
2016-11-23 00:56	DenisChenu	Note Added: 42163
2016-11-23 08:14	jansch2015	Note Added: 42166
2016-11-23 08:50	DenisChenu	Note Added: 42167
2016-11-23 08:51	DenisChenu	Note Edited: 42167
2016-11-23 09:06	DenisChenu	Relationship added	related to 08958
2016-11-23 09:09	c_schmitz	Relationship deleted	related to 08958
2016-11-23 09:09	c_schmitz	Note Added: 42168
2016-11-23 09:13	DenisChenu	Note Added: 42169
2016-11-23 09:15	c_schmitz	Assigned To	=> c_schmitz
2016-11-23 09:15	c_schmitz	Status	new => feedback
2016-11-23 09:15	c_schmitz	Note Added: 42170
2016-11-23 09:16	c_schmitz	Note Edited: 42170
2016-11-23 09:19	DenisChenu	Note Added: 42171
2016-11-23 10:14	jansch2015	Note Added: 42179
2016-11-23 10:14	jansch2015	Status	feedback => assigned
2016-11-23 10:30	c_schmitz	Status	assigned => closed
2016-11-23 10:30	c_schmitz	Resolution	open => unable to reproduce
2016-11-23 10:30	c_schmitz	Note Added: 42183

View Issue Details

Users monitoring this issue

Activities

Issue History