PHPBB3-12865

[Ogion]

https://tracker.phpbb.com/browse/PHPBB3-12865

Reopen, I think.



Installed just Russian language pack, and after that error installed some themes.
PHPBB Version 3.1.5
Php version: 5.3.3
Mysql version: 5.1.73
OS: Centos. uname -a: 2.6.32-573.1.1.el6.x86_64

Solution with adding in .htaccess doesn't works with string :AddType application/x-httpd-php55.php
First saw that problem with board announcements module.

On another server, with higher php version there is no problem.

I will try to import his base into my, and will write here result.

[A_Jelly_Doughnut]

This bit of code (phpbb\config\db_text()) is basically unchanged from phpBB 3.0. (Update, if affected_rows == 0 then insert) If there's a bug, I'd suggest it is in that particular PHP version or possibly some kind of server configuration.

[MattF]

I believe the hot-fix we found for people who experienced that error was to switch from mysqli to mysql in their config file. Though it does seem to be happening to people using PHP 5.3.3. No one on the teams have been able to reproduce it AFAIK.

Edit: I just reproduced it with PHP 5.3.5 and a vanilla install by trying to add some content to the Contact Admin Form

Code: Select all

SQL ERROR [ mysqli ]

Duplicate entry 'contact_admin_info_uid' for key 'PRIMARY' [1062]

SQL

INSERT INTO phpbb_config_text (config_name, config_value) VALUES ('contact_admin_info_uid', '')

BACKTRACE

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

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

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

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/config/db_text.php
LINE: 111
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/acp/acp_contact.php
LINE: 93
CALL: phpbb\config\db_text->set_array()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: acp_contact->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

Using PHP 5.3.29 or above the error does not occur (but I don't have any other PHP versions between 5.3.5 to 5.3.29) so must be some kind of PHP issue in those older versions.

[A_Jelly_Doughnut]

I wonder if it is related to this php bug: https://bugs.php.net/bug.php?id=55582

[MattF]

I actually found that it's fixed from 5.3.6 and above. People just need to update, honestly... Get to 5.6 already!