Error after upgrade

After an upgrade, this error appears

Code:

---

Fatal error: Call to undefined function vault_group_permission() in /www/showwiki.php on line 970

---

Has been settled. See here: https://www.vaultwiki.org/threads/4920/

Make sure that all the files were uploaded to your forum. It sounds like the current version of vault/functions/group.php isn't there, since this contains vault_group_permission() right at the top...

EDIT: Okay, yes. Always need to be careful to select the right patch-file.

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

Fixed in 3.0.15 Build 002. Download the new build from the Members Area and continue the upgrade from your current step.

Thanks, fixed.