Serendipity Forums

Code: Select all

== ERROR-REPORT (DEBUGGING ENABLED) ==
== (When you copy this debug output to a forum or other places, make sure to remove your username/passwords, as they may be contained within function calls) ==

#0 /homepages/41/d26790088/htdocs/serendipity/include/compat.inc.php(233): errorToExceptionHandler(1, 'Uncaught mysqli...', '/homepages/41/d...', 68)
#1 [internal function]: fatalErrorShutdownHandler()

Fatal Error: Uncaught mysqli_sql_exception: 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 'integer) < (1744280862)' at line 2 in /homepages/41/d26790088/htdocs/serendipity/include/db/mysqli.inc.php:68 Stack trace: #0 /homepages/41/d26790088/htdocs/serendipity/include/db/mysqli.inc.php(68): mysqli_query() #1 /homepages/41/d26790088/htdocs/serendipity/include/functions_comments.inc.php(975): serendipity_db_query() #2 /homepages/41/d26790088/htdocs/serendipity/comment.php(41): serendipity_commentSubscriptionConfirm() #3 {main} thrown in /homepages/41/d26790088/htdocs/serendipity/include/db/mysqli.inc.php on line 68.

Code: Select all

// Delete possible current cookie. Also delete any confirmation hashs that smell like 3-week-old, dead fish.
if (stristr($serendipity['dbType'], 'sqlite')) {
    $cast = "name";
} else {
    // Adds explicits casting for mysql, postgresql and others.
    $cast = "cast(name as integer)";
}

serendipity_db_query("DELETE FROM {$serendipity['dbPrefix']}options
                                WHERE okey LIKE 'commentsub_%' AND $cast < (" . (time() - 1814400) . ")");

Code: Select all

./functions_config.inc.php:455:        $cast = "cast(okey as integer)";
./functions_config.inc.php:483:        $cast = "cast(okey as integer)";