MyBB Community Forums

Hi,

Just a week back I got done with running all merge modules for merging the existing PhpBB forum with MyBB. I see a lot of inconsistency in the data for all tables
Like in all tables the title columns are not complete rather they're as follows:

Actual data in PhpBB table: "This is a sample data mentioned here." 
Data showing up in MyBB tables after merge: "This is a sample ..." 

Noted both source and destination DB used is Postgres DB's.

Also after this, I see the dependant module data isn't mapped to any table properly even if it was existing in Phpbb tables
i.e. Forums table does not have user information stored for migrated records, the thread table doesn't have forum or user information stored in it, and so on. And because of this the forum details are not showing up properly on index.php

There's a lot of inconsistency and issues I'm facing at this moment. When I tried to run the merge module again, after selecting Phpbb on the merge screen, I saw the following issue, while I could not find any file db_.php in forums/inc/db

Warning [2] require_once(C:\xampp\htdocs\forums/inc/db_.php): failed to open stream: No such file or directory - Line: 161 - File: C:\xampp\htdocs\forums\merge\resources\class_converter.php PHP 7.4.21 (WINNT)
File

Fatal error: require_once(): Failed opening required 'C:\xampp\htdocs\forums/inc/db_.php' (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\forums\merge\resources\class_converter.php on line 161





Please if someone can help me with this, it'll be really really nice. Many many thanks in advance. I need this to get resolved as soon as possible. 

Can you please post your database system and their versions?

I have PostgreSQL 13.4.2 both for source and destination
and xampp 7.3.29 for hosting

I'm sorry I forgot to reply to your thread.

Current version of the Merge System doesn't work well if your MyBB database is PostgreSQL. We're still working on it. You may expect it being fixed in near future.

(2021-12-20, 11:32 AM)noyle Wrote: [ -> ]I'm sorry I forgot to reply to your thread.

Current version of the Merge System doesn't work well if your MyBB database is PostgreSQL. We're still working on it. You may expect it being fixed in near future.

hey @noyle, 

By when can we expect this to be resolved from your end? If it is a matter of a few weeks or months?
I desperately need a workaround on this.

(2021-12-20, 11:41 AM)radhika__awasthi Wrote: [ -> ]hey @noyle, 

By when can we expect this to be resolved from your end? If it is a matter of a few weeks or months?
I desperately need a workaround on this.

Days or around the new year maybe. The actual release of it would also require a new release of MyBB.

Anyway, you may try the following (just a workaround, not a formal fix):

Edit the function prepare_insert_array() in /resources/class_converter_module.php:
https://github.com/mybb/merge-system/blo...#L142-L188

and remove the following part from it:
https://github.com/mybb/merge-system/blo...#L169-L184

(2021-12-20, 02:24 PM)noyle Wrote: [ -> ]

(2021-12-20, 11:41 AM)radhika__awasthi Wrote: [ -> ]hey @noyle, 

By when can we expect this to be resolved from your end? If it is a matter of a few weeks or months?
I desperately need a workaround on this.

Days or around the new year maybe. The actual release of it would also require a new release of MyBB.

Anyway, you may try the following (just a workaround, not a formal fix):

Edit the function prepare_insert_array() in /resources/class_converter_module.php:
https://github.com/mybb/merge-system/blo...#L142-L188

and remove the following part from it:
https://github.com/mybb/merge-system/blo...#L169-L184

Thanks a ton Noyle, will wait for the workaround to release, meanwhile I'll work on this formal solution that you have shared. In case I get stuck I'll keep updating you about it.

(2021-12-20, 06:38 PM)radhika__awasthi Wrote: [ -> ]

(2021-12-20, 02:24 PM)noyle Wrote: [ -> ]

(2021-12-20, 11:41 AM)radhika__awasthi Wrote: [ -> ]hey @noyle, 

By when can we expect this to be resolved from your end? If it is a matter of a few weeks or months?
I desperately need a workaround on this.

Days or around the new year maybe. The actual release of it would also require a new release of MyBB.

Anyway, you may try the following (just a workaround, not a formal fix):

Edit the function prepare_insert_array() in /resources/class_converter_module.php:
https://github.com/mybb/merge-system/blo...#L142-L188

and remove the following part from it:
https://github.com/mybb/merge-system/blo...#L169-L184

Thanks a ton Noyle, will wait for the workaround to release, meanwhile I'll work on this formal solution that you have shared. In case I get stuck I'll keep updating you about it.

Hi @Noyle, 

I applied did the solution given by you. Error appearing is still the same and it is before the part you asked to remove.

What kind of errors?

(2021-12-22, 11:36 AM)noyle Wrote: [ -> ]What kind of errors?

This is the error msg which was showing earlier and even now;

Warning [2] require_once(C:\xampp\htdocs\forums/inc/db_.php): failed to open stream: No such file or directory - Line: 161 - File: C:\xampp\htdocs\forums\merge\resources\class_converter.php PHP 7.4.21 (WINNT)
File

Fatal error: require_once(): Failed opening required 'C:\xampp\htdocs\forums/inc/db_.php' (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\forums\merge\resources\class_converter.php on line 161