Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-13282

PostgreSQL error when creating boolean/dropdown custom profile fields

XMLWordPrintable

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

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

              Created:
              Updated:
              Resolved: