[SMF Converter] e107 - 0.7.7

Started by JayBachatero, January 10, 2007, 01:26:50 PM

Previous topic - Next topic

Angpeu

what a pity! :(
I hope that buy new monitor it's big problem for you...


lets change all (No Subject) to (Re: + Topic) i think its Right.

File BBC its attachmets
[file=../../files/public/1168523378_3063_FT39255_winamp_to_qip.zip]1168523378_3063_FT39255_winamp_to_qip.zip[/file]

i found one more BBC
<span class='smallblacktext'>[ Edit 06 07 2004, 23:13 ]</span>
on smf it's =  « Last Edit: Today at 03:38:24 am by Angpeu »




JayBachatero

Ok I got a new monitor....

I removed the Last edit time stamp and it will save it to the database.  I need to add support for attachments.  I can't seem to find the option to enable it for the forum.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

JayBachatero

#82
This file should support last edit time stamp and subject stuff.  Let me know how it goes.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Angpeu

Quote from: JayBachatero on January 12, 2007, 07:53:30 PM
Ok I got a new monitor....

I removed the Last edit time stamp and it will save it to the database.  I need to add support for attachments.  I can't seem to find the option to enable it for the forum.

Attachements enable on this page http://www.test.com/e107_admin/upload.php

Angpeu

this query on step 13
http://www.onet.local/smf/convert.php?step=1&substep=13&start=3400
works too long, about 2 min on 200 row.
my 360000 rows converted with 60 hours. :((((
mysql take 100% processor time.

SELECT
CASE WHEN m.thread_parent = 0 THEN m.thread_id ELSE m.thread_parent END AS ID_TOPIC,
m.thread_forum_id AS ID_BOARD, m.thread_datestamp AS posterTime,
m.thread_id AS ID_MSG, IFNULL(u.user_id, 0) AS ID_MEMBER,
SUBSTRING(IFNULL(m.thread_name, m2.thread_name), 1, 255) AS subject,
SUBSTRING(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(m.thread_user, '.', 2), '.', -1), 0x1, 1), 1, 255) AS posterName,
SUBSTRING(IFNULL(u.user_email, '[email protected]'), 1, 255) AS posterEmail,
'0.0.0.0' AS posterIP, 1 AS smileysEnabled, m.thread_thread AS body,
m.thread_edit_datestamp AS modifiedTime, 'xx' AS icon,
SUBSTRING(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(m.thread_lastuser, '.', 2), '.', -1), 0x1, 1), 1, 255) AS modifiedName
FROM `onet-local`.e107_forum_t AS m
LEFT JOIN `onet-local`.e107_forum_t AS m2 ON (m2.thread_parent = m.thread_id)
LEFT JOIN `onet-local`.e107_user AS u ON (u.user_id = SUBSTRING_INDEX(m.thread_user, '.', 1))
LIMIT 3400, 200

JayBachatero

That was some left over from where I was trying to convert the subject in one shot.  Use this file.  Did the subject convert good for the others though?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Angpeu

#86
Converting posts (step 2)... Unsuccessful!
This query:
SELECT
ID_FIRST_MSG, ID_TOPIC, subject
FROM `smf`.smf_messages
WHERE subject != ''
LIMIT 134000, 1000;
Caused the error:
Unknown column 'ID_FIRST_MSG' in 'field list'

im change step from 200 to 1000 it work faster now.

JayBachatero

Ok hopefully this will fix it.  Attachments are still not converted.  I have to see how I'm going to work this one out.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Angpeu

On this step convert.php?step=1&substep=13&start=136200
all  end with error.
this last query:
SELECT
t.ID_FIRST_MSG, t.ID_TOPIC, m.subject
FROM `smf`.smf_messages AS m
INNER JOIN `smf`.smf_topics AS t ON (t.ID_TOPIC = m.ID_TOPIC)
WHERE m.subject != ''
GROUP BY t.ID_TOPIC
LIMIT 136200, 200

its return no results
convert end with this screen:

JayBachatero

Ok try this.  It just kept on going even if it didn't have any results.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Angpeu

script normaly done.
Sctatistic on Replies not updated.
Img bbc and NO subject not converted.

JayBachatero

#91
Statistics on Replies not updated?

What is the current img bbc error?  I'll look into the subject stuff now.

EDIT:  Silly me.  I was looking for topics with a blank subject even though I set the subject to "(No Subject)" in the step before.  Try this file.

BTW can you get on ICQ now?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Angpeu

(No Subject) and IMG bbc - not conveted  :(

<span class='smallblacktext'>[ Edit 06 07 2004, 23:13 ]</span>

normaly removed.

JayBachatero

Not even with the file that I sent you?  The latest one.

Is the edit time being shown in SMF's style though?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Angpeu

How about finish (NoSubject) convert?

JayBachatero

I'm me tomorrow on ICQ and I can finish it off.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

darkwind

I get this error

Converting ranks...Converting groups... Successful.
Converting members... Unsuccessful!
This query:

    SELECT
    u.user_id AS ID_MEMBER, SUBSTRING(u.user_name, 1, 80) AS memberName,
    u.user_join AS dateRegistered, u.user_forums AS posts,
    (CASE WHEN u.user_admin = 1 THEN 1 ELSE 0 END) AS ID_GROUP, u.user_lastvisit AS lastLogin,
    SUBSTRING(u.user_name, 1, 255) AS realName,
    SUBSTRING(u.user_password, 1, 64) AS passwd,
    SUBSTRING(u.user_email, 1, 255) AS emailAddress, 0 AS gender,
    ue.user_birthday AS birthdate,
    SUBSTRING(REPLACE(ue.user_homepage, 'http://', ''), 1, 255) AS websiteTitle,
    SUBSTRING(ue.user_homepage, 1, 255) AS websiteUrl,
    SUBSTRING(ue.user_location, 1, 255) AS location,
    SUBSTRING(ue.user_icq, 1, 255) AS ICQ,
    SUBSTRING(ue.user_aim, 1, 16) AS AIM,
    SUBSTRING(ue.user_msn, 1, 255) AS MSN, u.user_hideemail AS hideEmail,
    SUBSTRING(u.user_signature, 1, 65534) AS signature,
    CASE
    WHEN SUBSTRING(u.user_timezone, 1, 1) = '+'
    THEN SUBSTRING(u.user_timezone, 2)
    ELSE u.user_timezone
    END AS timeOffset,
    SUBSTRING(u.user_image, 1, 255) AS avatar,
    SUBSTRING(u.user_customtitle, 1, 255) AS usertitle,
    SUBSTRING(u.user_ip, 1, 255) AS memberIP,
    SUBSTRING(u.user_ip, 1, 255) AS memberIP2, '' AS lngfile, '' AS buddy_list,
    '' AS pm_ignore_list, '' AS messageLabels, '' AS personalText, '' AS YIM,
    '' AS timeFormat, '' AS secretQuestion, '' AS secretAnswer, '' AS passwordSalt,
    '' AS validation_code, '' AS additionalGroups, '' AS smileySet
    FROM `kisha_pbaonline`.e107_user AS u
    LEFT JOIN `kisha_pbaonline`.e107_user_extended AS ue ON (ue.user_extended_id = u.user_id)
    WHERE u.user_id != 0
    LIMIT 0, 500;

Caused the error:

    Unknown column 'ue.user_icq' in 'field list'

Angpeu


enable extended user fields on e107 admin.

darkwind

ok. here's what i got after activating it.

Converting ranks...Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting posts (step 2)...
Notice: Undefined index: start in /home/kisha/public_html/convert.php(665) : eval()'d code on line 16
Unsuccessful!
This query:

    SELECT
    t.ID [nofollow]_FIRST_MSG, t.ID [nofollow]_TOPIC, m.subject
    FROM `kisha_thepba`.pba_messages AS m
    INNER JOIN `kisha_thepba`.pba_topics AS t ON (t.ID_TOPIC = m.ID [nofollow]_TOPIC)
    WHERE m.subject != '(No Subject)'
    GROUP BY t.ID [nofollow]_TOPIC
    LIMIT , 200;

Caused the error:

    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 ' 200' at line 7

JayBachatero

darkwind if you give me a few days I will have an updated converter that does smileys and that has a few other bug fixes.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Advertisement: