![]() | | ||||||||||
| |||||||||||
| |||||||
| Notices |
![]() |
| | LinkBack | Thread Tools | Display Modes |
| | #1 |
| Regular Member Join Date: Apr 2008 Location: California
Posts: 56
Credits: 1 ![]() | 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']).")";
}
__________________ Wicked3X|3xGuilds.com| "As long as darkness flows through my veins, I will never cease, As long as my dreams still haunt me, I will never show mercy, and as long as evil lives I will never die..... |
| | |
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
| |