Erro ao actualizar

[Tjda]

Estava a actualizar o forum para a versão mais recente quando me sucedeu este erro

Code Select Expand

Updating ban system... Unsuccessful!
This query:
SELECT mem.ID_MEMBER, mem.is_activated + 10 AS new_value
FROM (smf_ban_groups AS bg, smf_ban_items AS bi, smf_members AS mem)
WHERE bg.ID_BAN_GROUP = bi.ID_BAN_GROUP
AND bg.cannot_access = 1
AND (bg.expire_time IS NULL OR bg.expire_time > 1190752854)
AND (mem.ID_MEMBER = bi.ID_MEMBER OR mem.emailAddress LIKE bi.email_address)
AND mem.is_activated < 10;
Caused the error:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation 'like'

Alguem sabe como resolver ?

[margarett]

Aparentemente terás codificações diferentes em algumas tabelas? Verifica com o phpmyadmin as "collations" de todas as tabelas.