oh i'm sorry you get my wrong , the problem was in SM.org not about converter ... ( there is no converter IPB 3 to SMF ) , Normally you know better than me , Converter requests directly made here (http://custom.simplemachines.org/converter_request.php) , but when i was tried script has a small problem which not accepting converter requests , so yesterday night i tried again and sent my converter request
We need some details to be able to help. Are you converting from IPB 3.0.2? if yes, which version of smf do you have installed?
I believe a converter is as yet not available for the 3.0 versions.
Yes, i have IPB 3.0.x , really bored with IPS , they are not working on Native lngs ... SMF version is not important i want to move SMF asap :)
NoTe : i upgraded my version to 3.0.4 ... ( but this not make any sense )
Is there anymore data printed before that? It is a very generic error from the database abstraction, so we need some more data before it to know where in the converter this occurred.
i made my request ( problem fixed in converter_request page )
Antes: please tell, did you try the converter to 2.0, and with what effect if so?
It wouldn't do anything wrong to your databases anyway, it might try to bring some data in SMF or fail, that's all. (please do take a backup before just in case though).
Quote from: Norv on October 25, 2009, 10:46:21 PM
Antes: please tell, did you try the converter to 2.0, and with what effect if so?
It wouldn't do anything wrong to your databases anyway, it might try to bring some data in SMF or fail, that's all. (please do take a backup before just in case though).
oh :) i'm sorry you get my wrong , the problem was in SM.org not about converter ... ( there is no converter IPB 3 to SMF :) ) , Normally you know better than me :) , Converter requests directly made here (http://custom.simplemachines.org/converter_request.php) , but when i was tried script has a small problem which not accepting converter requests , so yesterday night i tried again and sent my converter request :)
Quote from: Antes on October 26, 2009, 03:02:33 AM
Quote from: Norv on October 25, 2009, 10:46:21 PM
Antes: please tell, did you try the converter to 2.0, and with what effect if so?
It wouldn't do anything wrong to your databases anyway, it might try to bring some data in SMF or fail, that's all. (please do take a backup before just in case though).
oh :) i'm sorry you get my wrong , the problem was in SM.org not about converter ... ( there is no converter IPB 3 to SMF :) ) , Normally you know better than me :) , Converter requests directly made here (http://custom.simplemachines.org/converter_request.php) , but when i was tried script has a small problem which not accepting converter requests , so yesterday night i tried again and sent my converter request :)
Actually, I understand that very well. ;)
However, I am handling requests for converters, not problems with the site. And I cannot help directly with your request for a converter from IPB 3.0.x as I don't have a IPB version 3.0.x, and I am not aware of how many changes there may be, from versions 2.x, that we can convert from, to 3.0.x. Therefore I am wondering if by any chance you tried a converter from 2.x, and with what results. As explained above, the worse that could happen is that it will fail, without touching your IPB installation. (it will wipe your data from SMF, but SMF should really be only a fresh install anyway).
In case you want, you can also send me a database backup file, and I will see what can be done. If you agree, please let me know.
Now , i tried to use IPB 2.3.x to SMF 1.1.10 ; ( yea i accept kinda crazy work :D - using 2.3.x converter to convert 3.0.x xD )
----------------------------------------------
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 `ztv`.ipb_members
WHERE id != 0
LIMIT 0, 500;
Caused the error:
Unknown column 'id' in 'field list'
Ah well, we might be out of luck.
If you can, you could perhaps run this in your phpMyAdmin, on the IPB database:
SHOW FULL COLUMNS FROM ipb_members;
and post the results here.
Alternatively, please consider making a database export in phpMyAdmin and making it available. (the data is not strictly needed, though very helpful sometimes, the "structure" matters most, so it can be structure-only in case you are uncomfortable with making data available). It's your call, of course.
xps added :) i hope this help more , i'm sorry about DB for now - i have partners too i need to ask them to sent back-up ... just only tooks 10 hour or less , forgive me...
Could you please consider to save it into another format than a microsoft one? I'm on Linux. ;)
A lightweight text editor like Notepad++ could offer a variety of open and portable formats, instead.
Firstly again forgive me never used Linux , and best i can do
Field Type Collation Null Key Default Extra Privileges Comment
member_id mediumint(8) NULL NO PRI NULL auto_increment select,insert,update,references
name varchar(255) utf8_general_ci NO select,insert,update,references
member_group_id smallint(3) NULL NO MUL 0 select,insert,update,references
email varchar(150) utf8_general_ci NO select,insert,update,references
joined int(10) NULL NO 0 select,insert,update,references
ip_address varchar(16) utf8_general_ci NO MUL select,insert,update,references
posts mediumint(7) NULL YES 0 select,insert,update,references
title varchar(64) utf8_general_ci YES NULL select,insert,update,references
allow_admin_mails tinyint(1) NULL YES NULL select,insert,update,references
time_offset varchar(10) utf8_general_ci YES NULL select,insert,update,references
hide_email varchar(8) utf8_general_ci YES NULL select,insert,update,references
email_pm tinyint(1) NULL YES 1 select,insert,update,references
email_full tinyint(1) NULL YES NULL select,insert,update,references
skin smallint(5) NULL YES NULL select,insert,update,references
warn_level int(10) NULL YES NULL select,insert,update,references
warn_lastwarn int(10) NULL NO 0 select,insert,update,references
language varchar(32) utf8_general_ci YES NULL select,insert,update,references
last_post int(10) NULL YES NULL select,insert,update,references
restrict_post varchar(100) utf8_general_ci NO 0 select,insert,update,references
view_sigs tinyint(1) NULL YES 1 select,insert,update,references
view_img tinyint(1) NULL YES 1 select,insert,update,references
view_avs tinyint(1) NULL YES 1 select,insert,update,references
view_pop tinyint(1) NULL YES 1 select,insert,update,references
bday_day int(2) NULL YES MUL NULL select,insert,update,references
bday_month int(2) NULL YES MUL NULL select,insert,update,references
bday_year int(4) NULL YES NULL select,insert,update,references
msg_count_new int(2) NULL NO 0 select,insert,update,references
msg_count_total int(3) NULL NO 0 select,insert,update,references
msg_count_reset int(1) NULL NO 0 select,insert,update,references
msg_show_notification int(1) NULL NO 0 select,insert,update,references
misc varchar(128) utf8_general_ci YES NULL select,insert,update,references
last_visit int(10) NULL YES 0 select,insert,update,references
last_activity int(10) NULL YES 0 select,insert,update,references
dst_in_use tinyint(1) NULL YES 0 select,insert,update,references
view_prefs varchar(64) utf8_general_ci YES -1&-1 select,insert,update,references
coppa_user tinyint(1) NULL YES 0 select,insert,update,references
mod_posts varchar(100) utf8_general_ci NO 0 select,insert,update,references
auto_track varchar(50) utf8_general_ci YES 0 select,insert,update,references
temp_ban varchar(100) utf8_general_ci YES 0 select,insert,update,references
sub_end int(10) NULL NO 0 select,insert,update,references
login_anonymous char(3) utf8_general_ci NO 0&0 select,insert,update,references
ignored_users text utf8_general_ci YES NULL select,insert,update,references
mgroup_others varchar(255) utf8_general_ci NO select,insert,update,references
org_perm_id varchar(255) utf8_general_ci NO select,insert,update,references
member_login_key varchar(32) utf8_general_ci NO select,insert,update,references
member_login_key_expire int(10) NULL NO 0 select,insert,update,references
subs_pkg_chosen smallint(3) NULL NO 0 select,insert,update,references
has_blog tinyint(1) NULL NO 0 select,insert,update,references
has_gallery tinyint(1) NULL NO 0 select,insert,update,references
members_editor_choice char(3) utf8_general_ci NO std select,insert,update,references
members_auto_dst tinyint(1) NULL NO 1 select,insert,update,references
members_display_name varchar(255) utf8_general_ci NO select,insert,update,references
members_seo_name varchar(255) utf8_general_ci NO select,insert,update,references
members_created_remote tinyint(1) NULL NO 0 select,insert,update,references
members_cache mediumtext utf8_general_ci YES NULL select,insert,update,references
members_disable_pm int(1) NULL NO 0 select,insert,update,references
members_l_display_name varchar(255) utf8_general_ci NO MUL select,insert,update,references
members_l_username varchar(255) utf8_general_ci NO MUL select,insert,update,references
failed_logins text utf8_general_ci YES NULL select,insert,update,references
failed_login_count smallint(3) NULL NO 0 select,insert,update,references
members_profile_views int(10) unsigned NULL NO 0 select,insert,update,references
members_pass_hash varchar(32) utf8_general_ci NO select,insert,update,references
members_pass_salt varchar(5) utf8_general_ci NO select,insert,update,references
identity_url text utf8_general_ci YES NULL select,insert,update,references
member_banned tinyint(1) NULL NO MUL 0 select,insert,update,references
member_uploader varchar(32) utf8_general_ci NO default select,insert,update,references
members_bitoptions int(10) unsigned NULL NO MUL 0 select,insert,update,references
fb_uid bigint(20) NULL NO 0 select,insert,update,references
fb_emailhash varchar(60) utf8_general_ci NO select,insert,update,references
fb_emailallow int(1) NULL NO 0 select,insert,update,references
fb_lastsync int(10) NULL NO 0 select,insert,update,references
members_day_posts varchar(32) utf8_general_ci NO 0 select,insert,update,references
invites_remaining int(11) NULL NO 0 select,insert,update,references
invite_offset int(11) NULL NO 0 select,insert,update,references
live_id varchar(32) utf8_general_ci YES NULL select,insert,update,references
I understand from the error messages that you want to convert to 1.1.10, is that understanding correct?
If that is the case, please eventually try using the attached file instead.
Quote from: Norv on October 26, 2009, 06:06:19 PM
I understand from the error messages that you want to convert to 1.1.10, is that understanding correct?
If that is the case, please eventually try using the attached file instead.
1.1.10 or 2.0 not make sense both are okey for me :) , 1.1.10 to 2.0 Upgrade is easy too :)
Edit :
Converting members... Unsuccessful!
This query:
SELECT
m.member_id AS ID_MEMBER, SUBSTRING(m.name, 1, 80) AS memberName,
m.joined AS dateRegistered,
IF(m.member_group_id = 4, 1, IF(m.member_group_id = 3, 0, IF(m.member_group_id > 5, m.member_group_id + 3, 0))) AS ID_GROUP,
posts, m.last_visit AS lastLogin, SUBSTRING(m.members_display_name, 1, 80) AS realName,
SUBSTRING(me.yahoo, 1, 32) AS YIM, m.msg_count_total AS instantMessages,
SUBSTRING(mc.converge_pass_hash, 1, 64) AS passwd,
SUBSTRING(mc.converge_pass_salt, 1, 5) AS passwordSalt,
SUBSTRING(m.email, 1, 255) AS emailAddress,
IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 1, m.bday_year), IF(m.bday_month = 0, 1, m.bday_month), IF(m.bday_day = 0, 1, m.bday_day))) AS birthdate,
SUBSTRING(me.website, 1, 255) AS websiteTitle,
SUBSTRING(me.website, 1, 255) AS websiteUrl, me.signature,
SUBSTRING(me.location, 1, 255) AS location,
SUBSTRING(me.icq_number, 1, 255) AS ICQ,
SUBSTRING(me.msnname, 1, 255) AS MSN, SUBSTRING(me.aim_name, 1, 16) AS AIM,
m.hide_email AS hideEmail, m.email_pm AS pm_email_notify,
SUBSTRING(IF(me.avatar_location = 'noavatar', '', me.avatar_location), 1, 255) AS avatar,
TRIM(BOTH ',' FROM mgroup_others) AS additionalGroups,
'' 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 smileySet, '' AS memberIP2
FROM `ztv`.ipb_members AS m
LEFT JOIN `ztv`.ipb_member_extra AS me ON (m.member_id = me.id)
LEFT JOIN `ztv`.ipb_members_converge AS mc ON (m.member_id = mc.converge_id)
WHERE m.id != 0
LIMIT 0, 500;
Caused the error:
Table 'ztv.ipb_member_extra' doesn't exist
I'm afraid the changes are big enough to require more work than just doing it on the fly.
Please feel free to let me know by PM in case you can make available a database backup file, and in that case I will take a look at this conversion as soon as possible.
I'm anxious to hear more on this. I'm also on an IPB 3.0.4 and am getting tired of it. The script usage seems to be tearing up my traffic stats. I just downloaded SMF 1.1.10 to a completely separate SQL database.
If all goes well, we may also need to use that converter.
I've worked on it, though unfortunately it is not ready yet and I'm insanely busy elsewhere right now, but will be back on it. We might also have a version for SMF 2.0 first, but it shouldn't take long to adapt it to 1.1.10.
Quote from: Norv on November 14, 2009, 11:28:28 AM
I've worked on it, though unfortunately it is not ready yet and I'm insanely busy elsewhere right now, but will be back on it. We might also have a version for SMF 2.0 first, but it shouldn't take long to adapt it to 1.1.10.
is there any test converter for IPB 3.0.x - SMF 2 RC2 ?
No, there isn't any available yet, I meant I was working on it and will be again when I have a little time.
I appreciate the efforts Norv. Hopefully one of these software will eventually have an IPB 3 converter.
Has there been any progress on a 3.0.4 conversion from IPB to SMF2?
Im also interested in knowing the status of the converter :)
I think they said 40%, but they've been at that state for a long time now.
Are there any other alternatives that i can use ?
Is the Converter available ???