VB 3.5 to SMF 1.1.4??

[Mystique]

What converter should I use to convert a vb 3.5.0 to smf 1.1.4??

[SleePy]

Are you able to upgrade to 3.6? I know we have one for 3.6 but we would have to search around to try to find one for 3.5..

The converter might work. Go ahead and using a test database of both smf and VB try to convert and see how things go.

[Mystique]

No, upgrading to 3.6 isn't an option. was wondering if the converter from 3.5 to 1.1.2 would work??

[mtindor]

No, upgrading to 3.6 isn't an option. was wondering if the converter from 3.5 to 1.1.2 would work??

I just converted a board with about 40K posts (IIRC).   Vbulletin was 3.51 and SMF was 1.1.4.   I used teh 3.5 to 1.1.2 converter.

I had a problem the first time I ran it (some problems apparently converting some data).   I ran it again and it completed and seemed to have done everything as expected - attachments, avatars, posts, boards, etc.

The one thing I had a problem with was PMs.   We had some users with hundreds (or even thousands) of PMs.   And it appears that for those with large numbers of PMs, it only converted less than 100.   My PM mailbox, for instance, has over 2000 messages on vB.     but it only imported 86 of those over.

So I think there is  a problem with using the 3.5 to 1.1.2 converter when going from Vbulletin 3.5 to 1.1.4..   However, with that said, I'm still going to do further testing to see if I can figure out what is happening in order to attempt to fix.   And, all in all, I think the conversion went magnitudes better than I could ever have expected.   I think it did an excellent job.

From reading about the 3.6 converter, I doubt you would want to use it witih 3.5 - in fact, I doubt you'd want to use it at all.   Looks like there are known unfixed bugs/issues with the 3.6 converter that don't exist in 3.5.   So if I were you I would _not_ attempt to update to 3.6 before converting.   I would try using the 3.5 to 1.1.2 converter to convert your 3.5 to 1.1.4 SMF.

Oh - its a win/win situation either way - you won't mess anything up on your Vbulletin forum by running the converter, so there is no harm in testing it for yourself and seeing how it works for you.

Mike

[SleePy]

If you are able to figure it out, feel free to post it up to benefit future conversions
As well I will put it in our bug tracker for jay to fix up.

[mtindor]

If you are able to figure it out, feel free to post it up to benefit future conversions
As well I will put it in our bug tracker for jay to fix up.

Will do.   It is taking me a long time to figure out the PM logic in VB 3.5.1 as well as in SMF 1.1.4.   This is compounded by the fact that I'm truly not a PHP or SQL coder.

I definitely can verify that there is a problem.    SMF appears to require an entry in pm_recipients for EACH person that is the recipient of a PM.    The VB 3.5-to-SMF 1.1.2 converter doesn't even begin to take this into consideration.    The converter is trying to take information from pmreceipt (a VB table) and put it into pm_recipients (an SMF table).   The problem is that the pmreceipt table in VB is only designed to keep track of the receipt/acceptance/denial of PMs to recipients.

The VB table that the converter needs to query in order to gain information about recipient user ids to add to pm_recipients (an SMF table) is pm (a VB table).    pm (the VB table) contains the user id of all users who are recipients of the message.

In pm (the VB table), if pm.folderid = '-1', then the userid in that table entry is the sender (and the message goes into the users outbox).    If pm.folderid != '-1', then the userid in that table entry is the recipient of the PM.

I may figure something out after struggling the rest of the weekend.   This is truly a challenge for me - It would not be a challenge for an SQL person, especially one familiar with the logic of the VB pm tables and the SMF pm tables.

file as distributed:  smf_1-1-2_vbulletin35_converter.tar.gz
specific SQL file:  vbulletin35_to_smf.sql

In the '--- Converting personal messages (step 1)...' section of vbulletin35_to_smf.sql, I think that looks alright - as does convert.php itself.

The problem lies in the '--- Converting personal messages (step 2)...' section of vbulletin35_to_smf.sql.

I believe the focus in that section should be on pulling data primarily from pm (a VB table) instead of from pmreceipt (a VB table).   Perhaps it needs to pull from both, but it absolutely does need to gather information from 'pm' because there is an entry in 'pm' for each recipient of a PM - there is NOT an entry in pmreceipt for each recipient of a PM.

I hope this makes some sense.  i'm trying to be as helpful as I can.   If I figure it out, I'll post further.    I have the table structures (and sample table data in a VB database that is NOT being added to the SMF database after the conversion).   This may help somebody.

Mike

[SleePy]

I will add this to our bug tracker for Jay to look into further.

Edit,
Does going to Admin -> Forum Maintenance -> Find and Repair errors fix this up?

[mtindor]

Sleepy,

No, that does not fix it.   Please see my post at:

http://www.simplemachines.org/community/index.php?topic=213775.0

Thanks

Mike

I will add this to our bug tracker for Jay to look into further.

Edit,
Does going to Admin -> Forum Maintenance -> Find and Repair errors fix this up?