CDbException

CDbCommand::fetchAll() failed: SQLSTATE[42S22]: Column not found: 1054
Unknown column '20DESC' in 'order clause'. The SQL statement executed was:
SELECT DISTINCT `t`.`Id` AS `t0_c0`, `t`.`UserId` AS `t0_c1`, `t`.`Type` AS
`t0_c2`, `t`.`Title` AS `t0_c3`, `t`.`TitleTranslated` AS `t0_c4`,
`t`.`Alias` AS `t0_c5`, `t`.`Description` AS `t0_c6`, `t`.`DesTranslated`
AS `t0_c7`, `t`.`Tags` AS `t0_c8`, `t`.`IsFeatured` AS `t0_c9`,
`t`.`ReferrerUrl` AS `t0_c10`, `t`.`ReferrerName` AS `t0_c11`, `t`.`Status`
AS `t0_c12`, `t`.`Created` AS `t0_c13`, `t`.`Updated` AS `t0_c14`,
`t`.`Views` AS `t0_c15`, `t`.`Exposures` AS `t0_c16`, `t`.`Shares` AS
`t0_c17`, `t`.`Comments` AS `t0_c18`, `t`.`Useful` AS `t0_c19`,
`t`.`Unuseful` AS `t0_c20`, `t`.`c_year` AS `t0_c21`, `t`.`c_month` AS
`t0_c22`, `Translation`.`Title` AS `t1_c1`, `Translation`.`Description` AS
`t1_c3`, `Translation`.`Locale` AS `t1_c5`, `Translation`.`TranslatedId` AS
`t1_c4` FROM `news_briefs` `t`  LEFT JOIN `news_briefs_translated`
`Translation` ON (`Translation`.`Id`=`t`.`Id`)  WHERE (t.Type != 'selfhelp'
AND t.Status>=0 AND t.id IN
(115,157017,38937,269,297,332,12633,15898,22243,23824,25429,31963,33586,33626,37874,54942,70121,89072,140109,141498,159481,41098,81191,123698,23327,35066,42545,30,62,93,204,232,22234,27020,30197,31962,35095,36441,41257,43779,53526,54900,54912,56005,56703,58066,65240,71796,77505,134866,140112,172211,67,12978,372,26,209,210,287,288,298,308,316,317,324,329,330,333,370,9694,11528,11531,14300,14742,18734,21826,23630,23857,27064,28907,39420,41074,47200,49006,69921,73050,96570,102949,107646,16055,32986,58095,15,98,116,128,147,208,211,212,214,216,277,307,2263,8209,12991,13720,14171,14509,16053,17618,17620,17838,18105,19079,19150,19152,20680,21230,22276,23856,23858,25194,25394,25396,25398,27019,27059,27062,28587,28625,30224,31949,32023,32024,33556,33620,34722,35063,35124,35125,35128,35159,36474,36475,36477,36482,37889,37893))
ORDER BY Views%20DESC LIMIT 16.

CDbException: CDbCommand 无法执行 SQL 语句: SQLSTATE[42S22]: Column
not found: 1054 Unknown column '20DESC' in 'order clause' in
/home/www/sites/framework/db/CDbCommand.php:541
Stack trace:
#0 /home/www/sites/framework/db/CDbCommand.php(395):
CDbCommand->queryInternal('fetchAll', Array, Array)
#1 /home/www/sites/framework/db/ar/CActiveFinder.php(761):
CDbCommand->queryAll()
#2 /home/www/sites/framework/db/ar/CActiveFinder.php(422):
CJoinElement->runQuery(Object(CJoinQuery))
#3 /home/www/sites/framework/db/ar/CActiveFinder.php(68):
CJoinElement->find(Object(CDbCriteria))
#4 /home/www/sites/framework/db/ar/CActiveRecord.php(1302):
CActiveFinder->query(Object(CDbCriteria), true)
#5 /home/www/sites/framework/db/ar/CActiveRecord.php(1416):
CActiveRecord->query(Object(CDbCriteria), true)
#6
/home/www/sites/techbrood/protected/modules/News/services/NewsBriefService.php(273):
CActiveRecord->findAll(Object(CDbCriteria))
#7
/home/www/sites/techbrood/protected/modules/News/services/NewsBriefService.php(226):
NewsBriefService->searchWithSphinx(Array)
#8 /home/www/sites/techbrood/protected/base/Cms.php(182):
NewsBriefService->searchByKeywords(Array)
#9
/home/www/sites/techbrood/protected/modules/News/components/BriefListWidget.php(17):
Cms::service('News/NewsBrief/...', Array)
#10
/home/www/sites/techbrood/protected/extensions/helpers/Template.php(38):
BriefListWidget->run()
#11 /home/www/sites/techbrood/themes/techbrood/views/briefs.php(23):
Template::widget('MAIN_CONTENT_BR...', 'application.mod...')
#12 /home/www/sites/framework/web/CBaseController.php(126):
require('/home/www/sites...')
#13 /home/www/sites/framework/web/CBaseController.php(95):
CBaseController->renderInternal('/home/www/sites...', NULL, true)
#14 /home/www/sites/framework/web/CController.php(869):
CBaseController->renderFile('/home/www/sites...', NULL, true)
#15 /home/www/sites/framework/web/CController.php(782):
CController->renderPartial('/briefs', NULL, true)
#16
/home/www/sites/techbrood/protected/controllers/CmsBaseController.php(82):
CController->render('/briefs')
#17
/home/www/sites/techbrood/protected/controllers/DefaultController.php(40):
CmsBaseController->showTemplate()
#18 /home/www/sites/framework/web/actions/CInlineAction.php(49):
DefaultController->actionIndex()
#19 /home/www/sites/framework/web/CController.php(308):
CInlineAction->runWithParams(Array)
#20 /home/www/sites/framework/web/CController.php(286):
CController->runAction(Object(CInlineAction))
#21 /home/www/sites/framework/web/CController.php(265):
CController->runActionWithFilters(Object(CInlineAction), Array)
#22 /home/www/sites/framework/web/CWebApplication.php(282):
CController->run('index')
#23 /home/www/sites/framework/web/CWebApplication.php(141):
CWebApplication->runController('default/index')
#24 /home/www/sites/framework/base/CApplication.php(168):
CWebApplication->processRequest()
#25 /home/www/sites/techbrood/index.php(31): CApplication->run()
#26 {main}
REQUEST_URI=/briefs?q=css&o=Views%2520DESC
HTTP_REFERER=http://techbrood.com/briefs?q=css&o=Views%2520DESC
---