Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
3.1.1
-
None
Description
When creating custom profile fields (either via the ACP or migrations) using PostgreSQL, the DBAL will throw errors when creating custom profile fields with of types boolean and dropdown. Most likely because these fields use default NULL.
SQL ERROR [ postgres ]
|
|
|
ERROR: invalid input syntax for integer: "" []
|
|
|
SQL
|
|
|
ALTER TABLE phpbb_profile_fields_data ADD COLUMN "pf_foobar" INT4 NULL DEFAULT '' CHECK (pf_foobar >= 0)
|
|
|
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/postgres.php
|
LINE: 191
|
CALL: phpbb\db\driver\driver->sql_error()
|
|
|
FILE: [ROOT]/phpbb/db/driver/factory.php
|
LINE: 329
|
CALL: phpbb\db\driver\postgres->sql_query()
|
|
|
FILE: [ROOT]/phpbb/db/tools.php
|
LINE: 1428
|
CALL: phpbb\db\driver\factory->sql_query()
|
|
|
FILE: [ROOT]/phpbb/db/tools.php
|
LINE: 1801
|
CALL: phpbb\db\tools->_sql_run_sql()
|
|
|
FILE: [ROOT]/includes/acp/acp_profile.php
|
LINE: 885
|
CALL: phpbb\db\tools->sql_column_add()
|
|
|
FILE: [ROOT]/includes/acp/acp_profile.php
|
LINE: 550
|
CALL: acp_profile->save_profile_field()
|
|
|
FILE: [ROOT]/includes/functions_module.php
|
LINE: 674
|
CALL: acp_profile->main()
|
|
|
FILE: [ROOT]/adm/index.php
|
LINE: 81
|
CALL: p_master->load_active()
|