Merge VB5 to MyBB: 1146 - Table 'meydan1967.post' doesn't exist

[sercan82]

I am unable to merge from VB5 database to MyBB database.

Downloaded the latest version of MyBB and also the merge system. When I choose for database configuration, fill in all the necessary fields (choosing the database of VB5 which I have restored), then I get the error

SQL Error: 1146 - Table 'meydan1967.post' doesn't exist Query: SELECT LENGTH(pagetext) as length FROM post ORDER BY length DESC LIMIT 1

What do I have to do to solve this issue?

[yuliu]

Do your vb5 tables have a prefix? Uhh, like vb_, and therefore your post table name should be vb_post. I don't have a vb forum installation and don't know what the default prefix is, just a guess.

Off-topic comment: is vb commercial-only now? Meaning I have to pay to install one.

[sercan82]

Do your vb5 tables have a prefix? Uhh, like vb_, and therefore your post table name should be vb_post. I don't have a vb forum installation and don't know what the default prefix is, just a guess.

Off-topic comment: is vb commercial-only now? Meaning I have to pay to install one.

Hi Yuliu,

no I don't have a prefix. See attachment. I have payed for the VB forum. It's commercial that's correct.

[euantorano]

Does the ‘post’ table exist in the database?

On 31 Jul 2019, at 10:41, sercan82 notifications@github.com wrote:

Do your vb5 tables have a prefix? Uhh, like vb_, and therefore your post table name should be vb_post. I don't have a vb forum installation and don't know what the default prefix is, just a guess.

Off-topic comment: is vb commercial-only now? Meaning I have to pay to install one.

Hi Yuliu,

no I don't have a prefix. See attachment. I have payed for the VB forum. It's commercial that's correct.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

[yuliu]

Does the ‘post’ table exist in the database?

I was about to ask the same question, and still searching for a documented vb5 database structure. But only found this.

Do your vb5 tables have a prefix? Uhh, like vb_, and therefore your post table name should be vb_post. I don't have a vb forum installation and don't know what the default prefix is, just a guess. Off-topic comment: is vb commercial-only now? Meaning I have to pay to install one.

Hi Yuliu,

no I don't have a prefix. See attachment. I have payed for the VB forum. It's commercial that's correct.

I see. You can't get there, can't pass the table check, if the database setting you've input is wrong. Please have a check on any relevant table existence, as @euantorano suggested.

[sercan82]

Does the ‘post’ table exist in the database? … On 31 Jul 2019, at 10:41, sercan82 @.***> wrote: Do your vb5 tables have a prefix? Uhh, like vb_, and therefore your post table name should be vb_post. I don't have a vb forum installation and don't know what the default prefix is, just a guess. Off-topic comment: is vb commercial-only now? Meaning I have to pay to install one. Hi Yuliu, no I don't have a prefix. See attachment. I have payed for the VB forum. It's commercial that's correct. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

Not standard, I made one self by copying the table to a new table with the name post. But then I receive a new error.

@yuliu

I pass the database check: Checking database details... success. Not able to pass the table.

[yuliu]

Not standard, I made one self by copying the table to a new table with the name post. But then I receive a new error.

I don't quite understand this. What is the table you've copied from? Did you lost this table? If its structure and column settings differ from the original one, which is the one installed by default, you'll probably fail during importing this table, even if you can pass the column length check.

I pass the database check: Checking database details... success. Not able to pass the table.

The database check only checks if one particular table exists, it doesn't check if all the tables for merging exists or are valid.

The Merge system checks a table's existence first, then do column length checks, and this is where you have that error. After all checks are OK, you'll see a module list where you can merge any old data.

If the post table is manually generated by yourself, and it indeed contains data where they should be in, you would like to compare the structure and field settings between the table you made and the one installed by vb. Otherwise, I suggest search for it in any possible backup. Seems you've lost this table?

By the way, backup your data before making changes to your database.

Edit to add: I don't have a vb forum copy and don't know its database structure. I just want to help but in dark LOL. Hope anything helps here.

[sercan82]

@yuliu

These are the steps I follow.

1. Imported the VB5 database with phpmyadmin.
2. VB5 database doesn't have the table posts (it is the table node and a few others linked to each other).
3. I made a new table (in the VB5 database) and copied all the content from the node table to the post table.
4. Opened domain.com/forum/merge/index.php.
5. Board selection is Vbulletin 5, click next.
6. Run database configuration and fill in all the fields with database username / password / database name (VB5 database which I restored).
7. Click on next I receive the error.

[yuliu]

2. VB5 database doesn't have the table posts (it is the table node and a few others linked to each other).

The vb5 converter comes along with the Merge system was added in 2016. But seems the supported vb5 converter is superseded by vb5 connect that changes a lot in database, I guess. It uses nodes for storing contents, just like the way how Drupal works, rather than saving threads/posts/polls/etc individually.

What I mean is that the built-in vbulletin5 converter may not be your choice and there's no converter in this repo can help you for merging right now.

You could write a converter for merging vb5 connect. I've done one to convert my old Discuz! forum data to MyBB, and find the Merge System pretty easier to extend than any other forum converters. Or check this post, I don't know if that works, or try to get help in the community.

[euantorano]

If I had access to a VB5 database I could try to find some time to get a basic converter done. If anybody is willing to share (feel free to remove user details or anonymise etc), please email me at “euantor -at- mybb.com”

On 31 Jul 2019, at 13:18, yuliu notifications@github.com wrote:

2. VB5 database doesn't have the table posts (it is the table node and a few others linked to each other). The vb5 converter comes along with the Merge system was added in 2016. But seems the supported vb5 converter is superseded by vb5 connect that changes a lot in database, I guess. It uses nodes for storing contents, just like the way how Drupal works, rather than saving threads/posts/polls/etc individually.

What I mean is that the built-in vbulletin5 converter may not be your choice and there's no converter in this repo can help you for merging right now.

You could write a converter for merging vb5 connect. I've done one to convert my old Discuz! forum data to MyBB, and find the Merge System pretty easier to extend than any other forum converters. Or check this post, I don't know if that works, or try to get help in the community.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

[sercan82]

@yuliu

I will make a VB5 Database for you and give you access to the database. Please give me some time.

[yuliu]

@yuliu

I will make a VB5 Database for you and give you access to the database. Please give me some time.

Thank you for contributing to MyBB.

Although it's @euantorano who first offers to make a converter, I'd like to help with building it, too.