Simple Machines Community Forum

SMF Support => Converting to SMF => Topic started by: JayBachatero on January 26, 2007, 09:25:01 AM

Title: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on January 26, 2007, 09:25:01 AM
Software: SimpleBoard (JoomlaBoard)
Version: 1.0 and 1.1

This is the official support topic for SimpleBoard converter.  Use this topic to ask for support for this converter.

Changelog
! Escape special characters in the preg_match when converting posts. (simpleboard_to_smf.sql)
! Typo in avatar conversion. (simpleboard_to_smf.sql)

convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741) with the .sql file attached in this topic.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 03:13:09 PM
hello,

with your mysql file and convert.php it converts without any text errors now...
but main bug still excist.....
all replies show    0

Any ideas ?
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on January 26, 2007, 03:29:18 PM
Are the replies there though?
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 03:34:07 PM
hi,

yes replies are there but funny thing is...if you go to the forum itself it shows replies   0
but the actual replies are there...

but thats not all...

some forums actual show the number of replies....
thats so weird....

but before i continue a few things i need to know....

will this realy work together with joomla ?
or do people have to login seperate for the forum?
and what if i use community builder ?






Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on January 26, 2007, 03:34:52 PM
Go to Admin > Forum Maintenance > Recount Board Stats.  Does that fix it?
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 03:37:19 PM
nice i dea but how i get to the stats ?
cause when i login on front i dont see any admin functions...
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on January 26, 2007, 03:40:56 PM
You saying that the admin account is not being transfered?
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 03:46:40 PM
well....as far as i can remember when i first installed smf yesterday i saw admin functions on frontpage...
is that correct ?
after converting that was gone....

want me to try again ?
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 03:51:39 PM
i installed it again ,iim logged in and admin stuff shows....
continue to converst again.... ;D
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 03:57:53 PM
ok thats clear then...as soon as you run convert the admin doesnt show anymore as soon as i login under the created administrator name....
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 04:27:22 PM
well i give up.....
but this is bull...

and im gonna have 2 logins instead of one....as i understand its not a full integration..
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on January 26, 2007, 06:23:15 PM
Umm it should convert the admins.  Can you please go to phpMyAdmin and tell me what does the usertype column in the users table say for your user name?
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 06:31:37 PM
Quoteusertype column in the users table
?  ?

there is no such thing....
smf doesnt have a users table , only smf_members , nor is there a user-type...

were discussing smf here so i assume your talking about the smf tables...

so if you want me to check something please tell me exactly what to look for...
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on January 26, 2007, 06:39:57 PM
No I'm talking about the SimpleBoards users table.  In SMF it's prefix_members.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 06:48:48 PM
yeah i looked there...
but there's no usertype column in the smf_members table.

im in there as user admin with id 62 and with the name i registered with....
that should be admin from the start when i installed it....
both names work as login but non of them gets admin functions.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on January 26, 2007, 07:02:02 PM
I know that there is no usertype column in SMF's members table.  I'm asking you what is the value for the usertype column in the SimpleBoard users table.  If it superadministrator or administrator?
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 07:26:14 PM
well maybe its me and im just stupid but what your asking me is very confusing....

you say you know there's no usertype column ,but still you ask me..what is the value for the usertype column  ?    ?

i have a smf_members table...
admin and my registered name...
they have id 62 and 63 .....
there is no other id or whatever....

And just in case you cant remember them all.... ;D

Here's the list of fiels of smf_members...

So ?  ?  ?

ID_MEMBER
memberName
dateRegistered
posts
ID_GROUP
lngfile
lastLogin
realName
instantMessages
unreadMessages
buddy_list
pm_ignore_list
messageLabels
passwd
emailAddress
personalText
gender
birthdate
websiteTitle
websiteUrl
location
ICQ
AIM
YIM
MSN
hideEmail
showOnline
timeFormat
signature
timeOffset
avatar
pm_email_notify
karmaBad
karmaGood
usertitle
notifyAnnouncements
notifyOnce
notifySendBody
notifyTypes
memberIP
memberIP2
secretQuestion
secretAnswer
ID_THEME
is_activated
validation_code
ID_MSG_LAST_VISIT
additionalGroups
smileySet
ID_POST_GROUP
totalTimeLoggedIn
passwordSalt


Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on January 26, 2007, 07:28:50 PM
Quote from: JayBachatero on January 26, 2007, 07:02:02 PM
I know that there is no usertype column in SMF's members table.  I'm asking you what is the value for the usertype column in the SimpleBoard users table.  If it superadministrator or administrator?

I said in the SimpleBoard users table.  Not SMF.  I've been saying that.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 07:35:04 PM
mmm, ok ...
its Administrator

i tried to change the username admin to Administrator (in smf) ,just to try....but then the login fails...
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on January 26, 2007, 07:38:37 PM
Is it Administrator or administrator?  Notice the case.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 07:44:36 PM
yes i tries administrator and Administrator..

and i just used the lost pass function..
made the password again ,now i could login...but no admin functions...
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: Oldiesmann on January 26, 2007, 08:02:51 PM
What specifically does it say in the "usertype" column in your simpleboard users table? Is it "Administrator" with a capital A or "administrator" with a lowercase a? It makes a big difference because PHP sees them as two different things (I'm pretty sure MySQL does as well)
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 08:08:29 PM
i have it now ...JayBachatero :D

i dumped the tables again and try to find out what the problem was,cause whatever it was ,it happend after converting...

and then i noticed....
before the converting the admins ID_GROUP is 1
after converting its set to 0

now i could login and all admin functions show...

i run that count and statistics and now also the total replies show...

but...JayBachatero...

a thing you didnt answered was ....

Am i gonna end up with 2 logins if i use this forum ?
My site runs with community builder as well...






Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on January 26, 2007, 08:12:57 PM
Well I knew that 1 id for admin and 0 is regular memebr :P.  Still doesn't andwer the question.  What did the usertype column say?  Can you email me a dump of the users table?

About the loggin I think you can just use the joomla/mambo integration.  I'm not familiar with that though.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 08:20:12 PM
the usertype ?

Of my joomla users table the was Administrator and is Super Administrator as usertype.

btw..
another thing.....

Words like :....    don't ,  I'm  ,   I'll

no show like      don\\'t ,  I\\'m  ,   I\\'ll

Where does that come from ?
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on January 26, 2007, 08:53:07 PM
Ok I stripped slashes since the converter already adds them so it should fix this issue you have now.

Is it possible for me to get access to your phpMyAdmin so that I can look at the users table and determine what I need to do to convert administrator correctly.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 26, 2007, 08:59:51 PM
but you can get a copy of the users table everywhere cause its joomla ...right?
i cant give any access,sorry....
its not personal...but a rule..

and i just decided not to use it cause with intergration / bridge it looks terrible...

but atleast it helped you....
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: Oldiesmann on January 26, 2007, 09:09:26 PM
We can get a copy anywhere, but it takes a while to set everything up, and the default configuration might be different than how you have things set up. You can trust the team members with access to your database.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: babylon on January 27, 2007, 05:12:25 AM
well sure you can ask,but its not a question of trust....
its something i just cant do.....

but this is my users table.....


CREATE TABLE `jos_users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `username` varchar(25) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `password` varchar(100) NOT NULL default '',
  `usertype` varchar(25) NOT NULL default '',
  `block` tinyint(4) NOT NULL default '0',
  `sendEmail` tinyint(4) default '0',
  `gid` tinyint(3) unsigned NOT NULL default '1',
  `registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `activation` varchar(100) NOT NULL default '',
  `params` text NOT NULL,
  `enable_blog` int(11) default '1',
  `enable_frontpage` int(11) default '0',
  `profile_detail` mediumtext NOT NULL,
  `blogmail_enable` int(11) default '1',
  `blogmail_count` int(11) default '10',
  `blogmail_blog_published` int(11) default '0',
  `blogmail_blog_section` int(11) default '0',
  `blogmail_blog_category` int(11) default '0',
  `blogmail_account` varchar(100) default '[email protected]',
  `blogmail_password` varchar(100) default NULL,
  `blogmail_server` varchar(100) default 'site.com',
  `blogmail_protocol` varchar(50) default '110/pop3',
  `blogmail_ssl` varchar(100) default 'none',
  `blogmail_folder` varchar(255) default 'images/stories',
  PRIMARY KEY  (`id`),
  KEY `usertype` (`usertype`),
  KEY `idx_name` (`name`)
) TYPE=MyISAM AUTO_INCREMENT=5357 ;
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: imranbaig on February 16, 2007, 02:04:27 PM
Thanks a billion this worked like a charm.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: maranate on March 22, 2007, 04:24:34 AM
Did you ever figure out why the admin disappears?  I just converted a joomlaboard to smf, and the admin disappeared.  To fix it, I just reinstalled smf, added a new admin, logged in as the new admin, changed the original admin back to an admin, then deleted the "new" admin.

Also, I'm still getting slashes wherever there is an apostrophe (like I\'m).
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on March 26, 2007, 10:15:57 AM
Umm are you using the converter from this topic right?  It should strip the slashes.  In regards to the admin stuff I never really figured it out.  Never got a forum to test the conversion on and rewrite the query that handles the admin permission.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: maranate on March 26, 2007, 11:17:53 AM
Well, I thought I had! 

Do you need a very big forum to test it on?  I'm going to be moving a joomla site that has joomlaboard with barely any use, and after I move it, I'm going to switch it to SMF too.  Let me know if I can help.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on March 26, 2007, 02:43:40 PM
Send me a PM with access to phpMyAdmin and I'll see what I can come up with.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: maranate on March 26, 2007, 03:38:11 PM
OK, I have to move it first because it's on Go Daddy and I hate it - I'm moving it to a host with cPanel access.  It will probably be later this week, then I'll send you the PM.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: eclipse115 on July 10, 2007, 10:56:57 PM
I'm having problems with the converter.

I have a Mambo installation 4.5.2 and Simpleboard 1.1 RC.

This is the error I'm getting:

Converting posts (this may take some time)... Unsuccessful!
This query:

    INSERT INTO `girlsgam_smf1`.smf_messages
    (ID_MSG, ID_TOPIC, posterTime, SUBSTRING(m.subject, 1, 255), ID_MEMBER, posterName, posterEmail, posterIP, ID_BOARD, body, modifiedName, icon)

lots of post data then:
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 'SUBSTRING(m.subject, 1, 255), ID_MEMBER, posterName, posterEmail, posterIP, ID_B' at line 2

I customized a few things on my simpleboard back in the day, mainly layout and look.  Any help you can provide is appreciated.  If you need access to any of my files please let me know.

Thanks in advance!
lindsey
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: Daen on July 31, 2007, 12:43:03 PM
Quick question for you guys-- I'm converting from Simpleboard 1.0 to SMF-- I downloaded the script off the Download page.  I'll probably take a look at the one on the thread and try to see which one is newer. 

However, there's another issue: We're using SMF in conjunction with Drupal.  I've been working on carrying over all the data and so far on our own we've already got the members and everything else worked out and synced.  The only thing we're interested in copying are the threads and posts-- we don't want administrator accounts, users, members, avatars, categories/boards, or anything else other than the threads and posts carried over.

Will it work if I simply comment out the sql and sections that deal with converting the parts we don't want moved?  Or is it more complicated than that?  Any tips or advice is appreciated.

Edit: Actually, if it's easier to port over the categories and boards than it is to deal with them already in place, then we might be interested in doing that.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: SleePy on July 31, 2007, 11:59:23 PM
You shouldn't comment them out, but you can. SMF needs to know who made the posts. If it can't find them it will assume they are guest posts. So you will lose lots of posts counts. Everything will be a guest post without the user.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: Daen on August 01, 2007, 10:25:19 AM
That's another issue: we don't care about post counts on a per user basis.  As a matter of fact, I'd like to totally disable it if possible.  Is there a way to do that other than have the boards not count posts?

However, I managed to find a way to port it using some of our own SQL.  All the posters' IDs are the same on both the old and the new systems, so it managed to keep track of who posted what.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: SleePy on August 01, 2007, 05:36:53 PM
Then you can comment it out. But run forum maintinance stuff in Admin -> Forum maintinance after you do this so it can find and repair stuff that might be broken. Which may be a lot.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: Daen on August 03, 2007, 05:34:09 PM
Yeah, ran that.  It was pretty good.  Mostly it just informed me that there were two or three users that didn't exist anymore (meh), and fixed all the most recent posts.  So, I was pretty pleased with that, saved me a lot of work.  Recalculate Forum Statistics is also good.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: pocamil on October 03, 2007, 05:36:29 PM
Hello, I am trying to convert my joomlaboard to smf. I have more than 10k users and more than 3k message.

after running the scritp, I got this error msg:

Converting...
Converting categories... Unsuccessful!
This query:
INSERT INTO `fengshui_mamb1`.smf_categories
(ID_CAT, name, catOrder)
VALUES ('504', 'Feng Shui', '1');
Caused the error:

Duplicate entry '255' for key 1

I spent hours trying to find a solution in different places and could not find one... any ideas or help?
thanks!
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on October 17, 2007, 02:06:38 PM
In phpMyAdmin run this query

ALTER TABLE smf_categories
CHANGE COLUMN ID_CAT ID_CAT smallint(5) unsigned NOT NULL auto_increment
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: terovn on February 24, 2008, 03:29:47 AM
can someone reupload the convert.php file? the link is not working now.

Thanks
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: terovn on February 24, 2008, 03:55:47 PM
I found it in another topic: http://www.simplemachines.org/community/index.php?topic=140741.0

There is also another version here: http://www.simplemachines.org/download/?converters
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: terovn on February 24, 2008, 08:06:53 PM
The script worked great and I succeeded in converting users, messages, categories... but there are 2 problems remain:

1. Permissions were not copied. I can deal with this manually so it is not a big problem, but the second one is:

2. Encoding is not compatible, we used unicode characters in our previous Joomlaboard, but all non-English characters now become strange symbols in SMF, including topic titles, usernames, categories' names...

I guess the reason is SMF store unicode directly into its database, while Joomlaboard uses some kind of encoding before writing into its database. Does anyone know what kind of encoding Joomlaboard use, or how to fix this problem? (my Joomlaboard version is 1.1.3).

Thanks
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on February 24, 2008, 09:59:15 PM
Try converting the SMF tables to UTF-8.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: terovn on February 24, 2008, 10:48:51 PM
Thanks for replying. I tried to convert tables to UTF-8 in the maintainance menu of SMF, but I am not sure what to use for source encoding option. Do you know what is the encoding that Joomlaboard uses?
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: robert_vining on February 25, 2008, 07:53:36 PM
latin1_swedish is usually the standard joomla install encoding for mysql.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: terovn on February 28, 2008, 12:29:01 AM
Quote from: robert_vining on February 25, 2008, 07:53:36 PM
latin1_swedish is usually the standard joomla install encoding for mysql.

I checked in the DB and it seem to be latin1_swedish_ci. But when I try to convert it to utf-8 using Linux's iconv command: iconv -f latin1 -t utf-8 the result is not readable. I am so frustrated with this problem. Thought it was easy but it's taking so much of my time. Anyone has suggestion for the next step?
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: JayBachatero on February 28, 2008, 01:36:10 AM
Is SimpleBoard latin1_swedish_ci as well?
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: terovn on February 29, 2008, 03:56:18 AM
Yes. I mean all SimpleBoard tables (in fact all Joomla tables) use latin1_swedish_ci. So something like "Thơ và Câu Đối ngày Xuân" would become "ThÆ¡ và Câu Đá»'i ngà y Xuân" in the DB. Could someone confirm that it is actually latin1_swedish_ci? If it is, I dont see any reason why iconv did not work :(
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: SleePy on April 12, 2008, 11:30:40 PM
terovn,

Where you able to fix this?

From my install of joomla, it is reporting plain latin1


ENGINE=MyISAM DEFAULT CHARSET=latin1;
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: terovn on April 13, 2008, 12:06:23 AM
I fixed it, but very manually (search and replace). I ran out of patience.

Surely hope someone will come up with a better solution for switching from JoomlaBoard to SMF with non-English language.

Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: locutusweb on November 09, 2009, 03:50:07 AM
I had an old site with Joomlaboard and it sure needed some attention  O:)

In the process I tuned the conversion script for Simpleboard/Joomlaboard

Changelog
! Use the realname instead of username. (simpleboard_to_smf.sql)
! Accept the extra salty passwords of Joomla 1.0.13 and newer. (simpleboard_to_smf.sql)

Joomla_Login_Fix_v11.tgz.gz
If you were using Joomla 1.0.13 or newer (including Joomla 1.5.x), you need to install this mod attached in this topic before converting to accept the extra salty passwords. (Please note it's the same mod for Fireboard)

convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741) with the .sql file attached in this topic.
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: Norv on November 09, 2009, 12:46:39 PM
Thank you for sharing! :)
Title: Re: [SMF Converter] SimpleBoard 1.0 and 1.1
Post by: locutusweb on November 26, 2009, 05:48:08 AM
You're welcome!  :)