Suite Upgrade failed? 3.8.6-p1 -> 4.0.5, parse errors
 

Hi guys
I upgraded my forum from 3.8.4 to 1.8.6-p1 two weeks ago, and all went well.

I just now upgraded it from 3.8.6-p1 to 4.0.5.

The upgrade process went well, and in the end when it asked me to login
http://site/upgrades/vbps_4.0.5/upload/login.php?do=login
it gave me the following errors:
Code:
Warning: fetch_template() calls should be replaced by the vB_Template class. Template name: forumhome_google_ads2 in [path]/includes/functions.php on line 3984

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in [path]/includes/class_bootstrap.php(1280) : eval()'d code on line 4

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in [path]/includes/class_bootstrap.php(1280) : eval()'d code on line 6

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in [path]/includes/class_bootstrap.php(1280) : eval()'d code on line 10

Fatal error: Call to a member function hide_errors() on a non-object in /home/boerev/public_html/upgrades/vbps_4.0.5/upload/includes/class_bootstrap.php(394) : eval()'d code on line 983
Then when I try to go to the homepage I get the following:
Code:
Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/boerev/public_html/forum/global.php(832) : eval()'d code on line 6

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/boerev/public_html/forum/global.php(833) : eval()'d code on line 5

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/boerev/public_html/forum/global.php(834) : eval()'d code on line 8

and more
In admincp default page I get this on the main page:
Code:
Database error in vBulletin 4.0.5:

Invalid SQL:

SELECT COUNT(*) AS count
FROM attachment AS attachment
INNER JOIN post AS post USING (postid)
WHERE attachment.visible = 0;

MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Request Date : Sunday, August 29th 2010 @ 11:54:52 AM
Error Date : Sunday, August 29th 2010 @ 11:54:52 AM
Script : http://site/forums/admincp/index.php?do=home
Referrer : http://site/forums/admincp/index.php
IP Address : x.x.x.x
Username : adminuser
Classname : vB_Database
MySQL Version : 5.0.91-community
I saw some template issues, deleted the incompatible ones, and am now looking at what seems to be the only vbulletin default style.
The rest of the admincp console still works, it's just the main page that's giving me issues

I'm out of ideas, can anyone help with this?