PHP Error Report
Date:2024-11-03 10:08:46 (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
                (
                )
                
        )

)