SQL Error : 1064

[Jildou]

Kunnen jullie me helpen bij het fixen van deze error?


Could not query users

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '; WHERE user_id <> -1 ORDER BY user_regdate ASC LIMIT 0, 50'

SELECT username, user_points, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar FROM therapy_phpbb_users; WHERE user_id <> -1 ORDER BY user_regdate ASC LIMIT 0, 50

Line : 154
File : memberlist.php

Dit is de code waar het om gaat:

Code: Selecteer alles

$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar 
	FROM " . USERS_TABLE . ";
	WHERE user_id <> " . ANONYMOUS . "
	ORDER BY $order_by";$cm_memberlist->generate_columns($template,$sql,8);
if( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}

Thanks, als je nog meer info nodig hebt zeg het maar

[Paul]

verander het eens in:

Code: Selecteer alles

$sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website, user_email, user_icq, user_aim, user_yim, user_msnm, user_avatar, user_avatar_type, user_allowavatar
   FROM " . USERS_TABLE . "
   WHERE user_id <> " . ANONYMOUS . "
   ORDER BY $order_by";
$cm_memberlist->generate_columns($template,$sql,8);
if( !($result = $db->sql_query($sql)) )
{
   message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
} 

[Jildou]

Het werkte, enorm bedankt!! :thumb: