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

Profile Update causes MySQL Error

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 3.1.3
    • Fix Version/s: 3.1.10-RC1
    • Labels:
      None
    • Environment:
      MySQL version 5.1.73
      PHP Version 5.3.3
      Browser Chrome Mac 40.0.2214.115 (64-bit)

      Description

      Reproduction:
      (hint: I use the german translation and thus have to translate everything back to english for the bug report. So please forgive me, if not all terms are exactly like they would be in an English phpBB)

      1. Login to Board
      2. Click your "Username", then "Profile"
      3. Click "Change Profile"
      4. Alter your date of birth
      5. Click "Submit"
      => MySQL Error:
      Duplicate entry '2' for key 'PRIMARY' [1062]

      For the exact result please see the screenshot. I already tried this with different users and I tried to repair the database.

      What seems strange to me ist that phpBB tries an INSERT where I only want to alter my profile data.

      Maybe this is related? http://stackoverflow.com/questions/6153552/mysql-error-1062-duplicate-entry-for-key-2

      Many thanks for any help!

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                CHItA CHItA
                Reporter:
                hai2210 hai2210 [X] (Inactive)
              • Votes:
                3 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: