One day I was trying to install ipb 2.0 and I kept getting mysql errors upon install after searching for 2+ hours I finally found a solution.. So I thought I would post it on here to save others loads of time. Not sure how many people actually still use 2.0 but yeah here it is anyway.
Go to sources > sql > mysql_queries.php
Find:
Code:
function msg_get_cc_users( $a )
{
return "SELECT m.mgroup_others, m.id, m.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.name) IN (".implode(",",$a['name_array']).")
AND m.mgroup=g.g_id";
}
Replace With:
Code:
function msg_get_cc_users( $a )
{
return "SELECT m.mgroup_others, m.id, m.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
INNER JOIN ".SQL_PREFIX."groups g ON m.mgroup=g.g_id
LEFT JOIN ".SQL_PREFIX."member_extra me ON (m.id=me.id)
WHERE LOWER(m.name) IN (".implode(",",$a['name_array']).")";
}
04-10-2008, 07:24 PM
[2.0]Ipb 2.0 Pm Fix 
Linear Mode
