Blog MYSQL error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Eagle Creek
    Senior Member
    • Apr 2003
    • 1206
    • 3.6.x

    Blog MYSQL error

    Database error in vBulletin 3.6.8:

    Invalid SQL:


    SELECT COUNT(*) AS total,
    FROM_UNIXTIME(dateline - , '%c-%e-%Y') AS period
    FROM blog AS blog

    WHERE state IN('visible', 'moderation', 'deleted') AND dateline >= 1206313200 AND dateline < 1208300065 AND blog.userid = 275
    GROUP BY period;

    MySQL Error : 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 ' '%c-%e-%Y') AS period
    FROM blog AS blog

    WHERE state IN('visible', 'mo' at line 2
    Error Number : 1064
    Date : Wednesday, April 16th 2008 @ 12:54:25 AM
    Script : http://www.nucia.nl/forum/blog.php?b=83
    Referrer :
    IP Address :
    Username : Eagle Creek
    Classname : vB_Database

    What to do about it :-).
    http://www.nucia.nl/forum/
    The best way to kill malware; is to kill it together.
  • Jake Bunce
    Senior Member
    • Dec 2000
    • 46598
    • 3.6.x

    #2
    Syntax errors are usually code problems. Try these standard troubleshooting steps to see if the problem goes away. Then you can begin to isolate it.

    Try disabling your plugins:

    Admin CP -> vBulletin Options -> Plugin/Hook System

    Also run a file check to look for customized files:

    Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

    Comment

    • Eagle Creek
      Senior Member
      • Apr 2003
      • 1206
      • 3.6.x

      #3
      Going to try, thanks.
      http://www.nucia.nl/forum/
      The best way to kill malware; is to kill it together.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...