Simple Machines Community Forum

SMF Support => Converting to SMF => Topic started by: JayBachatero on January 10, 2007, 01:26:50 PM

Title: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 01:26:50 PM
Software: e107
Version: 0.7.7

This is the official support topic for e107 converter.  Use this topic to ask for support for this converter.

Changelog
! Updated the converter to use the new user_extended table for profile data. (e107_to_smf.sql)
! Subtract 499 from the forum_id when converting categories since tinyint max value unsigned is 255. (e107_to_smf.sql)
! If no subject is specified use the default "(No subject)" subject. (e107_to_sql.sql)
! The table should be polls not poll. (e107_to_smf.sql)
! Updated to use the new table structure for polls. (e107_to_smf.sql)
! Updated to use the new table structure for private messages. (e107_to_smf.sql)
! Use the user_loginname column for the memberName column. (e107_to_smf.sql)

convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic) with the .sql file attached in this topic.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 03:17:59 PM
sorry, but where sql attached file?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 03:29:07 PM
[acting like nothing happened]What chu talking about.  It's right there :P.

Sorry about that.  I uploaded the file.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 03:37:32 PM
ok. tnx.
I will test it.

How about True convert E107 Subforums?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 03:44:33 PM
I have trouble convert more 1500 members on this error
Caused the error:
Duplicate entry '3482' for key 1
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 04:33:45 PM
On what step is that?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 04:38:03 PM
hmm....
m.b. step1
Converting ranks...Converting groups... Successful.
Converting members... Unsuccessful!
This query:
INSERT INTO `smf`.smf_members

Caused the error:
Duplicate entry '3482' for key 1

I do select count(1) from `smf`.smf_members
Result 1500 Records.
My table E107_user have 1740 records...
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 04:46:36 PM
Try this one.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 04:57:02 PM
Converting members... Successful.
but e107_user have 1742 rows
new smf_members have 1621 rows  :(
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 05:01:11 PM
Darn it.  Check your e107 install for duplicate accounts.  Check to see if there are duplicate user_id.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 05:42:24 PM
User_id it's primary key and not have dupelecated rows

look to screenshot
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 05:45:42 PM
I'll look more into this.  Not sure why the duplicate key.  Try the first converter again and see if it works.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 05:50:46 PM
i already try, but no changes.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 05:59:48 PM
Ok drop the ID_MEMBER key from the members table and run the first converter.  Let me know how that goes.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 06:05:07 PM
good!!!!
all rows added.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 06:16:02 PM
have dupe id on smf_members but where i do
this script from sql file:
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,
    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,
    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,
    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 validation_code, '' AS additionalGroups, '' AS smileySet,
    '' AS passwordSalt, SUBSTRING(u.user_ip, 1, 255) AS memberIP2
FROM e107_user AS u
    LEFT JOIN e107_user_extended AS ue ON (u.user_id = user_extended_id)
WHERE u.user_id > 0
order by u.user_id;


no dupes on result and all 1742 row retuturned.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 06:33:56 PM
This is weird.  I wonder if they some how got into the e107 table with the dup id.  Run this query on e107 board and tell me what you get.

SELECT user_id, COUNT(user_id) AS count
FROM {$e107_prefix}user
GROUP BY user_id
WHERE count > 1
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 06:41:02 PM
no count > 1
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 06:44:29 PM

SELECT uid_member, COUNT(id_member) AS count
FROM smf_members
GROUP BY id_member
WHERE count > 1

Check SMF table.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 07:04:17 PM
WHERE cannot plased after GORUP True query
SELECT id_member, COUNT(id_member) AS count
FROM smf_members
GROUP BY id_member
HAVING count > 1


Result return 121 row with count = 2

1742-(121*2)=1500  IT's more 1500 rows Convert Problem.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 07:08:21 PM
Did you run the same query that you posted on the e107 table?  Can't see a reason for dup ids.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 07:17:56 PM
SELECT user_id, COUNT(user_id) AS count
FROM e107_user
GROUP BY user_id
HAVING count > 1


=> No results => No Dup

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,
    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,
    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,
    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 validation_code, '' AS additionalGroups, '' AS smileySet,
    '' AS passwordSalt, SUBSTRING(u.user_ip, 1, 255) AS memberIP2
FROM e107_user AS u
    LEFT JOIN e107_user_extended AS ue ON (u.user_id = user_extended_id)
WHERE u.user_id > 0;


=> Query from e107_to_smf.sql => Returns 1742 row and no dups.

SELECT id_member, COUNT(id_member) AS count
FROM smf_members
GROUP BY id_member
HAVING count > 1


=> Query to smf_members table with droped PRIMARY.
Return 121 row with coun = 2.

I think problem with convert procedure.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 07:28:24 PM
Ok try this one.  The left join was missing the table alas.  Maybe that was the cause for the error.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 07:43:39 PM
line 89 add "," on end
line 90 remove "," on end

No errors. All rows convert Rights. Victory !!!

next trouble

Converting categories... Unsuccessful!
This query:
INSERT INTO `smf`.smf_categories
(ID_CAT, name, catOrder)
VALUES ('18446744073709551118', 'Общие', '1'),
('18446744073709551121', 'РЎРµС,СЊ', '2'),
('18446744073709551127', 'РљРѕРјРїСЊСЋС,еры', '3'),
('18446744073709551130', 'Развлечения', '4');
Caused the error:

Duplicate entry '255' for key 1
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 07:48:58 PM
I wonder why the heck to they insists in not using regular id's for the categories table.  I have to find out what is the value that they use.  I thought they started it at 500.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 08:04:29 PM
Not sure how to take on this.  I need to dig deeper and find out what is the correct forum_id that they use for categories.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 08:08:50 PM
i have normal id's 1,2,4,5 for categories table and remove -499 from sql query.
converts OK.

Next my BIG problem this sql works too many time and not compleate.

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,
    IF(t.thread_active = 1, 0, 1) AS locked
FROM `onet-local`.e107_forum_t AS t
    LEFT JOIN `onet-local`.e107_user AS us ON (us.user_id = SUBSTRING_INDEX(t.thread_user, '.', 1))
    LEFT JOIN `onet-local`.e107_forum_t AS tl ON (tl.thread_parent = t.thread_id AND tl.thread_datestamp = t.thread_lastpost)
    LEFT JOIN `onet-local`.e107_user AS ul ON (ul.user_id = SUBSTRING_INDEX(tl.thread_user, '.', 1))
    LEFT JOIN `onet-local`.e107_forum_t AS m ON (tl.thread_parent = t.thread_id)
    LEFT JOIN `onet-local`.e107_polls AS p ON (p.poll_datestamp = t.thread_id)
WHERE t.thread_parent = 0
GROUP BY t.thread_id
LIMIT 0, 500

its run more 3 hours and mysql use 100% CPU on Athlon64 3200. ;(
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 08:13:12 PM
my e107_forum_t table have 135541 rows, may be its too many for 5 LEFT JOIN's?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 08:16:00 PM
Ok limited the query to just 200 results for topics.  Also I put a check to see if the forum_id is greater than 500 and what to do with it.  Try this one.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 08:37:31 PM
this query not complete on my DB with LIMIT 1  :(
i do now why :(

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 `onet-local`.e107_forum_t AS t
LEFT JOIN `onet-local`.e107_user AS us ON (us.user_id = SUBSTRING_INDEX(t.thread_user, '.', 1))
LEFT JOIN `onet-local`.e107_forum_t AS tl ON (tl.thread_parent = t.thread_id AND tl.thread_datestamp = t.thread_lastpost)
LEFT JOIN `onet-local`.e107_user AS ul ON (ul.user_id = SUBSTRING_INDEX(tl.thread_user, '.', 1))
LEFT JOIN `onet-local`.e107_forum_t AS m ON (tl.thread_parent = t.thread_id)
LEFT JOIN `onet-local`.e107_polls AS p ON (p.poll_datestamp = t.thread_id)
WHERE t.thread_parent = 0
GROUP BY t.thread_id
LIMIT 1

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 08:42:20 PM
What error are you getting?  It's just over loading the server?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 08:46:00 PM
No errors
MySql show State: Copying to tmp table and just over loading server.
i kill him for stop.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 08:56:14 PM
Might be a problem with index.  Might have some missing index causing MySQL to choke.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 09:00:33 PM
How is 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 `onet-local`.e107_forum_t AS t
LEFT JOIN `onet-local`.e107_user AS us ON (us.user_id = SUBSTRING_INDEX(t.thread_user, '.', 1))
LEFT JOIN `onet-local`.e107_forum_t AS tl ON (tl.thread_parent = t.thread_id AND tl.thread_datestamp = t.thread_lastpost)
LEFT JOIN `onet-local`.e107_user AS ul ON (ul.user_id = SUBSTRING_INDEX(tl.thread_user, '.', 1))
LEFT JOIN `onet-local`.e107_polls AS p ON (p.poll_datestamp = t.thread_id)
WHERE t.thread_parent = 0
GROUP BY t.thread_id
LIMIT 1
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 09:02:38 PM
super.
Work Real FAST.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 09:04:00 PM
Ok try this file.  Not sure why that table was being joined 3 times.  The last one didn't seem to have a purpose.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 09:14:17 PM
Next Problem:
Converting posts (this may take some time)... Unsuccessful!
This query:
INSERT INTO `smf`.smf_messages
...................
Caused the error:
Duplicate entry '69422' for key 1
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 09:27:17 PM
Ok lets set ignore to true to see how many "duplicate" posts are there.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 09:35:05 PM
Converting topics... Unsuccessful!
This query:
INSERT INTO `smf`.smf_topics
(ID_TOPIC, isSticky, ID_BOARD, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_POLL, numReplies, numViews, locked)
VALUES ('95039', '0', '11', '95039', '95324', '77', '77', '0', '1', '51', '0'),
.........................................
Caused the error:
Duplicate entry '95039' for key 1

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 09:38:20 PM
Weird.  It worked before so it should be working now.  Converting topics comes before converting posts.  Try truncating the topics table.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 09:44:25 PM
truncate table `smf`.`smf_topics`
reapeat convert:
Converting topics... Unsuccessful!
This query:
INSERT INTO `smf`.smf_topics
(ID_TOPIC, isSticky, ID_BOARD, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_POLL, numReplies, numViews, locked)
.............
Caused the error:
Duplicate entry '36540' for key 1

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 09:55:18 PM
Seems like the $ignore is not working :(.  Are you using the convert.php from the other topic?  The link to it its on the first post.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 09:57:36 PM
im usin this convert:
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 10:07:43 PM
Ok I was looking at the wrong section.  It has the ignore now.  Try this one.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 10:21:21 PM
Converting...
Recalculating forum statistics... Successful.
Conversion Complete
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 10, 2007, 10:24:37 PM
numbers topics and post on new forum = old forum.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 10, 2007, 10:42:09 PM
So that means it was a success?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 11, 2007, 10:53:17 AM
success, but have many errors.
i need some time for full test after then i post full list errors.

First find it not right convert Child Boards. its placed on first level forum...
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 11, 2007, 01:10:47 PM
I'll make a test install of e107 and try working with child boards.  I would appreciate it if you post the errors that you are getting.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 11, 2007, 01:27:52 PM
Ok a question.  How do I add child boards?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 11, 2007, 01:36:33 PM
On the forum admin click to planet icons (like the site icon on you profile)
:)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 11, 2007, 01:38:29 PM
Yea I found it after I posted :P.  Try this file and lets see what happens.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 11, 2007, 02:04:53 PM
Converting boards... Unsuccessful!
This query:
INSERT INTO `smf`.smf_boards
....
Caused the error:
Duplicate entry '2' for key 1
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 11, 2007, 02:32:34 PM
Can you send me a dump of the forum table so that I can run a test query here?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 11, 2007, 02:42:37 PM
take.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 11, 2007, 02:44:47 PM
forum names at windows-1251 charset.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 11, 2007, 02:56:46 PM
Before converting you changed SMF to UTF-8 right?

BTW I'm off to work so I won't be able to have a response for you till I get home tonight.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 11, 2007, 02:59:54 PM
no, im using windows-1251
dump on UTF8, because im use mysql 5.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: jonjax on January 11, 2007, 03:12:04 PM
I have tried the above but still having problems and getting

Caused the error:

Unknown column 'ue.user_birthday' in 'field list'
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 11, 2007, 03:16:00 PM
Quote from: jonjax on January 11, 2007, 03:12:04 PM
I have tried the above but still having problems and getting

Caused the error:

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

on e107 admin, turn on all extended user fields.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: jonjax on January 11, 2007, 04:11:09 PM
works thank you sooooooooooooooooo much... this is amazing all converted
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 11, 2007, 04:16:00 PM
not all.
converter not support smiles and e107 bb codes.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 11, 2007, 11:32:16 PM
Quote from: Angpeu on January 11, 2007, 04:16:00 PM
not all.
converter not support smiles and e107 bb codes.

I'll look into that Angpeu.  I'll have something for you tom.

EDIT: Angpeu what exactly do you mean that the smileys and bbc code are not converted?  They are same bbc codes and smileys so the post should stay in tact.  The images themselves are not converted.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 12, 2007, 05:15:35 AM
this BBC:
[size=14] Club "AR" [/size]
========
[quote1148889148=KOT]
How Can?
[/quote1148889148]
==========
[link=http://www.mc-ent.ru/MAF_V.html]Moscow Anime festival[/link]
==========
[img:width=75&height=75]../../files/public/1168259047_2074_FT96453_av-143.gif[/img]
==========
[blockquote]
[img:width=100&height=100]../../files/public/1166833109_3880_FT96453_.gif[/img][/blockquote]
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 12, 2007, 06:31:59 AM
smiles at e107 look that (pic1)
and stored on  table e107_core (pic2)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 12, 2007, 11:05:04 AM
Ok I added the bbc tags.  Just the ones that are shown.  I also added smileys conversion.  Keep in mind that some smileys will be a bit different expression since there are some smileys that we don't have that e107 has.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 12, 2007, 11:20:11 AM
how about:
Converting boards... Unsuccessful!
This query:
INSERT INTO `smf`.smf_boards
(ID_BOARD, name, description, ID_CAT, ID_PARENT, childLevel, numTopics, numPosts, boardOrder, memberGroups)
VALUES ('2', 'Общие вопросы', '', '1', '0', '0', '378', '6501', '1', '-1,0'),
.........
Caused the error:
Duplicate entry '2' for key 1


but if look to forum i can see normaly converted boards....
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 12, 2007, 11:57:27 AM
In convert.php find

if (!empty($rows))
convert_query("
INSERT $ignore INTO $special_table
(" . implode(', ', $keys) . ")
VALUES (" . implode('),
(', $rows) . ")");


Add before.

if ($special_table == $to_prefix . 'boards')
echo "</pre>
INSERT $ignore INTO $special_table
(" . implode(', ', $keys) . ")
VALUES (" . implode('),
(', $rows) . ")</pre>";


Paste the output here.  It will show all the rows that are being inserted to tract down the problem.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 12, 2007, 12:30:25 PM
atached
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 12, 2007, 12:48:08 PM
Ok add echo '<h2>', count($rows), '</h2>'; before if ($special_table == $to_prefix . 'boards')

That will show the amount of rows that are being fetched.  Trying to see if its a query issue or a convert.php issue.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 12, 2007, 01:33:39 PM
Converting...
Converting ranks...Converting groups...
28
Successful.
Converting members...
500
500
500
247
Successful.
Converting additional member groups... Successful.
Converting categories...
4
Successful.
Converting boards... Unsuccessful!
This query:
INSERT INTO `smf`.smf_boards
----
Caused the error:
Duplicate entry '2' for key 1
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 12, 2007, 02:05:53 PM
Seems like there is no count for the boards table.. Try this.

BTW can you IM me on ICQ?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 12, 2007, 02:16:45 PM
yes i can.
board converts Ok.
im wait for 320000 post convert.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 12, 2007, 02:45:02 PM
all converted.
have some trouble with quote..
double quote converts not true.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 12, 2007, 02:48:05 PM
bbc on Signature not converted:

[size=13]Loving you was like loving the dead (Type O Negative)[/size]
[link=ftp://10.7.0.82]ftp://10.7.0.82[/link]
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 12, 2007, 02:49:46 PM
Paste the whole post in a code tag.  I'll fix that nested quotes issue.  Damn forgot about sigs.  I'll convert those too. Any others? I did it for PMs.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 12, 2007, 02:53:13 PM
Ok here you go.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 12, 2007, 03:57:40 PM
After convert need Recount all forum totals and statistics

All Re: to Post not "have Sublect" i think it's not right
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 12, 2007, 04:08:19 PM
new :) BBC (atached file) not converted
[file=../../files/public/1168545033_808_FT123596_43904_lamertest.zip]1168545033_808_FT123596_43904_lamertest.zip[/file]

And diferent image posts not converted too:

[img:width=480&height=359]../../files/public/1168433990_3151_FT46420_3075_.jpg[/img]

[img:width=480&height=360]../../files/public/1168433990_3151_FT46420_1154378382_girl19_.jpg[/img]

[img:width=321&height=168]../../files/public/1168433990_3151_FT46420_69392_65435.jpg[/img]
[img:width=457&height=328]../../files/public/1168433990_3151_FT46420_1165913549_2.jpg[/img]
[img:width=400&height=318]../../files/public/1168433990_3151_FT46420_1157974820_114.jpg[/img]
[img:width=480&height=360]../../files/public/1168433990_3151_FT46420_1168355496_humor_17_.jpg[/img]

[img:width=270&height=364]../../files/public/1168433990_3151_FT46420_tarakani.gif[/img]
[img:width=480&height=360]../../files/public/1168433990_3151_FT46420_normal_pd800_.jpg[/img]




Quote and Multi Quote Converted Preffect.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 12, 2007, 04:17:57 PM
Actually that is a problem with e107.  They don't put a subject to replies to a post so they are left NULL.  What I can do is do another step to change the subjects of the other posts.  I can either make it have the Re: part in english or no Re: to it.

About the recount part I have to update that part of the converter.

The file tag is for attachments?  I'll take a look at the img tag issue when ever I get a new monitor.  My PC monitor just burnt a few mins ago so I'm not on my PC.  All my test stuff is there.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 12, 2007, 04:56:18 PM
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 »



Title: Re: [SMF Converter] e107 - 0.7.7
Post by: 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.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 13, 2007, 01:22:24 AM
This file should support last edit time stamp and subject stuff.  Let me know how it goes.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 13, 2007, 05:21:05 AM
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
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 13, 2007, 06:31:14 AM
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
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 13, 2007, 01:42:51 PM
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?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 13, 2007, 02:15:17 PM
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.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 13, 2007, 02:32:50 PM
Ok hopefully this will fix it.  Attachments are still not converted.  I have to see how I'm going to work this one out.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 13, 2007, 06:18:29 PM
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:
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 13, 2007, 11:29:19 PM
Ok try this.  It just kept on going even if it didn't have any results.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 14, 2007, 02:12:16 AM
script normaly done.
Sctatistic on Replies not updated.
Img bbc and NO subject not converted.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 14, 2007, 02:27:14 AM
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?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on January 14, 2007, 09:43:33 AM
(No Subject) and IMG bbc - not conveted  :(

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

normaly removed.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on January 14, 2007, 01:27:36 PM
Not even with the file that I sent you?  The latest one.

Is the edit time being shown in SMF's style though?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on February 11, 2007, 12:47:36 PM
How about finish (NoSubject) convert?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on February 12, 2007, 01:53:46 AM
I'm me tomorrow on ICQ and I can finish it off.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: darkwind on February 17, 2007, 07:05:28 PM
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'
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on February 17, 2007, 07:33:18 PM

enable extended user fields on e107 admin.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: darkwind on February 18, 2007, 06:22:13 AM
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_FIRST_MSG, t.ID_TOPIC, m.subject
    FROM `kisha_thepba`.pba_messages AS m
    INNER JOIN `kisha_thepba`.pba_topics AS t ON (t.ID_TOPIC = m.ID_TOPIC)
    WHERE m.subject != '(No Subject)'
    GROUP BY t.ID_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
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on February 18, 2007, 01:46:57 PM
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.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: darkwind on February 18, 2007, 02:00:27 PM
Sure, I'll give you the few days. You're helping us a lot.

Thanks.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: tesk on March 19, 2007, 09:08:42 AM
Hmmm....

Can anyone tell me why I get this error:
Unknown column 'ue.user_homepage' in 'field list'

I have read something about 'extended user fields' in somwhere in e107.
My knowledge on e107 is minimal.
I have the login credentials for the admin account on the e107 installation.


Here in all its glory:

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 `fredheimarena_3`.e107_user AS u
    LEFT JOIN `fredheimarena_3`.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_homepage' in 'field list'
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Angpeu on March 19, 2007, 10:43:57 AM
look my post 5 replays UP.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: tesk on March 19, 2007, 10:53:06 AM
Quote from: tesk on March 19, 2007, 09:08:42 AM
Hmmm....

Can anyone tell me why I get this error:
Unknown column 'ue.user_homepage' in 'field list'

I have read something about 'extended user fields' in somwhere in e107.
My knowledge on e107 is minimal.
I have the login credentials for the admin account on the e107 installation.


Here in all its glory:

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 `fredheimarena_3`.e107_user AS u
    LEFT JOIN `fredheimarena_3`.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_homepage' in 'field list'

I created the missing tables in e107. Sorry! I should have tried that before posting.

Now I get the following error:

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...
Fatal error: Cannot break/continue 1 level in /home/users/fredheimarena/wwwzoom-in/forum/convert/convert.php(642) : eval()'d code on line 13
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: sd45 on March 26, 2007, 02:28:14 PM
Wondering if there is an updated sql for this?
Trying to convert.....can't figure out where the extended user fields are.

Thanks!
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on March 26, 2007, 02:51:08 PM
The extended user fields are in the e107 settings.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: sd45 on March 27, 2007, 07:52:00 AM
I can not seem to find a that shows to enable them.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: herc on March 27, 2007, 10:24:28 AM
HELP!
i have e107 0.7.and enabled extended user propertis but not converting members (table not found) i see script ...but script linking user table not user_extended ..
i can edit script delete is inmemebers section as extended propertis (birthday,msn,etc..)but script frezze is topic converting......
sorry i weak writing english
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on March 28, 2007, 12:05:42 AM
Quote from: sd45 on March 27, 2007, 07:52:00 AM
I can not seem to find a that shows to enable them.
I'm not too familiar with e107.  I'll install it and see where it's located.

Quote from: herc on March 27, 2007, 10:24:28 AM
HELP!
i have e107 0.7.and enabled extended user propertis but not converting members (table not found) i see script ...but script linking user table not user_extended ..
i can edit script delete is inmemebers section as extended propertis (birthday,msn,etc..)but script frezze is topic converting......
sorry i weak writing english
What error are you getting exactly?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on March 28, 2007, 12:06:34 AM
Ok I have managed to fix the no subject issue and the smileys support.  Give this a try.  You must redownload the convert.php (http://www.simplemachines.org/community/index.php?topic=140741) file if you have the old one.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: _.Glasseater._ on March 31, 2007, 12:28:22 AM
I have the sql file that was attached above and I've downloaded the zipped file with the convert.php file.

However, when I run it, it gives me an error saying:

QuoteConverting 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 /usr/home/mgfx6090/public_html/glasseater/forums/convert.php(665) : eval()'d code on line 22

Any ideas?

Thanks in advance :D
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on March 31, 2007, 11:23:21 PM
You didn't upload the new convert.php.  Make sure that you over write it.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: _.Glasseater._ on April 01, 2007, 08:03:05 AM
I did overwrite it, I uploaded the wrong one, I never saw the attached convert.php on the page. All seems to be working now, thanks! :)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: shalibaji on June 09, 2007, 04:05:25 AM
Recalculating forum statistics... Unsuccessful!
This query:

    ALTER TABLE `e107`.smf_smileys
    ORDER BY LENGTH(code) DESC;

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 'LENGTH(code) DESC' at line 2

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: shalibaji on June 09, 2007, 10:37:12 AM
it's working now!

it only works on mysql 4.x ...
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: badm4n on June 12, 2007, 08:41:15 AM
Quote from: Angpeu on January 11, 2007, 03:16:00 PM
Quote from: jonjax on January 11, 2007, 03:12:04 PM
I have tried the above but still having problems and getting

Caused the error:

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

on e107 admin, turn on all extended user fields.

Not work for me
Quote
Converting...
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 `portal_portal`.e107_user AS u
    WHERE u.user_id > 0
    LIMIT 0, 500;

Caused the error:

    Unknown column 'u.user_birthday' in 'field list'
at e107 admin :
Quote
ame     Preview   Req'd     Applicable     Read access     Write access           Action
No assigned Category
aim
[AIM Address]       No    Members    Members    Members    
   
yahoo
[Yahoo! Address]       No    Members    Members    Members    
   
msn
[MSN]       No    Members    Members    Members    
   
location
[Location]       No    Members    Members    Members    
   
language
[Language]       No    Members    Members    Members    
   
icq
[ICQ Number]       No    Members    Members    Members    
   
homepage
[Homepage]       No    Members    Members    Members    
   
country
[Country]       No    Members    Members    Members    
   
birthday
[Birthday]       No    Members    Members    Members    
   

i have already enable all
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: SleePy on July 14, 2007, 11:19:17 PM
Is this issue solved or do you still require assistance?

It appears the user_birthday field doesn't exist.
A possible solution would be to edit it and change it from user_birthday to birthday. As the output you have given shows the field name is birthday.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mitooz on August 04, 2007, 03:27:05 AM
Hello I get this on the first step of the converter.
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of e107. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'warriors_smf'@'localhost' for table 'e107_user'

Any idea how to fix this?
Thanks in advance.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: SleePy on August 04, 2007, 01:30:46 PM
talk to your host about this.
The script is being denied permission to use the other database so permissions to use the other databse needs to be granted.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on August 08, 2007, 01:34:09 AM
badm4n what version of e107 are you running?

mitooz - Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: xanaphia on August 08, 2007, 02:35:04 PM
I am using this sql file;
http://www.simplemachines.org/community/index.php?topic=141395.msg1025912#msg1025912

And the converter from this page timestamped June 24, 2007, 07:23:55 AM;
http://www.simplemachines.org/community/index.php?topic=140741

I am running e107 Version 0.7.8 and SMF 1.1.3 both out of mySQL 5.0.27 and PHP 5.1.6, separated into different virtual hosts.

And I am getting the following errors.
Converting smileys...
Notice: Array to string conversion in /var/www/test.vegasfurs/htdocs/convert.php(671) : eval()'d code on line 46
Warning: in_array() [function.in-array]: Wrong datatype for second argument in /var/www/test.vegasfurs/htdocs/convert.php(671) : eval()'d code on line 46

There are stack traces that I can probably snapshot as needed. It says conversion complete but I am always concerned that this means something didn't go properly.

- - - -
I also noticed two things I though were really off, maybe bugs maybe features, but I thought I would point them out;

1) When users are migrated over their login name and display name is not pulled over in a way I thought logical. It makes their SMF login name their current e107 display name and  the SMF display name is set to match.

2) User Avatars are not migrated over.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on August 09, 2007, 01:22:39 AM
For the username issue if I remember correctly e107 just has one column for it.
In regards to the avatarsmiley.  I'll look into it.

EDIT:  Can you give me a sample of the data in the core table under the emote_ name.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: xanaphia on August 10, 2007, 03:53:59 PM
Quote from: JayBachatero on August 09, 2007, 01:22:39 AM
For the username issue if I remember correctly e107 just has one column for it.
In regards to the avatarsmiley.  I'll look into it.

EDIT:  Can you give me a sample of the data in the core table under the emote_ name.

Is this the info you want?
a:60:{i:0;a:1:{s:2:"&|";s:7:"cry.png";}i:1;a:1:{s:3:"&-|";s:7:"cry.png";}i:2;a:1:{s:3:"&o|";s:7:"cry.png";}i:3;a:1:{s:3:":((";s:7:"cry.png";}i:4;a:1:{s:3:"~:(";s:7:"mad.png";}i:5;a:1:{s:4:"~:o(";s:7:"mad.png";}i:6;a:1:{s:4:"~:-(";s:7:"mad.png";}i:7;a:1:{s:2:":)";s:9:"smile.png";}i:8;a:1:{s:3:":o)";s:9:"smile.png";}i:9;a:1:{s:3:":-)";s:9:"smile.png";}i:10;a:1:{s:2:":(";s:9:"frown.png";}i:11;a:1:{s:3:":o(";s:9:"frown.png";}i:12;a:1:{s:3:":-(";s:9:"frown.png";}i:13;a:1:{s:2:":D";s:8:"grin.png";}i:14;a:1:{s:3:":oD";s:8:"grin.png";}i:15;a:1:{s:3:":-D";s:8:"grin.png";}i:16;a:1:{s:2:":?";s:12:"confused.png";}i:17;a:1:{s:3:":o?";s:12:"confused.png";}i:18;a:1:{s:3:":-?";s:12:"confused.png";}i:19;a:1:{s:3:"%-6";s:11:"special.png";}i:20;a:1:{s:2:"x)";s:8:"dead.png";}i:21;a:1:{s:3:"xo)";s:8:"dead.png";}i:22;a:1:{s:3:"x-)";s:8:"dead.png";}i:23;a:1:{s:2:"x(";s:8:"dead.png";}i:24;a:1:{s:3:"xo(";s:8:"dead.png";}i:25;a:1:{s:3:"x-(";s:8:"dead.png";}i:26;a:1:{s:2:":@";s:7:"gah.png";}i:27;a:1:{s:3:":o@";s:7:"gah.png";}i:28;a:1:{s:3:":-@";s:7:"gah.png";}i:29;a:1:{s:2:":!";s:8:"idea.png";}i:30;a:1:{s:3:":o!";s:8:"idea.png";}i:31;a:1:{s:3:":-!";s:8:"idea.png";}i:32;a:1:{s:2:":|";s:11:"neutral.png";}i:33;a:1:{s:3:":o|";s:11:"neutral.png";}i:34;a:1:{s:3:":-|";s:11:"neutral.png";}i:35;a:1:{s:2:"?!";s:12:"question.png";}i:36;a:1:{s:2:"B)";s:12:"rolleyes.png";}i:37;a:1:{s:3:"Bo)";s:12:"rolleyes.png";}i:38;a:1:{s:3:"B-)";s:12:"rolleyes.png";}i:39;a:1:{s:2:"8)";s:10:"shades.png";}i:40;a:1:{s:3:"8o)";s:10:"shades.png";}i:41;a:1:{s:3:"8-)";s:10:"shades.png";}i:42;a:1:{s:2:":O";s:12:"suprised.png";}i:43;a:1:{s:3:":oO";s:12:"suprised.png";}i:44;a:1:{s:3:":-O";s:12:"suprised.png";}i:45;a:1:{s:2:":p";s:10:"tongue.png";}i:46;a:1:{s:3:":op";s:10:"tongue.png";}i:47;a:1:{s:3:":-p";s:10:"tongue.png";}i:48;a:1:{s:2:":P";s:10:"tongue.png";}i:49;a:1:{s:3:":oP";s:10:"tongue.png";}i:50;a:1:{s:3:":-P";s:10:"tongue.png";}i:51;a:1:{s:2:";)";s:8:"wink.png";}i:52;a:1:{s:3:";o)";s:8:"wink.png";}i:53;a:1:{s:3:";-)";s:8:"wink.png";}i:54;a:1:{s:4:"!ill";s:7:"ill.png";}i:55;a:1:{s:7:"!amazed";s:10:"amazed.png";}i:56;a:1:{s:4:"!cry";s:7:"cry.png";}i:57;a:1:{s:6:"!dodge";s:9:"dodge.png";}i:58;a:1:{s:6:"!alien";s:9:"alien.png";}i:59;a:1:{s:6:"!heart";s:9:"heart.png";}}
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: xanaphia on August 10, 2007, 04:37:08 PM
To be honest am all I loosing is the import of my smileys from e107?
If so I care so very little. I will note that pulling avatars is much more important to me but if that dosn't work with e107 then it just doesn't
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on August 11, 2007, 10:24:03 AM
I,'ll download e107 and take a look at the avatar conversion and see if I can make it work.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 21, 2007, 05:24:01 AM
sorry if I ask here I've been looking into SMF for a long time now... just wondering about the convertion system do I need to install SMF first and run the convert.php file from that directory? sorry for asking since there is really now exact procedure on how to do this..

by the way what version of SMF can I use with this conversion system? thanks
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 21, 2007, 10:35:20 AM
also just a follow when I run the convert.php file will it create a new database for use with SMF for will it rewrite my existing database the e107 is using?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on August 21, 2007, 11:45:34 AM
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 21, 2007, 02:55:14 PM
Thanks alot I owe you one

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 21, 2007, 03:18:25 PM
ok i've started converting from e107 0.7.8 so far as per my screen everything's been successful except for one mishap about extended user fields which I had to enable all fields as stated on previous posts..

Will post results here once it's done

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 21, 2007, 04:01:31 PM
gave me errors

Notice: Undefined index: convert_script in /home/pinode1/public_html/smf/convert.php on line 586

Notice: Undefined index: convert_script in /home/pinode1/public_html/smf/convert.php on line 594
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 939

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 949

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 957

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 967

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 980

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 993

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1039

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1041

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1047

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1053

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1064

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1065

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1073

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1075

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1081

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1082

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1088

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1089

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1113

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1115

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1121

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1133

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1158

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1160

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1197

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1198

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1235

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1240

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1301

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1303

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1339

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1358

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1845

Notice: Undefined variable: result in /home/pinode1/public_html/smf/convert.php on line 1846

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1381

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/pinode1/public_html/smf/convert.php on line 1382
Successful.

but it shows it was successful

Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the
Notice: Undefined index: name in /home/pinode1/public_html/smf/convert.php on line 1472
installation.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 21, 2007, 04:14:48 PM
ok some threads were not transferred when you look at the forum it says that there are threads and reply on that forum but when you enter it no threads show up
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 21, 2007, 04:34:10 PM
Quote from: Angpeu on January 14, 2007, 02:12:16 AM
script normaly done.
Sctatistic on Replies not updated.
Img bbc and NO subject not converted.

I think what he meant was the number of members it does not update SMF like for me when I tried it I got like 7k+ members and its not showing that I have 7k+

by the way I am starting from scratch SMF 1.1.3 and e107 0.7.8 using my database.. will post later if I get any errors
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on August 21, 2007, 05:21:22 PM
slackerpunk try http://www.simplemachines.org/community/index.php?topic=141395.msg1025912#msg1025912
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 21, 2007, 10:29:22 PM
yup I am using the last sql file that you posted.. I started from scratch and seems like everything was moved properly.

only problem I am seeing right now would be ascii characters
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on August 21, 2007, 11:26:38 PM
You have a non-english forum?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 21, 2007, 11:28:00 PM
nope it english just happens that some users use ascii characters for username like ñ ¢ and others
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on August 21, 2007, 11:30:21 PM
Oh ok.  I was going to suggest using the UTF-8 converter but no reason to convert your forum to UTF-8 if its an English forum.  A lot of the data is messed up or only a few members?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 22, 2007, 12:51:21 PM
@Jay

Only a few nothing to worry about. So I can confirm this convert works fine for e107 0.7.8

only found one error inside error.log file. Would it be possible if you can post what exactly do we need to see if the conversion was successful?

i.e.

Converting ranks.... Successful
Converting members.... Successful

because it took around 2 hours to convert my whole site around 1,000,000+ posts and 7000+ members so I did not have the luxury on staying infront of the computer waiting for errors or messages to come out.

So far everything works great except for:

1. like I posted earlier ascii characters not converted properly (does not matter only 4-5 members affected)
2. diplay names for e107 will become their login username after conversion
3. after converting I found out that some threads that has multiple pages did not come out it only shows 1 page but the post/reply count is correct. All I did was optimize the database and recomplete/recalculate forum posts/threads inside SMF admin and everything showed up fine with some salvaged posts around 15 of them.

will report more as and if they come by
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on August 22, 2007, 12:54:28 PM
If I remember correctly e107 does not have a username column.  I'll have to look more into it and see if there is a way to keep the display name and the username.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 22, 2007, 01:05:24 PM
@Jay

thanks appreciate it.... if you can also look at the third item I posted it would be great... but everything works and all pages come out now all I did was go to ADMIN > FORUM MAINTENANCE >

1. Optimize all tables to improve performance.
2. Find and repair any errors.
3. Recount all forum totals and statistics.

and all the pages showed up.

Btw I am really greatful for your converter script thanks alot
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on August 22, 2007, 01:09:28 PM
Ok there is a loginname column.  I updated the converter to reflect that.  About the recount stats.  What convert.php are you using?  Are you using the one from Updated Converters List & Support Topics (http://www.simplemachines.org/community/index.php?topic=140741.0)?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 22, 2007, 01:13:39 PM
yeps thats the only one I can find with the latest timestamp June 24, 2007 I compared it with the one from the downloads section and that one seems to be the latest one I used that and I used the sql from page 6 I think
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on August 22, 2007, 01:19:35 PM
Use the sql from the first page.  It seems like its not calculating the stats correctly.  I'll look more into it.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 22, 2007, 01:23:14 PM
ok maybe on my other site when I have the time I will finish this one that I just converted.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 23, 2007, 10:24:29 PM
@jay

what database version does the this convert to?

1.1.2 or 1.1.3? because seems like the database is 1.1.2 and the version I am using is 1.1.3

reason I ask is because I got this error message:

QuoteCan't create/write to file '/tmp/#sql_161f_0.MYD' (Errcode: 23)
File: /home/pinode1/public_html/smf/Sources/Profile.php
Line: 2576

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.3, while your database is at version 1.1.2. The above error might possibly go away if you execute the latest version of upgrade.php.

that showed up when I tried to disable this function Receive reply notification only for the first unread reply. on my profile.

it caused the server to die? not sure why my VPS kernelmemsize maxed out and I had to restart it for my website to work
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on August 23, 2007, 10:46:27 PM
Try repairing the table.  Also go to Admin > Forum Maintenance and check for errors.  If I remember correctly there are no database changes in 1.1.3.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: slackerpunk on August 23, 2007, 10:53:18 PM
hmm thats weird


QuoteCongratulations, no errors found! Thanks for checking.

after checking for errors
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: russia213 on September 03, 2007, 03:16:12 PM
QuoteConverting members... Unsuccessful!
This query:
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 `angryunlimited_all`.e107_user AS u
LEFT JOIN `angryunlimited_all`.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'

Ummmmmmmmmmmmm... help?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on September 04, 2007, 08:07:46 AM
Use the file in the first post.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mitooz on September 06, 2007, 03:21:19 AM
I have the same problem as russia213,Tried it with the SQL in the first post.
Any idea how to fix this?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mitooz on September 06, 2007, 04:46:31 AM
I fixed that now I get


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...
Fatal error: Call to undefined function: copy_smileys() in /home/warriors/public_html/convert.php(665) : eval()'d code on line 22
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on September 06, 2007, 08:20:57 AM
Download the latest convert.php file.  Updated Converters List & Support Topics (http://www.simplemachines.org/community/index.php?topic=140741.0)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: nelram on November 15, 2007, 12:47:35 PM
ALTER TABLE `quuqorg_test`.smf_smileys
ORDER BY LENGTH(code) DESC;
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 'LENGTH(code) DESC' at line 2

My servar work on Mysql v. 5.0

How can fix that problem
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on November 15, 2007, 02:10:10 PM
In convert.php

Find:
ORDER BY LENGTH(code) DESC;

Replace:
ORDER BY code DESC;
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: milija on February 20, 2008, 01:37:56 PM
I still have problem with

Converting ranks...Converting groups... Successful.
Converting members...Unknown column 'ue.user_birthday' in 'field list'

How to solve this?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on February 20, 2008, 01:52:55 PM
Need to enable the extended profile.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: tcbflyr on February 20, 2008, 07:03:03 PM
Quote from: JayBachatero on February 20, 2008, 01:52:55 PM
Need to enable the extended profile.

I'm getting the same error
Converting ranks...Converting groups... Successful.
Converting members...Unknown column 'ue.user_birthday' in 'field list'

Can you explain your solution, for the computer illiterate (stupid)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on February 20, 2008, 11:52:27 PM
My solution was that.  Enable the extended profile.  What version of e107 are you running?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: tcbflyr on February 21, 2008, 04:23:23 AM
e107
Version 0.7.10
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: victorjohn on February 25, 2008, 03:34:04 PM
Hello all,

I too am getting the infamous u.user_birthday error.  I tried several attempts, each with a fresh SMF install on my test server, turning the extended user profiles on in e107, and even messing with editing the conversion .sql file (which I really have no business messing with due to lack of skill).

I am running SMF 1.1.4 and e107 0.7.8?  I am wiling to work to sort it out, but am having little luck knowing where to begin?

Anyone?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: victorjohn on February 25, 2008, 09:24:45 PM
Also can someone help me to understand the bit of syntax involving the "u.whatever" contained in those statements??  What does the "u." stand for?  Is it short for the user extended field name?

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on February 26, 2008, 04:00:45 AM
http://wiki.e107.org/?title=Using_e107:Users:Extended_Fields
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: victorjohn on February 26, 2008, 11:53:56 AM
I've read that document before, or I wouldn't trouble you.  I still don't quite understand the syntax "u." in your converter file, but maybe I am totally missing something.  Either way it doesn't matter.  I am still quite stuck on the errors I am getting involving the extended user fields, and as such might not be able to go with SMF, which I would very much like to do, any suggestions?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on February 26, 2008, 01:21:57 PM
The u. part is an alias for the table name.  Example.

SELECT full_table_name.column1, full_table_name.column2
FROM full_table_name


You write

SELECT ftb.column1, ftp.column2
FROM full_table_name AS ftb


For everyone else here enabling the extended profile worked for them.  There might be something that you are doing wrong and it's not being enabled.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: victorjohn on February 26, 2008, 01:47:19 PM
Thanks!
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: victorjohn on February 26, 2008, 02:27:04 PM
btw eres dominicano? soy boriqua.  que te vaya bien!
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: victorjohn on February 26, 2008, 02:27:57 PM
Quote from: JayBachatero on February 26, 2008, 01:21:57 PM
For everyone else here enabling the extended profile worked for them.  There might be something that you are doing wrong and it's not being enabled.

You are most likely right about that part!  :)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: JayBachatero on February 26, 2008, 10:24:53 PM
Quote from: victorjohn on February 26, 2008, 02:27:04 PM
btw eres dominicano? soy boriqua.  que te vaya bien!
Si soy Dominicano ;).

Quote from: victorjohn on February 26, 2008, 02:27:57 PM
Quote from: JayBachatero on February 26, 2008, 01:21:57 PM
For everyone else here enabling the extended profile worked for them.  There might be something that you are doing wrong and it's not being enabled.

You are most likely right about that part!  :)
If you don't get it to week.  I'm going to setup e107 locally and see id I can enable them.  It's been a while since I mess with e107 so need to see how to do it.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: 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
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: DanielKvist on May 07, 2008, 12:57:17 PM
I have problem with characters. My forum is in swedish and your converter doesnt convert åäö propperly. Is there another one for international forums?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: SleePy on May 07, 2008, 01:44:08 PM
When you installed SMF, did you set it to use UTF-8?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: DanielKvist on May 08, 2008, 08:37:21 AM
Quote from: SleePy on May 07, 2008, 01:44:08 PM
When you installed SMF, did you set it to use UTF-8?


Dont remember. I try to reinstall it. But i think it said error when i wanted UTF-8... brb
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: DanielKvist on May 08, 2008, 09:15:43 AM
The current version of your database doesn't support the use of the UTF-8 character set. You can still install SMF without any problems, but only with UTF-8 support unchecked. If you would like to switch over to UTF-8 in the future (e.g. after the MySQL server of your forum has been upgraded to a version >= 4.1), you can convert your forum to UTF-8 through the admin panel.

-------------------------------------

The current version is 4.0.21 and i cant upgrade it. It's not a localhost. But in the old forum all swedish characters work fine...
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: SleePy on May 08, 2008, 11:57:56 AM
Most likely because they where using another charset or doing html entities to make it work.
Do you know what charset your other forum was? or if it was stored as html entities?

I would really suggest asking to get your mysql upgraded though. The MySQL Team recently dropped support for mysql 4 (the php team did the same as well recently for php4).
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: DanielKvist on May 08, 2008, 12:43:42 PM
e107
Version v0.7.2

Install date
Friday 24 February 2006 - 14:37:50

Server
Apache/1.3.41 (Unix)

PHP Version
4.4.8

MySQL
4.0.21

Charset
utf-8

The weird thing is that it's utf-8 on the old one!?
Anyways php, mysql and apache are really old so I should try to make an upgrade. Just got the control of this forum, the old admin missbehaved so we had to take him away. And now im in charge and this is what I get :P
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: maple on June 05, 2008, 10:30:00 PM
having a little problem:

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 `afilms_e107`.e107_user AS u
WHERE u.user_id > 0
LIMIT 0, 500;
Caused the error:

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

birthday
[birthday]   No Members Members Members         
aim
[AIM Address]  No Members Members Members         
country
[Country]    No Members Members Members         
homepage
[Homepage]  No Members Members Members         
icq
[ICQ Number]  No Members Members Members         
language
[Language]    English  No Members Members Members         
location
[Location]  No Members Members Members         
msn
[MSN]  No Members Members Members         
yahoo
[Yahoo! Address]

followed what everyone said, and no change
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on June 06, 2008, 05:05:41 AM
Take a look at
http://www.simplemachines.org/community/index.php?topic=141395.msg1434335#msg1434335
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: maple on June 06, 2008, 08:05:12 PM
ok so i fixed everything, got the post and users over, now i get this when i try and make a new category:

Duplicate entry '255' for key 1
File: /home/cooldude/public_html/forum/Sources/Subs-Boards.php
Line: 1342

any ideas?

Tryed all the maint things already
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: SleePy on June 06, 2008, 09:53:22 PM
Quote from: SleePy on March 31, 2008, 11:37:32 PM
That error is saying that the max category ID that SMF allows by default has been reached. For some reason fireboard wants a category ID that is higher than 255..

You can fix it by doing this to your SMF database in phpMyAdmin (What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)). You may need to change smf_ to your database prefix if it is different.
ALTER TABLE smf_categories CHANGE id_cat id_cat smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT   

Edit,
Oops, a Jay pointed out that tinyint only has a max of 255.. So we have to use smallint.

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Terebro on June 27, 2008, 08:04:58 AM
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
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on June 27, 2008, 09:33:58 AM
Latest Version is attached in this topic (first post)
http://www.simplemachines.org/community/index.php?topic=141395.0
u.user_birthday problem:
http://www.simplemachines.org/community/index.php?topic=141395.msg1434335#msg1434335
http://wiki.e107.org/?title=Using_e107:Users:Extended_Fields
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Terebro on June 27, 2008, 10:06:07 PM
OK Thanks

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

Where can I download v0.7.7
I cant find it anywhere
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on June 28, 2008, 01:38:33 AM
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.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Terebro on June 30, 2008, 06:27:41 AM
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
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: 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)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: SleePy on June 30, 2008, 05:53:03 PM
Hmm, I wonder if I can put checks to have it skip the polls section if it doesn't exist :|
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Terebro on June 30, 2008, 09:18:29 PM
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 :)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Terebro on July 01, 2008, 06:34:10 AM
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?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on July 01, 2008, 07:48:22 AM
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
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Terebro on July 01, 2008, 08:53:32 AM
I still get same error :/
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on July 01, 2008, 09:33:11 AM
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.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Terebro on July 01, 2008, 09:42:55 AM
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!
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on July 01, 2008, 10:42:56 AM
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)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Terebro on July 01, 2008, 11:12:12 AM
Excellent :)

Thanks again!
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Kronyx on August 20, 2008, 12:41:25 PM
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'
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on August 20, 2008, 02:56:58 PM
http://www.simplemachines.org/community/index.php?topic=141395.msg1597366#msg1597366 should help you.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: WarBirD on December 04, 2008, 05:32:36 AM
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 ?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mcdemon on December 04, 2008, 07:07:12 PM
+1
i have this problem in 0.7.14 to :(
(sorry my bad englesh)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on December 05, 2008, 01:24:31 AM
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..
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mcdemon on December 05, 2008, 10:53:11 AM
Unknown column 'ue.user_homepage' in 'field list'
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on December 05, 2008, 12:41:00 PM
you need to  enable extended fields in e107.
also go to e107 - admin area - Plugins - Plugin-Manager and install the plugins polls and private messenger (if not installed until yet)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mcdemon on December 05, 2008, 08:46:33 PM
i ebable all extended fields
error: Incorrect date value: '' for column 'birthdate' at row 1
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on December 06, 2008, 02:11:01 AM
mcdemon,
try this please:
http://www.simplemachines.org/community/index.php?topic=141395.msg1827556#msg1827556
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mcdemon on December 06, 2008, 06:00:52 AM
i dont idiot
"ue.user_birthday AS birthdate," replased "''AS birthdate," & activated all extended fields
result:  Incorrect date value: '' for column 'birthdate' at row 1
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on December 06, 2008, 07:42:22 AM
please try the attached version..

which version of e017 are you wanting to convert?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mcdemon on December 06, 2008, 10:40:08 AM
0.7.14
new e107_to_smf.sql
result: Incorrect date value: '' for column 'birthdate' at row 1
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on December 06, 2008, 02:23:24 PM
mhh, sounds like a MySQL issue with the locale settings..
try this version please..
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mcdemon on December 07, 2008, 02:52:37 AM
Converting posts (this may take some time)... Successful.
Converting posts (step 2)... Unsuccessful!
This query:
UPDATE `smf`.smf_messages
SET subject = '[голосование] УсÑ,раиваеÑ, ли Ð'ас цвеÑ,овое решение в дизайне данного Ñ,,орума?'
WHERE ID_TOPIC = '833';
Caused the error:
Incorrect string value: '\xE2\x82\xAC\xC3\x91\xC6...' for column 'subject' at row 1
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on December 07, 2008, 07:03:58 AM
is your SMF installed in UTF-8? both forums must use the same table collation in MySQL during the conversion.. please check the collation from the e107 installation. 

if it is set to a local character set you must install SMF with this character set (during install leave the UTF-8 checkbox unchecked).. if e107 is UTF-8 your SMF should also be installed with UTF-8 collation (checkbox during install enabled).
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mcdemon on December 07, 2008, 11:11:33 AM
e107 - utf8
smf - utf8
in convert.php set utf8

result
Converting posts (this may take some time)... Successful.
Converting posts (step 2)... Unsuccessful!
This query:
UPDATE `smf`.smf_messages
SET subject = '[голосование] УсÑ,раиваеÑ, ли Ð'ас цвеÑ,овое решение в дизайне данного Ñ,,орума?'
WHERE ID_TOPIC = '833';
Caused the error:
Incorrect string value: '\xE2\x82\xAC\xC3\x91\xC6...' for column 'subject' at row 1
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on December 08, 2008, 02:25:38 AM
mhh, not sure but maybe this helps:

e107 - utf8
smf - utf8
in convert.php NOT utf8

what character set /language is it?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mcdemon on December 08, 2008, 06:58:00 AM
Russian
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on December 08, 2008, 09:42:28 AM
any difference when UTF-8 in convert.php is not selected?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mcdemon on December 08, 2008, 03:33:33 PM
   I try to understand myself ... There appears to be a problem with the coding ... Because the site are displayed perfectly, at phpmyadmin and the same is not understandable characters.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: H.A on December 08, 2008, 07:42:27 PM
which system suport is this ?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on December 09, 2008, 01:20:08 AM
there might be a special character like ' in your subjects (topic ID 833) or the subject is longer than 254 characters..
my main issue: I cannot read your charset so it's very diffucult to find the error..

Try the attached version please (254 characters problem schould be fixed)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Newbster on December 29, 2008, 01:47:32 PM
I have the following problem:

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...
Fatal error: Cannot break/continue 1 level in /www/****.com******/htdocs/smf/convert.php(929) : eval()'d code on line 13

Most strange thing is that on the top there comes up the following:

QuoteWarning: set_time_limit() has been disabled for security reasons in /www/****.com******/htdocs/smf/convert.php on line 29

Actually I can't seem to find anything on the forum that hasn't been converted expect the avatars but I'm sure they can set it up themselves again.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on December 31, 2008, 09:37:20 AM
newbster, sorry for the late responce.
please try this version from e107_to_smf.sql
http://www.simplemachines.org/community/index.php?action=dlattach;topic=141395.0;attach=79044
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Newbster on January 01, 2009, 02:22:00 PM
No worries even moderators need breaks. :)

If converting all again does it affect the forum that is set-up at the moment? As I've already published the forum and people posted there last time the posts have been lost when I set it up for a test. Due to e107 being bit silly I already had manually hidden all emails of members lol.

But other than that I have to say that smf is great!

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on January 02, 2009, 02:17:51 AM
when re-starting the converter all data from SMF (not e107 data) will be lost! our converters empty all tables before inserting the source forums data.

hide all members email adresses is easy with phpMyAdmin:

UPDATE smf_members SET hideEmail = '1';


What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Newbster on January 02, 2009, 04:42:16 AM
Thanks for that. I'll try it on another testforum to see what is actually missing with the old error if nothing is missing then still thanks but won't do the convert again.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Newbster on January 02, 2009, 08:35:43 AM
Tried the sql file but still the same error coming up.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: SleePy on January 06, 2009, 07:14:00 PM
Do you have any banned users in e107?

What version of e107 are you using btw?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: kaloer on February 13, 2009, 08:38:18 AM
Hi!

I have a problem with the charset (utf8_danish_ci).
Both e107 and SMF have the utf8_danish_ci charset, but still, the danish characters(æøå) is displayed as Ã¥.
In the convert.php have I chosen the UTF8 charset.
How do I solve my problem?
Thanks in advance!
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on February 13, 2009, 11:19:28 AM
Quote from: kaloer on February 13, 2009, 08:38:18 AM
In the convert.php have I chosen the UTF8 charset.
How do I solve my problem?
Do not select the UTF-8 checkbox in convert.php, both forums (source and destination) allready use the same charset, so you don't need to convert the characters again.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: kaloer on February 13, 2009, 11:38:25 AM
I can select the charset from a dropdown menu (not a checkbox). Am I using an old convert.php, or which charset should I select?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on February 13, 2009, 12:23:45 PM
uups, you're right. the newer convert.php has a dropdown, not a select box .. try it with ISO-8859-1 (danish characters are latin based).
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: kaloer on February 13, 2009, 01:18:39 PM
Hmm. It doesn't work.
I got this error:


    Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_danish_ci,IMPLICIT) for operation '='

All the e107 and SMF tables are utf8_danish_ci. I also have some utf8_general_ci, but they are not a part of the e107 or SMF system.
Every time I use the converter, I got a lot of these warnings:

Warning: apache_reset_timeout() [function.apache-reset-timeout]: Cannot reset the Apache timeout in safe mode in {my directory}  on line 1963
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on February 15, 2009, 02:10:39 PM
are you sure about the collation? maybe some table fields in e107 or SMF have utf8_general_ci and others have utf8_danish_ci?

You can export your database, then edit the .sql file with a text editor and replace all "utf8_general_ci" with "utf8_danish_ci", then import the modified script and try the conversion.

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: kaloer on February 15, 2009, 02:55:57 PM
I am sure all my e107 and SMF tables have the utf8_danish_ci collation. Because I am going to use SMF with Joomla, I also have my Joomla tables in the database. These tables have the utf8_general_ci collation.
What do you mean by exporting the database, and then replace all utf8_general_ci with utf8_danish_ci?
Do you think it would help if I converts the Joomla tables to utf8_danish_ci? And if so, will it reflect my Joomla installation/setup?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on February 15, 2009, 03:03:01 PM
not the tables but some table columns / fields are possible utf_8_genral_ci?
you got this error during conversion:
QuoteIllegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_danish_ci,IMPLICIT) for operation '='
do you know the step in convert.php? was it during the board_permissions conversion?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: kaloer on February 15, 2009, 03:38:28 PM
I have tried to export the database, but there are not any search-result of utf8_general_ci.
The error occurres in the "Converting boards..." step with the following query:


SELECT
DISTINCT f.forum_id AS ID_BOARD, SUBSTRING(f.forum_name, 1, 255) AS name,
SUBSTRING(f.forum_description, 1, 65534) AS description,
CASE
WHEN f.forum_parent > 500
THEN f.forum_parent - 499
ELSE f.forum_parent
END AS ID_CAT, f.forum_sub AS ID_PARENT,
CASE WHEN f.forum_sub = 0 THEN 0 ELSE 1 END AS childLevel, f.forum_threads AS numTopics,
f.forum_threads + f.forum_replies AS numPosts, f.forum_order AS boardOrder,
CASE f.forum_class
WHEN 252 THEN '-1'
WHEN 255 THEN ''
WHEN 253 THEN '0'
WHEN 251 THEN '0'
WHEN 254 THEN ''
WHEN 0 THEN '-1,0'
ELSE IFNULL(mg.ID_GROUP, '')
END AS memberGroups
FROM (`db1_db`.e107_forum AS f, `db1_db`.e107_forum AS c)
LEFT JOIN `db1_db`.e107_userclass_classes AS uc ON (uc.userclass_id = f.forum_class)
LEFT JOIN `db1_db`.smf_membergroups AS mg ON (mg.groupName = CONCAT('e107 ', uc.userclass_name))
WHERE f.forum_parent != 0
LIMIT 0, 500;
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on February 16, 2009, 01:42:45 AM
ok, you can try this: edit the e107_to_smf.sql and replace


/******************************************************************************/
--- Converting boards...
/******************************************************************************/

TRUNCATE {$to_prefix}boards;

DELETE FROM {$to_prefix}board_permissions
WHERE ID_BOARD != 0;

---* {$to_prefix}boards
SELECT
DISTINCT f.forum_id AS ID_BOARD, SUBSTRING(f.forum_name, 1, 255) AS name,
SUBSTRING(f.forum_description, 1, 65534) AS description,
CASE
WHEN f.forum_parent > 500
THEN f.forum_parent - 499
ELSE f.forum_parent
END AS ID_CAT, f.forum_sub AS ID_PARENT,
CASE WHEN f.forum_sub = 0 THEN 0 ELSE 1 END AS childLevel, f.forum_threads AS numTopics,
f.forum_threads + f.forum_replies AS numPosts, f.forum_order AS boardOrder,
CASE f.forum_class
WHEN 252 THEN '-1'
WHEN 255 THEN ''
WHEN 253 THEN '0'
WHEN 251 THEN '0'
WHEN 254 THEN ''
WHEN 0 THEN '-1,0'
ELSE IFNULL(mg.ID_GROUP, '')
END AS memberGroups
FROM ({$from_prefix}forum AS f, {$from_prefix}forum AS c)
LEFT JOIN {$from_prefix}userclass_classes AS uc ON (uc.userclass_id = f.forum_class)
LEFT JOIN {$to_prefix}membergroups AS mg ON (BINARY mg.groupName = CONCAT('e107 ', uc.userclass_name))
WHERE f.forum_parent != 0;
---*


with:

/******************************************************************************/
--- Converting boards...
/******************************************************************************/

TRUNCATE {$to_prefix}boards;

DELETE FROM {$to_prefix}board_permissions
WHERE ID_BOARD != 0;

---* {$to_prefix}boards
SELECT
DISTINCT f.forum_id AS ID_BOARD, SUBSTRING(f.forum_name, 1, 255) AS name,
SUBSTRING(f.forum_description, 1, 65534) AS description,
CASE
WHEN f.forum_parent > 500
THEN f.forum_parent - 499
ELSE f.forum_parent
END AS ID_CAT, f.forum_sub AS ID_PARENT,
CASE WHEN f.forum_sub = 0 THEN 0 ELSE 1 END AS childLevel, f.forum_threads AS numTopics,
f.forum_threads + f.forum_replies AS numPosts, f.forum_order AS boardOrder,
'-1' AS memberGroups
FROM ({$from_prefix}forum AS f, {$from_prefix}forum AS c)
LEFT JOIN {$from_prefix}userclass_classes AS uc ON (uc.userclass_id = f.forum_class)
WHERE f.forum_parent != 0;
---*

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: kaloer on February 16, 2009, 03:32:21 AM
Thank you. Now, I don't get the error any more.
But I get a new error message in the "Converting banned users..." step:


Fatal error: Cannot break/continue 1 level in /var/www/fifazone.dk/public_html/SMF/convert.php(929) : eval()'d code on line 13


The forum-topics/posts are converted, but still, the danish characters aren't shown right.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on February 16, 2009, 03:36:44 AM
ok, we are near the solution.. can you completely remove this block from e107_to_smf.sql?
It's not a big problem, only the ban-list is not converted then.


/******************************************************************************/
--- Converting banned users...
/******************************************************************************/

TRUNCATE {$to_prefix}ban_items;
TRUNCATE {$to_prefix}ban_groups;


---# Moving banned entries...
---{
$_REQUEST['start'] = isset($_REQUEST['start']) ? (int) $_REQUEST['start'] : 0;
while (true)
{
pastTime($substep);

$result = mysql_query("
SELECT banlist_ip, banlist_reason
FROM {$from_prefix}banlist
LIMIT $_REQUEST[start], 250");
$ban_time = time();
$ban_num = 0;
while ($row = mysql_fetch_assoc($result))
{
$ban_num++;
mysql_query("
INSERT INTO {$to_prefix}ban_groups
(name, ban_time, expire_time, notes, reason, cannot_access)
VALUES ('migrated_ban_$ban_num', $ban_time, NULL, '', '" . addslashes($row['banlist_reason']) . "', 1)");
$ID_BAN_GROUP = mysql_insert_id();

if (empty($ID_BAN_GROUP))
continue;

if (strpos($row['banlist_ip'], '@') !== false)
{
mysql_query("
INSERT INTO {$to_prefix}ban_items
(ID_BAN_GROUP, email_address, hostname)
VALUES ($ID_BAN_GROUP, '" . addslashes($row['banlist_ip']) . "', '')");
continue;
}
else
{
list ($octet1, $octet2, $octet3, $octet4) = explode('.', $row['banlist_ip']);

$ip_high1 = $octet1;
$ip_low1 = $octet1;

$ip_high2 = $octet2;
$ip_low2 = $octet2;

$ip_high3 = $octet3;
$ip_low3 = $octet3;

$ip_high4 = $octet4;
$ip_low4 = $octet4;

mysql_query("
INSERT INTO {$to_prefix}ban_items
(ID_BAN_GROUP, ip_low1, ip_high1, ip_low2, ip_high2, ip_low3, ip_high3, ip_low4, ip_high4, email_address, hostname)
VALUES ($ID_BAN_GROUP, $ip_low1, $ip_high1, $ip_low2, $ip_high2, $ip_low3, $ip_high3, $ip_low4, $ip_high4, '', '')");
continue;
}
}

$_REQUEST['start'] += 250;
if (mysql_num_rows($result) < 250)
break;

mysql_free_result($result);
}
$_REQUEST['start'] = 0;
---}
---#

---# Moving banned user...
---{
$request = mysql_query("
SELECT user_id
FROM {$from_prefix}user
WHERE user_ban = 1");
if (mysql_num_rows($request) > 0)
{
mysql_query("
INSERT INTO {to_prefix}ban_groups
(name, ban_time, expire_time, reason, notes, cannot_access)
VALUES ('migrated_ban_users', $ban_time, NULL, '', 'Imported from e107', 1)");
$ID_BAN_GROUP = mysql_insert_id();

if (empty($ID_BAN_GROUP))
continue;

$inserts = '';
while ($row = mysql_fetch_assoc($request))
$inserts .= "
($ID_BAN_GROUP, $row[user_id], '', ''),";
mysql_free_result($request);

mysql_query("
INSERT INTO {$to_prefix}ban_items
(ID_BAN_GROUP, ID_MEMBER, email_address, hostname)
VALUES " . substr($inserts, 0, -1));
}
---}
---#

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: kaloer on February 16, 2009, 03:51:44 AM
It isn't a problem to "ignore" the banned users, and now, the converter completes succesfull. The users and all threads are convertet, but still, the characters aren't showed correctly.
I have tried both the UTF8 and ISO-8859-1.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: kaloer on February 18, 2009, 03:13:07 AM
As I said earlier, I am going to use the forum with Joomla! and JFusion.
Now, when I show the forum through JFusion (frameless), the danish characters are shown correctly.
Stange it doesn't work if I go directly to the SMF forum, but whatever - I don't need to :)

Thank you very much for your great help!
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: kaloer on February 18, 2009, 10:09:51 AM
Hmm.. It doesn't work any more. It turns to be very strange :S
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: kaloer on February 20, 2009, 04:57:55 AM
I got it working!
I made a php-script which used the utf8_decode function in php:


mysql_connect("HOST_ADDR", "DB_USERNAME", "DB_PASSWORD");
mysql_select_db("DB_NAME");

$query = mysql_query("SELECT ID_BOARD, name, description FROM smf_boards") or die(mysql_error());

while($row = mysql_fetch_array($query))
{
$name = utf8_decode($row['name']);
$description = utf8_decode($row['description']);
$id = $row['ID_BOARD'];
mysql_query("UPDATE smf_boards SET name='$name', description='$description' WHERE ID_BOARD='$id'") or die(mysql_error());
}

$query = mysql_query("SELECT ID_CAT, name FROM smf_categories") or die(mysql_error());

while($row = mysql_fetch_array($query))
{
$name = utf8_decode($row['name']);
$id = $row['ID_CAT'];
mysql_query("UPDATE smf_categories SET name='$name' WHERE ID_CAT='$id'") or die(mysql_error());
}

$query = mysql_query("SELECT ID_MEMBER, memberName, realName, signature, avatar, usertitle FROM smf_members") or die(mysql_error());

while($row = mysql_fetch_array($query))
{
$name = utf8_decode($row['memberName']);
$realName = utf8_decode($row['realName']);
$signature = utf8_decode($row['signature']);
$avatar = utf8_decode($row['avatar']);
$usertitle = utf8_decode($row['usertitle']);
$id = $row['ID_MEMBER'];
mysql_query("UPDATE smf_members SET memberName='$name', realName='$realName', signature='$signature', avatar='$avatar', usertitle='$usertitle' WHERE ID_MEMBER='$id'") or die(mysql_error());
}

$query = mysql_query("SELECT ID_PM, body FROM smf_personal_messages") or die(mysql_error());

while($row = mysql_fetch_array($query))
{
$name = utf8_decode($row['body']);
$id = $row['ID_OM'];
mysql_query("UPDATE smf_personal_messages SET body='$name' WHERE ID_PM='$id'") or die(mysql_error());
}
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on February 20, 2009, 05:31:37 AM
Great work, and thank you for sharing your solution to the public :)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: kaloer on February 20, 2009, 05:43:27 AM
Thank you for your help :)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: WarBirD on April 28, 2009, 06:36:46 AM
Anyone knows how to get passed this ?

Quote
Converting members... Unsuccessful!
This query:

    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'

I know, activate Extended Userfields. It is active. But it still gives me that error. Before it was the same error with "ICQ" instead of the "Birthday", then I deleted the ICQ Field and now its the Birthday field. I read many topics that just say "Enable extended User Fields" which is on, but it just won´t work.

Any ideas ?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: WarBirD on April 28, 2009, 07:10:24 AM
UPADTE:

I do have the User Extended Fields in the Database, just not that Birthday thing. Other extended Fields are in the tables. I tried adding a Extended userfield called "user_birthday" but I did not know exactly what to fill in, and what i tried usually led to a message like:

Quote
Update unsuccessful as no changes were made.
Please try again.

Any help on this please ?  :(
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on April 28, 2009, 10:01:38 AM
try removing this line from e107_to_smf.sql

ue.user_birthday AS birthdate,
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: WarBirD on April 28, 2009, 10:24:30 AM
Ok, thanks. :) That worked. So far it looks good. But i realize that the IP´s that usually are shown only to Admins & Moderators now are all set to "0.0.0.0" even if I am posting things in the new Forum already. Its not picking up my IP in there.

That the others are not visible from before is because that Data isn´t converted from the old Site, but shouldn´t that at least start now after the conversion ?

Thanks
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: SleePy on April 29, 2009, 05:39:16 PM
Sounds like you are getting an invalid ip address.

Are these for new posts? The converter may not be picking up existing posts ips, but new posts you make on your SMF forum should work.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: WarBirD on May 08, 2009, 02:49:59 PM
Well, now I´ve realized that the Conversion had a major flaw.

None of the Useraccounts has its Email still. How the hell can that be ? How can the Emails be just not in there ?

OMG, now I see it. There were some lines like the ICQ in the sql File i had to remove, otherwise it wouldn´t work. And now I see, i must have deleted the line that says to import the Email Accounts as well. :(

How can I use the converter to only convert the users again, not all the other stuff that is converted ??? Any idea how I can make that possible ? I don´t want to redo all of it, since the rest works. I just need to convert the Email Adresses really. Please, anyone knows how to make that that specific ?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: SleePy on May 11, 2009, 08:12:08 PM
You would just need to remove the other parts of the conversion in the .sql.

I attached a file that has only the members conversion.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: SBurke930 on May 19, 2009, 11:04:08 AM
Quote from: mitooz on August 04, 2007, 03:27:05 AM
Hello I get this on the first step of the converter.
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of e107. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user xxxxxxxxxx @'localhost' for table 'e107_user'

Any idea how to fix this?
Thanks in advance.

I get this same error and after talking to the host (netfirms) they wanted me to make a backup of the database and upload it into the test forum. 


UPDATE!

I got the convertor to work however I have a list of errors
Notice: Undefined index: convert_script in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 810

Warning: Invalid argument supplied for foreach() in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 813

Notice: Undefined index: convert_script in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 825

Notice: Undefined index: convert_script in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 721
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1211

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1221

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1229

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1252

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1265

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1311

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1313

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1319

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1325

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1336

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1337

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1345

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1347

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1353

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1354

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1360

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1361

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1385

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1387

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1393

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1405

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1430

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1432

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1476

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1491

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1520

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1522

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1535

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1557

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1562

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1623

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1625

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1661

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1680

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1703

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 1704

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2411

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2411

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2239

Notice: Undefined variable: result in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 2240
Successful.


When I checked the testforum nothing has happened.  Can someone help me get this corrected?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on May 19, 2009, 02:35:10 PM
the new error is a broken session... have you tried to restart the conversion from the beginning?

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: SBurke930 on May 19, 2009, 07:07:37 PM
How can it be a broken session when the first warning says there is an Invalid argument supplied for foreach() in /mnt/w0903/d45/s17/b02eea8f/www/myforum.xxx/testforum/convert.php on line 813

This is line 813 so what is wrong with it?

foreach ($convert_data['globals'] as $global)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on May 20, 2009, 05:44:48 AM
There is nothing wrong with convert.php (I used convert.php more than 500x myself), the error indicates that $convert_data['globals'] isn't set.  I believe the cause of this problem is that your host has session.save_path to a non writeable directory. Ask your host to change this setting in php.ini and use the correct path.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: defac on June 14, 2009, 05:14:58 PM
Hello there :)
I was successfully converted e107 (0.7.15) to SMF (1.1.9) I was read this theme and i do. After all, i wrapped smf forum into joomla 1.5. And thats also okay. Well, only problem is not too big, but if you can help me that will be fine. All my members, topics and themes (30.737 topics and 6.256 themes) are here, but all my members have a zero (0) messages in statistic under avatar and nickname.

And, also i have question about default smf theme customisation: how to remove or edit help button from top menu.

PS#Sorry for my poor english.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on June 15, 2009, 03:02:24 AM
Buttons:
How do you add custom tabs to the Core (default) theme menu? (http://docs.simplemachines.org/index.php?topic=564)
Post counter:
http://custom.simplemachines.org/mods/index.php?mod=561
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: dimmdesign on July 26, 2009, 01:18:23 PM
I'm getting this error could you please help me! thanks in advance.

Fatal error: Call to undefined function loadDatabase() in /var/www/vhosts/macephemera.gr/httpdocs/smf/smf-import/convert.php on line 410.

i've searched inside the convert.php file and although there was a reference to a loadDatabase() there was no function with the the same name. really weird to me...
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on July 26, 2009, 01:25:44 PM
I belive you used the wrong files (SMF 2.0 converters instead of SMF 1.1.x converters)
this one should be right: http://download.simplemachines.org/index.php?thanks;filename=smf_1-1-10_e107_converter.zip
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: dimmdesign on July 26, 2009, 01:39:04 PM
thanks that got me to the next page which for my own bad luck I again got another error :

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of e107 ver.0.7.7. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'my_smf_username'@'localhost' for table 'e107_user'

should i have installed smf into the same database as the e107 and not on a new one as I did???
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ThorstenE on July 26, 2009, 02:02:03 PM
convert.php needs read access to your e107 database..

Quote from: dimmdesign on July 26, 2009, 01:39:04 PM
should i have installed smf into the same database as the e107 and not on a new one as I did???
that's the easiest solution ;)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ABCDiamond on March 15, 2011, 07:49:03 PM
Is this still the right topic for the converter from E107 to SMF ?

And are there different methods for each SMF version. ?

Thanks
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Unilein on May 22, 2011, 05:10:35 AM
Hello,

ich want to convert my e107-installation (version 0.7.25) to smf (version 1.1.13). For the conversion i use the convert.php-script with the e107_to_smf.sql-script.
It doesn't work! I allways get the following error: Illegal mix of collations (latin1_german1_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='.
I don't know why, because my mysql-server is UTF8 and the Databases are all UTF8.

Do you have any ideas for me?

Greetz
Uni
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Unilein on May 24, 2011, 06:54:49 AM
Ok, i solved the problem. :-)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: general_z on May 27, 2011, 07:37:14 PM
Anyone got an idea on how to import everything when e107 isn't already on the host but just a fresh SMF-install? Why doesn't the converter just allow one to upload the SQL from e107?

The reason i'm asking is because change of host and e107 isn't installed on that new host of course.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Norv on June 16, 2011, 12:21:40 PM
Sorry for the delay, general_z. You can still convert if you simply make a database on the new host, and import the .sql file in it. Then all the converter needs is to know where to find it.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ice5192 on June 20, 2011, 02:52:55 AM
I am lost ?


i am getting this error.

Converting...

Notice: Undefined index: convert_script in /home/tgclan/public_html/tgclan.com/hq/convert.php on line 972

Warning: Invalid argument supplied for foreach() in /home/tgclan/public_html/tgclan.com/hq/convert.php on line 975

Notice: Undefined index: convert_script in /home/tgclan/public_html/tgclan.com/hq/convert.php on line 987
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home/tgclan/public_html/tgclan.com/hq/convert.php on line 2494

Notice: Undefined variable: result in /home/tgclan/public_html/tgclan.com/hq/convert.php on line 2495

Notice: Undefined index: db_fetch_assoc in /home/tgclan/public_html/tgclan.com/hq/convert.php on line 1386

Fatal error: Function name must be a string in /home/tgclan/public_html/tgclan.com/hq/convert.php on line 1386

Warning: Unknown: open(/tmp/sess_b49e073861772b89079a9f62b41f3d24, O_RDWR) failed: Permission denied (13) in Unknown on line 0

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/tmp) in Unknown on line 0
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ice5192 on June 21, 2011, 04:41:00 AM
anybody?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ice5192 on June 21, 2011, 05:49:00 AM
i am getting this error now.

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of e107 ver.0.7.7. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user 'tgclan_smf223'@'localhost' for table 'e107_user'

password and username are right user has full permission
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ice5192 on June 23, 2011, 01:38:21 AM
I am very displeased with the help here can any body please help me out ?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ABCDiamond on July 08, 2011, 12:26:59 AM
A couple of quick questions:

I am converting e107 0.7.25 to SMF 2

Will this be different to the e107 0.7.7 that this post is discussing ?

I am getting this error message, when converting:

Converting ranks...Converting groups... Successful.
Converting members...Wrong value type sent to the database. Floating point number expected. (time_offset)


Any simple fixes for this ?

Thanks


Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ABCDiamond on July 12, 2011, 01:58:18 AM
Quote from: ice5192 on June 21, 2011, 05:49:00 AM
i am getting this error now.

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of e107 ver.0.7.7. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user 'tgclan_smf223'@'localhost' for table 'e107_user'

password and username are right user has full permission

I had the same error:
QuoteThe error that was received from the Database was: SELECT command denied to user '-mysite-_smp2'@'localhost' for table 'user'

I fixed it by:

In CPanel I went to: MySQL Databases.  My plan was to create a new user in e107 with the SMF user details.

I didn't actually create a new user, I just allocated the existing smf user to the e107 database, and visa versa, using the Add User To Database section.

Remembering to tick: Allowing ALL Privileges.

That worked for me.

I still have a problem as my earlier post, re the (time_offset).
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: railto on July 20, 2011, 04:36:36 PM
Im looking to import from e107 0.725 to SMF 2, tried to download the converter.php file on the front page but it just re-directs to the main forum page, can anyone help please
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: ABCDiamond on July 20, 2011, 05:37:55 PM
Quote from: railto on July 20, 2011, 04:36:36 PM
Im looking to import from e107 0.725 to SMF 2, tried to download the converter.php file on the front page but it just re-directs to the main forum page, can anyone help please
This is the location of the converter:  http://download.simplemachines.org/?converters;software=e
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Toddie on November 27, 2011, 01:01:31 AM
Hallo Community,
thank you for the converter and for spending time to resolve our problems.
i try to migrate from e107 0.7.26 to smf, but i have problems at converting-run:
Converting ranks...Converting groups... Successful.
Converting members...Wrong value type sent to the database. Floating point number expected. (time_offset)

Is anyone here with a tip for me ???

Thank you in advance  :)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: jack_wade on January 07, 2012, 11:44:47 AM
Quote from: Toddie on November 27, 2011, 01:01:31 AM
Hallo Community,
thank you for the converter and for spending time to resolve our problems.
i try to migrate from e107 0.7.26 to smf, but i have problems at converting-run:
Converting ranks...Converting groups... Successful.
Converting members...Wrong value type sent to the database. Floating point number expected. (time_offset)

Is anyone here with a tip for me ???

Thank you in advance  :)

I'm experiencing the same problem, any help?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: robeitor on November 04, 2013, 10:10:02 AM
Hi,

i´m having problems whit the Converter

Use the ver.0.7.7 converter

I try to enable all Extended User Fields...... but dont work.

The message is:

Converting...
Converting members...
Unsuccessful!
This query:
SELECT
u.user_id AS id_member, SUBSTRING(u.user_loginname, 1, 80) AS member_name,
u.user_join AS date_registered, u.user_forums AS posts,
(CASE WHEN u.user_admin = 1 THEN 1 ELSE 0 END) AS id_group, u.user_lastvisit AS last_login,
SUBSTRING(u.user_name, 1, 255) AS real_name,
SUBSTRING(u.user_password, 1, 64) AS passwd,
SUBSTRING(u.user_email, 1, 255) AS email_address, 0 AS gender,
ue.user_birthday AS birthdate,
SUBSTRING(REPLACE(ue.user_homepage, 'http://', ''), 1, 255) AS website_title,
SUBSTRING(ue.user_homepage, 1, 255) AS website_url,
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 hide_email,
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 time_offset,
SUBSTRING(u.user_image, 1, 255) AS avatar,
SUBSTRING(u.user_customtitle, 1, 255) AS usertitle,
SUBSTRING(u.user_ip, 1, 255) AS member_ip,
SUBSTRING(u.user_ip, 1, 255) AS member_ip2, '' AS lngfile, '' AS buddy_list,
'' AS pm_ignore_list, '' AS message_labels, '' AS personal_text, '' AS yim,
'' AS time_format, '' AS secret_question, '' AS secret_answer, '' AS password_salt,
'' AS validation_code, '' AS additional_groups, '' AS smiley_set
FROM `trailadmin_cta`.e107_user AS u
LEFT JOIN `trailadmin_cta`.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'
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Oldiesmann on November 04, 2013, 12:24:33 PM
That means there's no column named "user_birthday" in the "user_extended" table. What version of e107 are you using?
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: robeitor on November 04, 2013, 03:08:10 PM
Is a old version:
0.7.25, build zero
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mentalist on November 04, 2013, 11:09:16 PM
Extended user Fields are managed via the Admin->Users->Extended User Fields pages in e107.. please turn them on and try it again.
http://wiki.e107.org/index.php?title=Using_e107:Users:Extended_Fields
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: LiroyvH on November 05, 2013, 10:41:47 AM
Quote from: ThorstenE on December 05, 2008, 01:24:31 AM
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..
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mentalist on November 05, 2013, 11:32:10 AM
I'm affraid but that won't work, it's not just birthdate which is a custom field ... It's all from e107_user_extended.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Oldiesmann on November 05, 2013, 12:26:53 PM
Are you sure you enabled extended user fields? It should have added that table and the appropriate columns to the database when that feature was enabled. I've never used e107 so the only help I can provide at this point is telling you how to modify the converter to just import blank strings for those fields (which is all it would be doing anyway if you hadn't previously enabled that option).

Find
ue.user_birthday AS birthdate,
SUBSTRING(REPLACE(ue.user_homepage, 'http://', ''), 1, 255) AS website_title,
SUBSTRING(ue.user_homepage, 1, 255) AS website_url,
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 hide_email,


Replace
'' AS birthdate,
'' AS website_title,
'' AS website_url,
'' AS location,
'' AS icq,
'' AS aim,
'' AS msn, u.user_hideemail AS hide_email,


Find and remove this line:
LEFT JOIN {$from_prefix}user_extended AS ue ON (ue.user_extended_id = u.user_id)
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: robeitor on November 06, 2013, 02:19:56 AM
Hi,

modified all and i have the same error....   :(

The "extended user fields" are activated, i attached the screen shot.


Converting...
Converting ranks...Converting groups... Successful.
Converting members...Wrong value type sent to the database. Date expected. (birthdate)

Title: Re: [SMF Converter] e107 - 0.7.7
Post by: Oldiesmann on November 06, 2013, 02:22:30 PM
Ok. This time it's SMF being picky about trying to insert a string into a date field. The good news is if you set the date low enough, SMF won't try to calculate their age.

So...

Find
'' AS birthdate

Replace
'0004-01-01' AS birthdate

That should fix your issue there.
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: robeitor on November 07, 2013, 01:58:32 AM
Hi,

This resolve the problem with the birthday, thanks!

Now, i have other error:

I suppose that is similar at the error of birthday¿?

Converting ranks...Converting groups... Successful.
Converting members... Unsuccessful!
This query:
SELECT
u.user_id AS id_member, SUBSTRING(u.user_loginname, 1, 80) AS member_name,
u.user_join AS date_registered, u.user_forums AS posts,
(CASE WHEN u.user_admin = 1 THEN 1 ELSE 0 END) AS id_group, u.user_lastvisit AS last_login,
SUBSTRING(u.user_name, 1, 255) AS real_name,
SUBSTRING(u.user_password, 1, 64) AS passwd,
SUBSTRING(u.user_email, 1, 255) AS email_address, 0 AS gender,
'0004-01-01' AS birthdate
'' AS website_title,
'' AS website_url,
'' AS location,
'' AS icq,
'' AS aim,
'' AS msn, u.user_hideemail AS hide_email,
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 time_offset,
SUBSTRING(u.user_image, 1, 255) AS avatar,
SUBSTRING(u.user_customtitle, 1, 255) AS usertitle,
SUBSTRING(u.user_ip, 1, 255) AS member_ip,
SUBSTRING(u.user_ip, 1, 255) AS member_ip2, '' AS lngfile, '' AS buddy_list,
'' AS pm_ignore_list, '' AS message_labels, '' AS personal_text, '' AS yim,
'' AS time_format, '' AS secret_question, '' AS secret_answer, '' AS password_salt,
'' AS validation_code, '' AS additional_groups, '' AS smiley_set
FROM `trailadmin_cta`.e107_user AS u
WHERE u.user_id != 0
LIMIT 0, 500;
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 ''' AS website_title,
'' AS website_url,
'' AS location,
'' AS icq,
' at line 9
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: mentalist on November 07, 2013, 04:13:50 AM
there's a missing comma (that line where you applied the mentioned fix):
'0004-01-01' AS birthdate -> '0004-01-01' AS birthdate,
Title: Re: [SMF Converter] e107 - 0.7.7
Post by: robeitor on November 07, 2013, 04:46:41 AM
Hi!

Thats solved these problem.

The next error is about the  "Converting banned users..."

The error show a lot of lines like this:

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648

Warning: Missing argument 1 for convert_insert_id(), called in C:\xampp\htdocs\smf\convert.php(1091) : eval()'d code on line 18 and defined in C:\xampp\htdocs\smf\convert.php on line 2643

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648

Warning: Missing argument 1 for convert_insert_id(), called in C:\xampp\htdocs\smf\convert.php(1091) : eval()'d code on line 18 and defined in C:\xampp\htdocs\smf\convert.php on line 2643

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648

Warning: Missing argument 1 for convert_insert_id(), called in C:\xampp\htdocs\smf\convert.php(1091) : eval()'d code on line 18 and defined in C:\xampp\htdocs\smf\convert.php on line 2643

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648

Warning: Missing argument 1 for convert_insert_id(), called in C:\xampp\htdocs\smf\convert.php(1091) : eval()'d code on line 18 and defined in C:\xampp\htdocs\smf\convert.php on line 2643

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648

Warning: Missing argument 1 for convert_insert_id(), called in C:\xampp\htdocs\smf\convert.php(1091) : eval()'d code on line 18 and defined in C:\xampp\htdocs\smf\convert.php on line 2643

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648

Warning: Missing argument 1 for convert_insert_id(), called in C:\xampp\htdocs\smf\convert.php(1091) : eval()'d code on line 18 and defined in C:\xampp\htdocs\smf\convert.php on line 2643


and these at the final:

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648
Unsuccessful!
This query:
INSERT INTO `smf`.smf_ban_items
(id_ban_group, ip_low1, ip_high1, ip_low2, ip_high2, ip_low3, ip_high3, ip_low4, ip_high4, email_address, hostname)
VALUES (1556, 59, 59, 60, 60, 11*, 11*, **, **, '', '');
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 ' 11*, **, **, '', '')' at line 3