super
Je vais tester tous ceci et vous tiens au courant si cela fonctionne
En tous les cas merci déjà pour votre aide.
Le seul truc c'est que mon champ se nom "vos auto" et non auto, donc quels sont les endroits que je dois modifier?
Merci
Modérateur: Equipe
SQL ERROR [ mysql4 ] Unknown column 'u.user_id' in 'on clause' [1054] SQL SELECT u.user_id FROM phpbb_users u , phpbb_user_group ug LEFT JOIN phpbb_profile_fields_data fd ON (u.user_id = fd.user_id) WHERE u.user_type IN (0, 3) AND ug.user_pending = 0 AND u.user_id = ug.user_id AND ug.group_id = 2087 ORDER BY ug.group_leader DESC, u.user_regdate ASC LIMIT 50 BACKTRACE FILE: includes/db/mysql.php LINE: 175 CALL: dbal->sql_error() FILE: includes/db/mysql.php LINE: 222 CALL: dbal_mysql->sql_query() FILE: includes/db/dbal.php LINE: 170 CALL: dbal_mysql->_sql_query_limit() FILE: memberlist.php LINE: 1450 CALL: dbal->sql_query_limit()
SQL ERROR [ mysql4 ] Unknown column 'u.user_id' in 'on clause' [1054] SQL SELECT u.user_id FROM phpbb_users u , phpbb_user_group ug LEFT JOIN phpbb_profile_fields_data fd ON (u.user_id = fd.user_id) WHERE u.user_type IN (0, 3) AND ug.user_pending = 0 AND u.user_id = ug.user_id AND ug.group_id = 2 ORDER BY ug.group_leader DESC, u.user_regdate ASC LIMIT 25 BACKTRACE FILE: includes/db/mysql.php LINE: 175 CALL: dbal->sql_error() FILE: includes/db/mysql.php LINE: 222 CALL: dbal_mysql->sql_query() FILE: includes/db/dbal.php LINE: 170 CALL: dbal_mysql->_sql_query_limit() FILE: memberlist.php LINE: 1448 CALL: dbal->sql_query_limit()
if(isset($sort_key_sql['y'])) { $sql = "SELECT u.user_id FROM " . USERS_TABLE . " u $sql_from LEFT JOIN " . PROFILE_FIELDS_DATA_TABLE . " fd ON (u.user_id = fd.user_id) WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ") $sql_where ORDER BY $order_by"; } else {
ForumsFaciles a écrit:ok. je regarde ca si j'en ai le courage. trente minute a pied par ce temps froid c'est dur lol surtout apres avoir attendu le train pendant un peu plus de trente minutes. @+++
*** EDIT ***
Hum... Personnellement, je ne rencontre aucune erreur, je vais dans la liste des membres, je fais le tri, et tout se passe de manière correcte![]()
J'ai même testé avec le compte utilisateur.
A mon avis cela vient de votre modification. Quelque chose a bugué quelque part, et provoque cette erreur.
Erreur générale SQL ERROR [ mysql4 ] Unknown column 'u.user_id' in 'on clause' [1054] SQL SELECT u.user_id FROM phpbb_users u , phpbb_user_group ug LEFT JOIN phpbb_profile_fields_data fd ON (u.user_id = fd.user_id) WHERE u.user_type IN (0, 3) AND ug.user_pending = 0 AND u.user_id = ug.user_id AND ug.group_id = 2 ORDER BY ug.group_leader DESC, u.user_regdate ASC LIMIT 25 BACKTRACE FILE: includes/db/mysql.php LINE: 175 CALL: dbal->sql_error() FILE: includes/db/mysql.php LINE: 222 CALL: dbal_mysql->sql_query() FILE: includes/db/dbal.php LINE: 170 CALL: dbal_mysql->_sql_query_limit() FILE: memberlist.php LINE: 1448 CALL: dbal->sql_query_limit()
if(isset($sort_key_sql['y']))
{
$sql = "SELECT u.user_id
FROM " . USERS_TABLE . " u
$sql_from
LEFT JOIN " . PROFILE_FIELDS_DATA_TABLE . " fd ON (u.user_id = fd.user_id)
WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ")
$sql_where
ORDER BY $order_by";
}
else
if(isset($sort_key_sql['y']) && !$mode['group'])
{
$sql = "SELECT u.user_id
FROM " . USERS_TABLE . " u
$sql_from
LEFT JOIN " . PROFILE_FIELDS_DATA_TABLE . " fd ON (u.user_id = fd.user_id)
WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ")
$sql_where
ORDER BY $order_by";
}
else
SQL ERROR [ mysql4 ] Unknown column 'fd.pf_auto' in 'order clause' [1054] SQL SELECT u.user_id FROM phpbb_users u , phpbb_user_group ug WHERE u.user_type IN (0, 3) AND ug.user_pending = 0 AND u.user_id = ug.user_id AND ug.group_id = 2084 ORDER BY ug.group_leader DESC, fd.pf_auto ASC LIMIT 50 BACKTRACE FILE: includes/db/mysql.php LINE: 175 CALL: dbal->sql_error() FILE: includes/db/mysql.php LINE: 222 CALL: dbal_mysql->sql_query() FILE: includes/db/dbal.php LINE: 170 CALL: dbal_mysql->_sql_query_limit() FILE: memberlist.php LINE: 1449 CALL: dbal->sql_query_limit()
if(isset($sort_key_sql['y']) && !$mode['group'])
{
$sql = "SELECT u.user_id
FROM " . USERS_TABLE . " u
$sql_from
LEFT JOIN " . PROFILE_FIELDS_DATA_TABLE . " fd ON (u.user_id = fd.user_id)
WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ")
$sql_where
ORDER BY $order_by";
}
else
if(isset($sort_key_sql['y']))
{
$sql = "SELECT u.user_id
FROM (" . USERS_TABLE . " u
$sql_from)
LEFT JOIN " . PROFILE_FIELDS_DATA_TABLE . " fd ON (u.user_id = fd.user_id)
WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ")
$sql_where
ORDER BY $order_by";
}
else
Utilisateurs parcourant ce forum : Bing [Bot] et 9 invités