вот, редактируй...емто просто проблемы совместимости Ипб с 5 мускулем, это для версий 2.1:
редактируем файлы хранилища запросов ipb - sources/sql/mysql_queries.php
ищем:
<!--quoteo--><div class='quotetop'>Цитата</div><div class='quotemain'><!--quotec-->function msg_get_cc_users( $a )
{
return "SELECT m.mgroup_others, m.id, m.name, m.members_disable_pm, m.members_display_name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_messages, g.g_use_pm FROM ".SQL_PREFIX."members m, ".SQL_PREFIX."groups g
LEFT JOIN ".SQL_PREFIX."member_extra me ON (m.id=me.id)
WHERE LOWER(m.members_display_name) IN (".implode(",",$a['name_array']).")
AND m.mgroup=g.g_id";
}<!--QuoteEnd--></div><!--QuoteEEnd-->
Заменяем на:
<!--quoteo--><div class='quotetop'>Цитата</div><div class='quotemain'><!--quotec-->function msg_get_cc_users( $a )
{
return "SELECT m.mgroup_others, m.id, m.name, m.members_disable_pm, m.members_display_name, m.msg_total, m.view_pop, m.email_pm, m.language, m.email, me.vdirs, g.g_max_messages, g.g_use_pm FROM (".SQL_PREFIX."members m, ".SQL_PREFIX."groups g)
LEFT JOIN ".SQL_PREFIX."member_extra me ON (m.id=me.id)
WHERE LOWER(m.members_display_name) IN (".implode(",",$a['name_array']).")
AND m.mgroup=g.g_id";
}<!--QuoteEnd--></div><!--QuoteEEnd-->
Ищем:
<!--quoteo--><div class='quotetop'>Цитата</div><div class='quotemain'><!--quotec-->function portal_get_poll_join( $a )
{
return "SELECT t.tid, t.title, t.state, t.last_vote, p.*, v.member_id as member_voted
FROM ".SQL_PREFIX."topics t, ".SQL_PREFIX."polls p
LEFT JOIN ".SQL_PREFIX."voters v ON (v.member_id={$a['mid']} and v.tid=t.tid)
WHERE t.tid={$a['tid']} AND p.tid=t.tid";
}<!--QuoteEnd--></div><!--QuoteEEnd-->
Меняем:
<!--quoteo--><div class='quotetop'>Цитата</div><div class='quotemain'><!--quotec-->function portal_get_poll_join( $a )
{
return "SELECT t.tid, t.title, t.state, t.last_vote, p.*, v.member_id as member_voted
FROM (".SQL_PREFIX."topics t, ".SQL_PREFIX."polls p)
LEFT JOIN ".SQL_PREFIX."voters v ON (v.member_id={$a['mid']} and v.tid=t.tid)
WHERE t.tid={$a['tid']} AND p.tid=t.tid";
}<!--QuoteEnd--></div><!--QuoteEEnd-->
Вот и всё.