-
Bug
-
Resolution: Invalid
-
None
-
3.0.x
-
None
-
PHP Environment:
Database:
in the ACP when I click restore database and select a db backup, it gives me this error
[phpBB Debug] PHP Notice: in file /includes/session.php on line 438: Undefined index: user_type
|
[phpBB Debug] PHP Notice: in file /includes/session.php on line 758: Undefined index: user_id
|
[phpBB Debug] PHP Notice: in file /includes/session.php on line 760: Undefined index: user_email
|
[phpBB Debug] PHP Notice: in file /includes/session.php on line 445: Undefined index: user_id
|
[phpBB Debug] PHP Notice: in file /includes/session.php on line 455: Undefined index: user_id
|
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 142: Undefined index: rand_seed
|
[phpBB Debug] PHP Notice: in file /includes/functions.php on line 144: Undefined index: rand_seed
|
[phpBB Debug] PHP Notice: in file /includes/auth.php on line 59: Undefined index: user_permissions
|
[phpBB Debug] PHP Notice: in file /includes/auth.php on line 317: Undefined index: user_id
|
Return to forum index
|
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 'ORDER BY a.forum_id, ao.auth_option' at line 4 [1064]
|
|
SQL
|
|
SELECT ao.auth_option, a.auth_role_id, r.auth_setting as role_auth_setting, a.user_id, a.forum_id, a.auth_setting FROM (phpbb_acl_options ao, phpbb_acl_users a) LEFT JOIN phpbb_acl_roles_data r ON (a.auth_role_id = r.role_id) WHERE (ao.auth_option_id = a.auth_option_id OR ao.auth_option_id = r.auth_option_id) AND a.user_id = ORDER BY a.forum_id, ao.auth_option
|
|
BACKTRACE
|
|
FILE: includes/db/mysqli.php
|
LINE: 110
|
CALL: dbal->sql_error()
|
|
FILE: includes/auth.php
|
LINE: 517
|
CALL: dbal_mysqli->sql_query()
|
|
FILE: includes/auth.php
|
LINE: 317
|
CALL: auth->acl_raw_data()
|
|
FILE: includes/auth.php
|
LINE: 61
|
CALL: auth->acl_cache()
|
|
FILE: adm/index.php
|
LINE: 25
|
CALL: auth->acl()
|