intval/phpguide — Issue #39: The db not upgrade...
Author: KingYes
Created: 2012-02-21 07:25:50+00:00
State: open

I can't use now with the codes..

```CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'last_activity' in 'order clause'. The SQL statement executed was: SELECT `t`.`qid` AS `t0_c0`, `t`.`subject` AS `t0_c1`, `t`.`bb_text` AS `t0_c2`, `t`.`html_text` AS `t0_c3`, `t`.`authorid` AS `t0_c4`, `t`.`time` AS `t0_c5`, `t`.`status` AS `t0_c6`, `t`.`views` AS `t0_c7`, `t`.`answers` AS `t0_c8`, `t`.`last_answer_time` AS `t0_c9`, `author`.`real_name` AS `t1_c2`, `author`.`login` AS `t1_c1`, `author`.`email` AS `t1_c6`, `author`.`id` AS `t1_c0` FROM `qna_questions` `t` LEFT OUTER JOIN `users` `author` ON (`t`.`authorid`=`author`.`id`) WHERE (status!="hidden") ORDER BY last_activity DESC LIMIT 7 ```