upgrade 3.0.15 error
Step 1) Fixing Corrupt Books
Code:
Database error in vBulletin 4.1.8:
Invalid SQL:
SELECT forumid
FROM vb_vault_namespace
WHERE forumid IN (254,-1
AND forumid <> 254;
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 4
Error Number : 1064
Request Date : Saturday, November 19th 2011 @ 07:53:07 PM
Error Date : Saturday, November 19th 2011 @ 07:53:07 PM
Script : http://www.xxx.com/forums/vault/install/upgrade_3x3015.php?step=1
Referrer : http://www.xxx.com/forums/vault/install/upgrade_3x3015.php
IP Address : xx.xx.xx.xxx
Username : xxxxxxx
Classname : vB_Database
MySQL Version : 5.5.17-cll
Code:
Database error in vBulletin 4.1.8:
Invalid SQL:
SELECT u.`userid`,
(`_wr` * 0) +
((`_count` - `_wr` - `_rr` - `_rd`) * 1) +
(`_rd` * 2) +
(`_rr` * 3) AS `points`,
`_rr`, `_rd`, (`_count` - `_wr` - `_rr` - `_rd`) AS `_rw`
FROM (
SELECT userid, COUNT(*) AS `_count`,
SUM(score_key != bet_score_key) AS `_wr`,
SUM(bet_home=points_home AND bet_away=points_away) AS `_rr`,
SUM(CAST(bet_home - bet_away AS SIGNED)=(points_home - points_away)
AND NOT (bet_home = points_home AND bet_away = points_away)) AS `_rd`
FROM vb_soccer_user_bet AS b
INNER JOIN vb_soccer_match AS m ON(m.id=b.match_id)
WHERE m.league_id=48 AND score_key>0
GROUP BY userid) AS userpoints
INNER JOIN vb_user AS u USING(userid)
ORDER BY points DESC, `_rr` DESC, `_rd` DESC, `_rw` DESC, username
LIMIT 40;
MySQL Error : BIGINT UNSIGNED value is out of range in '(`supagr_vb`.`b`.`bet_home` - `supagr_vb`.`b`.`bet_away`)'
Error Number : 1690
Request Date : Saturday, November 19th 2011 @ 05:05:33 PM
Error Date : Saturday, November 19th 2011 @ 05:05:33 PM
please help
Bookmarks