erro member list

[desert spider]

ik krijg deze erro bij de member list



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 '' at line 4

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 phpbb_users WHERE user_id <> -1 AND username LIKE '%' ORDER BY user_regdate ASC LIMIT 0,

Line : 209
File : /home/owns/public_html/hwfactory/forum/memberlist.php



alvast bedankt
desert spider

[cartoontje]

Post eens memberlist.php regel 200 t/m 220!

[desert spider]

{
$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 . "$letter_sql
ORDER BY $order_by";
}

if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}

if ( $row = $db->sql_fetchrow($result) )
{
$i = 0;
do
{
$username = $row['username'];
$user_id = $row['user_id'];

$from = ( !empty($row['user_from']) ) ? $row['user_from'] : '&nbsp;';

zet het niet tussen [ code ] word het smaller van

[Podium4]

Moet $letter_sql niet op een nieuwe regel? Dus onder WHERE user_id <> " . ANONYMOUS . "

[desert spider]

heeft geen verschil

[mosymuis]

Moet $letter_sql niet op een nieuwe regel? Dus onder WHERE user_id <> " . ANONYMOUS . "

Nee, SQL trekt zich niets aan van breaks, het had net zo goed allemaal op 1 regel mogen staan.

[desert spider]

oke? maar wat is het probleem

[mosymuis]

Het zit hem in het stuk vóór het stuk dat je hebt gepost. Zoek eens naar

Code: Selecteer alles

$letter_sql = 

[desert spider]

Code: Selecteer alles

if($by_letter == 'all')
{
	$letter_sql = '';
}
else if($by_letter == 'others')
{
	$letter_sql = $others_sql;
}
else
{
	$letter_sql = " AND username LIKE '$by_letter%' ";
}

[mosymuis]

Hmm, ik zat verkeerd. Kan je

Code: Selecteer alles

$order_by = 

vinden?

[desert spider]

Code: Selecteer alles

switch( $mode )
{
	case 'joined':
		$order_by = "user_regdate $sort_order LIMIT $start, " . $board_config['members_per_page'];
		break;
	case 'username':
		$order_by = "username $sort_order LIMIT $start, " . $board_config['members_per_page'];
		break;
	case 'location':
		$order_by = "user_from $sort_order LIMIT $start, " . $board_config['members_per_page'];
		break;
	case 'posts':
		$order_by = "user_posts $sort_order LIMIT $start, " . $board_config['members_per_page'];
		break;
	case 'email':
		$order_by = "user_email $sort_order LIMIT $start, " . $board_config['members_per_page'];
		break;
	case 'website':
		$order_by = "user_website $sort_order LIMIT $start, " . $board_config['members_per_page'];
		break;
	case 'topten':
		$order_by = "user_posts $sort_order LIMIT 10";
		break;
	default:
		$order_by = "user_regdate $sort_order LIMIT $start, " . $board_config['members_per_page'];
		break;

[mosymuis]

Code: Selecteer alles

$board_config['members_per_page']

Bestaat dus niet. Je hebt waarschijnlijk deze mod geïnstalleerd, zonder de database update uit te voeren.

[desert spider]

dit is echt heel vaag
omdat ik wel de sql heb uitgevoert keek ik even in het admin paneel
hij stont op 40 members nu heb ik hem op 30 gezet en hij doet het weer