SMF Support > phpBB
[SMF Converter] phpBB - 2.0.19+
dusanp:
I have the same problem ... Wrong value type sent to the database. Integer expected. (id_member_updated)
Is there any way to go smf 2.0 direct or we must install smf1 and then update?
In that 2 cases ... result will be the same or not?
What to do?
If I must install smf1 where to find phpbb to smf1 converter? On download page there is only 2.0 version?
What is problem in php db?
(id_member_updated) ... I cant find that table ... or its a row? can i change that id or what to do
_____________________________
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
--- Quote ---Converting posts (this may take some time)... Unsuccessful!
This query:
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 (`sugdump`.phpbb_posts AS p, `sugdump`.phpbb_posts_text AS pt, `sugdump`.phpbb_topics AS t)
LEFT JOIN `sugdump`.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 120800, 200;
Caused the error:
MySQL server has gone away
--- End quote ---
what to do? I`ll do this in local ... on wamp program for local server ... my forum has 253720 posts, 12919 themes and 11626 users ... is that problem?
LiveWire:
I am having the same issue with id_member_updated. I have been trying to figure out the originating phpBB column that I am assuming is null. I looked at the code, found where id_member_updated is being written and searched back to where the corresponding variable was being set. I copied the SQL that pulled the value in. It is below. I then ran that in phpAdmin with the thought being to find the bad data and correct. Every value returned as myid_first_msg and myid_last_msg is null. So I am skeptical that this is bad data specific to my database or the several others that have had the problem.
--- Code: ---SELECT t.id_topic, MIN( m.id_msg ) AS myid_first_msg, t.id_first_msg, MAX( m.id_msg ) AS myid_last_msg, t.id_last_msg, COUNT( m.id_msg ) -1 AS my_num_replies, t.num_replies
FROM smf_topics AS t
LEFT JOIN smf_messages AS m ON ( m.id_topic = t.id_topic )
GROUP BY t.id_topic
HAVING id_first_msg != myid_first_msg
OR id_last_msg != myid_last_msg
OR num_replies != my_num_replies
--- End code ---
LiveWire:
It looks like it is probably earlier, I am looking the SQL file instead of convert.php. I added the order by and am getting one null.
SELECT
t.topic_id AS id_topic, (t.topic_type = 1 OR t.topic_type = 2) AS is_sticky,
t.topic_first_post_id AS id_first_msg, t.topic_last_post_id AS id_last_msg,
t.topic_poster AS id_member_started, p.poster_id AS id_member_updated,
t.forum_id AS id_board, IF(v.vote_id != 0, v.vote_id, 0) AS id_poll, t.topic_status = 1 AS locked,
t.topic_replies AS num_replies, t.topic_views AS num_views
FROM phpbb_topics AS t
LEFT JOIN phpbb_posts AS p ON (p.post_id = t.topic_last_post_id)
LEFT JOIN phpbb_vote_desc AS v ON (v.topic_id = t.topic_id)
GROUP BY t.topic_id
HAVING id_first_msg != 0
AND id_last_msg != 0
order by id_member_updated
dusanp:
Convert to 1.1.14 and than to 2.0 its easy and fast, save your time :)
LiveWire:
My concern about doing that was your last post still indicated you were having issues. I take it you resolved them.
I think I can fix the one topic that is giving the problem. The post indicated by the last post ID in the topic does not exist. I need to figure out the post ID of the real last post.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version