Error in convertion

[liberd]

Hello people and sorry my bad english  , I can`t complete my convertion because this error:

Converting...
Converting ranks... Successful.
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)... Unsuccessful!
This query:

    SELECT
    hxxp:p.post [nonactive]_id AS ID_MSG, p.topic_id AS ID_TOPIC, hxxp:p.post [nonactive]_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, hxxp:pt.post [nonactive]_subject), 1, 255) AS subject,
    SUBSTRING(IF(IFNULL(p.post_username, '') = '', u.username, hxxp:p.post [nonactive]_username), 1, 255) AS posterName,
    p.enable_smilies AS smileysEnabled, hxxp:p.post [nonactive]_edit_time 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 = '', hxxp:pt.post [nonactive]_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,
    hxxp:p.forum [nonactive]_id AS ID_BOARD, '' AS modifiedName, 'xx' AS icon
    FROM (`w1030203_mipalm`.foroposts AS p, `w1030203_mipalm`.foroposts_text AS pt, `w1030203_mipalm`.forotopics AS t)
    LEFT JOIN `w1030203_mipalm`.forousers AS u ON (u.user_id = p.poster_id)
    WHERE hxxp:pt.post [nonactive]_id = hxxp:p.post [nonactive]_id
    AND t.topic_id = p.topic_id
    LIMIT 0, 200;

Caused the error:

    Illegal mix of collations (utf8_spanish_ci,IMPLICIT), (utf8_general_ci,IMPLICIT), (latin1_swedish_ci,COERCIBLE) for operation 'replace'

Please anyone can help me?! I don`t know how solve...

[liberd]

Please anyone?!

[Sarge]

Send me a copy of your phpBB database and I'll see what I can do.