а у никого проблем не было с memberlist.php?
Код: Выделить всё
Could not query users
DEBUG MODE
SQL Error : 1052 Column: 'user_id' in field list is ambiguous
SELECT user_cf_iso3661_1, user_from_flag_cf_iso3661_1, username, phpbb_users.user_points, user_id, user_viewemail, user_posts, user_regdate, user_lastlogon, user_allow_viewonline, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar, u_up_total, u_down_total, user_allow_viewonline, user_session_time FROM phpbb_users LEFT JOIN phpbb_bt_users ON phpbb_users.user_id = phpbb_bt_users.user_id WHERE phpbb_users.user_id <> -1 ORDER BY user_regdate ASC LIMIT 0, 25
Line : 208
File : memberlist.php
вот кусок из файла
Код: Выделить всё
$sql = "SELECT username, " . USERS_TABLE . ".user_id, user_viewemail, user_posts, user_regdate, user_lastlogon, user_allow_viewonline, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar, u_up_total, u_down_total, user_allow_viewonline, user_session_time
FROM " . USERS_TABLE . "
LEFT JOIN " . BT_USERS_TABLE . " ON " . USERS_TABLE . ".user_id = " . BT_USERS_TABLE . ".user_id
WHERE " . USERS_TABLE . ".user_id <> " . ANONYMOUS . "
ORDER BY $order_by";
//-- mod : IP Country Flag II ----------------------------------------------
// add
$sql = str_replace ('SELECT ', 'SELECT user_cf_iso3661_1, user_from_flag_cf_iso3661_1, ' . $sql_where, $sql);
//-- end mod : IP Country Flag II ------------------------------------------
$cm_memberlist->generate_columns($template,$sql,8);
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}