Elternsprechtagsanwendung (ESTA)

<localhost>

Error 500: <h1>CDbException</h1>
<p>CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dateAndTime.id' in 'order clause'. The SQL statement executed was: SELECT `t`.`id` AS `t0_c0`, `t`.`reason` AS `t0_c1`, `t`.`dateAndTime_id` AS `t0_c2`, `t`.`user_id` AS `t0_c3`, `user`.`id` AS `t1_c0`, `user`.`username` AS `t1_c1`, `user`.`email` AS `t1_c2`, `user`.`activationKey` AS `t1_c3`, `user`.`createtime` AS `t1_c4`, `user`.`firstname` AS `t1_c5`, `user`.`lastname` AS `t1_c6`, `user`.`title` AS `t1_c7`, `user`.`state` AS `t1_c8`, `user`.`lastLogin` AS `t1_c9`, `user`.`badLogins` AS `t1_c10`, `user`.`bannedUntil` AS `t1_c11`, `user`.`password` AS `t1_c12`, `dateandtime`.`id` AS `t2_c0`, `dateandtime`.`time` AS `t2_c1`, `dateandtime`.`date_id` AS `t2_c2` FROM `blockedAppointment` `t` LEFT OUTER JOIN `user` `user` ON (`t`.`user_id`=`user`.`id`) LEFT OUTER JOIN `dateAndTime` `dateandtime` ON (`t`.`dateAndTime_id`=`dateandtime`.`id`) ORDER BY dateAndTime.id LIMIT 10 (/home/cehringfeld/public_html/esta/trunk/src/framework/db/CDbCommand.php:543)</p>

#0 /home/cehringfeld/public_html/esta/trunk/src/framework/db/CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 /home/cehringfeld/public_html/esta/trunk/src/framework/db/ar/CActiveFinder.php(803): CDbCommand->queryAll()
#2 /home/cehringfeld/public_html/esta/trunk/src/framework/db/ar/CActiveFinder.php(437): CJoinElement->runQuery(Object(CJoinQuery))
#3 /home/cehringfeld/public_html/esta/trunk/src/framework/db/ar/CActiveFinder.php(68): CJoinElement->find(Object(CDbCriteria))
#4 /home/cehringfeld/public_html/esta/trunk/src/framework/db/ar/CActiveRecord.php(1356): CActiveFinder->query(Object(CDbCriteria), true)
#5 /home/cehringfeld/public_html/esta/trunk/src/framework/db/ar/CActiveRecord.php(1470): CActiveRecord->query(Object(CDbCriteria), true)
#6 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CActiveDataProvider.php(199): CActiveRecord->findAll(Object(CDbCriteria))
#7 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CDataProvider.php(168): CActiveDataProvider->fetchData()
#8 /home/cehringfeld/public_html/esta/trunk/src/framework/zii/widgets/CBaseListView.php(111): CDataProvider->getData()
#9 /home/cehringfeld/public_html/esta/trunk/src/framework/zii/widgets/grid/CGridView.php(339): CBaseListView->init()
#10 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CBaseController.php(147): CGridView->init()
#11 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CBaseController.php(172): CBaseController->createWidget('zii.widgets.gri...', Array)
#12 /home/cehringfeld/public_html/esta/trunk/src/protected/views/appointment/admin.php(93): CBaseController->widget('zii.widgets.gri...', Array)
#13 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CBaseController.php(126): require('/home/cehringfe...')
#14 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CBaseController.php(95): CBaseController->renderInternal('/home/cehringfe...', Array, true)
#15 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CController.php(869): CBaseController->renderFile('/home/cehringfe...', Array, true)
#16 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CController.php(782): CController->renderPartial('admin', Array, true)
#17 /home/cehringfeld/public_html/esta/trunk/src/protected/controllers/AppointmentController.php(372): CController->render('admin', Array)
#18 /home/cehringfeld/public_html/esta/trunk/src/framework/web/actions/CInlineAction.php(49): AppointmentController->actionAdmin()
#19 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CController.php(308): CInlineAction->runWithParams(Array)
#20 /home/cehringfeld/public_html/esta/trunk/src/framework/web/filters/CFilterChain.php(133): CController->runAction(Object(CInlineAction))
#21 /home/cehringfeld/public_html/esta/trunk/src/framework/web/filters/CFilter.php(40): CFilterChain->run()
#22 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CController.php(1145): CFilter->filter(Object(CFilterChain))
#23 /home/cehringfeld/public_html/esta/trunk/src/framework/web/filters/CInlineFilter.php(58): CController->filterAccessControl(Object(CFilterChain))
#24 /home/cehringfeld/public_html/esta/trunk/src/framework/web/filters/CFilterChain.php(130): CInlineFilter->filter(Object(CFilterChain))
#25 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CController.php(291): CFilterChain->run()
#26 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CController.php(265): CController->runActionWithFilters(Object(CInlineAction), Array)
#27 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CWebApplication.php(282): CController->run('admin')
#28 /home/cehringfeld/public_html/esta/trunk/src/framework/web/CWebApplication.php(141): CWebApplication->runController('appointment/adm...')
#29 /home/cehringfeld/public_html/esta/trunk/src/framework/base/CApplication.php(180): CWebApplication->processRequest()
#30 /home/cehringfeld/public_html/esta/trunk/src/index.php(30): CApplication->run()
#31 {main}

Zeile 126-129 models/Appointment.php