News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

IPB 3.0.x to SMF 1.1.x or SMF 2

Started by Antes, October 14, 2009, 10:29:46 AM

Previous topic - Next topic

Antes

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

Powerbob

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.



My SMF 2.1 Beta test site; http://www.pplb.net/smf21/index.php

Antes

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 )

SleePy

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.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Antes

#4
i made my request ( problem fixed in converter_request page )

Norv

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).
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Antes

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 , 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 :)

Norv

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 , 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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Antes

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'

Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Antes

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

Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Antes

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    

Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Antes

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

Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

skysummit

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.

Norv

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.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Antes

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 ?

Norv

No, there isn't any available yet, I meant I was working on it and will be again when I have a little time.
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

Advertisement: