Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-15911

SQL general error on DB update from 3.0 branch

    XMLWordPrintable

Details

    Description

      The PR https://github.com/phpbb/phpbb/pull/5343 had changed the user_delete function by adding new tables to the $table_ary array to delete data for users.

      But those tables don't exist in phpBB 3.0/3.1 on \phpbb\db\migration\data\v310\bot_update.php execution while updating from phpBB 3.0.

      This causes errors on update like:

      General Error:SQL ERROR [ mysqli ]Table 'lcforum.lcforumoauth_states' doesn't exist [1146]SQLDELETE FROM lcforumoauth_states WHERE user_id = 28 in file J:\FPFPanel\domains\forum\phpbb\db\driver\driver.php on line 997

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. PHPBB3-15906 Two tables not being created during upgrades

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          was caused by solution of

          Bug - A problem which impairs or prevents the functions of the product. PHPBB3-15716 OAuth link information remains after deleting a user, causes fatal exception

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Marc Marc
              rxu rxu
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: