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

Fix DB error in update_profile_field_data() with disabled fields

    Details

      Description

      SQL ERROR [ mysqli ]
       
      Field 'pf_phpbb_interests' doesn't have a default value [1364]
       
      SQL
       
      INSERT INTO phpbbi_profile_fields_data (pf_phpbb_location, pf_phpbb_website, user_id) VALUES ('test', '', 2)
       
      BACKTRACE
       
      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()
       
      FILE: [ROOT]/phpbb/db/driver/driver.php
      LINE: 803
      CALL: trigger_error()
       
      FILE: [ROOT]/phpbb/db/driver/mysqli.php
      LINE: 181
      CALL: phpbb\db\driver\driver->sql_error()
       
      FILE: [ROOT]/phpbb/profilefields/manager.php
      LINE: 238
      CALL: phpbb\db\driver\mysqli->sql_query()
       
      FILE: [ROOT]/includes/ucp/ucp_profile.php
      LINE: 347
      CALL: phpbb\profilefields\manager->update_profile_field_data()
       
      FILE: [ROOT]/includes/functions_module.php
      LINE: 629
      CALL: ucp_profile->main()
       
      FILE: [ROOT]/ucp.php
      LINE: 350
      CALL: p_master->load_active()

      The error is currently surpressed by sql_return_on_error() which should be removed aswell.

        Attachments

          Activity

            People

            • Assignee:
              nickvergessen Joas Schilling
              Reporter:
              nickvergessen Joas Schilling
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: