MyBB to NodeBB Importer?

TaLoche

@a_5mith Thanks a lot for your help, it worked like a charm! Imported my whole database with no errors!

@Nifty I went back to importing my Mybb forum in Nodebb and I get this error. Users and category are imported fine but I can't import my topics.

{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","index":0}
Importing 0 topics.
{"code":"ER_BAD_FIELD_ERROR","errno":1054,"sqlState":"42S22","index":0}
current phase: topicsImportStart
current phase: usersImportDone
Importing 46/46 users took: 0.94 seconds
Importing 46 users.
current phase: usersImportStart
current phase: categoriesImportDone
Importing 9/9 categories took: 0.21 seconds
Importing 9 categories.
current phase: categoriesImportStart
current phase: resetGlobalsDone
current phase: deleteTmpImportedSetsAndObjectsDone
current phase: deleteTmpImportedSetsAndObjectsStart
current phase: resetGlobalsStart
current phase: purgeUsersDone
current phase: purgeUsersStart
current phase: purgeCategories+Topics+PostsDone
current phase: purgeCategories+Topics+PostsStart

Nifty

@TaLoche Which Version of mybb are you using ?

TaLoche

@Nifty My Mybb version is 1.6.12
Do you think I need to upgrade it in 1.8 before doing my database export?

My forum is in French, could the accents been an issue in the import?

Nifty

@TaLoche They change a few fields from 1.6 -> 1.8. I can give you a modified export if you like. It's not a big deal. The accents should not be a problem.

TaLoche

@Nifty You're the man! So I just send you my DB export and you would be able to modify the export?

Nifty

@TaLoche No need for a dump. Give me 10h to check it out.

TaLoche

@Nifty You have 10h Jack Bauer style then. Thanks again!

a_5mith

TaLoche

Now you're talking!

Nifty

But it all has a price... :

bentael

@Nifty let me know if you run into issues

a_5mith

@Nifty said:

But it all has a price... :

Some people go skydiving to experience life on the edge, I run master NodeBB in production.

TaLoche

@Nifty said:

But it all has a price... :

I'm okay with that kind of invoice to pay, since I'm stuck without you!

Nifty

@TaLoche It was the soft delete option of Mybb1.8. I removed it. Just Upgrade the import plugin and you are fine.

TaLoche

@Nifty Thanks a lot for this!
I gave it a go and it didn't work. So, I started a fresh installation of Nodebb and Mysql, exported my database in Mysql and this time, I got the users, the categories and the topics. But in each topic I've only got the first post (OP).

A few topics have all their posts but that's like 2% of the topics.

Sorry to bother you with all this!

julian

@a_5mith Hey, we run master in production too!

? Offline

@a_5mith, remember when you didn't take risks like that - but I convinced you it was a great idea, so you gave it a go - and then everything broke?
Everything's been a lot smoother than then lately xD

bentael

@TaLoche

cd /path/to/where/this/plugin/is/installed/nodebb-plugin-import-mybbex

Then edit test.js, with your favorite editor to enter your real database info
it's this file https://github.com/NiftyXXL/nodebb-plugin-import-mybbex/blob/master/test.js

then try this

node test.js

after that's done, it should have written a tmp.json file, open it, it's probably big, but deal with it, take a look at the data, can you find the posts?

if there are too much stuff in there, change this line

from

    fs.writeFileSync('./tmp.json', JSON.stringify(results, undefined, 2));

to

    fs.writeFileSync('./tmp.json', JSON.stringify(results[4], undefined, 2));

this will only write the posts to tmp.json, then open it again and take a look.

if the posts are not in there, that means it's this exporter's issue, if they are, that means it's my plugin's issue

I can help so much without access to the data or the server.

Nifty

@TaLoche Did you saved the Log Files to the Server ?

TaLoche

Thanks guys for your help.

@Nifty I'll send you as requested my db export.

@bentael I'll give it a go right now to see what happens. Thanks for your help.