[Converter] XenForo 1.2 --> SMF 2.0.x

[SaltedWeb]

To far out of my ability, maybe someday day they will create a converter.
I really hate XF, never should have left.

[AllanD]

If you are talking about converting to smf I will say this is very easy compared to some I have done. Biggest them to remember is to put SMF in to the same datebase as the Xenforo, then run the script.

[SaltedWeb]

Hi there, not sure if I even know how to do that

[margarett]

I'm not sure I understand your question, sorry...

Do you have XF? Do you wish to convert to SMF? Can't you do it? Need help? Having issues?

Sorry, we really need more to help you in whatever problem you're having...

[SaltedWeb]

If you are talking about converting to smf I will say this is very easy compared to some I have done. Biggest them to remember is to put SMF in to the same datebase as the Xenforo, then run the script.

Hi sorry , I have 1.25 Xenforo. Been using SMF along time and migrated the current SMF in 2/14 and I really hate XF .
The support is horrible for a paid product and XF is not even close to SMF productivity.  I am wanting to go back to SMF.
I have an active forum with 7000+ posts . I was intrigued in this topic. But seems way beyond what I can do.
" to put SMF in to the same datebase as the Xenforo, then run the script."
Made no sense to me I barely understand how Mysqls work. I am old school webmaster since 1996 used to HTML and Java, then along came PHP and MYsqls and I never caught up.  Had Smf back in 2005 and loved it then, reopened another two sites this year.
One is SMF and I have it working well. The other was one I converted and went DOH!
I would like to go back to SMF but no idea where to even start to take XF to SMF.

[margarett]

1.25 is your XF  version?

[SaltedWeb]

1.2.5 . Left a period out ooops :-)

[margarett]

The database schema should be the same, so it should work.

You only need to install SMF in the same database as XF. Then run the converter

[SaltedWeb]

The database schema should be the same, so it should work.
You only need to install SMF in the same database as XF. Then run the converter

The " should be " part is what worries me.

[AllanD]

Just take a backup of the database, before you do anything. This way you can always put it back.

[margarett]

And, like with any other converter, the original setup is untouched, which means there is no risk
A backup is always nice to have, nevertheless.

[AllanD]

And, like with any other converter, the original setup is untouched, which means there is no risk
A backup is always nice to have, nevertheless.

I just thought about this and came back to post it

[ashkir]

I'm attempting to convert a very, very large forum. Members did fine. But, when it went to nodes:

Code Select Expand

step=2
Database Error: Duplicate entry '255' for key 'PRIMARY'

I checked the node ids we have no two copies of 255

Tried a few more times. Anyways,



Any time it gets to 255 no matter what or if I change the node type it stops there. Is there a 255 limit?

[margarett]

That's a different problem. It's something SMF/MySQL related.

In step 2 we convert categories. In SMF, they are stored in smf_categories table and the column "id_cat" is a "tinyint", which means that it can only store values up to 255. Two or more of your categories have an ID larger that this and, when MySQL tries to add that ID to the database, it is limited to and written as 255. There lies your issue.

You need to ALTER the table "smf_categories" and make "id_cat" an "int" or "smallint" field instead of tinyint.

[ashkir]

Thanks. We have over 500 nodes =X

[ashkir]

I'm not entirely sure how to do the alter. But, in the backup of categories

Code Select Expand

CREATE TABLE IF NOT EXISTS `smf_categories` (
  `id_cat` smallint(4) unsigned NOT NULL AUTO_INCREMENT,
  `cat_order` smallint(4) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `can_collapse` smallint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id_cat`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=256

Would the 256 also pose a problem?

[margarett]

What's the highest node ID you have?

That auto-increment=256 just tells the server what's the next AI value it should use.

[ashkir]

650 is the biggest node_id

[margarett]

That backup you indicate above... Is it a backup from the current conversion after it ran?

[ashkir]

after it ran. I don't know how to change it regularly as I never changed anything from tinyint to something else before.