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

Cannot convert SQLite DB from 3.0.12 to 3.1.0

    XMLWordPrintable

Details

    Description

      Failing to convert DB from 3.0.12, step: process update from 3.1.0-dev

      SQL ERROR [ sqlite3 ]

      table phpbb_forums has no column named forum_posts_approved [1]

      SQL

      INSERT INTO phpbb_forums (display_subforum_list,forum_id,parent_id,left_id,right_id,forum_parents,forum_name,forum_desc,forum_desc_bitfield,forum_desc_options,forum_desc_uid,forum_link,forum_password,forum_style,forum_image,forum_rules,forum_rules_link,forum_rules_bitfield,forum_rules_options,forum_rules_uid,forum_topics_per_page,forum_type,forum_status,forum_topics,forum_topics_real,forum_last_post_id,forum_last_poster_id,forum_last_post_subject,forum_last_post_time,forum_last_poster_name,forum_last_poster_colour,forum_flags,display_on_index,enable_indexing,enable_icons,enable_prune,prune_next,prune_days,prune_viewed,prune_freq,forum_options,forum_posts_approved,forum_posts_unapproved,forum_posts_softdeleted,forum_topics_approved,forum_topics_unapproved,forum_topics_softdeleted) SELECT display_subforum_list,forum_id,parent_id,left_id,right_id,forum_parents,forum_name,forum_desc,forum_desc_bitfield,forum_desc_options,forum_desc_uid,forum_link,forum_password,forum_style,forum_image,forum_rules,forum_rules_link,forum_rules_bitfield,forum_rules_options,forum_rules_uid,forum_topics_per_page,forum_type,forum_status,forum_topics,forum_topics_real,forum_last_post_id,forum_last_poster_id,forum_last_post_subject,forum_last_post_time,forum_last_poster_name,forum_last_poster_colour,forum_flags,display_on_index,enable_indexing,enable_icons,enable_prune,prune_next,prune_days,prune_viewed,prune_freq,forum_options,forum_posts_approved,forum_posts_unapproved,forum_posts_softdeleted,forum_topics_approved,forum_topics_unapproved,forum_topics_softdeleted FROM phpbb_forums_temp;

      BACKTRACE

      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()

      FILE: [ROOT]/phpbb/db/driver/driver.php
      LINE: 745
      CALL: trigger_error()

      FILE: [ROOT]/phpbb/db/driver/sqlite3.php
      LINE: 133
      CALL: phpbb\db\driver\driver->sql_error()

      FILE: [ROOT]/phpbb/db/tools.php
      LINE: 1506
      CALL: phpbb\db\driver\sqlite3->sql_query()

      FILE: [ROOT]/phpbb/db/tools.php
      LINE: 2017
      CALL: phpbb\db\tools->_sql_run_sql()

      FILE: [ROOT]/phpbb/db/tools.php
      LINE: 909
      CALL: phpbb\db\tools->sql_column_remove()

      FILE: (not given by php)
      LINE: (not given by php)
      CALL: phpbb\db\tools->perform_schema_changes()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 457
      CALL: call_user_func_array()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 403
      CALL: phpbb\db\migrator->run_step()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 242
      CALL: phpbb\db\migrator->process_data_step()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 204
      CALL: phpbb\db\migrator->try_apply()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 204
      CALL: phpbb\db\migrator->try_apply()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 204
      CALL: phpbb\db\migrator->try_apply()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 204
      CALL: phpbb\db\migrator->try_apply()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 204
      CALL: phpbb\db\migrator->try_apply()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 204
      CALL: phpbb\db\migrator->try_apply()

      FILE: [ROOT]/phpbb/db/migrator.php
      LINE: 155
      CALL: phpbb\db\migrator->try_apply()

      FILE: [ROOT]/install/database_update.php
      LINE: 234
      CALL: phpbb\db\migrator->update()

      Attachments

        Activity

          People

            bantu Andreas Fischer [X] (Inactive)
            Boris Berdichevski Boris Berdichevski [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: