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

Duplicate entry phpbb_profile_fields_data

    XMLWordPrintable

Details

    Description

      When i update profile data from ucp and there is no change in custom field
      i have the next error. for exemple if i modify only my birthday.

      SQL ERROR [ mysqli ]
       
      Duplicate entry '2' for key 'PRIMARY' [1062]
       
      SQL
       
      INSERT INTO phpbb_profile_fields_data (pf_phpbb_interests, pf_phpbb_occupation, pf_phpbb_location, pf_phpbb_icq, pf_phpbb_website, pf_phpbb_wlm, pf_phpbb_yahoo, pf_phpbb_aol, pf_phpbb_facebook, pf_phpbb_googleplus, pf_phpbb_skype, pf_phpbb_youtube, pf_phpbb_twitter, user_id) VALUES ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 2)
       
      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/mysqli.php
      LINE: 194
      CALL: phpbb\db\driver\driver->sql_error()
       
      FILE: [ROOT]/phpbb/db/driver/factory.php
      LINE: 329
      CALL: phpbb\db\driver\mysqli->sql_query()
       
      FILE: [ROOT]/phpbb/profilefields/manager.php
      LINE: 249
      CALL: phpbb\db\driver\factory->sql_query()
       
      FILE: [ROOT]/includes/ucp/ucp_profile.php
      LINE: 350
      CALL: phpbb\profilefields\manager->update_profile_field_data()
       
      FILE: [ROOT]/includes/functions_module.php
      LINE: 674
      CALL: ucp_profile->main()
       
      FILE: [ROOT]/ucp.php
      LINE: 369
      CALL: p_master->load_active()
      

      Attachments

        Issue Links

          Activity

            People

              prototech prototech [X] (Inactive)
              dkone164 dkone164 [X] (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: