Issue: Fatal Error on Upgrading (Alpha 1)

Issue Tools
- View Changes

July 24, 2013 5:05 PM
Morrus

Regular Member
Fatal Error on Upgrading (Alpha 1)

So I bit the bullet, renewed the license, and set aside the evening for the upgrade.

I *think* I followed the instruction correctly, but the install script gives me this when I navgigate to it:

Code:

Fatal error: Cannot redeclare class vw_Install_UpgradePath_Steps_400alpha2_3X_Controller in /vault/core/controller/install/upgradepath/steps/4/0/0/alpha/2/4X/vw.php on line 79

What am I doing wrong?

Issue Details

Issue Number 3228

Issue Type Bug

Project VaultWiki 4.x Series

Category Install / Upgrade

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.0.0 Beta 3

Fixed Version 4.0.0 Beta 3

Milestone VaultWiki 4 Beta X

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 1

Assigned Users (none)

Tags (none)

July 24, 2013 7:45 PM

Morrus

Regular Member

Hmm. This is suboptimal. I tried to reactivate the wiki in the meantime (re-enable product, switch back on in Server Settings, set wiki forums back to visible), but I just get the forum page when I click on the wiki link. I guess uploading all those files busted the original install?

Any help would be appreciated. Right now, I got nothing!

Reply
July 24, 2013 11:47 PM
pegasus

VaultWiki Team
I don't know how this bug never got reported back when Alpha 2 was released, but to fix, open the file vault/core/controller/install/upgradepath/steps/4/0/0/alpha/2/4X/vw.php, and find:

Code:

class vw_Install_UpgradePath_Steps_400alpha2_3X_Controller extends vw_Install_UpgradePath_Steps_Controller

Replace with:

Code:

class vw_Install_UpgradePath_Steps_400alpha2_4X_Controller extends vw_Install_UpgradePath_Steps_Controller
Reply
July 25, 2013 4:19 AM

Morrus

Regular Member

That fixed that; thanks.

The install script started OK, but now it seems to be hung on 7%. I've left it alone for quite some time now.

I'm not able to tell what stage that's at, because (in Firefox at least) there's a box with a scrollbar where the progress is listed, but the progress list is longer than the box and the scrollbar can't be selected.

Reply
July 25, 2013 4:24 AM

Morrus

Regular Member

Here's where it's hung. That scrollbar doesn't do anything.

(Dunno what happened to the image dimensions there - got stretched or something. Bu you should be able to see it).

Reply
July 25, 2013 8:10 AM

Morrus

Regular Member

A second attempt stalls it at 1%.

Reply
July 25, 2013 9:32 AM

pegasus

VaultWiki Team

You will have to perform the upgrade in manual mode. Simply put ?step=1 after the install URL to enter manual mode. Once you get past the problematic step, feel free to re-enter auto-mode by requesting the page without a step parameter.

Reply

July 25, 2013 9:34 AM

Morrus

Regular Member

OK, I continued on with the manual thing (yeah, I know, that was quick!)

That helped. Next 30 seconds of progress completed! Now we have a database error at:

Upgrading to 4.0.0 Alpha 1
Step 15

creating_empty_main_pages

Code:

Database Error 	Database error
The EN World: RPG News & Reviews database has encountered a problem.
Please try the following:

    Load the page again by clicking the Refresh button in your web browser.
    Open the [url]www.enworld.org[/url] home page, then try to open another page.
    Click the Back button to try another link.

The [url]www.enworld.org[/url] forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.

Database error in vBulletin 4.2.1:

Invalid SQL:
UPDATE `vw_area` SET `pageid` =  CASE `areaid` 
		 WHEN 1 THEN  
		 WHEN 2 THEN  
		 WHEN 3 THEN  
		 WHEN 4 THEN  
		 WHEN 5 THEN  
		 WHEN 6 THEN  
		 WHEN 7 THEN  
		 WHEN 8 THEN  
		 WHEN 9 THEN  
		 WHEN 10 THEN  
		 WHEN 11 THEN  
	 END  WHERE  `areaid` IN (1,2,3,4,5,6,7,8,9,10,11);

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 'WHEN 2 THEN  
		 WHEN 3 THEN  
		 WHEN 4 THEN  
		 WHEN 5 THEN  
		 WHEN 6 THEN ' at line 3
Error Number  : 1064
Request Date  : Thursday, July 25th 2013 @ 09:30:04 AM
Error Date    : Thursday, July 25th 2013 @ 09:30:04 AM
Script        : [url]http://www.enworld.org/forum/vault/install/index.php[/url]
Referrer      : [url]http://www.enworld.org/forum/vault/install/index.php[/url]
IP Address    : 
Username      : Morrus
Classname     : vB_Database
MySQL Version : 5.5.29

July 25, 2013 9:42 AM

pegasus

VaultWiki Team

Since there are bugs affecting your upgrade, I have added a free Upgrade Service to your Members area here. Please fill it out and I will see what I can do.

Reply
July 25, 2013 9:49 AM

Morrus

Regular Member

Originally Posted by pegasus

Since there are bugs affecting your upgrade, I have added a free Upgrade Service to your Members area here. Please fill it out and I will see what I can do.

Done; thanks. I'll be glad to get this upgrade over and done with!

Reply
July 25, 2013 10:51 AM

pegasus

VaultWiki Team

Fixed in the current ZIP. With some new features, there were some regressions that affected the upgrade process from VW3 to Alpha 1.

Reply
July 25, 2013 10:55 AM

Morrus

Regular Member

Does that mean I should continue with the upgrade, or are you doing it? (Don't want to cross the streams!)

Reply
July 25, 2013 12:26 PM

Morrus

Regular Member

Sorry, I'm not trying to bug you, but could you let me know if I should be doing anything?

Reply
July 25, 2013 12:27 PM

pegasus

VaultWiki Team

I would set aside your last database backup in case you notice problems with the imported data.
Due to the issues we had earlier with upgrading your site, some pages were imported twice.

Go to AdminCP > VaultWiki > Admin Panel > Integrity > URL Conflicts. Try to resolve each one.

For types of "Page,Area", only delete areas that don't have pages inside (it will tell you if it does).
For duplicate "Page" or "Redirect", compare the text content. If none is shown, I would keep the very last item in the list and delete the rest.

If you notice even after this that the wiki is still messed up, create a new database with your database backup and fill out the info in vault/core/controller/import/config/vw.php and let me know.

You do NOT need to restore your database. With the importer rather than the upgrader we can try as many times as we need to get the data without a problem. We may alter the upgrade process and just recommend this course in the future, since it's much much safer.

Reply
July 25, 2013 12:43 PM

Morrus

Regular Member

I have the db from last night. Hopefully it won't be needed, as plenty of people have posted on the boards since.

OK, I'll take a look at the URL Conflicts thing. Not sure what I'm doing there though.

So, very quick glance, lots of issues immediately apparent:

There seems to be content missing. For example this page:

http://www.enworld.org/forum/showwik...WotC-Employees

Had a great big long table of information on it.

This page:

http://www.enworld.org/forum/showwik...title=Numenera

Gives a database error.

This page:

http://www.enworld.org/forum/showwik...itle=Wiki-Home

Was my main/home page. Now it's completely blank.

(From what I can tell, all the table on pages have been erased; I use a *lot* of tables via the standard vB4 WYSIWIG editor).

Comments are all missing from pages - there were some lengthy discussions on some of them.

I assume the old wiki forums are not deleted, so all the content is still OK in there at least?

Reply

July 25, 2013 12:48 PM

Morrus

Regular Member

Attempt to delete a duplicate node gave a database error:

Code:

Database error in vBulletin 4.2.1:

Invalid SQL:
DELETE FROM `vw_report` WHERE itemtypeid = 1 AND  `itemid` IN (596);

MySQL Error   : Table 'enworld.vw_report' doesn't exist
Error Number  : 1146
Request Date  : Thursday, July 25th 2013 @ 12:45:25 PM
Error Date    : Thursday, July 25th 2013 @ 12:45:25 PM
Script        : http://www.enworld.org/forum/admincp/wiki_cp.php?panel=conflict&do=update
Referrer      : http://www.enworld.org/forum/admincp/wiki_cp.php?panel=conflict&prefixid=6&key=monsters-dragons&do=edit
IP Address    : 81.101.96.161
Username      : Morrus
Classname     : vB_Database
MySQL Version : 5.5.29

+ Reply

All times are GMT -4. The time now is 11:16 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Fatal Error on Upgrading (Alpha 1)

Issue Tools