Announcement

Collapse
No announcement yet.

vBulletin Update Thread and Forum // Database Error

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

  • vBulletin Update Thread and Forum // Database Error

    Hello everyone ;

    I guess,


    There are some problems with my database.

    The first error

    Here (http://www.domainname.com/admincp/mi...o=updatethread)

    Gives the following error in the data base.

    Code:
    Database error in vBulletin 3.8.4:
    
    Invalid SQL:
    
            SELECT
                SUM(IF(visible = 1, attach, 0)) AS attachsum,
                SUM(IF(visible = 1, 1, 0)) AS visible,
                SUM(IF(visible = 0, 1, 0)) AS hidden,
                SUM(IF(visible = 2, 1, 0)) AS deleted
            FROM post AS post
            WHERE threadid = 9
                AND post.userid NOT IN (xx.xxx.xx.xx);
    
    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 '.39.18)' at line 8
    Error Number  : 1064
    Request Date  : Friday, March 26th 2010 @ 07:19:32 PM
    Error Date    : Friday, March 26th 2010 @ 07:19:32 PM
    Script        : /admincp/misc.php?do=updatethread
    Referrer      : /admincp/misc.php?do=chooser
    IP Address    : xx.xxx.xxx.xx
    Username      : Administrator
    Classname     : vB_Database
    MySQL Version : 5.0.89-community
    The other error


    Here (http://www.domainname.com/admincp/mi...do=updateforum)

    Gives the following error in the data base.

    Code:
    Database error in vBulletin 3.8.4:
    
    Invalid SQL:
    
                SELECT thread.postuserid, COUNT(*) AS threadcount
                FROM thread AS thread
                WHERE thread.postuserid IN (xx.xxx.xx.xx)
                    AND thread.visible = 1
                    AND thread.open <> 10
                    AND thread.forumid = 3
                GROUP BY thread.postuserid;
    
    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 '.39.18)
                    AND thread.visible = 1
                    AND thread.open <> 10
                    AND thread.foru' at line 3
    Error Number  : 1064
    Request Date  : Friday, March 26th 2010 @ 07:25:09 PM
    Error Date    : Friday, March 26th 2010 @ 07:25:09 PM
    Script        :  /admincp/misc.php?do=updateforum
    Referrer      : /admincp/misc.php?do=chooser
    IP Address    : xx.xxx.xxx.xx
    Username      : Administrator
    Classname     : vB_Database
    MySQL Version : 5.0.89-community
    To repair
    I have tried methods.

    1) SSH MySQL Repair > (mysqlcheck -A -h localhost -u root -r -p)
    2) vBulletin Admincp MySQL Repair (/admincp/repair.php?do=list)
    3) vBulletin 4 Upgrade Succceded. But the same mistakes are repeated. (As a result fails)
    4) I deleted all the files and I installed the new files. (Failed)
    5) config.php => Disable All Hooks (Failed) => [define('DISABLE_HOOKS', true);]
    6) phpmyadmin MySQL Repair // Failed

    To fix these errors, what should I do?

    Note: My English is not perfect.

    Thank you all
    Last edited by FuRK4N; Fri 26 Mar '10, 10:08am.

  • #2
    As the error states, the SQL syntax is wrong.

    You will need to run the finalupgrade again and disable ALL your hacks. If you've installed vB4 without hack disablement beforehand, it won't work.
    That's it. If you REALLY can't say ANYTHING nice to me at all on this forum, then I am going to go insanely mad at you. I've had enough of the UNTOLD ABUSE you are all giving me and you should really be CONSIDERATE of other people.

    Comment


    • #3
      Did you put an ipaddress in the Global Ban/ Tatchy goes to conventry feature?

      Comment

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