SMF Support > Converting to SMF

Same directories for conversion?

(1/3) > >>

BinkyM:
Hi, SMF peeps:

I'm currently running Ikonboard 3.1.2a which I've fairly heavily modified. I had about 100K records I need to convert to SMF. I'm trying to run convert.php and I'm getting an error message that makes no sense to me:

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of IkonBoard 3.1.x. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user '[SMF dB user name]' for table 'member_profiles'

It makes no sense that the SMF user name is trying to get at the Ikonboard tables because the SMF user doesn't have permissions for that database.

Mrf. Maybe I should give the SMF user access to the Ikonboard table. I'll go give that a try.

Well, that helped a little bit; I have a new error now:

The error that was received from the Database was: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.member_profiles' at line 2

Great! Neither convert.php nor ikonboard_to_smf.sql has any SQL at line 2, so I don't even know what this is referring to.

So it would appear that the answer to my question is no, they needn't be in the same directory (which is cool, since mine aren't), but I haven't the foggiest notion where to look for try to solve whatever's causing this to fail. I'd sure be grateful for suggestions from people who've been through this before!

Thanks,

Binky

IchBin™:
What is the message at the top. It usually starts with saying something like, "Converting Members...". Does it say anything like that?

BinkyM:
Hi, Brad:

I'm still on the page that asks for the deets when I get the error (the one that wants the paths, passwords and so on); it's titled "IkonBoard 3.1.x to SMF Converter," so I've not gotten anywhere like "Converting Members" yet. I guess that's because I'm getting zotzed before a single line of SQL is executing (pout), but like I said, in neither file is there any SQL at line 2, so I'm at a loss!

Binky

IchBin™:
My guess is that you aren't putting the proper text in the prefix section. From your error I think it looks like it can't find the proper table name. What are you putting in that section? Does it match what is shown on your database?

Actually, what are you putting in both of these sections?
MySQL database used by IkonBoard:
Prefix used by IkonBoard:

BinkyM:
Brad:


--- Quote --- My guess is that you aren't putting the proper text in the prefix section. From your error I think it looks like it can't find the proper table name. What are you putting in that section? Does it match what is shown on your database?
--- End quote ---

That's an excellent question. I haven't table prefixes, so I was flummoxed by what to put in that field. I tried leaving that empty and that didn't work, but I believe that didn't work during my first go round when I didn't have my SMF user assigned to my Ikonboard database. The second time around, I tried putting in what MySQL prepends to the names of EVERYTHING, which is "luckybin_"

So I'm looking at my database and there's nothing prepended onto any of my table names but there WAS a good reason that I put "luckybin_" into the prefix field. You hafta believe me, Brad, when I tell you that while I was clicking around looking at my database from various angles that I saw things like "luckybin.member_profiles." I swear!

Alright, so I just tried it with the Prefix field empty, and now I'm getting:

Converting...
Successful.
Recalculating forum statistics...

(blush)

Well, who looks like a big dummy now, Brad, huh?

It's weird, though; it said it was successful in just a second but I have 78,998 records to convert. I'm not sure I believe it. I think I'll go to bed and see what kinda mess I have in the morning (lopsided grin).

But thanks for getting me to take another stab at my prefix field! It looks as if that's what was what was flummoxing me. We'll see what new horrors await me tomorrow! Thanks for holding my hand this far!

Binky

Navigation

[0] Message Index

[#] Next page

Go to full version