XMB 1.9 Converter?

[Rushfan]

I know there is a converter for XMB 1.8 currently available, but I was wondering if a converter exists to convert XMB 1.9 Nexus to SMF.

[Grudge]

Have you tried it to see whether it works? If you could let us know how it copes that would be useful.

[Rushfan]

Have you tried it to see whether it works? If you could let us know how it copes that would be useful.

Sorry. Yes, I did try. It had no effect. I was left with a blank SMF forum; that was it.

And I got a bunch of MySql errors too.

[Grudge]

OK. Well - today I install 1.9 and the converter worked completly correctly. You obviously are doing something wrong. Have you made sure that the SQL user can see BOTH databases. If they are installed in different databases the SMF database user MUST be able to see the XMB database.

[[Unknown]]

You obviously are doing something wrong.

I wouldn't say that.  It could be that he's using databases with characters like '-' in them.

For the reason that the current converters do not convert properly for older versions, updating them is not really an option right now.  However, this is something I believe is still a problem in the ones downloadable....

So, no, it's not obvious whether Rushfan is doing anything wrong or not.

-[Unknown]

[Rushfan]

You obviously are doing something wrong.

I wouldn't say that.  It could be that he's using databases with characters like '-' in them.

For the reason that the current converters do not convert properly for older versions, updating them is not really an option right now.  However, this is something I believe is still a problem in the ones downloadable....

So, no, it's not obvious whether Rushfan is doing anything wrong or not.

-[Unknown]

Hmm... The way my webhost works, is that when you create a database, it names it like this:

username_dbname

So, that could be the cause of a problem. I thought I did everything right. Let me try again.

----Update---

Hmm... It worked this time, so I don't know what went wrong. My web host has been transferring accounts to a different server lately, so maybe I just did it at a bad time...

However, whenever an apostraphe appears in the new forum, I get a slash... IT seems to be having some strip-slash variable problems...

[Grudge]

Open up the converter, find line starting $from_prefix = and make it:
$from_prefix = '`' . $dbname . '`.' . $tablepre;

do the same for $to_prefix, making it:
$to_prefix = '`' . $db_name . '`.' . $db_prefix;

[Rushfan]

Open up the converter, find line starting $from_prefix = and make it:
$from_prefix = '`' . $dbname . '`.' . $tablepre;

do the same for $to_prefix, making it:
$to_prefix = '`' . $db_name . '`.' . $db_prefix;

Thank you... Some of the posts were really bad with slashes...

[ccheaton]

I'm going to try this soon with a database that has some file attachments (in XMB).  How does that work?  Do they remain embedded in the database?

[[Unknown]]

It copies them out of the database, assuming your chmod settings are set properly.  SMF does not store attachments in the database for many reasons.

-[Unknown]

[ccheaton]

Well, poo.  My stinky old host won't allow me to dump the database table that contains the attachments.  I stink with command-line stuff.   

[[Unknown]]

Well, poo.  My stinky old host won't allow me to dump the database table that contains the attachments.  I stink with command-line stuff.   

I'm not sure I understand.  The converter will automatically take the files out of the database and create files for you, you don't need to mess with the command line to do so.

-[Unknown]

[ccheaton]

Well, I was switching hosts as part of the process.  Most of the old files were irrelevant, and my old host wouldn't let me export the database without dumping them.

I wanted to move the XMB board to my new host before doing the conversion.