Importing from vBulletin 3

Error with Stack Trace

I am trying to import from vBulletin and it's an older version where the php doesn't work anymore. Either 3.0 or 3.5. When I put the URL to get the import from (public_html/forums/includes/config.php) I get an error. Is this something I can fix? Error pasted below:

PHP NOTICE [8] Undefined variable: sql_host in sources/hooks/modules/admin_import/vb3.php on line 128 (version: 10.0.24, PHP version: 5.4.45, URL: /ocportal/adminzone/index.php?page=admin-import&type=hook&session=d24e4288d65d5&importer=vb3)

Here is the stack trace:

Below is a stack trace revealing the state Composr was in when the error occurred. If this represents a bug in the unmodified software, you may want to check Composr website for a fix, and if there isn't one, report this as a bug. Please note that merely posting a stack trace is not sufficient for us to solve your problem; the stack trace is just an aid that presents us with additional information. We still need to know the error message, what you tried to do, how you tried to do it, version numbers, and any other appropriate information.
We apologise for this problem and if it's a bug we hope you will work with us so that we can fix it for you promptly.

Parameters

Hi,

Sorry you didn't get a reply in a reasonable time.

I fixed this issue in git yesterday, it's an obvious bug in our code:
https://github.com/ocproducts/composr/commit/389e6ce25f473e643a3be9f98008b335942c3b77

That said, the importers aren't officially supported, and tend to break for various reasons. If you'd like me to hand-test your import in advance and make any fixes needed, send me an email with an SQL dump (chris@ocproducts.com).

Best,
Chris

Hi,

For anyone reading, I have this test data now . No new bugs happened, but it's a big forum so I'm optimising the import so it can finish more quickly, and also tweaking the user experience a bit to make it smoother. It's always great to have good real-world test data for testing an import experience.
All changes will be in the next patch release.

Oh, and I'll add - as it's a lot of data, it may well take quite a while to finish, like an hour. The easiest way to assess progress is to look to see if the number of rows in Composr database tables continue to be going up.

Thank you!

A couple more things…

1) I advise temporarily raising the Session expiry-time option (Admin Zone > Setup > Configuration > Security options > General). Put it to something like 24. This is because currently it's problematic if the session expires during an import. I'm going to improve that, but I don't think I have time to fit it into this patch release.

2) The attachments in the SQL dump you gave me seem to be corrupted. I don't think it's a problem on the importer end, but I could be wrong and can come back to it if they are working fine for your VB forum still and you're not aware of any issue. We actually used VB for this forum a long long time ago and had a similar issue once, with them corrupting after an upgrading (due to them previously being stored in the database with a character set then migrated to a blob column, but the VB upgrader messing the conversion up).

I've changed it to 24. I'm not really worried about any attachments, as long as the forums themselves import with their contents. The VB forums do not work as they are 3.5 so the php is out of date (which is why I hoped to import it into Composr). What do I need to do for that to work?

Sorry for a very late reply again, I'm having a hard time keeping up with things at the moment. I'm away on vacation now too so I won't be able to reply again until at least June 10th.

You can just import as normal, no special instructions.

However as mentioned I did want to make this work better for your large forums without having to go back in and resume the session if it takes too long. I have now done that.

If you replace your adminzone/pages/modules/admin_import.php file with this file then that will give you my latest improvements:
https://raw.githubusercontent.com/ocproducts/composr/master/adminzone/pages/modules/admin_import.php

Thank you! I replaced the admin_import.php with yours, but now it's telling me that the config.php is not there:

mpcode -> The given import path is not correct (the <kbd>includes/config.php</kbd> file is not there).

home/swepics/public_html/forums/includes/config.php – it's there.

I can email the new stack trace and/or the config.php but enjoy your vacation, I can wait.   

Hi again, I am still trying to import the vBulletin 3.5 and now I'm getting this when I click the Import icon:

Forbidden

You don't have permission to access /ocportal/adminzone/index.php on this server.

Additionally, a 403 Forbidden error was encountered while trying to use an ErrorDocument to handle the request.

I am logged in as admin, the highest rank on the site.

So it seems there a couple of issues here.

1. The import path given is wrong, should have a leading '/'. I've made a commit for it to try and fix incorrect paths https://github.com/ocp…9dfe48f31613e7731aa93f3dd
2. Something that looks like a correct path will make ModSecurity choke, I've added a workaround for ModSecurity https://github.com/ocp…c2fa441e524454377ee098b80