YUM 0.8-rc7, mysql Ver 14.14 Distrib 5.5.30 php 5.5, apache webserver 2.2.25
using standard testdrive application
when clicking on "My Inbox", the following error occurs. A very similar error occurs when clicking "Sent messages".
CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'admin' in 'where clause'. The SQL statement executed was: SELECT COUNT(*) FROM messaget WHERE to_user_id = admin
– /Volumes/Static Backups/Dropbox/www/testdrive/index.php(13): CApplication->run()
08 defined('YII_DEBUG') or define('YII_DEBUG',true);
09 // specify how many levels of call stack should be shown in each log message
10 defined('YII_TRACE_LEVEL') or define('YII_TRACE_LEVEL',3);
11
12 require_once($yii);
13 Yii::createWebApplication($config)->run();
YUM 0.8-rc7, mysql Ver 14.14 Distrib 5.5.30 php 5.5, apache webserver 2.2.25 using standard testdrive application when clicking on "My Inbox", the following error occurs. A very similar error occurs when clicking "Sent messages".
CDbException
CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'admin' in 'where clause'. The SQL statement executed was: SELECT COUNT(*) FROM
messagetWHERE to_user_id = admin/Volumes/Static Backups/Dropbox/yii-1.1.14.f0fee9/framework/db/CDbCommand.php(543)
531 { 532 if($this->_connection->enableProfiling) 533 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query'); 534 535 $errorInfo=$e instanceof PDOException ? $e->errorInfo : null; 536 $message=$e->getMessage(); 537 Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.', 538 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand'); 539 540 if(YII_DEBUG) 541 $message.='. The SQL statement executed was: '.$this->getText().$par; 542 543 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}', 544 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo); 545 } 546 } 547 548 /* 549 * Builds a SQL SELECT statement from the given query specification. 550 * @param array $query the query specification in name-value pairs. The following 551 * query options are supported: {@link select}, {@link distinct}, {@link from}, 552 * {@link where}, {@link join}, {@link group}, {@link having}, {@link order}, 553 * {@link limit}, {@link offset} and {@link union}. 554 * @throws CDbException if "from" key is not present in given query parameter 555 \ @return string the SQL statement Stack Trace
0
1
2
3
4
5
6
7
8
9
10
– /Volumes/Static Backups/Dropbox/www/testdrive/protected/modules/message/views/message/index.php(38): CBaseController->widget("zii.widgets.grid.CGridView", array("id" => "yum-message-grid", "dataProvider" => CActiveDataProvider, "columns" => array(array("type" => "raw", "name" => "From", "value" => "CHtml::link($data->from_user->username, array( Yum::route..."), array("type" => "raw", "name" => "title", "value" => "CHtml::link($data->getTitle(), array("view", "id" => $data->id))"), array("name" => "timestamp", "value" => "$data->getDate()"), array("class" => "CButtonColumn", "template" => "{view}{delete}")))) 33 array( 34 'class'=>'CButtonColumn', 35 'template' => '{view}{delete}', 36 ), 37 ), 38 )); ?>
11
12
13
14
15
– /Volumes/Static Backups/Dropbox/www/testdrive/protected/modules/message/controllers/YumMessageController.php(109): CController->render("application.modules.message.views.message.index", array("model" => YumMessage)) 104 public function actionIndex() 105 { 106 $model = new YumMessage; 107 108 $this->render(Yum::module('message')->inboxView, array( 109 'model'=> $model)); 110 } 111 112 public function actionSent() 113 { 114 $model = new YumMessage;
16
17
18
19
20
21
22
23
24
25
26
27
28
– /Volumes/Static Backups/Dropbox/www/testdrive/index.php(13): CApplication->run() 08 defined('YII_DEBUG') or define('YII_DEBUG',true); 09 // specify how many levels of call stack should be shown in each log message 10 defined('YII_TRACE_LEVEL') or define('YII_TRACE_LEVEL',3); 11 12 require_once($yii); 13 Yii::createWebApplication($config)->run();