Database error upgrading from vb 3.0.7

[Joe Blow]

Okay, I got a fair way into the upgrade before encountering this error:

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 'jkeiby_vhost2801.podcast' doesn't exist
Error Number : 1146
Date : Tuesday, July 11th 2006 @ 04:44:21 AM
Script : http://XXX.XXX.XXX.XXX/forums/install/upgrade_350b1.php?step=7 (http://207.210.111.166/forums/install/upgrade_350b1.php?step=7)
Referrer : http://XXX.XXX.XXX.XXX/forums/install/upgrade_350b1.php?step=7 (http://207.210.111.166/forums/install/upgrade_350b1.php?step=7)
IP Address : XXX.XXX.XX.XXX
Username :
Classname : vb_database
:confused:

Any help appreciated!

[Colin F]

That file doesn't have such a query in it.
Reupload the default files and run the upgrade.php script again please.

[Joe Blow]

That file doesn't have such a query in it.
Reupload the default files and run the upgrade.php script again please.

I reuploaded all the files and ran the upgrade script again and got the same error:

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 'jkeiby_vhost2801.podcast' doesn't exist
Error Number : 1146
Date : Tuesday, July 11th 2006 @ 09:53:48 AM
Script : http://XXX.XXX.XXX.XXX/forums/install/upgrade_350b1.php?step=7 (http://207.210.111.166/forums/install/upgrade_350b1.php?step=7)
Referrer : http://XXX.XXX.XXX.XXX/forums/install/upgrade_350b1.php?step=6 (http://207.210.111.166/forums/install/upgrade_350b1.php?step=7)
IP Address : XXX.XXX.XX.XXX
Username :
Classname : vb_database
Any more ideas? :(

[1yesfan]

I am getting the same error! Anyone?

[Steve Machol]

I have personally checked the upgrade_350b1.php script. There is no query dealing with 'podcast' in that script. I have no idea where that is coming from.

[1yesfan]

Ha ha ha, well it has to be from your side??? I dowloaded 3.6rc1 or what ever you call it and this is the error I get doign the upgrade from 3.0.3

[1yesfan]

No query that xcan be run or what ever to get aroudn this?

[Steve Machol]

That query does exist in upgrade_360b1.php, but not upgrade_350b1.php which is what the error shows.

[1yesfan]

ok, what do I do now, I am dead in the water at this error in the upgrade process.

[1yesfan]

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


Step 7) Upgrade to vBulletin 3.5.0 Beta 1 Complete!
http://www.yesfans.com/forum/image.php?type=dberrorDatabase 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'yesfan1_yesfan12forumsql.podcast'
Date : Tuesday, July 11th 2006 @ 02:32:55 PM
Script : http://www.yesfans.com/forum/install/upgrade_350b1.php?step=7
Referrer : http://www.yesfans.com/forum/install/upgrade_350b1.php?step=6
IP Address : 24.29.18.51
Username :
Classname : vb_database





That is what I am getting....

[Steve Machol]

I honestly don't see how you can get this error with the original 3.6.0RC1 files. I suggest deleting the originals and then reuploading them.

[daredevildan]

I'm getting database error too when the upgrade script attempts to run. (upgrade from 3.6 beta 4)

[1yesfan]

I installed the INSTALL folder again, same error, at the same place in the install process.

[Steve Machol]

Please start your own thread with all the relevant info related to your problem.

[Steve Machol]

I installed the INSTALL folder again, same error, at the same place in the install process.
I honestly don't see how but please feel free to report this in the 3.6 Bug Tracker here:

http://www.vbulletin.com/forum/bugs36.php

[1yesfan]

I am installed the UPLAOD folder again as you asked.

[1yesfan]

reloaded, same error!

[1yesfan]

I tried the install from step one, got this error right out the gate! Reporting bug now...

[1yesfan]

isnt the error saying that a podcast table does not exist? Can't I add to the tables what this step is lookign for or does it not work this way?

[1yesfan]

isnt the error saying that a podcast table does not exist? Can't I add to the tables what this step is lookign for or does it not work this way?




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


Step 7) Upgrade to vBulletin 3.5.0 Beta 1 Complete!
http://www.yesfans.com/forum/image.php?type=dberrorDatabase 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 (http://javascript<b></b>:history.back(1)) button to try another link.The www.yesfans.com (http://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'yesfan1_yesfan12forumsql.podcast'
Date : Tuesday, July 11th 2006 @ 02:32:55 PM
Script : http://www.yesfans.com/forum/install/upgrade_350b1.php?step=7
Referrer : http://www.yesfans.com/forum/install/upgrade_350b1.php?step=6
IP Address : 24.29.18.51
Username :
Classname : vb_database





That is what I am getting....