CDbException

CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 144 Table './creole01_nouvoo/user_log' is marked as crashed and last (automatic?) repair failed. The SQL statement executed was: INSERT into user_log (url,domain,user_id,controller,action,module_id,item_id,is_bot,request,session,user_agent,referer,ip,timestamp) VALUES ('/guadeloupe','www.nouvoo.fr','','portal','render','0','0','1','array (
\'department_id\' => 1,
1 => \'\',
)','9agscik53ipt2o6rmslfv03rm0','claudebot','','23.20.220.59','2024-03-19 07:05:10')

/home2/creole01/nouvoo.fr/domains/prod.nouvoo.fr/public_html/framework/db/CDbCommand.php(358)

346         {
347             if($this->_connection->enableProfiling)
348                 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().$par.')','system.db.CDbCommand.execute');
349 
350             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
351             $message=$e->getMessage();
352             Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
353                 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
354 
355             if(YII_DEBUG)
356                 $message.='. The SQL statement executed was: '.$this->getText().$par;
357 
358             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
359                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
360         }
361     }
362 
363     /**
364      * Executes the SQL statement and returns query result.
365      * This method is for executing an SQL query that returns result set.
366      * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative
367      * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
368      * them in this way can improve the performance. Note that if you pass parameters in this way,
369      * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
370      * Please also note that all values are treated as strings in this case, if you need them to be handled as

Stack Trace

#0
+
 /home2/creole01/nouvoo.fr/domains/prod.nouvoo.fr/public_html/protected/helpers/helpers.php(804): CDbCommand->execute()
799     }
800     
801     $sql = "INSERT into " . $tablename . " (" . $keys_str . ") VALUES (" . $values_str . ")";    
802     
803     $command=Yii::app()->db->createCommand($sql);
804     $ret=$command->execute();
805     
806     if ($return_id)
807         return Yii::app()->db->getLastInsertID();
808     else
809         return $ret;
#1
+
 /home2/creole01/nouvoo.fr/domains/prod.nouvoo.fr/public_html/protected/extensions/giix-components/GxController.php(195): insert("user_log", array("url" => "/guadeloupe", "domain" => "www.nouvoo.fr", "user_id" => null, "controller" => "portal", ...))
190                 'user_agent' => $_SERVER['HTTP_USER_AGENT'],
191                 'referer' => $_SERVER['HTTP_REFERER'],
192                 'ip' => $_SERVER['REMOTE_ADDR'],
193                 'timestamp' => NOW,
194             );
195             insert("user_log",$entry);
196             
197             if ($this->getId()=='api' && $this->getAction()->getId()=='mail')
198                 $_SESSION['mail_api_log']=date("YmdH");
199         }        
200     }
#11
+
 /home2/creole01/nouvoo.fr/domains/prod.nouvoo.fr/public_html/index.php(58): CApplication->run()
53         // header("Location: http://pro.".AP_DOMAIN_NAME."/".$url);
54         // exit;
55     // }
56 
57 require_once($yii);
58 Yii::createWebApplication($config)->run();
2024-03-19 07:05:11 Apache Yii Framework/1.1.14