I am having trouble getting the importer (http://www.elkarte.net/community/index.php?topic=3204.0) to work, I get an error of
I searched the forum but there was no concrete solution/answer.
Thanks in advance!
Hi
@Spuds I still get the same error even with that version.
It looks like the mysql user doesn't have access to one of the two databases.
IIRC, in 1.x OI, the database users (both from the source and the destination) have to have read/write access to both the source and destination databases (to stay on the safe side).
How would I give access? Thanks for the help by the way, the technical side of forums is not my forte...
Firstly, I think this post should be merged with http://www.elkarte.net/community/index.php?topic=3204.50 as it is relating the discussed importer.
Secondly, I think the easiest way to use this importer is having both MyBB and ElkArte using the same user and database but different prefix. That way, you shouldn't face any issue with database access.
Thirdly, make sure you make a proper backup before pursing with this.
Even with doing that, I still get the same error.
Sorry but may be you try again when you are ready and make sure all these steps are followed?
1. Ensure that your MyBB site is working good.
2. Create ElkArte database (it can be either in the same database with different prefix or different database but make sure that database user and password is the same for both MyBB and ElkArte).
3. Install ElkArte in another directory and make sure it is working too.
4. Upload the importer files to your ElkArte installation.
5. Get
the latest xml file (http://www.elkarte.net/community/index.php?topic=3204.msg22853#msg22853) and replace the one in the zip file with it.
6. Open import.php in your browser and follow the instructions.
7. Cross your fingers again. O:-)
Still not working. Maybe it is step 2 that I am messing up on, not sure. Currently I have my ElkArte installation under home/
sitenamehere/public_html/
ElkArte Installation Name and my MyBB installation under /home/
sitenamehere/MyBB Installation Name. Both were installed with Softaculous and both are working fine. As far as databases go they both have the same prefixes but I am not sure how to check if passwords are the same . I am using the password from ElkArte's settings.php to fill in the database field as instructed.
I guess it's time to read the settings.
1) Go go "/sitenamehere/public_html/ElkArte Installation Name", and open the file Settings.php, take note of the values of $db_user and $db_name,
2) go to "/home/sitenamehere/MyBB Installation Name/inc", and open the file config.php, take note of the values $config['database']['username'] and $config['database']['database'].
Now compare them and see if they are the same or not.
That way we can set a milestone and be sure if we are talking about the same database or not.
I've checked and they both have the same prefixes.
You're using cPanel?
If so, log into it, then goto MySQL Databases, scroll to 'Add user to database' and add the elkarte user to the MyBB database, tick the box that says 'All privileges' on the screen that pops up, then hit 'make changes'. Then do the exact same for the MyBB user to the elkarte database.
Now it should work :)
What does it mean they have the same prefix?
I think the key was a bit further back, softaculous in cPanel by default creates a new database user and new database for every installation it does. However the permissions to run the queries need manually assigned if you're going to use both at once.
So it will have created
users user_mybb and user_elk, and
databases user_mybbdata and user_elkdata for example, however user_elk won't have permission to run 'SELECT' on user_mybbdata, unless the permissions are added.
As you can see in the first error it's connecting to the database but hasn't yet got the credentials to continue.
That worked thank you!! :) I am still having a few issues... some avatars are not displaying, poll choices weren't able to import, and the statistics in Forum Stats didn't update but I'll have to work that out a little later.