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.
sorry, but where sql attached file?
[acting like nothing happened]What chu talking about. It's right there :P.
Sorry about that. I uploaded the file.
ok. tnx.
I will test it.
How about True convert E107 Subforums?
I have trouble convert more 1500 members on this error
Caused the error:
Duplicate entry '3482' for key 1
On what step is that?
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...
Try this one.
Converting members... Successful.
but e107_user have 1742 rows
new smf_members have 1621 rows :(
Darn it. Check your e107 install for duplicate accounts. Check to see if there are duplicate user_id.
User_id it's primary key and not have dupelecated rows
look to screenshot
I'll look more into this. Not sure why the duplicate key. Try the first converter again and see if it works.
i already try, but no changes.
Ok drop the ID_MEMBER key from the members table and run the first converter. Let me know how that goes.
good!!!!
all rows added.
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.
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
no count > 1
SELECT uid_member, COUNT(id_member) AS count
FROM smf_members
GROUP BY id_member
WHERE count > 1
Check SMF table.
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.
Did you run the same query that you posted on the e107 table? Can't see a reason for dup ids.
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.
Ok try this one. The left join was missing the table alas. Maybe that was the cause for the error.
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
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.
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.
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. ;(
my e107_forum_t table have 135541 rows, may be its too many for 5 LEFT JOIN's?
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.
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
What error are you getting? It's just over loading the server?
No errors
MySql show State: Copying to tmp table and just over loading server.
i kill him for stop.
Might be a problem with index. Might have some missing index causing MySQL to choke.
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
super.
Work Real FAST.
Ok try this file. Not sure why that table was being joined 3 times. The last one didn't seem to have a purpose.
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
Ok lets set ignore to true to see how many "duplicate" posts are there.
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
Weird. It worked before so it should be working now. Converting topics comes before converting posts. Try truncating the topics table.
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
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.
im usin this convert:
Ok I was looking at the wrong section. It has the ignore now. Try this one.
Converting...
Recalculating forum statistics... Successful.
Conversion Complete
numbers topics and post on new forum = old forum.
So that means it was a success?
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...
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.
Ok a question. How do I add child boards?
On the forum admin click to planet icons (like the site icon on you profile)
:)
Yea I found it after I posted :P. Try this file and lets see what happens.
Converting boards... Unsuccessful!
This query:
INSERT INTO `smf`.smf_boards
....
Caused the error:
Duplicate entry '2' for key 1
Can you send me a dump of the forum table so that I can run a test query here?
take.
forum names at windows-1251 charset.
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.
no, im using windows-1251
dump on UTF8, because im use mysql 5.
I have tried the above but still having problems and getting
Caused the error:
Unknown column 'ue.user_birthday' in 'field list'
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.
works thank you sooooooooooooooooo much... this is amazing all converted
not all.
converter not support smiles and e107 bb codes.
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.
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]
smiles at e107 look that (pic1)
and stored on table e107_core (pic2)
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.
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....
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.
atached
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.
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
Seems like there is no count for the boards table.. Try this.
BTW can you IM me on ICQ?
yes i can.
board converts Ok.
im wait for 320000 post convert.
all converted.
have some trouble with quote..
double quote converts not true.
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]
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.
Ok here you go.
After convert need Recount all forum totals and statistics
All Re: to Post not "have Sublect" i think it's not right
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.
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.
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 »
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.
This file should support last edit time stamp and subject stuff. Let me know how it goes.
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
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
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?
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.
Ok hopefully this will fix it. Attachments are still not converted. I have to see how I'm going to work this one out.
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:
Ok try this. It just kept on going even if it didn't have any results.
script normaly done.
Sctatistic on Replies not updated.
Img bbc and NO subject not converted.
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?
(No Subject) and IMG bbc - not conveted :(
<span class='smallblacktext'>[ Edit 06 07 2004, 23:13 ]</span>
normaly removed.
Not even with the file that I sent you? The latest one.
Is the edit time being shown in SMF's style though?
How about finish (NoSubject) convert?
I'm me tomorrow on ICQ and I can finish it off.
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'
enable extended user fields on e107 admin.
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
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.
Sure, I'll give you the few days. You're helping us a lot.
Thanks.
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'
look my post 5 replays UP.
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
Wondering if there is an updated sql for this?
Trying to convert.....can't figure out where the extended user fields are.
Thanks!
The extended user fields are in the e107 settings.
I can not seem to find a that shows to enable them.
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
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?
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.
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
You didn't upload the new convert.php. Make sure that you over write it.
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! :)
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
it's working now!
it only works on mysql 4.x ...
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
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.
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.
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.
badm4n what version of e107 are you running?
mitooz - Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
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.
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.
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";}}
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
I,'ll download e107 and take a look at the avatar conversion and see if I can make it work.
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
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?
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Thanks alot I owe you one
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
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.
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
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
slackerpunk try http://www.simplemachines.org/community/index.php?topic=141395.msg1025912#msg1025912
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
You have a non-english forum?
nope it english just happens that some users use ascii characters for username like ñ ¢ and others
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?
@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
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.
@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
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)?
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
Use the sql from the first page. It seems like its not calculating the stats correctly. I'll look more into it.
ok maybe on my other site when I have the time I will finish this one that I just converted.
@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
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.
hmm thats weird
QuoteCongratulations, no errors found! Thanks for checking.
after checking for errors
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?
Use the file in the first post.
I have the same problem as russia213,Tried it with the SQL in the first post.
Any idea how to fix this?
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
Download the latest convert.php file. Updated Converters List & Support Topics (http://www.simplemachines.org/community/index.php?topic=140741.0)
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
In convert.php
Find:
ORDER BY LENGTH(code) DESC;
Replace:
ORDER BY code DESC;
I still have problem with
Converting ranks...Converting groups... Successful.
Converting members...Unknown column 'ue.user_birthday' in 'field list'
How to solve this?
Need to enable the extended profile.
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)
My solution was that. Enable the extended profile. What version of e107 are you running?
e107
Version 0.7.10
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?
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?
http://wiki.e107.org/?title=Using_e107:Users:Extended_Fields
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?
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.
Thanks!
btw eres dominicano? soy boriqua. que te vaya bien!
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! :)
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.
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
I have problem with characters. My forum is in swedish and your converter doesnt convert åäö propperly. Is there another one for international forums?
When you installed SMF, did you set it to use UTF-8?
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
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...
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).
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
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
Take a look at
http://www.simplemachines.org/community/index.php?topic=141395.msg1434335#msg1434335
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
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.
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
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
OK Thanks
I am using v0.7.11 which isn't helping.
Where can I download v0.7.7
I cant find it anywhere
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.
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
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)
Hmm, I wonder if I can put checks to have it skip the polls section if it doesn't exist :|
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 :)
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?
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
I still get same error :/
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.
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!
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)
Excellent :)
Thanks again!
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'
http://www.simplemachines.org/community/index.php?topic=141395.msg1597366#msg1597366 should help you.
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 ?
+1
i have this problem in 0.7.14 to :(
(sorry my bad englesh)
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..
Unknown column 'ue.user_homepage' in 'field list'
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)
i ebable all extended fields
error: Incorrect date value: '' for column 'birthdate' at row 1
mcdemon,
try this please:
http://www.simplemachines.org/community/index.php?topic=141395.msg1827556#msg1827556
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
please try the attached version..
which version of e017 are you wanting to convert?
0.7.14
new e107_to_smf.sql
result: Incorrect date value: '' for column 'birthdate' at row 1
mhh, sounds like a MySQL issue with the locale settings..
try this version please..
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
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).
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
mhh, not sure but maybe this helps:
e107 - utf8
smf - utf8
in convert.php NOT utf8
what character set /language is it?
Russian
any difference when UTF-8 in convert.php is not selected?
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.
which system suport is this ?
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)
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.
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
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!
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)
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.
Tried the sql file but still the same error coming up.
Do you have any banned users in e107?
What version of e107 are you using btw?
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!
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.
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?
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).
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
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.
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?
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?
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;
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;
---*
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.
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));
}
---}
---#
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.
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!
Hmm.. It doesn't work any more. It turns to be very strange :S
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());
}
Great work, and thank you for sharing your solution to the public :)
Thank you for your help :)
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 ?
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 ? :(
try removing this line from e107_to_smf.sql
ue.user_birthday AS birthdate,
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
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.
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 ?
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.
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?
the new error is a broken session... have you tried to restart the conversion from the beginning?
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)
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.
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.
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
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...
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
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???
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 ;)
Is this still the right topic for the converter from E107 to SMF ?
And are there different methods for each SMF version. ?
Thanks
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
Ok, i solved the problem. :-)
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.
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.
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
anybody?
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 am very displeased with the help here can any body please help me out ?
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
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).
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
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
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 :)
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?
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'
That means there's no column named "user_birthday" in the "user_extended" table. What version of e107 are you using?
Is a old version:
0.7.25, build zero
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
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..
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.
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)
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)
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.
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
there's a missing comma (that line where you applied the mentioned fix):
'0004-01-01' AS birthdate
-> '0004-01-01' AS birthdate,
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