Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-789

Error on Restore Database

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Invalid
    • None
    • 3.0.x
    • ACP
    • 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()

            DavidMJ DavidMJ
            Handyman` Handyman` [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: