What to do now?

[benz1]

Apologies for posting this here when there is already a thread at here but unfortunately there's been no response there for several days and I'm getting desperate!

I'm trying to convert a vBulletin 3.7.4 database to SMF. I don't have access to the vb server but was provided with a backup which I have imported into the SMF database. TE was kind enough to provide a customized vbulletin37_to_smf.sql file to allow me to do the conversion within a single database.

When I run it however I get the error that  Table 'massive_smf1.mos_usertextfield' doesn't exist.

My understanding from TE is that this is a required table but it doesn't exist in my imported database.

Is it possible that the backup I imported was incomplete or didn't import correctly due to the size of the database, (288MB)?

Any help gratefully received.

Thanks,
Benz1

[benz1]

I appreciate that this is a voluntary community support forum and I have no right to expect anything different but it's very disappointing that you assist to a point and then when the going gets tough you bail out and leave me to my own devices.

Even if you can't help any further it would be good to have an acknowledgment that this is the case and perhaps an opinion as to what the problem is.

I guess I have no option but to buy a vBulletin license and go that route instead 

Benz1

[ThorstenE]

sorry, I'm extremly busy at the moment (have to move ~400 websites to a new server)
please try the attached version..

[benz1]

Thanks TE and apologies for having a go. I realise you have other stuff going on and I have no right to expect anything more of you.

I found the problem. For some reason the original dump I was given either didn't fully import or didn't include the whole vb database but they provided a new one which did import correctly and contained all the tables.

I ran convert.php and got one error:

Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Unsuccessful!
This query:

    SELECT
    pm.pmid AS ID_PM, pm.userid AS ID_MEMBER, pm.messageread != 0 AS is_read,
    '-1' AS labels
    FROM `massive_smf1`.vb_pm
    LIMIT 0, 500;

Caused the error:

    Unknown column 'pm.pmid' in 'field list'

In the end I simply removed the code from the sql file that related to Converting personal messages (step 2) and the rest ran correctly. Not having personal messages converted is not the end of the world (unless you can advise a solution for this?).

Unfortunately the dump only appeared to include 2 users instead of the several hundred it should have but I asked them to send an export of the user file to import. I assume I can run convert.php again, if not I can remove all data and start again.

So thanks for your help and for persevering with me.

Ben

[ThorstenE]

your vBulletin seems to have a different database layout than a normal "vBulletin  3.7.4".. I need a copy from your dump in order to find the lost members. Can you PM me a link to your database dump? (Note: I'm very busy, I may need some days to find a solution).

[benz1]

your vBulletin seems to have a different database layout than a normal "vBulletin  3.7.4".. I need a copy from your dump in order to find the lost members. Can you PM me a link to your database dump? (Note: I'm very busy, I may need some days to find a solution).

Thanks TE but don;t worry, apparently they didn't send the users as this is a subset of a bigger forum and they can't (or won't) export just the users who are members of this forum. We're going to manually re-register them.

Just one last question. Has the data been migrated into the SMF tables within the database? Can I drop the old VB tables to save some space and make backups smaller?

Thanks again for all your help,
Benz1

[ThorstenE]

yes, all data is migrated to the SMF tables during conversion and you can drop your old vBulletin tables without risk (nevertheless I recommend a backup before).

[benz1]

Thanks TE, all good now.

Benz1