Topic: [SMF Converter] SimpleBoard 1.0 and 1.1

[JayBachatero]

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 with the .sql file attached in this topic.

[babylon]

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 ?

[JayBachatero]

Are the replies there though?

[babylon]

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 ?

[JayBachatero]

Go to Admin > Forum Maintenance > Recount Board Stats.  Does that fix it?

[babylon]

nice i dea but how i get to the stats ?
cause when i login on front i dont see any admin functions...

[JayBachatero]

You saying that the admin account is not being transfered?

[babylon]

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 ?

[babylon]

i installed it again ,iim logged in and admin stuff shows....
continue to converst again....

[babylon]

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....

[babylon]

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..

[JayBachatero]

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?

[babylon]

usertype 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...

[JayBachatero]

No I'm talking about the SimpleBoards users table.  In SMF it's prefix_members.

[babylon]

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.

[JayBachatero]

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?

[babylon]

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....

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

[JayBachatero]

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.

[babylon]

mmm, ok ...
its Administrator

i tried to change the username admin to Administrator (in smf) ,just to try....but then the login fails...

[JayBachatero]

Is it Administrator or administrator?  Notice the case.

[babylon]

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...

[Oldiesmann]

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)

[babylon]

i have it now ...JayBachatero

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...

[JayBachatero]

Well I knew that 1 id for admin and 0 is regular memebr .  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.

[babylon]

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 ?

[JayBachatero]

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.

[babylon]

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....

[Oldiesmann]

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.

[babylon]

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 'name@site.com',
  `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 ;

[imranbaig]

Thanks a billion this worked like a charm.

[maranate]

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).

[JayBachatero]

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.

[maranate]

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.

[JayBachatero]

Send me a PM with access to phpMyAdmin and I'll see what I can come up with.

[maranate]

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.

[eclipse115]

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

[Daen]

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.

[SleePy]

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.

[Daen]

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.

[SleePy]

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.

[Daen]

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.

[pocamil]

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!

[JayBachatero]

In phpMyAdmin run this query

Code: [Select]

ALTER TABLE smf_categories
CHANGE COLUMN ID_CAT ID_CAT smallint(5) unsigned NOT NULL auto_increment


[terovn]

can someone reupload the convert.php file? the link is not working now.

Thanks

[terovn]

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

[terovn]

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

[JayBachatero]

Try converting the SMF tables to UTF-8.

[terovn]

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?

[robert_vining]

latin1_swedish is usually the standard joomla install encoding for mysql.

[terovn]

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?

[JayBachatero]

Is SimpleBoard latin1_swedish_ci as well?

[terovn]

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

[SleePy]

terovn,

Where you able to fix this?

From my install of joomla, it is reporting plain latin1

Code: [Select]

ENGINE=MyISAM DEFAULT CHARSET=latin1;

[terovn]

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.

[locutusweb]

I had an old site with Joomlaboard and it sure needed some attention 

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 with the .sql file attached in this topic.

[N. N.]

Thank you for sharing!

[locutusweb]

You're welcome!