-
Bug
-
Resolution: Won't Fix
-
Major
-
3.0.1
-
None
-
Database: MySQL 5.0.46
During installation, the schema that gets used to create the tables and populate them with initial data does not specify id's for certain fields, but later refers to those entries assuming that the id's inserted into an auto_increment field will start at 1 and increment by 1. This is not always the case – for example, when MySQL is setup in a Master-Master replication setting, the auto_increment settings will be setup so that the two servers don't have conflicting auto_increment numbers. For example, a MySQL server may be setup to start an auto_increment column at 2 and increment by 3 each insert.
The schema used for the phpBB install causes the forum to be unusable after a standard install when the MySQL server is setup this way.
I am attaching a patch to the schema file which sets the _id fields where needed. I have tested this out on one MySQL db where the auto increment settings are as follows:
auto_increment_increment = 3
auto_increment_offset = 2
- is duplicated by
-
PHPBB-14728 Install SQL schema expects style_id to be '1'
- Open
-
PHPBB-15658 Forum won't install correctly with SQL master-master configuration
- Open
-
PHPBB-9043 auto_increment_increment breaks install
- Closed
-
PHPBB-10097 phpBB3 assumes that for a MySql database the auto_increment is set to 1. As with many load balanced MySql server setups this is not true for us. Having an auto_increment of 2 means that all the foreign keys (and other data) is wrong.
- Closed