Doctrine\DBAL\Exception\SyntaxErrorException
Message
An exception occurred while executing 'SELECT w.id, w.tw_name as name, w.tw_url_title as title, MAX(w.date_published) as date_published, MIN(ws.sequence IS NULL) as ws_sequence_null, MIN(ws.sequence) as ws_sequence FROM works w LEFT JOIN work_service ws ON w.sid=ws.id WHERE (w.publish = 1) AND (w.tw_display = 1) AND (w.id <> ) GROUP BY w.id HAVING (MIN(ws.sequence IS NULL) < ?) OR ((MIN(ws.sequence IS NULL) = ?) AND (((MIN(ws.sequence IS NULL) = 0) AND (MIN(ws.sequence) < ?)) OR ((MIN(ws.sequence IS NULL) = 0) AND (MIN(ws.sequence) = ?) AND (MAX(w.date_published) > ?)) OR ((MIN(ws.sequence IS NULL) = 1) AND (MAX(w.date_published) > ?)))) ORDER BY ws_sequence_null DESC, ws_sequence DESC, date_published ASC LIMIT 1' with params [null, null, null, null, null, null]:

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 ') GROUP BY w.id HAVING (MIN(ws.sequence IS NULL) < NULL) OR ((MIN(ws.sequence IS' at line 1
File
/var/www/html/user-web/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php
Line
98
Trace
file line class type function object args
/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php
182
Doctrine\DBAL\Driver\AbstractMySQLDriver
->
convertException
NULL
Array
(
    [0] => 'An exception occurred while executing \'SELECT w.id, w.tw_name as name, w.tw_url_title as title, MAX(w.date_published) as date_published, MIN(ws.sequence IS NULL) as ws_sequence_null, MIN(ws.sequence) as ws_sequence FROM works w LEFT JOIN work_service ws ON w.sid=ws.id WHERE (w.publish = 1) AND (w.tw_display = 1) AND (w.id <> ) GROUP BY w.id HAVING (MIN(ws.sequence IS NULL) < ?) OR ((MIN(ws.sequence IS NULL) = ?) AND (((MIN(ws.sequence IS NULL) = 0) AND (MIN(ws.sequence) < ?)) OR ((MIN(ws.sequence IS NULL) = 0) AND (MIN(ws.sequence) = ?) AND (MAX(w.date_published) > ?)) OR ((MIN(ws.sequence IS NULL) = 1) AND (MAX(w.date_published) > ?)))) ORDER BY ws_sequence_null DESC, ws_sequence DESC, date_published ASC LIMIT 1\' with params [null, null, null, null, null, null]:

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 \') GROUP BY w.id HAVING (MIN(ws.sequence IS NULL) < NULL) OR ((MIN(ws.sequence IS\' at line 1'
    [1] => Doctrine\DBAL\Driver\PDO\Exception
)
/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php
159
Doctrine\DBAL\DBALException
::
wrapException
NULL
Array
(
    [0] => Doctrine\DBAL\Driver\PDO\MySQL\Driver
    [1] => Doctrine\DBAL\Driver\PDO\Exception
    [2] => 'An exception occurred while executing \'SELECT w.id, w.tw_name as name, w.tw_url_title as title, MAX(w.date_published) as date_published, MIN(ws.sequence IS NULL) as ws_sequence_null, MIN(ws.sequence) as ws_sequence FROM works w LEFT JOIN work_service ws ON w.sid=ws.id WHERE (w.publish = 1) AND (w.tw_display = 1) AND (w.id <> ) GROUP BY w.id HAVING (MIN(ws.sequence IS NULL) < ?) OR ((MIN(ws.sequence IS NULL) = ?) AND (((MIN(ws.sequence IS NULL) = 0) AND (MIN(ws.sequence) < ?)) OR ((MIN(ws.sequence IS NULL) = 0) AND (MIN(ws.sequence) = ?) AND (MAX(w.date_published) > ?)) OR ((MIN(ws.sequence IS NULL) = 1) AND (MAX(w.date_published) > ?)))) ORDER BY ws_sequence_null DESC, ws_sequence DESC, date_published ASC LIMIT 1\' with params [null, null, null, null, null, null]:

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 \') GROUP BY w.id HAVING (MIN(ws.sequence IS NULL) < NULL) OR ((MIN(ws.sequence IS\' at line 1'
)
/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php
2225
Doctrine\DBAL\DBALException
::
driverExceptionDuringQuery
NULL
Array
(
    [0] => Doctrine\DBAL\Driver\PDO\MySQL\Driver
    [1] => Doctrine\DBAL\Driver\PDO\Exception
    [2] => 'SELECT w.id, w.tw_name as name, w.tw_url_title as title, MAX(w.date_published) as date_published, MIN(ws.sequence IS NULL) as ws_sequence_null, MIN(ws.sequence) as ws_sequence FROM works w LEFT JOIN work_service ws ON w.sid=ws.id WHERE (w.publish = 1) AND (w.tw_display = 1) AND (w.id <> ) GROUP BY w.id HAVING (MIN(ws.sequence IS NULL) < ?) OR ((MIN(ws.sequence IS NULL) = ?) AND (((MIN(ws.sequence IS NULL) = 0) AND (MIN(ws.sequence) < ?)) OR ((MIN(ws.sequence IS NULL) = 0) AND (MIN(ws.sequence) = ?) AND (MAX(w.date_published) > ?)) OR ((MIN(ws.sequence IS NULL) = 1) AND (MAX(w.date_published) > ?)))) ORDER BY ws_sequence_null DESC, ws_sequence DESC, date_published ASC LIMIT 1'
    [3] => Array
        (
            [1] => NULL
            [2] => NULL
            [3] => NULL
            [4] => NULL
            [5] => NULL
            [6] => NULL
        )

)
/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php
1315
Doctrine\DBAL\Connection
->
handleExceptionDuringQuery
NULL
Array
(
    [0] => Doctrine\DBAL\Driver\PDO\Exception
    [1] => 'SELECT w.id, w.tw_name as name, w.tw_url_title as title, MAX(w.date_published) as date_published, MIN(ws.sequence IS NULL) as ws_sequence_null, MIN(ws.sequence) as ws_sequence FROM works w LEFT JOIN work_service ws ON w.sid=ws.id WHERE (w.publish = 1) AND (w.tw_display = 1) AND (w.id <> ) GROUP BY w.id HAVING (MIN(ws.sequence IS NULL) < ?) OR ((MIN(ws.sequence IS NULL) = ?) AND (((MIN(ws.sequence IS NULL) = 0) AND (MIN(ws.sequence) < ?)) OR ((MIN(ws.sequence IS NULL) = 0) AND (MIN(ws.sequence) = ?) AND (MAX(w.date_published) > ?)) OR ((MIN(ws.sequence IS NULL) = 1) AND (MAX(w.date_published) > ?)))) ORDER BY ws_sequence_null DESC, ws_sequence DESC, date_published ASC LIMIT 1'
    [2] => Array
        (
            [0] => NULL
            [1] => NULL
            [2] => NULL
            [3] => NULL
            [4] => NULL
            [5] => NULL
        )

    [3] => Array
        (
            [0] => 2
            [1] => 2
            [2] => 2
            [3] => 2
            [4] => 2
            [5] => 2
        )

)
/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php
212
Doctrine\DBAL\Connection
->
executeQuery
NULL
Array
(
    [0] => 'SELECT w.id, w.tw_name as name, w.tw_url_title as title, MAX(w.date_published) as date_published, MIN(ws.sequence IS NULL) as ws_sequence_null, MIN(ws.sequence) as ws_sequence FROM works w LEFT JOIN work_service ws ON w.sid=ws.id WHERE (w.publish = 1) AND (w.tw_display = 1) AND (w.id <> ) GROUP BY w.id HAVING (MIN(ws.sequence IS NULL) < ?) OR ((MIN(ws.sequence IS NULL) = ?) AND (((MIN(ws.sequence IS NULL) = 0) AND (MIN(ws.sequence) < ?)) OR ((MIN(ws.sequence IS NULL) = 0) AND (MIN(ws.sequence) = ?) AND (MAX(w.date_published) > ?)) OR ((MIN(ws.sequence IS NULL) = 1) AND (MAX(w.date_published) > ?)))) ORDER BY ws_sequence_null DESC, ws_sequence DESC, date_published ASC LIMIT 1'
    [1] => Array
        (
            [0] => NULL
            [1] => NULL
            [2] => NULL
            [3] => NULL
            [4] => NULL
            [5] => NULL
        )

    [2] => Array
        (
            [0] => 2
            [1] => 2
            [2] => 2
            [3] => 2
            [4] => 2
            [5] => 2
        )

)
/da-vinci3/App/Http/Controllers/WorkController.php
411
Doctrine\DBAL\Query\QueryBuilder
->
execute
NULL
Array
(
)
0
App\Http\Controllers\WorkController
->
dAction
NULL
Array
(
    [0] => '109'
)
/da-vinci3/App/Components/Dispatcher.php
141
call_user_func_array
NULL
Array
(
    [0] => Array
        (
            [0] => Object (App\Http\Controllers\WorkController)
            [1] => 'dAction'
        )

    [1] => Array
        (
            [0] => '109'
        )

)
/da-vinci3/index.php
5
App\Components\Dispatcher
->
dispatch
NULL
Array
(
)