keke_exception[ 1054 ]: Unknown column 'case_id' in 'order clause' [ select count(*) as count from keke_witkey_shop_case where shop_id=8046 order by case_id desc ]

E:\kechuangwang\kechuangwang\lib\db\mysql_driver.php[ 187 ]

182 	}
183 	public function getErrno() {
184 		return ($this->_link) ? mysql_errno ( $this->_link ) : mysql_errno ();
185 	}
186 	public function halt($message = '', $sql = '') {
187 		throw new keke_exception ( ':error [ :query ]', array ('msg'=>$message,':error' => mysql_error ( $this->_link ), ':query' => $sql ), mysql_errno ( $this->_link ) );
188 		exit ();
189 	}
190 	public function special_filed(&$value) {
191 		if ('*' == $value || false !== strpos ( $value, '(' ) || false !== strpos ( $value, '.' ) || false !== strpos ( $value, '`' )) {
192 		} else {

1. E:\kechuangwang\kechuangwang\index.php [ 79 ] » require ( arguments )

   0	string(47) "E:\kechuangwang\kechuangwang\control\seller.php"

   74     $intService = db_factory::get_count("SELECT COUNT(*) as count2 FROM `".TABLEPRE."witkey_order` AS a  LEFT JOIN ".TABLEPRE."witkey_order_detail AS b ON a.order_id = b.order_id  LEFT JOIN ".TABLEPRE."witkey_service_order AS c ON b.order_id = c.order_id  WHERE  1=1  and a.seller_uid = ".$gUid." and b.obj_type = 'service' and a.order_status ='seller_confirm' order by b.order_id desc");
   75     $intGy = db_factory::get_count("SELECT count(*) as count2 FROM `".TABLEPRE."witkey_service_order` as a LEFT JOIN ".TABLEPRE."witkey_order_detail as b ON a.order_id = b.order_id
   76 			LEFT JOIN ".TABLEPRE."witkey_order as c ON a.order_id = c.order_id
   77 			WHERE 1=1  and c.seller_uid= ".$gUid." and c.order_status!= 'close' and c.order_status ='seller_confirm' order by c.order_time desc");
   78 }
   79 require 'control/' . $do . '.php';
   80 require $kekezu->_tpl_obj->template ( $do );

2. E:\kechuangwang\kechuangwang\control\seller.php [ 113 ] » require ( arguments )

   0	string(52) "E:\kechuangwang\kechuangwang\control\seller\case.php"

   108 $intCaseCount = db_factory::get_count(sprintf('select count(*) from %s where shop_id = %d ',TABLEPRE.'witkey_shop_case',$arrSellerInfo['shop_id']));
   109 
   110 $intChanpinCount = db_factory::get_count(sprintf('select count(*) from %s where uid = %d and type =0',TABLEPRE.'witkey_product',$arrSellerInfo['uid']));
   111 $intXuqiuCount = db_factory::get_count(sprintf('select count(*) from %s where uid = %d and type =1',TABLEPRE.'witkey_product',$arrSellerInfo['uid']));
   112 $_SESSION['spread'] = 'index.php?do=seller&id='.intval($id);
   113 require $do.'/'.$view.'.php';
   114 require  $kekezu->_tpl_obj->template($do.'/'.$view);die();

3. E:\kechuangwang\kechuangwang\control\seller\case.php [ 11 ] » keke_table_class->get_grid ( arguments )

   0	string(36) " shop_id=8046 order by case_id desc"
   1	string(37) "index.php?do=seller&view=case&id=8047"
   2	int(1)
   3	int(8)
   4	NULL
   5	NULL
   6	NULL

    6 $strWhere .= "  shop_id=".intval($arrSellerInfo['shop_id']);
    7 $page and $intPage = intval ( $page );
    8 $intPage = intval ( $intPage ) ? $intPage : 1;
    9 $intPagesize = intval ( $intPagesize ) ? $intPagesize : 8;
   10 $strWhere .= " order by case_id desc";
   11 $arrDatas = $objTaskT->get_grid ( $strWhere, $strUrl, $intPage, $intPagesize, null, null, null );
   12 $arrCaseLists = $arrDatas ['data'];
   13 $strPages = $arrDatas ['pages'];

4. E:\kechuangwang\kechuangwang\lib\inc\keke_table_class.php [ 39 ] » Keke_witkey_shop_case_class->count_keke_witkey_shop_case ( )

   34 		} else {
   35 			$where = $wh;
   36 		}
   37 		$this->_table_obj->setWhere ( $where );
   38 		$count_query = "count_" . $this->_pre . $this->_table_name;
   39 		$this->_count = $count = $this->_table_obj->$count_query ();
   40 		$pages = $page_obj->getPages ( $count, $page_size, $page, $url_str );
   41 		$where .= $order .= $pages [where];
   42 		$this->_table_obj->setWhere ( $where );
   43 		$query = "query_" . $this->_pre . $this->_table_name;
   44 		$res_info [data] = $this->_table_obj->$query ();
   

5. E:\kechuangwang\kechuangwang\lib\table\Keke_witkey_shop_case_class.php [ 302 ] » keke_db->getCount ( arguments )

   0	string(94) "select count(*) as count from keke_witkey_shop_case where shop_id=8046 order by case_id desc"

   297 		}
   298 		else{
   299 			$sql = "select count(*) as count from $this->_tablename";
   300 		}
   301 		$this->_where = "";
   302 		return $this->_dbop->getCount($sql);
   303 	}
   304 
   305 	
   306 	function del_keke_witkey_shop_case(){
   307 		if($this->_where){
   

6. E:\kechuangwang\kechuangwang\lib\db\db_factory.php [ 75 ] » mysql_drver->getCount ( arguments )

   0	string(94) "select count(*) as count from keke_witkey_shop_case where shop_id=8046 order by case_id desc"
   1	int(0)
   2	NULL

   70 	}
   71 	public function select($fileds = '*', $table, $where = '', $order = '', $group = '', $limit = '', $pk = '') {
   72 		return $this->_mydb->select ( $fileds, $table, $where, $order, $group, $limit, $pk );
   73 	}
   74 	public function getCount($sql, $row = 0, $filed = null) {
   75 		return $this->_mydb->getCount ( $sql, $row, $filed );
   76 	}
   77 	public function get_one($sql) {
   78 		return $this->_mydb->get_one_row ( $sql );
   79 	}
   80 	public function query($sql, $is_unbuffer = 0) {
   

7. E:\kechuangwang\kechuangwang\lib\db\mysql_driver.php [ 42 ] » mysql_drver->execute_sql ( arguments )

   0	string(94) "select count(*) as count from keke_witkey_shop_case where shop_id=8046 order by case_id desc"

   37 		}
   38 		$this->free_result ();
   39 		return $result;
   40 	}
   41 	public function getCount($sql, $row = 0, $field = null) {
   42 		$query = $this->execute_sql ( $sql );
   43 		(is_resource ( $query ) and mysql_num_rows($query)) and  $result = mysql_result ( $query, $row, $field ) or $result = 0;
   44 		$this->free_result ();
   45 		return $result;
   46 	}
   47 	public function start_trans() {
   

8. E:\kechuangwang\kechuangwang\lib\db\mysql_driver.php [ 153 ] » mysql_drver->halt ( arguments )

   0	string(42) "Unknown column 'case_id' in 'order clause'"
   1	string(94) "select count(*) as count from keke_witkey_shop_case where shop_id=8046 order by case_id desc"

   148 	}
   149 	protected function execute_sql($sql, $is_nubuffer = 0) {
   150 		! is_resource ( $this->_link ) and $this->dbConnection ();
   151 		$is_nubuffer == 1 and $query_type = "mysql_unbuffered_query" or $query_type = "mysql_query";
   152 		array_push($this->_query_sql, $sql);
   153 		$this->_last_query_id = $query_type ( $sql, $this->_link ) or $this->halt ( mysql_error (), $sql );
   154 		$this->_query_num ++;
   155 		return $this->_last_query_id;
   156 	}
   157 	public function get_query_num() {
   158 		return $this->_query_num;