• Welcome to Simple Machines Community Forum. Please login or sign up.

[SMF Converter] e107 - 0.7.7

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

Previous topic - Next topic

Terebro

Quote from: slackerpunk on March 23, 2008, 10:46:18 PM
i've had issues with extended fields a while back when I ported from e107 and I found a solution I think given by Jay lemme see if I can still find it in a notepad or something... I used this converter to convert from e107 and it works flawlessly

Did you find the converter?

I am also getting the Unknown column 'u.user_birthday' in 'field list' problem
I have User Fields Extended and its made no difference.

Is this the latest version?
http://www.simplemachines.org/download/?converters

Thanks


Terebro

OK Thanks

I am using v0.7.11 which isn't helping.

Where can I download v0.7.7
I cant find it anywhere

ThorstenE

did you get any other errors while trying the 0.7.7 converter? (or is it yust the same as above?)
you need to  to enable the extended profile in e107.

Terebro

June 30, 2008, 06:27:41 AM #184 Last Edit: June 30, 2008, 06:32:08 AM by Terebro
Thanks for your reply.
I have made progress.

I get this now:

QuoteConverting ranks...Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
SELECT
t.thread_id AS ID_TOPIC, t.thread_s AS isSticky,
t.thread_forum_id AS ID_BOARD, t.thread_id AS ID_FIRST_MSG,
IFNULL(tl.thread_id, t.thread_id) AS ID_LAST_MSG,
IFNULL(us.user_id, 0) AS ID_MEMBER_STARTED,
IFNULL(ul.user_id, IFNULL(us.user_id, 0)) AS ID_MEMBER_UPDATED,
IFNULL(p.poll_id, 0) AS ID_POLL, COUNT(*) AS numReplies, t.thread_views AS numViews,
CASE WHEN t.thread_active = 1 THEN 0 ELSE 1 END AS locked
FROM `terebro_claneq`.eqforum_t AS t
LEFT JOIN `terebro_claneq`.eqforum_t AS tl ON (tl.thread_parent = t.thread_id AND tl.thread_datestamp = t.thread_lastpost)
LEFT JOIN `terebro_claneq`.equser AS us ON (us.user_id = SUBSTRING_INDEX(t.thread_user, '.', 1))
LEFT JOIN `terebro_claneq`.equser AS ul ON (ul.user_id = SUBSTRING_INDEX(tl.thread_user, '.', 1))
LEFT JOIN `terebro_claneq`.eqpolls AS p ON (p.poll_datestamp = t.thread_id)
WHERE t.thread_parent = 0
GROUP BY t.thread_id
LIMIT 0, 200;
Caused the error:

Table 'terebro_claneq.eqpolls' doesn't exist

I have enabled extended fields

ThorstenE

The script works with e107 v.0.7.11.
go to e107 - admin area - Plugins - Plugin-Manager and install the plugins polls and private messenger (if not installed until yet)

SleePy

Hmm, I wonder if I can put checks to have it skip the polls section if it doesn't exist :|
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Terebro

Quote from: ThorstenE on June 30, 2008, 01:49:54 PM
The script works with e107 v.0.7.11.
go to e107 - admin area - Plugins - Plugin-Manager and install the plugins polls and private messenger (if not installed until yet)

OK great, thanks for that I'll try out the conversion when I get home :)

Terebro

Almost there :)

QuoteConverting 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)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting moderators... Successful.
Converting banned users... Successful.
Converting smileys...
Fatal error: Call to undefined function copy_smileys() in /home/terebro/public_html/smf/convert.php(665) : eval()'d code on line 22

Any ideas?

ThorstenE

Download convert.php attached in this topic (i think you are yousing an outdated version from the download-page?)
http://www.simplemachines.org/community/index.php?topic=140741.0

Terebro


ThorstenE

open the convert.php with a texteditor and search for
function copy_smileys
the e107_to_smf.sql calls a function copy_smilieys for converting the smileys.
the above error means, that this function in your convert.php does not exists.

maybe your FTP-Client  is the problem? if you are using the convert.php from the topic i linked above it should run without any errors.

Terebro

That was it!
For some reason FileZilla didnt copy the entire convert.php

So it says it completed, but this is the result.

All OK?

Cheers mate, you've been a great help :)
Very impressed!

QuoteConverting...
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)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting moderators... Successful.
Converting banned users... Successful.
Converting smileys...
Notice: Array to string conversion in /home/terebro/public_html/smf/convert.php(910) : eval()'d code on line 46

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /home/terebro/public_html/smf/convert.php(910) : eval()'d code on line 46

Notice: Array to string conversion in /home/terebro/public_html/smf/convert.php(913) : eval()'d code on line 46

Warning: in_array() [function.in-array]: Wrong datatype for second argument in /home/terebro/public_html/smf/convert.php(913) : eval()'d code on line 46
Successful.
Recalculating forum statistics... Successful.

Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the e107 ver.0.7.7 installation.

We hope you had a smooth transition!

ThorstenE

Welcome to SMF :) the error's possible reason is a customized smiley-Code..
but all other relevant tables are converted successful. Check out your smileys and add the missing smileys manually. Your SMF is ready to use   8)

Terebro


Kronyx

August 20, 2008, 12:41:25 PM #195 Last Edit: August 20, 2008, 12:47:36 PM by Kronyx
I have this error when i try to convert

QuoteConverting...
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,
IF (u.user_admin = 1, 1, 0) 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,
u.user_birthday AS birthdate,
SUBSTRING(REPLACE(u.user_homepage, 'http://', ''), 1, 255) AS websiteTitle,
SUBSTRING(u.user_homepage, 1, 255) AS websiteUrl,
SUBSTRING(u.user_location, 1, 255) AS location,
SUBSTRING(u.user_icq, 1, 255) AS ICQ, SUBSTRING(u.user_aim, 1, 16) AS AIM,
SUBSTRING(u.user_msn, 1, 255) AS MSN, u.user_hideemail AS hideEmail,
SUBSTRING(u.user_signature, 1, 65534) AS signature,
IF(SUBSTRING(u.user_timezone, 1, 1) = '+', SUBSTRING(u.user_timezone, 2), u.user_timezone) 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, '' AS lngfile, '' AS buddy_list,
'' AS pm_ignore_list, '' AS messageLabels, '' AS personalText, '' AS YIM,
'' AS timeFormat, '' AS secretQuestion, '' AS secretAnswer,
'' AS validation_code, '' AS additionalGroups, '' AS smileySet,
'' AS passwordSalt, SUBSTRING(u.user_ip, 1, 255) AS memberIP2
FROM `armatatenebrae`.e107_user AS u
WHERE u.user_id > 0
LIMIT 0, 500;
Caused the error:

Unknown column 'u.user_birthday' in 'field list'

edit:

now i have:

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


WarBirD

I did try this Converter today with the current e107 Version, which is 0.7.14 and i got stock at the birthday thingy. And yes, I had these 2 plugins on e107 already installed before, but still get that message.


    SELECT
    u.user_id AS ID_MEMBER, SUBSTRING(u.user_loginname, 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 `advanc19_joawsite`.e107_user AS u
    LEFT JOIN `advanc19_joawsite`.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_birthday' in 'field list'


So i assume that this converter doesn´t work with the latest e107 version anymore since the plugins, according to your above posts, cannot be responsible in this case since they´re installed already, right ?

mcdemon

+1
i have this problem in 0.7.14 to :(
(sorry my bad englesh)

ThorstenE

ok, edit the e107_to_smf.sql with a text editor and find:
ue.user_birthday AS birthdate,
replace it with
'' AS birthdate,
then try again..

Advertisement: