My sql error
Posted: 04 Sep 2010, 03:09
i Get this error
So i figured it was the memberlist.php
and i cant find the problem. And this error happens when you lick the team link /memberlist.php?mode=leaders
Im not sure what mod made this happen.
memberlist.php Lines 264- 284
were using 3.0.7 pl
Code: Select all
General Error
SQL ERROR [ mysqli ]
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 3 [1064]
SQL
SELECT forum_id, auth_option_id, auth_role_id, auth_setting FROM phpbb_acl_users WHERE user_id =
BACKTRACE
FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()
FILE: includes/auth.php
LINE: 814
CALL: dbal_mysqli->sql_query()
FILE: includes/auth.php
LINE: 382
CALL: auth->acl_raw_data_single_user()
FILE: includes/auth.php
LINE: 71
CALL: auth->acl_cache()
FILE: memberlist.php
LINE: 274
CALL: auth->acl()and i cant find the problem. And this error happens when you lick the team link /memberlist.php?mode=leaders
Im not sure what mod made this happen.
memberlist.php Lines 264- 284
Code: Select all
}
$db->sql_freeresult($result);
// Start Ultimate Points
global $db, $ultimate_points, $points_config, $points_values;
$locked = $blocked = false;
if ( $config['points_enable'] )
{
$check_auth = new auth();
$check_auth->acl($member);
$locked = $check_auth->acl_get('u_use_points');
}
if ( $points_config['bank_enable'] && $config['points_enable'] )
{
$check_auth = new auth();
$check_auth->acl($member);
$blocked = $check_auth->acl_get('u_use_bank');
}