SMF Support > phpBB
[SMF Converter] phpBB - 2.0.19+
dusanp:
i thought you have same issue because you wrote that in first post ...
I finished converting with smf 1 ...
you want me to look for id of the last post? This is general problem ... not only in my case
If you want I can find that ... just tell me where to look
LiveWire:
I was referring to your second error:
--- Quote ---edit: I downloaded 1.1.14 smf and converter for smf 1 ... try to convert ... it was going ok but ... there is an error again
--- End quote ---
Anyway, the conversion is done straight to SMF 2. From the query I posted earlier which came from the convert sql file, I found the topic having problems. I searched in the database in the posts table for records linked to that topic. I copied the highest post ID and put that as the last post ID in the topic record. I reran convert and it is done. There was an issue during the recalc, but I can do that through the admin.
dusanp:
awesome ... I didn't saw it at first ... tnx ... it will be much easier for all now :)
my second error was something else ... I forgot what ... I resolved that ...
LiveWire:
I guess I never hit submit. This has been sitting in the quick reply window for a while.
There were problems with the data after. I got a fresh export of the DB from the old site and reran the convert. Had to change this:
SUBSTRING(IF(IFNULL(p.post_username, '') = '', u.username, IFNULL(p.post_username, '')), 1, 255)
to:
SUBSTRING(IF(IFNULL(p.post_username, '') = '', IFNULL(u.username, ''), IFNULL(p.post_username, '')), 1, 255)
then:
SUBSTRING(uf.username, 1, 255) AS from_name,
to:
SUBSTRING(ifnull(uf.username,''), 1, 255) AS from_name,
That got the convert to run and did not even get the errors during the recalc. All the boards are in the same category.
Since then, I noticed that attachments were all lost.
TGSICD:
Error below when converting from phpBB2 to smf1.1.16:
Converting...
Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `pinecam`.smf_topics
SET ID_FIRST_MSG = '',
ID_MEMBER_STARTED = '0', ID_LAST_MSG = '',
ID_MEMBER_UPDATED = '0', numReplies = '-1'
WHERE ID_TOPIC = 42173
LIMIT 1;
Caused the error:
Duplicate entry '0-2' for key 2
I even typed in the topic id in my url and it got my no where.(Could not find this link) /smf/index.php?topic=42173
Was told to change $sql = "SELECT * FROM users WHERE uid=".$uid;
with (In forum) $sql = "SELECT * FROM users WHERE uid='".$uid."'";
as a last resort used the converter and sql from this forum, different error message this time:
SELECT
p.post_id AS ID_MSG, p.topic_id AS ID_TOPIC, p.post_time AS posterTime,
p.poster_id AS ID_MEMBER,
SUBSTRING(IFNULL(u.user_email, ''), 1, 255) AS posterEmail,
SUBSTRING(IF(IFNULL(pt.post_subject, '') = '', t.topic_title, pt.post_subject), 1, 255) AS subject,
SUBSTRING(IF(IFNULL(p.post_username, '') = '', u.username, p.post_username), 1, 255) AS posterName,
p.enable_smilies AS smileysEnabled, IF(p.post_edit_time > 0, p.post_edit_time, 0) AS modifiedTime,
CONCAT_WS('.', CONV(SUBSTRING(p.poster_ip, 1, 2), 16, 10), CONV(SUBSTRING(p.poster_ip, 3, 2), 16, 10), CONV(SUBSTRING(p.poster_ip, 5, 2), 16, 10), CONV(SUBSTRING(p.poster_ip, 7, 2), 16, 10)) AS posterIP,
SUBSTRING(REPLACE(REPLACE(IF(pt.bbcode_uid = '', pt.post_text, REPLACE(REPLACE(REPLACE(pt.post_text, CONCAT(':u:', pt.bbcode_uid), ''), CONCAT(':1:', pt.bbcode_uid), ''), CONCAT(':', pt.bbcode_uid), '')), '\n', '<br />'), '"', '"'), 1, 65534) AS body,
p.forum_id AS ID_BOARD, '' AS modifiedName, 'xx' AS icon
FROM (`pinecam`.phpbb_posts AS p, `pinecam`.phpbb_posts_text AS pt, `pinecam`.phpbb_topics AS t)
LEFT JOIN `pinecam`.phpbb_users AS u ON (u.user_id = p.poster_id)
WHERE pt.post_id = p.post_id
AND t.topic_id = p.topic_id
LIMIT 485000, 200;
Caused the error:
When I check the scripts it seems to be ok. Is there something I am missing?
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version