Exception making GET request to /p/escaline/timeline/?_px_p=bpsqquqcpnmfubi
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 '-20' at line 4 - SELECT idf_timeline.`id` AS `id`, idf_timeline.`project` AS `project`, idf_timeline.`author` AS `author`, idf_timeline.`model_class` AS `model_class`, idf_timeline.`model_id` AS `model_id`, idf_timeline.`creation_dtime` AS `creation_dtime`, idf_timeline.`public_dtime` AS `public_dtime` FROM idf_timeline 
WHERE  (project='2' AND model_class IN ('IDF_Commit', 'IDF_Issue', 'IDF_IssueComment')) 
ORDER BY creation_dtime DESC
LIMIT 20 OFFSET -20

PHP: /srv/idevelop.org/pluf/src/Pluf/DB/MySQL.php, line 112
URI: GET /p/escaline/timeline/?_px_p=bpsqquqcpnmfubi

** Stacktrace **

* Pluf_DB_MySQL->select
        [/srv/idevelop.org/pluf/src/Pluf/Model.php, line 559] *
* Src *
554:             $req .= "\n".'ORDER BY '.$query['order'];
555:         }
556:         if (strlen($query['limit'])) {
557:             $req .= "\n".$query['limit'];
558:         }
>> 559:         if (false === ($rs=$this->_con->select($req))) {
560:             throw new Exception($this->_con->getError());
561:         }
562:         if (count($rs) == 0) {
563:             return new ArrayObject();
564:         } 

* Pluf_Model->getList
        [/srv/idevelop.org/pluf/src/Pluf/Paginator.php, line 440] *
* Src *
435:         if (!is_null($this->model)) {
436:             $items = $this->model->getList(array('view' => $this->model_view, 
437:                                                  'filter' => $this->filter(), 
438:                                                  'order' => $order, 
439:                                                  'start' => $st, 
>> 440:                                                  'nb' => $this->items_per_page));
441:         } else {
442:             $items = $this->items;
443:         }
444:         $out = '';
445:         $total = $items->count();

* Pluf_Paginator->body
        [/srv/idevelop.org/pluf/src/Pluf/Paginator.php, line 313] *
* Src *
308:         $out .= $this->colHeaders();
309:         $out .= '</thead>'."\n";
310:         // Opt: Generate the footer of the table with the next/previous links
311:         $out .= $this->footer();
312:         // Generate the body of the table with the items
>> 313:         $out .= $this->body();
314:         $out .= '</table>'."\n";
315:         return new Pluf_Template_SafeString($out, true);
316:     }
317: 
318:     /**

* Pluf_Paginator->render
        [/srv/idevelop.org/pluf/src/Pluf/Paginator.php, line 678] *
* Src *
673:      *
674:      * @param string Property to get
675:      */
676:     function __get($prop)
677:     {
>> 678:         if ($prop == 'render') return $this->render();
679:         return $this->$prop;
680:     }
681: 
682: }
683: 

* Pluf_Paginator->__get
        [/tmp/Pluf_Template-1391660c585fbc906b5b0eee220e11c0.phps, line 63] *
* Src *
58:       <div class="yui-b">
59:     <div class="yui-g"> 
60:           <?php if ($t->_vars['user'] and $t->_vars['user']->id):  $_extra_tag = Pluf::factory('Pluf_Template_Tag_Messages', $t); $_extra_tag->start($t->_vars['user']);  endif; ?>
61: 
62:       <div class="content">
>> 63: <?php Pluf_Template_safeEcho($t->_vars['timeline']->render); ?>
64: 
65: </div>
66:     </div>
67:       </div>
68:     </div>

* include
        [/srv/idevelop.org/pluf/src/Pluf/Template.php, line 91] *
* Src *
86:         }
87:         $this->context = $c;
88:         ob_start();
89:         $t = $c;
90:         try {
>> 91:             include $this->compiled_template;
92:         } catch (Exception $e) {
93:             ob_clean();
94:             throw $e;
95:         }
96:         $a = ob_get_contents();

* Pluf_Template->render
        [/srv/idevelop.org/pluf/src/Pluf/Shortcuts.php, line 92] *
* Src *
87:     if (is_null($request)) {
88:         $context = new Pluf_Template_Context($params);
89:     } else {
90:         $context = new Pluf_Template_Context_Request($request, $params);
91:     }
>> 92:     return new Pluf_HTTP_Response($tmpl->render($context));
93: }
94: 
95: 
96: /**
97:  * Get a given form from a model.

* Pluf_Shortcuts_RenderToResponse
        [/srv/idevelop.org/src/IDF/Views/Project.php, line 139] *
* Src *
134:                                                      'feedurl' => $feedurl,
135:                                                      'timeline' => $pag,
136:                                                      'team' => $team,
137:                                                      'downloads' => $downloads,
138:                                                      ),
>> 139:                                                $request);
140: 
141:     }
142: 
143:     /**
144:      * Timeline feed.

* IDF_Views_Project->timeline
        [/srv/idevelop.org/pluf/src/Pluf/Dispatcher.php, line 202] *
* Src *
197:                     return $res;
198:                 }
199:             } 
200:         }
201:         if (!isset($ctl['params'])) {
>> 202:             return $m->$ctl['method']($req, $match);
203:         } else {
204:             return $m->$ctl['method']($req, $match, $ctl['params']);
205:         }
206:     }
207: 

* Pluf_Dispatcher::send
        [/srv/idevelop.org/pluf/src/Pluf/Dispatcher.php, line 129] *
* Src *
124:             $i = 0;
125:             while ($i<$n) {
126:                 $ctl = $views[$i];
127:                 if (preg_match($ctl['regex'], $to_match, $match)) {
128:                     if (!isset($ctl['sub'])) {
>> 129:                         return self::send($req, $ctl, $match);
130:                     } else {
131:                         // Go in the subtree
132:                         $views = $ctl['sub'];
133:                         $i = 0;
134:                         $n = count($views);

* Pluf_Dispatcher::match
        [/srv/idevelop.org/pluf/src/Pluf/Dispatcher.php, line 56] *
* Src *
51:                         break;
52:                     }    
53:                 }
54:             }
55:             if ($skip === false) {   
>> 56:                 $response = self::match($req);
57:                 if (!empty($req->response_vary_on)) {
58:                     $response->headers['Vary'] = $req->response_vary_on;
59:                 }
60:                 $middleware = array_reverse($middleware);
61:                 foreach ($middleware as $mw) {

* Pluf_Dispatcher::dispatch
        [/srv/idevelop.org/www/index.php, line 34] *
* Src *
29:                  .PATH_SEPARATOR.$pluf_path
30:                  );
31: require 'Pluf.php';
32: Pluf::start(dirname(__FILE__).'/../src/IDF/conf/idf.php');
33: Pluf_Dispatcher::loadControllers(Pluf::f('idf_views'));
>> 34: Pluf_Dispatcher::dispatch(Pluf_HTTP_URL::getAction()); 
35: 
36: 
37: 





** Request **


* Request (parsed) *

$_GET
Variable: _px_p
Value:    bpsqquqcpnmfubi

$_POST
No data

$_COOKIE
No data

$_SERVER
Variable: PHP_FCGI_CHILDREN
Value:    5
Variable: PWD
Value:    /usr/share/cherokee/admin
Variable: SHLVL
Value:    0
Variable: PHP_FCGI_MAX_REQUESTS
Value:    490
Variable: FCGI_ROLE
Value:    RESPONDER
Variable: HTTP_FROM
Value:    googlebot(at)googlebot.com
Variable: SERVER_SOFTWARE
Value:    Cherokee
Variable: SERVER_SIGNATURE
Value:    <address>Cherokee Web Server</address>
Variable: GATEWAY_INTERFACE
Value:    CGI/1.1
Variable: PATH
Value:    /bin:/usr/bin:/sbin:/usr/sbin
Variable: DOCUMENT_ROOT
Value:    /srv/idevelop.org/www
Variable: REMOTE_ADDR
Value:    66.249.71.105
Variable: REMOTE_PORT
Value:    26576
Variable: HTTP_HOST
Value:    idevelop.org
Variable: SERVER_NAME
Value:    idevelop.org
Variable: QUERY_STRING
Value:    _px_p=bpsqquqcpnmfubi
Variable: SERVER_PROTOCOL
Value:    HTTP/1.1
Variable: REQUEST_METHOD
Value:    GET
Variable: PATH_INFO
Value:    /p/escaline/timeline/
Variable: REQUEST_URI
Value:    /p/escaline/timeline/?_px_p=bpsqquqcpnmfubi
Variable: SCRIPT_URL
Value:    /index.php/p/escaline/timeline/
Variable: HTTPS
Value:    off
Variable: SERVER_PORT
Value:    80
Variable: SERVER_ADDR
Value:    10.0.3.0
Variable: HTTP_ACCEPT
Value:    */*
Variable: HTTP_ACCEPT_ENCODING
Value:    gzip,deflate
Variable: HTTP_CONNECTION
Value:    Keep-alive
Variable: HTTP_USER_AGENT
Value:    Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)
Variable: SCRIPT_NAME
Value:    /index.php
Variable: PATH_TRANSLATED
Value:    /srv/idevelop.org/www/p/escaline/timeline/
Variable: SCRIPT_FILENAME
Value:    /srv/idevelop.org/www/index.php
Variable: PHP_SELF
Value:    /index.php/p/escaline/timeline/
Variable: REQUEST_TIME
Value:    1265805377

$_ENV
No data





** Response **

* Headers *

X-Powered-By: PHP/5.3.1