Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-13282

PostgreSQL error when creating boolean/dropdown custom profile fields

    Details

      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()
      

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Marc Marc
            Reporter:
            PayBas PayBas [X] (Inactive)
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development