Cannot convert to SMF from IPB 1.3

[kimalto]

Hello,

Need help...Thanks!!
I've got a error when I convert to the SMF in very beginning....

Code Select Expand


Converting members... Unsuccessful!
This query:
SELECT
id AS ID_MEMBER, SUBSTRING(name, 1, 80) AS memberName,
joined AS dateRegistered, posts,
IF(mgroup = 4, 1, IF(mgroup > 5, mgroup + 3, 0)) AS ID_GROUP,
last_visit AS lastLogin, SUBSTRING(name, 1, 255) AS realName,
msg_total AS instantMessages, SUBSTRING(password, 1, 64) AS passwd,
SUBSTRING(email, 1, 255) AS emailAddress,
SUBSTRING(website, 1, 255) AS websiteTitle,
SUBSTRING(website, 1, 255) AS websiteUrl,
SUBSTRING(location, 1, 255) AS location,
SUBSTRING(icq_number, 1, 255) AS ICQ, signature,
IF (bday_year = 0 AND bday_month != 0 AND bday_day != 0, CONCAT('0004-', bday_month, '-', bday_day), CONCAT_WS('-', IF(bday_year <= 4, 1, bday_year), IF(bday_month = 0, 1, bday_month), IF(bday_day = 0, 1, bday_day))) AS birthdate,
SUBSTRING(aim_name, 1, 16) AS AIM, SUBSTRING(yahoo, 1, 32) AS YIM,
SUBSTRING(msnname, 1, 255) AS MSN, hide_email AS hideEmail,
SUBSTRING(IF(avatar = 'noavatar' OR INSTR(avatar, 'upload') > 0, '', avatar), 1, 255) AS avatar,
email_pm AS pm_email_notify, '' AS lngfile, '' AS buddy_list,
'' AS pm_ignore_list, '' AS messageLabels, '' AS personalText,
'' AS timeFormat, '' AS usertitle, '' AS memberIP, '' AS secretQuestion,
'' AS secretAnswer, '' AS validation_code, '' AS additionalGroups,
'' AS smileySet, '' AS passwordSalt, '' AS memberIP
FROM ` $db_name`.$prefix_members
WHERE id != 0
LIMIT 0, 500;
Caused the error:

Unknown column 'joined' in 'field list'



I've found some posts about the convert problem in this community, however, all of other are passed the"Converting members... ".. so I no idea on it.
Does this convertion support Big5 or UTF-8 or not? Because many member are using Chinese character as UserID...
Many Thanks.

[kimalto]

Could someone help me??
Thanks.

[JayBachatero]

Are you using the converter from the sticky in this board?

[kimalto]

Yes.
I downloaded from this linkhttp://www.simplemachines.org/download/index.php?thanks;filename=smf_1-1-2_invision_converter.zip

And I read this post http://www.simplemachines.org/community/index.php?topic=146211.0

But all .sql have encounted problem when converting Members..

Thanks!

[JayBachatero]

You get the same error with both .sql files?

[kimalto]

Yes..
I don't know why...

All error are:

Unknown column 'joined' in 'field list'

[JayBachatero]

Can you post the structure for the members table?

[kimalto]

Please find the attachment.
Thanks you.

[JayBachatero]

Ok try this one.

[kimalto]

This is fixed the Joined As RegDate...
However.. is have another error..
Thanks for helping.

Caused the error:

Unknown column 'signature' in 'field list'

[JayBachatero]

Here.  I wonder if you are running a fork of 1.3 or something.

[kimalto]

This work!!!
Thank you, JayBachatero !!

Actually, I'm using the IPBM, or said X-IPBM that integate with Xoops before.
I've converted the database from the script that written by Koudansai, the Invision admin...

Now, I'll try to convert the orginial member list that INCULDE Chinese charset and space in the UserID...
Let me try....

[JayBachatero]

Hopefully the UTF-8 stuff will work.  The converter needs work on that area .

[kimalto]

Great!!
The UTF8 is work!
Thanks for your prompt reply!!

I thought many IPBM users who has interesting to convert from IPBM to SMF..because the IPBM is outdated!! But the way is not easy to find in the Internet......


Let me try to integrate the Xoops later~~ Because I don't know how to use....

Jay,
Thanks again!!

[JayBachatero]

Hey send them over and I'll help them convert .  Glad to hear the UTF-8 conversion worked.

[kimalto]

Do you means the database of the IPBM?
But the IPBM must integrate with Xoops, inculde the users list...
Due to the Board using Xoops member db.

I'll try to export the structure of the whole IPBM db...but I need to find out cuase I forgot which is orginal DB...

[JayBachatero]

Ohh I meant about bringing other people to SMF .

About XOOPs you can ask in the Portals, Bridges, and Integrations board.  I don't know much about bridges .

[kimalto]

I'll try to send them if they have interesting to use SMF, haha
SMF is easily to bridge with other CMS~~
This is the main reason that's why I change to SMF

[JayBachatero]

Yea bridging is easy.  If you have any issues with them just post in that board and you will get help there .

[kimalto]

Hi Jay,

I need help again..
After I converted the db to SMF, the member list is correct and the signature is no error.

But the fourm permission are lost...

Could you please help again??
Thanks.