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

Profile Update causes MySQL Error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 3.1.3
    • 3.1.10-RC1
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: