[Convertor] vBulletin 3.x to phpBB3

[AmazingAndrex]

So uh, I used the convertor and now all the posts are dollar signs.

http://i.imgur.com/ED1Ww.png

I was freaking out thinking all the posts were lost, but when editing the post it shows it just fine... weird. So they're all still preserved. Can anyone help me out?

Edit- Ah, ** was set to $$$$ in the censoring... weird. Deleting that made everything cool!

[AmazingAndrex]

Help PLS

I got a bunch of these errors. What you have to do is add the fields it tells you that you are missing into the vBulletin database. So add a contentid column to the attachments table. Then refresh/resubmit. You may have to do it several times.

[D¡cky]

Help PLS

I got a bunch of these errors. What you have to do is add the fields it tells you that you are missing into the vBulletin database. So add a contentid column to the attachments table. Then refresh/resubmit. You may have to do it several times.

This advice is totally wrong. If you are getting errors about missing tables, you are using the wrong convertor. vBulletin 3 does not have the attachment.contentid table. vBulletin 4 does have that table so you must be using the vBulletin 4 convertor for a vBulletin 3 database. Look in Available Convertors for the correct convertor to use with your version of vBulletin.

I was freaking out thinking all the posts were lost, but when editing the post it shows it just fine... weird. So they're all still preserved. Can anyone help me out?

Edit- Ah, ** was set to $$$$ in the censoring... weird. Deleting that made everything cool!

Glad to see that you were able to find the solution.

[majic13]

I'm attempting to convert a forum from vBulletin 3.0.1 to the latest version of phpBB. The forum is pretty well-established and has a lot of posts (the vBulletin post table is 28MB), and this seems to be causing difficulties in the conversion process.

Basically it gets through the initial checks and starts in on the conversion process, but times out partway through converting the database. This happens even when I'm performing the conversion locally on my own machine (using a mockup of the old and new forums and databases on EasyPHP, as described in the Offline Conversion knowledgebase article). The postindex table has been cleared out as well, just on the off-chance that'd help.

Is there any way to break the conversion down into smaller, more manageable chunks? Or might there be something else that's causing the converter to time out? Anything obvious I might've missed?

EDIT: Just tried running the conversion again after following the advice in this post, and can confirm that it's choking on the post table - it got to step 7 of 16, last step shown was converting the post table, then it time out again.

[ManiacX]

I am on the final stages of my conversion and I keep getting this error:

General Error
SQL ERROR [ mysqli ]

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 ')' at line 1 [1064]

SQL

insert into phpbb_poll_options (poll_option_id,topic_id,poll_option_text,poll_option_total) values(83,19517,'',)

BACKTRACE

FILE: [ROOT]/includes/db/mysqli.php
LINE: 182
CALL: dbal->sql_error()

FILE: [ROOT]/install/convertors/functions_vb30.php
LINE: 56
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/install/install_convert.php(1654) : eval()'d code
LINE: 2
CALL: vb_import_polloption()

FILE: [ROOT]/install/install_convert.php
LINE: 1654
CALL: eval()

FILE: [ROOT]/install/install_convert.php
LINE: 799
CALL: install_convert->jump()

FILE: [ROOT]/install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: [ROOT]/install/index.php
LINE: 326
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 203
CALL: module->load()

Any idea how to get past this?

Thanks.

[D¡cky]

I am on the final stages of my conversion and I keep getting this error:
Any idea how to get past this?

Thanks.

What may be happening is that votes are missing from one of the poll options. Look in the vb_threads table and find threadid 19517. Look to see what the pollid is for this thread and make a note of it. The look in the vb_poll table and find this pollid. In the options field, how many options are listed? In the votes field, how many sets of votes are listed? The number of sets of votes listed should match the number of options. For example, this poll has 4 options:phpBB |||vBulletin |||SMF |||MyBB and 4 sets of votes 1|||0|||0|||1. I suspect that you have only 3 sets of votes.

[ManiacX]

Hi Dicky,

Thanks, will take a crack at it tonight. Would it be easier to just delete that problem thread entirely? Its probably pretty old anyway.

[D¡cky]

Deleting the thread would probably work if it deletes the poll also, but I would appreciate it if you don't mind to help solve this problem. Other users have complained of this problem and I have been unable to reproduce the problem so I don't know how to fix it.

[ManiacX]

Ok so it is PollId 83. Numberoptions is 11. Votes is blank, voters is 14.

[ManiacX]

After deleting that poll, the error comes up again with a different thread ID. Seems like I'm having to delete every poll in the history of the forum.

[D¡cky]

Ok so it is PollId 83. Numberoptions is 11. Votes is blank, voters is 14.

With votes being blank, how do you know which option was voted on? If the error happens again, look at the poll on the vBulletin board and see if it gives the votes for each option.

[ManiacX]

On the forum the votes are displayed, but in phpMyAdmin the "votes" row is totally blank.

[D¡cky]

So ... it would appear that the votes for each option are stored somewhere else rather than the votes field. Can you try to find where they are stored? Or send me a backup of the database and I will look.

Also, what version of vBulletin are you converting from?

[ManiacX]

It is 3.8.3.

I will send you the backup of the db...where do i send it?

Also, conversion is completed (hallelujah!) but I don't have admin rights somehow so i can't access the ACP. There a way around that?

[D¡cky]

I will send you the backup of the db...where do i send it?

The best way for me is to place the backup on your server and PM me a link to the file. If the file is not too large, you can email it to me.

Also, conversion is completed (hallelujah!) but I don't have admin rights somehow so i can't access the ACP. There a way around that?

Log off the board, then run this query in phpMyAdmin:

Code: Select all

UPDATE phpbb_users SET user_type = 3, user_permissions = '' WHERE user_id = xx

Replace xx with your user_id and replace phpbb_ if that is not your table prefix.