This problem has small description here
http://code.google.com/p/yii/issues/detail?id=1207
But after erase all assets problem do not repeat.
But i spend 2 hours for find where is bug and i hope yii team can say whats up?
My full description with examples:
Models
class Project extends CActiveRecord{
public function relations(){
return array('seo'=> array(self::BELONGS_TO, 'User', 'seoid', 'alias'=>'seo'),)
}
}
class User extends CActiveRecord{
//Simple class for example
}
class TestController extends CController{
public function actionShow(){
//Work fine
// $prj=Project::model()->findByPk(intval($_GET['projectid']) );
//Doesnot work
$prj=Project::model()->with('seo')->findByPk(intval($_GET['projectid']) );
}
}
And full stack trace
Stack trace:
#0 C:\xampp\htdocs\yii\framework\db\CDbCommand.php(265): CDbCommand->queryInternal('fetchAll', 2, Array)
#1 C:\xampp\htdocs\yii\framework\db\ar\CActiveFinder.php(739): CDbCommand->queryAll()
#2 C:\xampp\htdocs\yii\framework\db\ar\CActiveFinder.php(413): CJoinElement->runQuery(Object(CJoinQuery))
#3 C:\xampp\htdocs\yii\framework\db\ar\CActiveFinder.php(85): CJoinElement->find(Object(CDbCriteria))
#4 C:\xampp\htdocs\yii\framework\db\ar\CActiveFinder.php(143): CActiveFinder->query(Object(CDbCriteria))
#5 C:\xampp\htdocs\sp\protected\controllers\TodoController.php(425): CActiveFinder->findByAttributes(Array)
#6 C:\xampp\htdocs\yii\framework\web\actions\CInlineAction.php(32): TodoController->actionAutoCompleteLookup()
#7 C:\xampp\htdocs\yii\framework\web\CController.php(300): CInlineAction->run()
#8 C:\xampp\htdocs\yii\framework\web\filters\CFilterChain.php(129): CController->runAction(Object(CInlineAction))
#9 C:\xampp\htdocs\yii\framework\web\filters\CFilter.php(41): CFilterChain->run()
#10 C:\xampp\htdocs\yii\framework\web\CController.php(999): CFilter->filter(Object(CFilterChain))
#11 C:\xampp\htdocs\yii\framework\web\filters\CInlineFilter.php(59): CController->filterAccessControl(Object(CFilterChain))
#12 C:\xampp\htdocs\yii\framework\web\filters\CFilterChain.php(126): CInlineFilter->filter(Object(CFilterChain))
#13 C:\xampp\htdocs\yii\framework\web\CController.php(283): CFilterChain->run()
#14 C:\xampp\htdocs\yii\framework\web\CController.php(257): CController->runActionWithFilters(Object(CInlineAction), Array)
#15 C:\xampp\htdocs\yii\framework\web\CWebApplication.php(320): CController->run('AutoCompleteLoo...')
#16 C:\xampp\htdocs\yii\framework\web\CWebApplication.php(120): CWebApplication->runController('todo/AutoComple...')
#17 C:\xampp\htdocs\yii\framework\base\CApplication.php(135): CWebApplication->processRequest()
#18 C:\xampp\htdocs\sp\index.php(15): CApplication->run()
#19 {main} REQUEST_URI=/index.php?r=test/show&q=aasdfds&limit=10×tamp=1273656577867&type=worker&projectid=262
2010/05/12 16:50:09 [error] [system.db.CDbCommand] Error in querying SQL: SELECT "project"."title" AS "t0_c0", "project"."budget_max" AS "t0_c1", "project"."budget_current" AS "t0_c2", "project"."cost" AS "t0_c3", "project"."site" AS "t0_c4", "project"."salesid" AS "t0_c5", "project"."seoid" AS "t0_c6", "project"."analyticid" AS "t0_c7", "project"."stausdescription" AS "t0_c8", "project"."status" AS "t0_c9", "project"."created" AS "t0_c10", "project"."id" AS "t0_c11", "project"."clientid" AS "t0_c12", "project"."intelsiblink" AS "t0_c13", "project"."paytime" AS "t0_c14", "project"."starttime" AS "t0_c15", "project"."debt" AS "t0_c16", "project"."pointsnow" AS "t0_c17", "project"."pointslast" AS "t0_c18", "project"."host_pwd" AS "t0_c19", "project"."host_usr" AS "t0_c20", "project"."ssh_pwd" AS "t0_c21", "project"."ssh_usr" AS "t0_c22", "project"."bd_pwd" AS "t0_c23", "project"."bd_usr" AS "t0_c24", "project"."adm_pwd" AS "t0_c25", "project"."adm_usr" AS "t0_c26", "project"."ftp_pwd" AS "t0_c27", "project"."ftp_usr" AS "t0_c28", "project"."host_server" AS "t0_c29", "project"."ssh_server" AS "t0_c30", "project"."ftp_server" AS "t0_c31", "project"."adm_server" AS "t0_c32", "project"."type" AS "t0_c33", "project"."top10" AS "t0_c34", "project"."top5" AS "t0_c35", "project"."top3" AS "t0_c36", "project"."state" AS "t0_c37", "project"."prompt_days" AS "t0_c38", "project"."prompt_status" AS "t0_c39", "project"."prompt_viewed" AS "t0_c40", "project"."show_cost" AS "t0_c41", "project"."partnerid" AS "t0_c42", "project"."copyrighterid" AS "t0_c43", "seo"."id" AS "t1_c0", "seo"."username" AS "t1_c1", "seo"."password" AS "t1_c2", "seo"."status" AS "t1_c3" FROM "Project" "project" LEFT OUTER JOIN "User" "seo" ON ("project"."seoid"="seo"."id") WHERE ("t"."id"=:yp0). Bind with parameter :yp0=262
2010/05/12 16:50:09 [error] [exception.CDbException] exception 'CDbException' with message 'CDbCommand failed to execute the SQL statement: SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "t"
LINE 1: ...r" "seo" ON ("project"."seoid"="seo"."id") WHERE ("t"."id"=$...
^' in C:\xampp\htdocs\yii\framework\db\CDbCommand.php:375