Hi,

I have Drupal 5.14 and the latest of all the modules required for that

I have Vbulletin 3.6.8

I did a test and it passed and said I should start the migration.

Pressed migration button and .. just get a blank white page with the following output:

1. Importing users...
2. Importing forums...
3. Importing threads...
4. Importing posts...

That is it.

My VB database is around 300,000 posts and almost 50,000 members

I really want to get off VB and go to Drupal, please help. What should I do, where am I going wrong?

Im on a cloud hosting service.

Comments

liam mcdermott’s picture

liam mcdermott commented
Status: Active » Postponed (maintainer needs more info)

Got a URL I can have a quick look at?

zooki’s picture

zooki commented

Hi I sent an email to you,

although, not sure what information you would need to get a better idea of the problem

thank you!

liam mcdermott’s picture

liam mcdermott commented
Status: Postponed (maintainer needs more info) » Fixed

This is a permissions problem, if you look in Administer -> Logs ->Recent log entries there are lots of SQL errors. Normally though, SQL errors are reported when the import happens, so it's not surprising you missed this. :)

In short, the problem is that the vBulletin user has to have permissions to INSERT and UPDATE tables in the Drupal database.

zooki’s picture

zooki commented

OK, thank you, I am pretty new at this, :$ how do i go about doing that?

I dont think i can have cross db user access. So, make it One Database?

I am adding vb_ prefix to all the tables in my database, and then will reinstall drupal, I hope that it will install into the same database,

zooki’s picture

zooki commented

OK just to say that I made some progress, I just added vb_ prefix to the tables for my VB and then did a fresh drupal install using that database for Drupal

I managed to get something imported, but it stopped after a few minutes.

1. Importing users...
2. Importing forums...
3. Importing threads...
4. Importing posts...

liam mcdermott’s picture

liam mcdermott commented
Status: Fixed » Postponed (maintainer needs more info)

Sorry I haven't had a chance to look into this recently, but how long did you leave it when the import 'stopped'? Importing posts is the longest part of the process, and could take some minutes. :)

zooki’s picture

zooki commented

Hi Liam,

I managed to import the forum in its entirety, however, it did stop a few times, after a while where the browser was busy importing, then there was no activity in the browser window for 5, 10 minutes, so I just had to click the back button and do the import over again.. It seemed to have imported all the posts.

Also, I noticed that if the admin username for both VB and Drupal is the same, then it does not import the posts. So, I edited my Drupal admin name so that it did not conflict with the VB one.

I have a question though, does it matter if my VB attachments are stored in the file system? I have around 1 gb of attachments, I have yet to try importing the database with attachments. At the moment with my Vbulletin forum they are stored in filesystem.

liam mcdermott’s picture

liam mcdermott commented

I managed to import the forum in its entirety, however, it did stop a few times, after a while where the browser was busy importing, then there was no activity in the browser window for 5, 10 minutes, so I just had to click the back button and do the import over again

This is a bit worrying, the results for your polls will be wrong if imported more than once. If you don't care about then, then all else should be well.

5-10 minutes is not a surprising amount of time for an import of a large forum, for reference the PHP timeout option is set to two hours when the script starts! :)

does it matter if my VB attachments are stored in the file system?

This should be possible, although I've never tried migrating a forum with this setup. You should be able to copy the files into the Drupal /files/ directory, make sure your avatar images are in the /files/pictures/.

The module does change the avatar filenames, it adds the user id at the front (to avoid conflicting names). Fixing this should just be a matter of running an UPDATE query on your Drupal database.

Firstly: just try moving the files into Drupal, see what does/doesn't work, and reply here. :)

liam mcdermott’s picture

liam mcdermott commented
Status: Postponed (maintainer needs more info) » Closed (fixed)

Am going to assume you got this working. Am about to check-in a version (for Drupal 5) that automatically checks to see if there are duplicate users, and deals with them.

Anyway, if you're still getting stuck, please re-open this support request by changing the status to active. Thanks!

zooki’s picture

zooki commented
Version: 5.x-1.1 » 6.x-1.0-rc1

Yes, I have got it to import the VB Forum, although there some issues, which I think perhaps I should mention in a new post