SMF Support > Converting to SMF

Converting XMB to SMF

(1/4) > >>

Tom84:
Hello, i have an XMB forum, and i wanted to convert it to SMF.

I already had some issues and i have fixed them, but still i can't find out what still is wrong on it.


This is what i can't still find out what is wrong on it:

Converting topics...
Unsuccessful!
This query:
SELECT
t.tid AS id_topic, t.topped AS is_sticky, t.fid AS id_board,
IFNULL(uf.uid, 0) AS id_member_started, t.replies AS num_replies,
t.views AS num_views,
CASE WHEN t.closed = 'yes' THEN 1 ELSE 0 END AS locked, MIN(p.pid) AS id_first_msg,
MAX(p.pid) AS id_last_msg, IF(t.pollopts != '', t.tid, 0) AS id_poll
FROM `forocato_seN1zEt`.xmb_threads AS t
INNER JOIN `forocato_seN1zEt`.xmb_posts AS p ON (p.tid = t.tid)
LEFT JOIN `forocato_seN1zEt`.xmb_members AS uf ON (uf.username = t.author)
GROUP BY t.tid
HAVING id_first_msg != 0
AND id_last_msg != 0
LIMIT 0, 500;
Caused the error:
1055





This is what i fixed:

   END AS id_group, '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list,
   '' AS message_labels, '' AS time_format, '' AS usertitle, '' AS member_ip,
   '' AS secret_question, '' AS secret_answer, '' AS validation_code,
   '' AS additional_groups, '' AS smiley_set, '' AS password_salt,
   '' AS member_ip2, '' AS openid_uri, '' AS ignore_boards

The lastests 2 ''AS openid and the ignore_boards one were missing.
Until this, you will have all users, passwords and emails migrated.


if someone can help me, i would apreciate it a lot ! Thanks

vbgamer45:
https://stackoverflow.com/questions/36207042/error-code-1055-incompatible-with-sql-mode-only-full-group-by

You will need to set your sql_mode in your my.cnf in MySQL config to sql_mode  = ''

Tom84:
i know on this case is a trouble of language between versions of mysql.

But i can't find where it is. I have another issue, i can't do what you say because it's on a web hosting provider the database, i can't modify anything except user privilege on it. That's why i'm asking for help. But thanks anyway

vbgamer45:
Group by in new mysql versions require all select items to be in group by clause now

You would need to change the GROUP BY t.tid

To something like
GROUP BY t.tid, is_sticky, id_board,  id_member_started, num_views, num_replies,  id_first_msg, id_last_msg, id_poll

Tom84:
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Unsuccessful!
This query:
SELECT
t.tid AS id_topic, t.topped AS is_sticky, t.fid AS id_board,
IFNULL(uf.uid, 0) AS id_member_started, t.replies AS num_replies,
t.views AS num_views,
CASE WHEN t.closed = 'yes' THEN 1 ELSE 0 END AS locked, MIN(p.pid) AS id_first_msg,
MAX(p.pid) AS id_last_msg, IF(t.pollopts != '', t.tid, 0) AS id_poll
FROM `forocato_seN1zEt`.xmb_threads AS t
INNER JOIN `forocato_seN1zEt`.xmb_posts AS p ON (p.tid = t.tid)
LEFT JOIN `forocato_seN1zEt`.xmb_members AS uf ON (uf.username = t.author)
GROUP BY t.tid, is_sticky, id_board, id_member_started, num_views, num_replies, id_first_msg, id_last_msg, id_poll
HAVING id_first_msg != 0
AND id_last_msg != 0
LIMIT 0, 500;
Caused the error:
1056



it's an error group field now, hahaha, this is like a karma. i can't migrate the database, i'm trying since 2 days with all this

Navigation

[0] Message Index

[#] Next page

Go to full version