[ANGEL OF FIRE]

vBulletin 3.7.1

Does not work at addition ID 31

31 => 3 /*posts_copied_to_x */,

Datenbankfehler in vBulletin 3.7.1:

Invalid SQL:

            SELECT 
                modtable.username as moderator, 
                modtable.usergroupid as modgroup,
                modlog.userid as modid,
                modlog.action as action, 
                modlog.type as type,
                modlog.dateline as dateline,
                modlog.threadid as threadid,
                modlog.postid as postid,
                forum.forumid as forumid,
                thread.title as threadtitle,
                forum.title as forumtitle, 
                deletionlog.reason as delreason
            FROM moderatorlog AS modlog
            LEFT JOIN user AS modtable ON (modtable.userid = modlog.userid) 
            LEFT JOIN thread AS thread ON (thread.threadid = modlog.threadid) 
            LEFT JOIN post AS post ON (post.postid = modlog.postid)
            LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
            LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = IF(deletionlog.type = 'post', modlog.postid, modlog.threadid))
            WHERE 
            IF(modlog.postid,post.userid=1,thread.postuserid=1) AND modlog.type !=20 AND modlog.type NOT IN (5,)  AND 1212884825-modlog.dateline <86400 AND modtable.usergroupid IN (5,6,7) 
            ORDER BY dateline DESC
            LIMIT 4;

MySQL-Fehler  : 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 ')  AND 1212884825-modlog.dateline <86400 AND modtable.usergroupid IN (5,6,7) 
    ' at line 21
Fehler-Nr.    : 1064
Fehler-Zeit   : Sunday, 08.06.2008 @ 00:27:05
Datum         : Sunday, 08.06.2008 @ 00:27:05
Skript        : http://www.xxxxxx.com/usercp.php?
Referrer      : http://www.xxxxx.com/forum.php
IP-Adresse    : xxxxxxxxxxxx
Benutzername  : ANGEL OF FIRE
Klassenname   : vB_Database
MySQL-Version : 5.0.54-log