keke_exception[ 1064 ]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') order by a.tasktop desc,a.task_id desc' at line 2 [ select a.*,d.* from keke_witkey_task as a left join keke_witkey_task_cash_cove d on a.task_cash_coverage=d.cash_rule_id where 1=1 and a.model_id in(4) and a.indus_id = 411 and a.task_id in () order by a.tasktop desc,a.task_id desc ]

/www/wwwroot/cccbb.com/lib/db/mysqli_driver.php[ 192 ]

187 	}
188 	public function getErrno() {
189 		return ($this->_link) ? mysqli_errno ( $this->_link ) : mysqli_errno ();
190 	}
191 	public function halt($message = '', $sql = '') {
192 		throw new keke_exception ( ':error [ :query ]', array (':error' => mysqli_error ( $this->_link ), ':query' => $sql ), mysqli_errno ( $this->_link ) );
193 		exit ();
194 	}
195 	public function special_filed(&$value) {
196 		if ('*' == $value || false !== strpos ( $value, '(' ) || false !== strpos ( $value, '.' ) || false !== strpos ( $value, '`' )) {
197 		} else {

1. /www/wwwroot/cccbb.com/index.php [ 101 ] » require ( arguments )

   0	string(43) "/www/wwwroot/cccbb.com/control/tasklist.php"

    96 //			LEFT JOIN " . TABLEPRE . "witkey_order as c ON a.order_id = c.order_id
    97 //			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");
    98     $intWaitPay = $intShopPay = $intMarkG = $intMarkW = $intService = $intGy = 0;
    99 }
   100 saveUseTime('index');
   101 require 'control/' . $do . '.php';
   102 
   103 require $kekezu->_tpl_obj->template($do);
   104 echUseTime();

2. /www/wwwroot/cccbb.com/control/tasklist.php [ 117 ] » db_factory::execute ( arguments )

   0	string(237) "select a.*,d.* from keke_witkey_task as a left join keke_witkey_task_cash_cove d on a.task_cash_coverage=d.cash_rule_id where 1=1 and a.model_id in(4) and a.indus_id = 411 and a.task_id in () order by a.tasktop desc,a.task_id desc "

   112 	case 6:  $strWhere .= " order by a.work_num asc ";	 	break;
   113 	default: $strWhere .= " order by a.tasktop desc,a.task_id desc ";	 	break;
   114 }
   115 $strTaskSql = "select a.*,d.* from " . TABLEPRE . "witkey_task as a left join " . TABLEPRE . "witkey_task_cash_cove d on a.task_cash_coverage=d.cash_rule_id
   116 		where ";
   117 $intCount = db_factory::execute ( $strTaskSql . $strWhere );
   118 $arrDatas = $page_obj->getPages ( $intCount, $intPagesize, $intPage, $strUrl );
   119 $arrTaskLists = db_factory::query ( $strTaskSql . $strWhere . $arrDatas ['where'] );
   120 if(is_array($arrTaskLists)){
   121 	foreach ($arrTaskLists as $k=>$v) {
   122 		$arrFavorite = db_factory::get_count(sprintf('select count(*) from %s where uid = %d and obj_id = %d and keep_type = "task"',TABLEPRE.'witkey_favorite',intval($gUid),intval($v['task_id'])));
   

3. /www/wwwroot/cccbb.com/lib/db/db_factory.php [ 96 ] » keke_db->execute ( arguments )

   0	string(237) "select a.*,d.* from keke_witkey_task as a left join keke_witkey_task_cash_cove d on a.task_cash_coverage=d.cash_rule_id where 1=1 and a.model_id in(4) and a.indus_id = 411 and a.task_id in () order by a.tasktop desc,a.task_id desc "

    91 		$db_obj = &keke_db::get_instance ( $dbtype );
    92 		return self::$db_obj = $db_obj;
    93 	}
    94 	public static function execute($sql) {
    95 		self::init ();
    96 		return self::$db_obj->execute ( $sql );
    97 	}
    98 	public static function query($sql, $is_cache = 0, $cache_time = 0, $is_unbuffer = 0) {
    99 		$db = self::init ();
   100 		$result='';
   101 		if(IS_CACHE){
   

4. /www/wwwroot/cccbb.com/lib/db/db_factory.php [ 65 ] » mysqli_drver->execute ( arguments )

   0	string(237) "select a.*,d.* from keke_witkey_task as a left join keke_witkey_task_cash_cove d on a.task_cash_coverage=d.cash_rule_id where 1=1 and a.model_id in(4) and a.indus_id = 411 and a.task_id in () order by a.tasktop desc,a.task_id desc "

   60 	}
   61 	public function updatetable($tablename, $setsqlarr, $wheresqlarr) {
   62 		return $this->_mydb->update ( $tablename, $setsqlarr, $wheresqlarr );
   63 	}
   64 	public function execute($sql) {
   65 		$res = $this->_mydb->execute ( $sql );
   66 		return $res ? $res : 0;
   67 	}
   68 	public function get_query_num() {
   69 		return $this->_mydb->get_query_num ();
   70 	}
   

5. /www/wwwroot/cccbb.com/lib/db/mysqli_driver.php [ 149 ] » mysqli_drver->execute_sql ( arguments )

   0	string(237) "select a.*,d.* from keke_witkey_task as a left join keke_witkey_task_cash_cove d on a.task_cash_coverage=d.cash_rule_id where 1=1 and a.model_id in(4) and a.indus_id = 411 and a.task_id in () order by a.tasktop desc,a.task_id desc "

   144 		}
   145 		$this->free_result ();
   146 		return $datalist;
   147 	}
   148 	public function execute($updatesql) {
   149 		$this->execute_sql ( $updatesql );
   150 		$res = mysqli_affected_rows ( $this->_link );
   151 		$this->free_result ();
   152 		return $res;
   153 	}
   154 	protected function execute_sql($sql, $is_nubuffer = 0) {
   

6. /www/wwwroot/cccbb.com/lib/db/mysqli_driver.php [ 158 ] » mysqli_drver->halt ( arguments )

   0	bool(false)
   1	string(237) "select a.*,d.* from keke_witkey_task as a left join keke_witkey_task_cash_cove d on a.task_cash_coverage=d.cash_rule_id where 1=1 and a.model_id in(4) and a.indus_id = 411 and a.task_id in () order by a.tasktop desc,a.task_id desc "

   153 	}
   154 	protected function execute_sql($sql, $is_nubuffer = 0) {
   155 		! is_resource ( $this->_link ) and $this->dbConnection ();
   156 		$is_nubuffer == 1 and $query_type = "mysqli_store_result" or $query_type = "mysqli_query";
   157 		array_push($this->_query_sql, $sql);
   158 		$this->_last_query_id = $query_type ($this->_link,$sql) or $this->halt ( mysql_error (), $sql );
   159 		$this->_query_num ++;
   160 		return $this->_last_query_id;
   161 	}
   162 	public function get_query_num() {
   163 		return $this->_query_num;