Import existing users from esoTalk

Dakoom

I did it via phpMyAdmin with the "LIKE" function, so using SQL queries like this:

DELETE FROM et_member WHERE email LIKE '%.ie%'
OR
email like '%.pw%'
OR
email like '%.ua%'
OR
email like '%.pl%'
OR
email like '%.vn%'
OR
email like '%.xyz%'
OR
email like '%.directory%'

Ok, finished. Now I'll try to import it on a Flarum local install to see what's happen.

Dakoom

I get problems with primary keys. How could I set them to AUTO INCREMENT?

luceos

Dakoom what is the exact problem. The Flarum database should have auto increment keys.

Dakoom

luceos I forgot to clean the Flarum database before importing. I'll try it again today and I'll let you know! 😛

VIRUXE Sure! I already have this in the gist I created:

I created this based on this other importer from phpBB: gist.github.com/robrotheram/fa15c112fd7c995fdbc0. It shoudl work but I still have not tested it because I have to clean the database from spammers users.

But please let me know if I should include something else.

Dakoom

luceos Ok, I tried but nothing. I clened the database, so I had only one users (admin) and the first tag/section/category that's by default on a normal Flarum install. I created the flarum.sql file from my esoTalk installation, but when I import it to Flarum I still geti this error: #1062 - Duplicate entry '3' for key 'PRIMARY'.

VIRUXE

Dakoom don't you think you should give credit to the original author of that importer?

Kulga

VIRUXE He does

I created this based on this other importer from phpBB: link. It shoudl work but I still have not tested it because I have to clean the database from spammers users.

VIRUXE

Dakoom check if you have that value doubled somewhere in your SQL script.

Kulga I fail to see where that is written. I'm on my mobile, I just see the snippet that displays the files contents/.

Dakoom

VIRUXE I fail to see where that is written. I'm on my mobile, I just see the snippet that displays the files contents/.

Don't worry at all. 🙂

VIRUXE check if you have that value doubled somewhere in your SQL script.

I really can't understand in the SQL file if I have it doubled. I'm not so SQL saavy. This is the current SQL file that I have: pastebin removed

Kulga

Dakoom It looks like you're importing users, tags, posts all at once?
Try separating that (just import users) to try and isolate the error.

HavocK

Dakoom Are those people ok for showing there email here ?

Just saying...

Dakoom

Kulga

I'll try! Good idea. Thank you!

HavocK

Yup, for the most of them they're all friends of mine. But I remove it. Thank you for poiting this out.

Dakoom

Ok, importing users: OK
Importing tags: this problem:

INSERT INTO fl_tags (id, name, description, slug, color, position) VALUES (1000, 'Area Privata', 'Area dedicata allo staff di ForumApicoltura.com. ', 'area-privata', '#726cea', 1),(1000, 'Forum di Benvenuto!', 'In questa sezione è possibile presentarsi se si è nuovi al Forum di Apicoltura. \r\nBuona permanenza!', 'forum-di-benvenuto', '#7a76aa', 2),(1000, 'Annunci & Feedback', 'Tutti gli ultimi annunci, il regolamento e le novità sul forum ForumApicoltura.com. Domande, FAQ, problemi e suggerimenti.', 'annunci-feedback', '#74ce56', 3),(1000, 'Iniziare con l\'Apicoltura', 'Per chi è alle prime armi, domande e risposte frequenti per iniziare a muovere i primi passi di apicoltura. ', 'iniziare-con-l-apicoltura', '#ffb6cc', 4),(1000, 'Strumenti e Attrezzatura', 'Discussioni sull\'utilizzo, il disegno e la costruzione degli alveari. Le attrezzature utilizzate e gli accessori utili di vario genere. ', 'n-a', '#44b164', 5),(1000, 'Foto & Video Forum', 'Il posto ideale per postare tutte le vost[...]

MySQL Message: Documentazione
#1062 - Duplicate entry '1000' for key 'PRIMARY'

luceos

Dakoom you are trying to insert the same primary key (1000) several times, just check the copied code. This is not possible, each primary key has to be unique.

Dakoom

Got it! I didn't noticed it was duplicated for each section! Ok!
Anyway, I imported everything (except the tags) and now they are there in my local test forum. The problem is that when I open a discussion, it keeps loading ano nothing else happen. What should I try? I already tried to optimize/repair tables in phpMyAdmin.

luceos

Dakoom open the browser underwater screen and check the console for errors. Sometimes the network tab might also show an error in the last XHR (ajax) call. These errors might also show up in your websites error log on disk.

Dakoom

I recreated a correct .sql file with all the queries, imported and I got no errors. So the importer went fine.
Now, in the browser console I get these errors:

mutating the [[Prototype]] of an object will cause your code to run very slowly; instead create the object with the correct initial [[Prototype]] value using Object.create forum-mrwP51LS3Nb5tGKe.js:1:320
TypeError: t[0] is undefined
forum-mrwP51LS3Nb5tGKe.js:9:30913
Pusher : Warning : You must pass your app key when you instantiate Pusher. pusher.min.js:12:491
Firefox non può stabilire una connessione con il server ws://ws.pusherapp.com/app/null?protocol=7&client=js&version=3.0.0&flash=false. pusher.min.js:61:129
Pusher : Error : {"type":"WebSocketError","error":{"type":"PusherError","data":{"code":4001,"message":"Could not find app by key null. Perhaps you're connecting to the wrong cluster."}}} pusher.min.js:12:491
La connessione con ws://ws.pusherapp.com/app/null?protocol=7&client=js&version=3.0.0&flash=false è stata interrotta durante il caricamento della pagina. pusher.min.js:61:129

Edit: another problem is that in the SQL table for users I have the discussions_count field at "0" for everyone.

luceos

Dakoom disable the pusher extension or add the required credentials for the extension in the admin. If you can't access the admin change the composer.json file and remove the pusher-related entry (flarum/flarum-ext-pusher), run composer update --no-scripts after that.

Please note that ANY javascript error will halt execution of javascript code. Even if the error is meant to inform you about a misconfiguration or missing settings.

Dakoom

Ok, I disabled that. Very informative post, luceos. Thank you.
Ok, unfortunately I get it to work. The discussions continues to keep loading and nothing happen. This as said could be due to the fact the the dabase info aren't so correct (every user have a discussions_count field at "0").

Another issue that I had in my other install (at labs.wpank.com) is the fact that in order to install it (I mean Flarum) I had to raise the PHP memory limit at 300MB. Is this normal? Now I set it back at 70MB but I can't install any extension. I always get a message that the script is interrupted due to memory limits.

I run some other scripts on the server (esoTalk, phpBB, vBulletin, WordPress, custom scripts, etc.) and I have no problmes with the memory limits. Does Composer require that much memory or is it a problem?

luceos

Dakoom what is the new error in your console? Debugging is a matter of patience:

1 Does it work?
2 No? Enable debug and check the console, logs or does an error show?
3 Fix the issue, move to 1.

« Previous Page Next Page »