Announcement

Collapse
No announcement yet.

After upgrading 4.0.6, I got error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] After upgrading 4.0.6, I got error

    Hello,

    I upgraded to 4.0.6 without any error, but after that, sometime I got some error link this.

    Database error in vBulletin 4.0.6:

    Invalid SQL:

    SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.lastposterid, thread.dateline, thread.views, thread.visible, thread.open, user.usergroupid, user.displaygroupid
    FROM thread AS thread
    LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
    WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10' AND thread.forumid NOT IN(6,45,65,69,21,39,)
    ORDER BY lastpost DESC
    LIMIT 0, 10;

    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 ')
    ORDER BY lastpost DESC
    LIMIT 0, 10' at line 4
    Error Number : 1064

    Request Date : Monday, August 16th 2010 @ 11:46:52 AM
    Error Date : Monday, August 16th 2010 @ 11:46:52 AM

    Script : http://www.domain.net/diendan/forumd...-độ
    Referrer :

    IP Address : 113.22.68.*
    Can you guys here help me and tell me how to fix this?

    Thanks in advance.

  • #2
    Try disabling your modifications/plugins and see if you still have this problem.
    Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

    PHP Code:
    define('DISABLE_HOOKS'true); 

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools &lt;- awesome site for html/css help

    Comment


    • #3
      Originally posted by Lynne View Post
      Try disabling your modifications/plugins and see if you still have this problem.
      Note: To temporarily disable the plugin system, edit includes/config.php and add this line right under <?php

      PHP Code:
      define('DISABLE_HOOKS'true); 
      Do you mean that happens because of plugin I installed?

      Comment


      • #4
        I don't know. But in order to find out, try disabling your plugins and see if you still have the problem.

        Please don't PM or VM me for support - I only help out in the threads.
        vBulletin Manual & vBulletin 4.0 Code Documentation (API)
        Want help modifying your vbulletin forum? Head on over to vbulletin.org
        If I post CSS and you don't know where it goes, throw it into the additional.css template.

        W3Schools &lt;- awesome site for html/css help

        Comment

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