No announcement yet.

database error

  • Filter
  • Time
  • Show
Clear All
new posts

  • AliMadkour
    I can view CMS page without any error !

    Maybe a plugin conflict!

    Leave a comment:

  • advancedgamerz
    started a topic [CMS] database error

    database error

    this is the error message im getting when i try to get on my home page

    Database error in vBulletin 4.2.0:

    Invalid SQL:
    SELECT blog.blogid, blog.title, blog.dateline AS publishdate, blog_text.blogtextid, blog_text.pagetext AS message, contenttype.class, attachment.attachmentid as previewimage, fd.width, fd.height
    FROM forumblog AS blog
    INNER JOIN forumblog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid)
    LEFT JOIN forumblog_categoryuser AS cu ON (cu.blogid = blog.blogid)
    LEFT JOIN forumcontenttype as contenttype ON (contenttype.class = 'BlogEntry')
    LEFT JOIN forumattachment AS attachment ON ( attachment.contentid = blog.blogid ) AND ( contenttype.contenttypeid = attachment.contenttypeid )
    LEFT JOIN forumfiledata as fd ON (attachment.filedataid = fd.filedataid)
    WHERE 1=1

    AND blog.dateline <= 1346216542

    GROUP BY blog.blogid
    ORDER BY blog.dateline DESC
    LIMIT 0,;

    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 '' at line 14
    Error Number : 1064
    Request Date : Tuesday, August 28th 2012 @ 11:02:22 PM
    Error Date : Tuesday, August 28th 2012 @ 11:02:24 PM
    Script :
    Referrer :
    IP Address :
    Username : !!!~GHOST~!!!
    Classname : vB_Database
    MySQL Version : 5.1.63-community-log
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.