My sql error

Support for PhpBB3. Post here to get help with any phpBB3 related issue here
There is no support here! Only Read Access!
Forum rules
In order the get any support, you will have to do following:
1. Use a describing title!
2. Describe your problem and what happened when the problem occured
3. Tell us what version of phpBB3 you are currently using.
Else your topic may be ignored or locked!
Locked
dragoth
BBCoder III
BBCoder III
Posts: 81
Joined: 05 Mar 2010, 02:57

My sql error

Post by dragoth »

i Get this error

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()
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

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');
		}
were using 3.0.7 pl
User avatar
Inner Circle
BBCoder III
BBCoder III
Posts: 107
Joined: 20 Mar 2010, 20:25
Location: Germany
Contact:

Re: My sql error

Post by Inner Circle »

Right here

Code: Select all

// Start Ultimate Points
Check the edits of the Ultimate Points Mod you made. It seems you made an error
Locked