Issue: Upgrade from 3.0.20 to latest

Issue Tools
- View Changes

February 17, 2024 1:23 AM
pingelich

Junior Member
Upgrade from 3.0.20 to latest

Table 'vb_vw_accelerate' doesn't exist

Hi,

I'm trying to upgrade from 3.0.20 to latest version of VaultWiki by following this blog post (https://www.vaultwiki.org/blogs/56/).
My issues is starting at Actually Upgrading > 5. I'm redirected to <site>/admincp/wiki_cp.php?panel=install. Here I'm getting following error:

Code:

Invalid SQL: INSERT IGNORE INTO `vb_vw_accelerate` (`entry_type`, `entry_name`, `entry_content`) VALUES ('file','/var/www/vault/core/model/dependency/vb4.php','1'), ... MySQL Error : Table 'vb_vw_accelerate' doesn't exist ...

The site is running on vB 4.2.5

How to solve it?

Cheers
Marco

Issue Details

Issue Number 6420

Issue Type Bug

Project VaultWiki 4.x Series

Category Importing

Status Fixed

Priority 2 - Fatal / Database Errors

Affected Version 4.1.7

Fixed Version 4.1.8

Milestone (none)

Software DependencyvBulletin 4.x w/ ckEditor

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

February 18, 2024 9:07 AM

pegasus

VaultWiki Team

Thanks for reporting this issue when upgrading from 3.x.

In vault/hard/core.php, find:

Code:

if (!self::model('Version')->installed('4.1.7'))

Replace with:

Code:

if (!self::model('Version')->installed('4.1.7') OR !self::model('Version')->patched(':installdb', 1))

In vault/install/full/steps/vw.php, find:

Code:

			if (!vw_Hard_Core::install('DB/Create')->execute($caller))
			{
				$next_step = false;

AFTER it, add:

Code:

vw_Hard_Core::model('Version')->patch(':installdb', 1);

February 18, 2024 12:45 PM

pingelich

Junior Member

Thank you! It is working so far, but now it is stuck at step 10:

Code:

[Error] [url]https://www.mysite.com/yui_loader.php?v=619dbf86&f=node-event-delegate/node-event-delegate-min.js,pluginhost-base/pluginhost-base-min.js,pluginhost-config/pluginhost-config-min.js,node-pluginhost/node-pluginhost-min.js,dom-screen/dom-screen-min.js,node-screen/node-screen-min.js,transition/transition-min.js[/url]
[Error] Failed to load resource: the server responded with a status of 500 (Internal Server Error) (yui_loader.php, line 0)
[Error] TypeError: undefined is not an object (evaluating 'str.trim')
	html_encode (cp-progress.js:741)
	popup (cp-progress.js:911)
	popup (cp-progress.js:11)
	(anonymous function) (cp-progress.js:778)
	recursive (base.js:318)
	(anonymous function) (base.js:363)
	(anonymous function) (base.js:1122)
	(anonymous function) (base.js:988)
	Global Code (overlay.js:7)

February 19, 2024 9:36 AM

pegasus

VaultWiki Team

It looks like your server is failing to load that URL for some reason. If you visit that yui_loader URL directly, do you get a specific error message, or can you find an error message in the server logs? Unfortunately "500 Internal Server Error" doesn't provide any useful information. It can be something like your server blocks URLs that are too long, or your server installed an update and missed the request, or the URL throws an error in PHP, or a file permissions issue, etc. If the error happens consistently, we will need to track down the actual error message to resolve that.

If you would prefer, you can submit a ticket here and we can investigate the issue for you: https://www.vaultwiki.org/members/?do=tickets

Reply

February 19, 2024 11:08 AM

pingelich

Junior Member

Yes, there was an issue with the config.php file.. Now I only have this error in my browser console as it seems to Js related, nowhere else (on the server).

Any idea?

Code:

cp-progress.js?v=095067c3:741 
Uncaught TypeError: Cannot read properties of undefined (reading 'trim')
    at Object.html_encode (cp-progress.js?v=095067c3:741:14)
    at Object.popup (cp-progress.js?v=095067c3:911:16)
    at Object.popup (cp-progress.js?v=095067c3:11:54)
    at cp-progress.js?v=095067c3:778:22
    at window.vw_Model.recursive (base.js?v=095067c3:318:6)
    at vw_Model.fire (base.js?v=095067c3:363:15)
    at vw_Model.onload_extend (base.js?v=095067c3:1122:9)
    at vw_Model.extend (base.js?v=095067c3:988:8)
    at overlay.js?v=095067c3:7:14
html_encode @ cp-progress.js?v=095067c3:741
popup @ cp-progress.js?v=095067c3:911
popup @ cp-progress.js?v=095067c3:11
(anonymous) @ cp-progress.js?v=095067c3:778
recursive @ base.js?v=095067c3:318
vw_Model.fire @ base.js?v=095067c3:363
vw_Model.onload_extend @ base.js?v=095067c3:1122
vw_Model.extend @ base.js?v=095067c3:988
(anonymous) @ overlay.js?v=095067c3:7

February 19, 2024 11:24 AM

pegasus

VaultWiki Team

When you make an attempt, please open your browser console's Network (or similar) tab and you should see that right before this error, the browser makes a request to a PHP file like wiki_cp.php?panel=install&progress=1
Please send me the content from that tab that the server responds with (usually under a section called "Response"). Normally it looks like gibberish. I believe in this case the installer is trying to ask you a question but for some reason something else is happening.

Reply

February 19, 2024 3:08 PM

pingelich

Junior Member

Thanks for your help! :-)

Yes I guess so... I tried to debug the javascript a bit and was able to get a popup, but without any content as 'title' is 'undefined'. By setting title to some string I was in a loop after clicking the continue button..

Code:

	popup: function(type, title, content)
	{
		title = this.html_encode(title);


		var overlay = vw_Overlay_obj.create('progress-' + this.progress_bar.generateID());


		overlay.set_title(title);
		overlay.set_content(content);


		// set cancel button url
		overlay.set_foot(this.popup_closer(type));


		return overlay;
	},

Here is what you requested:
Response.

Code:

VW\PROGRESS:{hf7acea3b36000000496e7374616c6c696e67205661756c7457696b692076342e312e37s6ecced690e00000053746570203130?038d08c000000000}

Headers

Code:

Request URL:
[url]https://www.mysite.com/administration/wiki_cp.php?panel=install&progress=1[/url]
Request Method:
POST
Status Code:
200 OK
Remote Address:
x.x.x.x:443
Referrer Policy:
strict-origin-when-cross-origin


HTTP/1.1 200 OK
Date: Mon, 19 Feb 2024 20:00:21 GMT
Server: Apache/2.4.29 (Ubuntu)
X-Powered-By: PHP/5.6.40
Connection: close
Cache-Control: no-cache, must-revalidate
Content-Encoding: none
X-Accel-Buffering: no
Surrogate-Control: BigPipe/1.0
X-VW-Stream: progress
Transfer-Encoding: chunked
Content-Type: application/octet-stream


POST /administration/wiki_cp.php?panel=install&progress=1 HTTP/1.1
Accept: */*
Accept-Encoding: gzip, deflate, br
Accept-Language: en-GB,en-US;q=0.9,en;q=0.8
Connection: keep-alive
Content-Length: 90
Content-type: application/x-www-form-urlencoded
Cookie: bb_lastvisit=1708267836; bb_lastactivity=0; bb_userid=1; bb_password=d43e1be06327c580c8debd0bb6004cd1; bb_userstyleid=7; bb_skimlinks_enabled=1; bb_; bb_cpsession=3fae01ac8c6ef960e0a9db2d29f51cd5
Host: [url]www.mysite.com[/url]
Origin: [url]https://www.mysite.com[/url]
Referer: [url]https://www.mysite.com/administration/wiki_cp.php?panel=install[/url]
Sec-Fetch-Dest: empty
Sec-Fetch-Mode: cors
Sec-Fetch-Site: same-origin
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36
sec-ch-ua: "Not A(Brand";v="99", "Google Chrome";v="121", "Chromium";v="121"
sec-ch-ua-mobile: ?0
sec-ch-ua-platform: "macOS"

February 20, 2024 11:25 AM
pegasus

VaultWiki Team
I see that the packets are being formed and the content makes sense, but the body of the popup is returned as an empty string which can only mean json_encode is failing. We can try to get more information about the reason for the failure, but judging from your website I see that your site is in German language and uses character set ISO-8859-1. Therefore I think you probably have some usergroups with umlauts or other similar characters in the name. I think most likely the failure is occurring trying to send an ISO-8859-1 accented character (such as umlaut) through json_encode which wants UTF-8 input only.

In vault/install/lib/full/steps/vb3.php, find:

Code:

'label' => strip_tags($group['title'])

Replace with:

Code:

'label' => strip_tags(vw_Hard_Core::model('String')->normalize($group['title'], VW_CHARSET))

This will attempt to display the names of your usergroups using the installer's character set.
Reply

February 20, 2024 3:39 PM

pingelich

Junior Member

Yes, we have ISO for historical reasons. :/

With this fix the installation part is done, but with enabled wiki the forum isn't working anymore..

Code:

[B]Fatal Error[/B][COLOR=#000000]: attempted to instantiate non-existent class [/COLOR][I]vw_UI_Special_Data_Statistics_Controller
[I][vw-core]/controller/ui/special/data/statistics/vw.php does not exist or does not contain the specified class.

#0: vw_Hard_Core::fetch_object() in [vw-depot]/vault/hard/core.php at line 907
#1: vw_Hard_Core::controller() in [vw-core]/model/plugins/forum/vw.php at line 321
#2: vw_Plugins_Forum_Model->statistics_block() in [vw-core]/model/plugins/forum/vb3.php at line 596
#3: vw_Plugins_Forum_Model_vB3->forumhome_complete() in [vw-depot]/forum.php(791) : eval()'d code at line 8
#4: eval() in [vw-depot]/forum.php at line 791

Please forward this error to VaultWiki technical support at [URL]https://www.vaultwiki.org/support/4X/[/URL] or email [EMAIL="support@vaultwiki.org"]support@vaultwiki.org[/EMAIL].[/I][/I]

February 20, 2024 4:21 PM
pingelich

Junior Member
Ok, that was an mistake while uploading the files.. it is fixed..
But even with a new upload of files the forum isn't working anymore. Topics cannot be opened. In error logs I have this:

Code:

[Tue Feb 20 22:09:55.746348 2024] [proxy_fcgi:error] [pid 11:tid 139698206881536] [client 66.249.72.236:50379] AH01071: Got error 'PHP message: PHP Fatal error: Cannot access protected property vw_Parser_Default_Wrapper_Model::$class in /var/www/web/vault/core/model/plugins/bbcode/vb3.php on line 94\n'

Also while importing the data from vw3 is not working: Hanging in a loop

Could not find phrase 'vw_import_config_saved'.

Failed to enter Manual mode. A log for the current import was not found.
Reply
February 20, 2024 9:43 PM
pegasus

VaultWiki Team
Yes, there is a known issue in that class in newer versions of PHP. I don't know how it wasn't an error for 10 years and suddenly it is (code from Oct 2014), but in vault/core/model/parser/default/wrapper/vw.php, find:

Code:

protected $class;

Replace with:

Code:

public $class;

But I don't think this is the issue you are having with the import.
As for the import, please try the following change as it looks like it's unable to read the import ID after the screen refreshes. In vault/core/controller/cp/impex/vw.php, find:

Code:

$importid = $input->clean_gpc('p', 'importid', 'UINT');

Replace with:

Code:

$importid = $input->clean_gpc('r', 'importid', 'UINT');

If you continue to have issues, again, you are welcome to open a ticket. The VaultWiki 3 importer is from 10 years ago and I don't know when the last time anyone tried to use it was. It's possible that with changes in PHP, vBulletin, or VaultWiki since that time that it may not work smoothly anymore.
Reply

February 21, 2024 12:55 AM

pingelich

Junior Member

Thank you so much for your support..

It is getting better and better..
Now I have following error. As I checked, the 'integrate' folder isn't in the zip as well

Code:

An exception occurred: require_once([vw-core]/controller/import/handle/vw3/integrate/vw.php): failed to open stream: No such file or directory in [vw-core]/controller/import/handle/vw.php on line 48
#0: vw_CP_Progress_View->handle_php_error() in [vw-core]/controller/import/handle/vw.php at line 48
#1: vw_Import_Handle_Controller::create() in [vw-core]/controller/import/handle/vw.php at line 48
#2: vw_Import_Handle_Controller->create() in [vw-core]/controller/import/handle/vw3/area/vw.php at line 1193
#3: vw_Import_Handle_VW3_Area_Controller->add_area() in [vw-core]/controller/import/handle/vw3/area/vw.php at line 1020
#4: vw_Import_Handle_VW3_Area_Controller->do_area_namespace() in [vw-core]/controller/import/handle/vw3/area/vw.php at line 752
#5: vw_Import_Handle_VW3_Area_Controller->do_namespace() in [vw-core]/controller/import/handle/vw3/area/vw.php at line 93
#6: vw_Import_Handle_VW3_Area_Controller->do_namespaces() in [vw-core]/controller/import/steps/vw3/vw.php at line 125
#7: vw_Import_Steps_VW3_Controller->{closure}() in [vw-core]/controller/progress/steps/vw.php at line 85
#8: vw_Progress_Steps_Controller->call() in [vw-core]/controller/progress/steps/vw.php at line 56
#9: vw_Progress_Steps_Controller->execute() in [vw-core]/controller/progress/vw.php at line 191
#10: vw_Progress_Controller->exec_script() in [vw-core]/controller/progress/vw.php at line 169
#11: vw_Progress_Controller->execute() in [vw-core]/view/response/progress/vw.php at line 27
#12: vw_Response_Progress_View->stream() in [vw-core]/view/response/progress/vw.php at line 63
#13: vw_Response_Progress_View->render() in [vw-core]/view/ui/vw.php at line 75
#14: vw_UI_View->output() in [vw-depot]/vault/helper/vb/global.php at line 98
#15: require_once() in [vw-depot]/administration/wiki_cp.php at line 91

February 21, 2024 9:29 AM

pegasus

VaultWiki Team

In vault/core/controller/import/handle/vw3/area/vw.php, find:

Code:

$integrater = vw_Hard_Core::controller('Import/Handle')->create('VW3/Integrate');

Replace with:

Code:

$integrater = vw_Hard_Core::controller('Import/Handle')->create('VW3/Header');

+ Reply

All times are GMT -4. The time now is 2:45 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: Upgrade from 3.0.20 to latest

Issue Tools