vBulletin Update Thread and Forum // Database Error

محروم.كوم · #1 03-26-2010, 09:50 PM

Hello everyone ;

Think,

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);]

To correct these errors, what should I do?

Note: My English is not perfect.

Thank you all __DEFINE_LIKE_SHARE__