3.0.3 to 3.6rc1 upgrade not working!

[1yesfan]

http://www.yesfans.com/forum/install/upgrade_350b1.php?step=7

Step 7) Upgrade to vBulletin 3.5.0 Beta 1 Complete!
Database errorThe Yesfans.com: Founded 4/01 database has encountered a problem.Please try the following:
Load the page again by clicking the Refresh (http://www.yesfans.com/forum/install/upgrade_350b1.php?step=7#) button in your web browser.
Open the www.yesfans.com (http://www.yesfans.com/) home page, then try to open another page.
Click the Back (javascript:history.back(1)) button to try another link.The www.yesfans.com forum technical staff have been notified of the error, though you may contact them (techhelp@yesfans.com) if the problem persists.
We apologise for any inconvenience.

Database error in vBulletin 3.0.14:
Invalid SQL:
SELECT forum.*, NOT ISNULL(podcast.forumid) AS podcast
FROM forum AS forum
LEFT JOIN podcast AS podcast ON (forum.forumid = podcast.forumid AND podcast.enabled = 1)
ORDER BY displayorder;
MySQL Error : Table 'yesfan1_yesfan12forumsql.podcast' doesn't exist
Error Number : 1146
Date : Tuesday, July 11th 2006 @ 04:17:04 PM
Script : http://www.yesfans.com/forum/install/upgrade_350b1.php?step=7
Referrer : http://www.yesfans.com/forum/install/install.php?step=2
IP Address : 24.29.18.51
Username :
Classname : vb_database


uploaded the UPLOAD folder 3x, still hitting this error. Reported as a bug already, noted it in a like thread (same error for others) and now have been told to open it's own thread.

[Zachery]

If you are upgrading from vB 3.0.3 you should be starting from a differnt upgrade. Had any of the previous upgrade steps been run at all?

[1yesfan]

When I first started it went through many steps jsut fine, then I hit this step and this happens. I re installed all the files, started the install.phph and the upgrade.php 9was told to use that jsut now in the bug thread I started) and it still goes right to this error..

[1yesfan]

I am assuming that I can upgrade from 3.0.3 to 3.6. I run the www.yesfans.com/forum/install.php (http://www.yesfans.com/forum/install.php) or the www.yesfans.com/forum/upgrade.php (http://www.yesfans.com/forum/upgrade.php) things and I get this error!

[1yesfan]

issue listed above by me here is fixed....

[Zachery]

How did you get it resolved?

[1yesfan]

resolved in BUG report forum thingy....

edit includes/adminfunctions.php and find around line 2913:
PHP Code:

$newforumcache = $vbulletin->db->query_read("
SELECT forum.*, NOT ISNULL(podcast.forumid) AS podcast
FROM " . TABLE_PREFIX . "forum AS forum
LEFT JOIN " . TABLE_PREFIX . "podcast AS podcast ON (forum.forumid = podcast.forumid AND podcast.enabled = 1)
ORDER BY displayorder
");



replace with
PHP Code:

$newforumcache = $vbulletin->db->query_read("
SELECT forum.*" . (VB_AREA != 'Upgrade' ? ",
NOT ISNULL(podcast.forumid) AS podcast" : "") . "
FROM " . TABLE_PREFIX . "forum AS forum
" . (VB_AREA != 'Upgrade' ? "LEFT JOIN " . TABLE_PREFIX . "podcast AS podcast ON (forum.forumid = podcast.forumid AND podcast.enabled = 1)" : "") . "
ORDER BY displayorder
");