-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
3.1.9
-
None
-
PHP 5.6.24, MariaDB Galera 10.0.26
Hello,
We're using a MariaDB Galera cluster which decide automatically what the next auto_increment id will be.
The current installer always expects the default_style id to be 1 while it relies on the systems auto_increment id on insert:
phpBB3/install/schemas/schema_data.sql |
96: INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style', '1');
|
473: INSERT INTO phpbb_styles (style_name, style_copyright, style_active, style_path, bbcode_bitfield, style_parent_id, style_parent_tree) VALUES ('prosilver', '© phpBB Limited', 1, 'prosilver', 'kNg=', 0, '');
|
Better (easy) is to assign 1 to the record like this:
INSERT INTO phpbb_styles (style_id, style_name, style_copyright, style_active, style_path, bbcode_bitfield, style_parent_id, style_parent_tree) VALUES (1, 'prosilver', '© phpBB Limited', 1, 'prosilver', 'kNg=', 0, '');
|
Or change the code that it will add the default style dynamically. I don't know if the default install relies on other fixed IDs (which is bad practice of course).
Let me know if you need any more information.
Regards,
Daan
- duplicates
-
PHPBB-7215 Installation schema assumes auto_increment will start at 1, increment by 1
- Closed
- is related to
-
PHPBB-15182 Install all styles from styles folder during install
- Open