| Date: | 2024-11-22 18:17:03 (NZDT) |
| Error Number: | 2 |
| Error Type: | Warning |
| Error Message: | PDOStatement::execute(): 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 '-10,10' at line 3 |
| Location: | /home/michael/www/core3/library/query.php, line 155 |
| URL: | /Guestbook?page=0 |
| Request Params: | Array
(
[page] => 0
)
|
| Variable Trace: | Array
(
[sql] => SELECT id, name, comments, referrer, date
FROM g_guestbook AS g
ORDER BY date DESC LIMIT -10,10
[args] => Array
(
)
[get_results] => 1
[s] => PDOStatement Object
(
[queryString] => SELECT id, name, comments, referrer, date
FROM g_guestbook AS g
ORDER BY date DESC LIMIT -10,10
)
)
|
| Stack Trace: | Array
(
[2] => Array
(
[file] => /home/michael/www/core3/library/query.php
[line] => 155
[function] => execute
[class] => PDOStatement
[object] => PDOStatement Object
(
[queryString] => SELECT id, name, comments, referrer, date
FROM g_guestbook AS g
ORDER BY date DESC LIMIT -10,10
)
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[3] => Array
(
[file] => /home/michael/www/core3/library/query.php
[line] => 60
[function] => pdo_run
[class] => query
[object] => query Object
(
[show_profiling_info] => 1
[sql] => SELECT id, name, comments, referrer, date
FROM g_guestbook AS g
ORDER BY date DESC LIMIT -10,10
[wcn] => 0
[cache] =>
[allow_nulls] =>
[distinct] =>
[log] => 1
[conn] => stdClass Object
(
[name] => MichaelAdams.org
[method] => pdo
[dsn] => mysql:host=localhost;dbname=ma2
[username] => ma
[password] => millusion348
)
[conn_alias] => default
[parsed_sql] => SELECT id, name, comments, referrer, date
FROM g_guestbook AS g
ORDER BY date DESC LIMIT -10,10
[q] => PDO Object
(
)
)
[type] => ->
[args] => Array
(
[0] => SELECT id, name, comments, referrer, date
FROM g_guestbook AS g
ORDER BY date DESC LIMIT -10,10
[1] => Array
(
)
[2] => 1
)
)
[4] => Array
(
[file] => /home/michael/www/core3/library/query.php
[line] => 298
[function] => run
[class] => query
[object] => query Object
(
[show_profiling_info] => 1
[sql] => SELECT id, name, comments, referrer, date
FROM g_guestbook AS g
ORDER BY date DESC LIMIT -10,10
[wcn] => 0
[cache] =>
[allow_nulls] =>
[distinct] =>
[log] => 1
[conn] => stdClass Object
(
[name] => MichaelAdams.org
[method] => pdo
[dsn] => mysql:host=localhost;dbname=ma2
[username] => ma
[password] => millusion348
)
[conn_alias] => default
[parsed_sql] => SELECT id, name, comments, referrer, date
FROM g_guestbook AS g
ORDER BY date DESC LIMIT -10,10
[q] => PDO Object
(
)
)
[type] => ->
[args] => Array
(
[0] => SELECT id, name, comments, referrer, date
FROM g_guestbook AS g
ORDER BY date DESC LIMIT -10,10
[1] => Array
(
)
[2] =>
)
)
[5] => Array
(
[file] => /home/michael/www/www.michael.net.nz/Guestbook/Controller.php
[line] => 24
[function] => get
[class] => query
[object] => query Object
(
[show_profiling_info] => 1
[sql] => SELECT id, name, comments, referrer, date
FROM g_guestbook AS g
ORDER BY date DESC LIMIT -10,10
[wcn] => 0
[cache] =>
[allow_nulls] =>
[distinct] =>
[log] => 1
[conn] => stdClass Object
(
[name] => MichaelAdams.org
[method] => pdo
[dsn] => mysql:host=localhost;dbname=ma2
[username] => ma
[password] => millusion348
)
[conn_alias] => default
[parsed_sql] => SELECT id, name, comments, referrer, date
FROM g_guestbook AS g
ORDER BY date DESC LIMIT -10,10
[q] => PDO Object
(
)
)
[type] => ->
[args] => Array
(
[0] => Table Object
(
[name] => g_guestbook
[id] => g
[columns] => Array
(
[id] => Array
(
[name] => id
[type] => int(10)
[extra] => auto_increment
)
[name] => Array
(
[name] => name
[type] => varchar(255)
)
[comments] => Array
(
[name] => comments
[type] => text
)
[referrer] => Array
(
[name] => referrer
[type] => varchar(255)
)
[date] => Array
(
[...SNIP...]
)
[6] => Array
(
[file] => /tmp/cache/home/michael/www/www.michael.net.nz/library/core/library/dispatcher.php
[line] => 319
[function] => doList
[class] => GuestbookController
[object] => GuestbookController Object
(
[defaultView] => List
[content] =>
[guestbook] => Table Object
(
[name] => g_guestbook
[id] => g
[columns] => Array
(
[id] => Array
(
[name] => id
[type] => int(10)
[extra] => auto_increment
)
[name] => Array
(
[name] => name
[type] => varchar(255)
)
[comments] => Array
(
[name] => comments
[type] => text
)
[referrer] => Array
(
[name] => referrer
[type] => varchar(255)
[...SNIP...]
[type] => ->
[args] => Array
(
)
)
[7] => Array
(
[file] => /tmp/cache/home/michael/www/www.michael.net.nz/library/core/library/dispatcher.php
[line] => 164
[function] => call_controller_method
[class] => CoreDispatcher
[object] => dispatcher Object
(
[content] =>
[q] => Array
(
[mysql:host=localhost;dbname=ma2] => PDO Object
(
)
)
[class] => GuestbookController Object
(
[defaultView] => List
[content] =>
[guestbook] => Table Object
(
[name] => g_guestbook
[id] => g
[columns] => Array
(
[id] => Array
(
[name] => id
[type] => int(10)
[extra] => auto_increment
)
[name] => Array
(
[name] => name
[type] => varchar(255)
)
[...SNIP...]
[type] => ->
[args] => Array
(
[0] => GuestbookController Object
(
[defaultView] => List
[content] =>
[guestbook] => Table Object
(
[name] => g_guestbook
[id] => g
[columns] => Array
(
[id] => Array
(
[name] => id
[type] => int(10)
[extra] => auto_increment
)
[name] => Array
(
[name] => name
[type] => varchar(255)
)
[comments] => Array
(
[name] => comments
[type] => text
[...SNIP...]
)
[8] => Array
(
[file] => /tmp/cache/home/michael/www/www.michael.net.nz/library/core/library/dispatcher.php
[line] => 78
[function] => render_mvc
[class] => CoreDispatcher
[object] => dispatcher Object
(
[content] =>
[q] => Array
(
[mysql:host=localhost;dbname=ma2] => PDO Object
(
)
)
[class] => GuestbookController Object
(
[defaultView] => List
[content] =>
[guestbook] => Table Object
(
[name] => g_guestbook
[id] => g
[columns] => Array
(
[id] => Array
(
[name] => id
[type] => int(10)
[extra] => auto_increment
)
[name] => Array
(
[name] => name
[type] => varchar(255)
)
[...SNIP...]
[type] => ->
[args] => Array
(
)
)
[9] => Array
(
[file] => /home/michael/www/core3/library/kernel.php
[line] => 30
[function] => init
[class] => CoreDispatcher
[object] => dispatcher Object
(
[content] =>
[q] => Array
(
[mysql:host=localhost;dbname=ma2] => PDO Object
(
)
)
[class] => GuestbookController Object
(
[defaultView] => List
[content] =>
[guestbook] => Table Object
(
[name] => g_guestbook
[id] => g
[columns] => Array
(
[id] => Array
(
[name] => id
[type] => int(10)
[extra] => auto_increment
)
[name] => Array
(
[name] => name
[type] => varchar(255)
)
[...SNIP...]
[type] => ->
[args] => Array
(
)
)
)
|