Fuel\Core\Database_Exception [ 42000 ]:
SQLSTATE[42000]: Syntax error or access violation: 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 '41 ORDER BY `date` DESC, `create_date` DESC LIMIT 10 OFFSET 20' at line 1 with query: "SELECT * FROM `fc_report` WHERE `status` = 'public' AND `img` IS NOT null AND `target` IN 41 ORDER BY `date` DESC, `create_date` DESC LIMIT 10 OFFSET 20"
265 { 266 $error_code = 0; 267 } 268 } 269 270 throw new \Database_Exception($e->getMessage().' with query: "'.$sql.'"', $error_code, $e); 271 } 272 } 273 274 // no more attempts left, bail out 275 else
282 catch (CacheNotFoundException $e) {} 283 } 284 285 // Execute the query 286 \DB::$query_count++; 287 $result = $db->query($this->_type, $sql, $this->_as_object); 288 289 // Cache the result if needed 290 if (isset($cache) and ($this->_cache_all or $result->count())) 291 { 292 $cache->set_expiration($this->_lifetime)->set_contents($result->as_array())->set();
250 $return['data']->where_open(); 251 $return['data']->or_where('target', 'in', $tmp[$a]); 252 $return['data']->where_close(); 253 } 254 } 255 $return['data'] = $return['data']->execute()->as_array(); 256 return $return; 257 } 258 259 /* 260 ---------------------------------------------
595 } 596 597 //$where_date['comment'] = array('like', htmlspecialchars($search_word)); 598 //$where_date['comment'] = array('like', htmlspecialchars('イカ')); 599 600 $result = Model_Report::get_reportlist(10,$page,$where_date); 601 $goView['report_list'] = $result['data']; 602 $goView['total'] = $result['total']; 603 $goView['max'] = $result['max']; 604 $goView['min'] = $result['min']; 605 $goView['page'] = $page;
439 // fire any controller started events 440 \Event::instance()->has_events('controller_started') and \Event::instance()->trigger('controller_started', '', 'none'); 441 442 $class->hasMethod('before') and $class->getMethod('before')->invoke($this->controller_instance); 443 444 $response = $action->invokeArgs($this->controller_instance, $this->method_params); 445 446 $class->hasMethod('after') and $response = $class->getMethod('after')->invoke($this->controller_instance, $response); 447 448 // fire any controller finished events 449 \Event::instance()->has_events('controller_finished') and \Event::instance()->trigger('controller_finished', '', 'none');
66 $response = Response::forge($response); 67 } 68 } 69 elseif ($e === false) 70 { 71 $response = Request::forge()->execute()->response(); 72 } 73 elseif ($route) 74 { 75 $response = Request::forge($route, false)->execute(array($e))->response(); 76 }
87{ 88 // Boot the app... 89 require APPPATH.'bootstrap.php'; 90 91 // ... and execute the main request 92 $response = $routerequest(); 93} 94catch (HttpNoAccessException $e) 95{ 96 $response = $routerequest('_403_', $e); 97}