PHPBB3-12865

Discuss requests for comments/changes posted in the Issue Tracker for the development of phpBB. Upcoming releases are 3.2/Rhea and 3.3.
Post Reply
Ogion
Registered User
Posts: 1
Joined: Mon Aug 17, 2015 6:10 pm

PHPBB3-12865

Post by Ogion » Mon Aug 17, 2015 6:30 pm

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

Reopen, I think.

Image

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.

User avatar
A_Jelly_Doughnut
Registered User
Posts: 1780
Joined: Wed Jun 04, 2003 4:23 pm

Re: PHPBB3-12865

Post by A_Jelly_Doughnut » Tue Aug 18, 2015 8:04 pm

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.
A_Jelly_Doughnut

User avatar
VSE
Extension Customisations
Extension Customisations
Posts: 670
Joined: Mon Mar 08, 2010 9:18 am

Re: PHPBB3-12865

Post by VSE » Wed Aug 19, 2015 4:54 am

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.
Has an irascible disposition.

User avatar
A_Jelly_Doughnut
Registered User
Posts: 1780
Joined: Wed Jun 04, 2003 4:23 pm

Re: PHPBB3-12865

Post by A_Jelly_Doughnut » Fri Aug 21, 2015 12:12 am

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

User avatar
VSE
Extension Customisations
Extension Customisations
Posts: 670
Joined: Mon Mar 08, 2010 9:18 am

Re: PHPBB3-12865

Post by VSE » Fri Aug 21, 2015 3:32 am

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

Post Reply