Bug Can't Install Latest Beta

[Webbstre]

Ok, after a bunch of computer troubles and getting things reinstalled, then trying to get my test domain finally set up, I attempted to install beta 3 onto my test forum, which is an exact replica of my live forum.

Unfortunately, very quickly into uploading the XML into the product manager, this appeared:

Updating Version Number To: 1.4.0b1

Altered Table: vb4_administrator
Altered Table: vb4_user
Altered Table: vb4_usergroup
Created Table: vb4_dbtech_downloads_category
Created Table: vb4_dbtech_downloads_comment
Created Table: vb4_dbtech_downloads_delay
Created Table: vb4_dbtech_downloads_download
Created Table: vb4_dbtech_downloads_downloadlog
Created Table: vb4_dbtech_downloads_extension
Created Table: vb4_dbtech_downloads_extensiongroup
Created Table: vb4_dbtech_downloads_favourite
Created Table: vb4_dbtech_downloads_file
Created Table: vb4_dbtech_downloads_rating
Re-created Table: vb4_dbtech_downloads_report
Populated Table: vb4_dbtech_downloads_category
Populated Table: vb4_dbtech_downloads_comment
Populated Table: vb4_dbtech_downloads_extension
Populated Table: vb4_dbtech_downloads_extensiongroup
Database error
The Runic Games Fansite database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the vb4testnew.runicgamesfansite.com home page, then try to open another page.
Click the Back button to try another link.
The vb4testnew.runicgamesfansite.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Invalid SQL:

				REPLACE INTO vb4_dbtech_downloads_download
				SELECT * FROM vb4_dbtech_downloads_filegroup;

MySQL Error   : Column count doesn't match value count at row 1
Error Number  : 1136
Request Date  : Friday, February 1st 2013 @ 10:24:25 PM
Error Date    : Friday, February 1st 2013 @ 10:24:36 PM
Script        : http://(test domain)/admincp/plugin.php?do=productimport
Referrer      : http://(test domain)/admincp/plugin.php?do=productadd
IP Address    : 125.207.211.47
Username      : Webbstre
Classname     : vB_Database
MySQL Version : 5.1.56-log

I altered the URL to hide the test domain from bots.

 

[Fillip H.]

Have you altered the filegroup table from its default amount of rows? Compare filegroup and download tables, let me know which rows differ.

 

[Webbstre]

Sorry for the slow response. I suspect we had to alter some of the tables when previous bugs caused things like files with no user assigned to them. Currently the database in my test domain is completely un-usable due to the failed upgrade. What should I do?

 

[Fillip H.]

Can you please compare the column count of dbtech_downloads_filegroup and dbtech_downloads_download and let me know if the amount of columns differ?

If so, please provide a screenshot of the Table Structure page in phpMyAdmin for both those tables.

 

[Webbstre]

I don't appear to have one of those tables? Here is what I see:

vb4_dbtech_downloads_categories
vb4_dbtech_downloads_comments
vb4_dbtech_downloads_extensions
vb4_dbtech_downloads_extension_groups
vb4_dbtech_downloads_filegroup
vb4_dbtech_downloads_filehash
vb4_dbtech_downloads_fileinfo
vb4_dbtech_downloads_filequeue
vb4_dbtech_downloads_modules
vb4_dbtech_downloads_ratings
vb4_dbtech_downloads_report

And a screenshot for you:

 

[Fillip H.]

What happens if you restart the installation?

 

[Webbstre]

I tried it again, using a fresh copy and the latest 2.0 beta. Same problem

 

[Fillip H.]

Can you give me FTP / AdminCP / phpMyAdmin access to this test site so I can see about figuring it out?

 

[Webbstre]

PM Sent! Thanks as always

 

[Fillip H.]

Just a quick note for anyone else seeing the thread: This was resolved, there were some custom columns in one of the database tables that halted the upgrade