42000!

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 '34 ORDER BY `date` DESC, `create_date` DESC LIMIT 10 OFFSET 0' at line 1 with query: "SELECT * FROM `fc_report` WHERE `status` = 'public' AND `img` IS NOT null AND `target` IN 34 ORDER BY `date` DESC, `create_date` DESC LIMIT 10 OFFSET 0"

COREPATH/classes/database/pdo/connection.php @ line 270

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

Backtrace

  1. COREPATH/classes/database/query.php @ line 287
    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();
    
  2. APPPATH/classes/model/report.php @ line 255
    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    ---------------------------------------------
    
  3. APPPATH/classes/controller/report.php @ line 600
    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;
    
  4. COREPATH/classes/request.php @ line 444
    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');
    
  5. DOCROOT/index.php @ line 71
    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($routefalse)->execute(array($e))->response();
    76    }
    
  6. DOCROOT/index.php @ line 92
    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}