Merge VB5 to MyBB: 1146 - Table 'meydan1967.post' doesn't exist #228
Comments
|
Do your vb5 tables have a prefix? Uhh, like 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.
|
|
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.
|
I was about to ask the same question, and still searching for a documented vb5 database structure. But only found this.
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. |
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 pass the database check: Checking database details... success. Not able to pass the table. |
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.
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 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. |
|
These are the steps I follow.
|
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 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. |
|
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 ***@***.***> 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.
|
|
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. |
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?
The text was updated successfully, but these errors were encountered: