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

Fix DB error in update_profile_field_data() with disabled fields

    XMLWordPrintable

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

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

            Dates

              Created:
              Updated:
              Resolved: