Wolf CMS - Uncaught RedBean_Exception_SQL

Description

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY project_categories_id, id DESC LIMIT 0, 10' at line 1

Location

Exception thrown on line 105 in /home/flex360/apps/harco/www/wolf/plugins/flexual/rb.php

Stack trace

require('/home/flex360/apps/harco/www/wolf/app/main.php')  on line 192 in /home/flex360/apps/harco/www/index.php
   main()  on line 167 in /home/flex360/apps/harco/www/wolf/app/main.php
      Dispatcher→dispatch('/projects/project_categories/favicon.ico')  on line 127 in /home/flex360/apps/harco/www/wolf/app/main.php
         Dispatcher→executeAction('plugin', 'flexual', array[4])  on line 237 in /home/flex360/apps/harco/www/wolf/Framework.php
            PluginController→execute('flexual', array[4])  on line 323 in /home/flex360/apps/harco/www/wolf/Framework.php
               call_user_func_array(array[2], array[3])  on line 183 in /home/flex360/apps/harco/www/wolf/app/controllers/PluginController.php
                  FlexualController→front_related_index('favicon.ico', 'projects', 'project_categories')  on line unknown in unknown
                     RedBean_Facade→getAll('SELECT x.* FROM `projects` x inner join `project_categories` y o...')  on line 571 in /home/flex360/apps/harco/www/wolf/plugins/flexual/FlexualController.php
                        RedBean_Facade→query('get', 'SELECT x.* FROM `projects` x inner join `project_categories` y o...', array[0])  on line 2200 in /home/flex360/apps/harco/www/wolf/plugins/flexual/rb.php
                           RedBean_Adapter_DBAdapter→get('SELECT x.* FROM `projects` x inner join `project_categories` y o...', array[0])  on line 2214 in /home/flex360/apps/harco/www/wolf/plugins/flexual/rb.php
                              RedBean_Driver_PDO→GetAll('SELECT x.* FROM `projects` x inner join `project_categories` y o...', array[0])  on line 437 in /home/flex360/apps/harco/www/wolf/plugins/flexual/rb.php
                                 RedBean_Driver_PDO→runQuery('SELECT x.* FROM `projects` x inner join `project_categories` y o...', array[0])  on line 111 in /home/flex360/apps/harco/www/wolf/plugins/flexual/rb.php

Dispatcher status
Variable	Value
`requested_url`	`/projects/project_categories/favicon.ico`
`controller`	`plugin`
`action`	`flexual`
`params`	`front_related_index, favicon.ico, projects, project_categories`
`request method`	`GET`

SERVER
Variable	Value
`PHP_INI_SCAN_DIR`	`/etc/php.d/:/home/flex360/apps/harco_public/`
`USER`	`flex360`
`HOME`	`/home/flex360`
`FCGI_ROLE`	`RESPONDER`
`REDIRECT_UNIQUE_ID`	`Zi8ArMEpIAOc5S6xcHRX8wAAAdQ`
`REDIRECT_HTTPS`	`on`
`REDIRECT_STATUS`	`200`
`UNIQUE_ID`	`Zi8ArMEpIAOc5S6xcHRX8wAAAdQ`
`HTTPS`	`on`
`proxy-nokeepalive`	`1`
`HTTP_HOST`	`www.harco.net`
`HTTP_X_FORWARDED_HOST`	`www.harco.net`
`HTTP_X_FORWARDED_SERVER`	`www.harco.net`
`HTTP_FORWARDED_REQUEST_URI`	`/projects/project_categories/favicon.ico`
`HTTP_HTTPS`	`on`
`HTTP_X_FORWARDED_PROTO`	`https`
`HTTP_X_FORWARDED_SSL`	`on`
`HTTP_CONNECTION`	`upgrade`
`HTTP_ACCEPT`	`/`
`HTTP_USER_AGENT`	`Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; C …`
`HTTP_REFERER`	`http://www.harco.net/projects/project_categories/favicon.ico`
`PATH`	`/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin`
`SERVER_SIGNATURE`	`<address>Apache Server at www.harco.net Port 80</address> …`
`SERVER_SOFTWARE`	`Apache`
`SERVER_NAME`	`www.harco.net`
`SERVER_ADDR`	`127.0.0.1`
`SERVER_PORT`	`80`
`REMOTE_ADDR`	`3.144.187.103`
`DOCUMENT_ROOT`	`/home/flex360/apps/harco_public`
`REQUEST_SCHEME`	`http`
`CONTEXT_PREFIX`	`/`
`CONTEXT_DOCUMENT_ROOT`	`/home/flex360/apps/harco_public/`
`SERVER_ADMIN`	`[no address given]`
`SCRIPT_FILENAME`	`/home/flex360/apps/harco_public/index.php`
`REMOTE_PORT`	`39260`
`REDIRECT_QUERY_STRING`	`WOLFPAGE=projects/project_categories/favicon.ico`
`REDIRECT_URL`	`/projects/project_categories/favicon.ico`
`GATEWAY_INTERFACE`	`CGI/1.1`
`SERVER_PROTOCOL`	`HTTP/1.1`
`REQUEST_METHOD`	`GET`
`QUERY_STRING`	`WOLFPAGE=projects/project_categories/favicon.ico`
`REQUEST_URI`	`/projects/project_categories/favicon.ico`
`SCRIPT_NAME`	`/index.php`
`PHP_SELF`	`/index.php`
`REQUEST_TIME_FLOAT`	`1714356396.5604`
`REQUEST_TIME`	`1714356396`