I need to convert Ikonboard 3.1.5 to SMF 1.1.11. But I'm running into two problems:
1. They are on separate servers, which would not be an issue, if not for the fact that . . .
2. My IB forum does not use MySQL.
I read somewhere that I need to give my new SMF database access to my IB database. How does that work?
Thank you!
I think you have to switch to mysql first.
Then you can use the converter.
I don't suppose anyone would have any idea how to do that would they? ;D
Or would it be faster to just recreate all the posts, categories and users from scratch? There's really not that much. 49 users, and a 504 posts.
If your ikonboard-webspace supports mysql you can stwitch to mysql in the ikonboard acp.
It was years ago when i did it and at that point of thime there was a better documentation but i think you have to create a mysql-Database, then import the dbm-Database and then switch to mysql.
you can also try to export your database in the acp, make a new ikonboard on your new host, import your database like mentioned in this thread:
http://www.vbulletin.org/forum/showthread.php?p=372058 (http://www.vbulletin.org/forum/showthread.php?p=372058)
of course you have to install a smf and run the converter instead of vb ;)
Perhaps you can get some advice at http://www.ikonboard.net/ (http://www.ikonboard.net/)
Ikonboard switched from com to net but the page is down at the moment.
i think it should work like this:
ikonboard->administration control panel->Database->Export Database
ikonboard->administration control panel->Database->Set-up Database->mysql
ikonboard->administration control panel->Database->Import Database
Import into... mysql
ikonboard->administration control panel->Database->Switch DB Driver
switch to mysql
Thank you very much. I have successfully created a new IB forum on the new server and have successfully imported the data from the old to the new. Now my problem is that when I switch DB from DBM to mySQL it doesn't import any of my data. If I switch it back to DBM, it works dandy. Any ideas as to how I can get this to work?
Sooooooo close . . . . . grrrrrr
This is what I did:
Export Database
Set Up Database - DBM
Import Database
Switch Database to mySQL
. . . . nothing
I tried to import the old data straight into the new mySQL database but didn't work. So then I tried importing the old data into the new DBM database, which worked, but then I tried to switch to mySQL and it didn't work.
Okay I tried something else. I kept the db as mySQL and tried importing the data. It worked for a little bit and then I got this error:
QuoteIkonboard CGI Error
Ikonboard has exited with the following error:
SQL error INSERT INTO ib_email_templates (TEMPLATE, ID, TYPE) VALUES ('Hi,\nYou have been sent this email from <#SENDER_NAME#>.\n<#SENDER_NAME#> thought that you might want to take a look
This error was reported at: the bulletin board, <#BOARD_NAME#> (<#BOARD_ADDRESS#>).\nThis email was sent via Ikonboard from <#SENDER_EMAIL#>.\nThanks!\n<#SIGNATURE#>', 'INVITE_FRIEND', 't') in table 'ib_email_templates'. Duplicate entry 'INVITE_FRIEND' for key 1
Please note that your 'real' paths have been removed to protect your information.
Tried it again and it's giving me this error:
QuoteIkonboard CGI Error
Ikonboard has exited with the following error:
SQL error INSERT INTO ib_active_sessions (RUNNING_TIME, ID, LOCATION, USER_AGENT, MEMBER_ID, MEMBER_PASSWORD, LOG_IN_TYPE, MEMBER_GROUP, MEMBER_NAME, THIS_IP, MEMBER_LOGSTATE, LAST_LOG_IN) VALUES ('1266439856', '9a2b8b130b33a636dbaf142f9734db97', 'LostPass|&|act=LostPass;CODE=00', 'msnbot/2.0b (+http://search.msn.com/msnbot.htm)', '', '', '0', '2', '', '65.55.207.96', '0', '1266439856') in table 'ib_active_sessions'. Duplicate entry '9a2b8b130b33a636dbaf142f9734db97' for key 1
This error was reported at: Sources/iDatabase/Driver/mySQL.pm line 570, line 1.
Please note that your 'real' paths have been removed to protect your information.
well i think i made a new iboard with dbm,
then Set Up Database - myqsl
(there must be an empty mysql-board)
then import the data into mysql
(now the mysql-board should be filled with data)
then switch to mysql
(to show the mysql-board that is filled with data)
... but i remember that i tried around some time
Is the new board and the old board the same version ?
Same version yeah. I'll keep messing with it—see if I can get it going.
If you can see that active_sessions table in phpMyAmin. Empty it and try again.
Also did the other tables get populated?
Ah, I didn't know I could manage using phpMyAdmin. That's probly why there was duplicate entries. I'll empty it and start over and see what happens.
Once you get the DBM database converted over to MySQL you can view MySQL database using phpMyAdmin.
IT WORKED! When IB setup the tables they put data in that causing the conflict. I just had to clear them. Now to convert to SMF . . .
That's the table which keeps track of who's online and it usually has data in it. When I was using Ikonboard, it got corrupted on a regular bases.
If this solves your issue, could you please mark this as solved by clicking on the green "Mark Topic Solved" button below.
I would love to mark this as solved . . . if it was. :(
Now I'm trying to convert IB to SMF using the converter but this is the error I'm getting:
QuoteThe error MySQL gave was: SELECT command denied to user '**********'@'**********' for table 'ib_member_profiles'
So as I understand it I'm getting this error because of user permissions. But I'm hosting with GoDaddy and apparently they don't use cpanel and I can't edit user permissions. How do I get around this? I REALLY REALLY don't want to have to go through that whole install again just to put them in the same database. Any simple solutions?
Just got off the phone with GoDaddy and they told me there's no way they can edit user permissions for me. Is there any way to just move the tables from one db to the other?
Okay I figured it out—the simple solution was to setup the database again using the other db specs and reimport the backup. Ran the convertor and had zero errors!
THANK YOU!
Cool, I was just about to respond.
And welcome to SMF. :)