• Plugin & Theme Dev

    open a new issue here with the list of extra fields
    https://github.com/akhoury/nodebb-plugin-import/issues

    then open another one here https://github.com/asciicat/nodebb-plugin-import-mybb just as a reference link


  • @Febian https://github.com/NiftyXXL/nodebb-plugin-import-mybbex
    It is far from perfect, but ok for a test. Feedback is welcome. The import does currently not support groups.


  • Hello Nifty,

    I'm not an expert user but I've managed to set up Nodebb v0.5.5 on Digital Ocean to play around with it for a while and everything is running pretty smoothly.
    I've tried exporting my existing MyBB forum (21 Mo database) to my Nodebb installation and this is where things get tricky for me.

    I've followed the instructions left by akhoury here:
    https://github.com/akhoury/nodebb-plugin-import/issues/90#issuecomment-64929108

    I manage to get through all the steps, but I'm not to sure how I add your nodebb-plugin-mybbex to the process.
    I've installed it through npm but in the Import plugin (from nodebb-plugin-import) I can't seem to select an exporter here
    "Select one of the few detected on npmjs's registry" since the list is blank.

    I've then tried the second solution "Or just enter the module's name or url you want to install": there I've typed the git address of your node-plugin-mybbex or the name of your plugin and the list in the previous step still stays blank.

    If I try running the import, things start to happen but I have nearly 10 seconds before an automatic request to refresh the page arrives and when I do refresh I have an message stating an error since there's no npm exporter detected.

    By any chance is there any way you can help me?

    Thanks for all your work on the Mybb export plugin !


  • @TaLoche
    Install it by npm from a console session ( nodebb directory):
    npm install git+https://github.com/NiftyXXL/nodebb-plugin-import-mybbex.git

    Then enter as module name
    nodebb-plugin-import-mybbex
    on the exporter configuration page and mark "Skip the module install ".


  • Thanks Nifty for your reply!

    I did a fresh Nodebb install, followed akhoury steps, added the npm install from a console session of your plugin and entered the name of your plugin as you said in your reply.

    But I still get the error about no converter/importer being selected.

    6616443.png

    and

    NodeBB Admin Control Panel 2014-11-30 15-14-59.png

    What am I doing wrong?


  • @TaLoche The error msg says "getaddrinfo " looks like a problem in resolving the mysql database host name to the ip address.

    The mysql server is not on the same host as the nodebb ? you need to make sure that the nodebb server can connect to the mysql server ( which is usualy not possible as the default mysql only binds to localhost for security reasons).


  • Thanks Nifty for your reply!

    My Mybb forum is hosted at 1&1 (A German provider).
    I did set up my new Nodebb forum on DigitalOcean since it wasn't possible for me to set up Nodebb on my 1&1 hosting plan.

    So you're saying that I should install my Mybb forum and database on DigitalOcean for make the import?


  • @TaLoche i would install a mysql on the new Server, make a backup of the db on your 1&1 host, import it on you're new server and than do the nodebb import. After that you can remove the mysql from you're new server. there is no need to get the whole mybb stuff installed. The node importer is only accessing the mysql database and the upload dirctory of the mybb.


  • Thank you so much Nifty for pointing me in the right direction!
    I'll try to figure out how to install a mysql on DigitalOcean to import my Mybb database.

    Thanks again!


  • @TaLoche which Linux ?


  • I'm sorry? My existing Nodebb install on DigitalOcean is running on Ubuntu 14.04.

    On DigitalOCean I can create another Droplet next to Nodebb on Linux (Ubuntu, Fedora, Debian, Coreos or Centos).
    My existing Mybb forum is on a MySQL5 server.

    I was going to use this

    to set up Mysql on OceanDigital in a new droplet to be able to import my existing Database to tried to import in afterwards in Nodebb.


  • I just installed MySQL on the same server, didn't need apache, or any of that, literally just MySQL, don't even bother with phpmyadmin, you can do it through terminal. You will need to upload your database to the server though to import it into MySQL.


  • Thanks a lot a_5mith!

    How do I import the database into MySQL on my server using terminal? I have a .sql file on my desktop.


  • @TaLoche You could temporarily (S)FTP into the server and upload it into your root folder, you connect via SFTP on port 22 with your usual username and password, then, close that connection once it's uploaded, and in Terminal, do.

    sudo apt-get install mysql-server
    mysql -u root -p
    CREATE DATABASE export;
    USE export;
    source <yourfilename>.sql
    exit
    

    That will give you a database to connect to called export, you could connect to it using 127.0.0.1, then use root for the username, and the password you set up during apt-get install.

    If it can't find the sql file, you may need to write the absolute position of it, so for example, /home/user/ or something like that.


  • @TaLoche You need to create the database & user first, then:
    mysql -u USERNAME -p DATABASE < file.sql

    Just saw that a_5mith already gave you a answer.


  • @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


  • @TaLoche Which Version of mybb are you using ?


  • @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?


  • @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.


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

Suggested Topics

| |