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

Duplicate entry in FORUMS_TRACK_TABLE

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Invalid
    • 3.0.5
    • None
    • Viewing posts
    • None
    • PHP Environment: 5.*
      Database: MySQL 5

    Description

      Topic: http://www.phpbb.com/community/viewtopic.php?f=46&t=1824885

      All 3 days, i've this too. (but then only one time)
      Problem is also existed in 3.0.5.

      viewtopic.php?f=2&t=1&start=
      Duplicate entry '2-2' for key 1 [1062]
      SQL
      INSERT INTO phpbb_forums_track (user_id, forum_id, mark_time) VALUES (2, 2, 1255265510), (2, 0, 1255265510)

      viewtopic.php?f=36&t=20&start=
      Duplicate entry '54-36' for key 1 [1062]
      SQL
      INSERT INTO phpbb_forums_track (user_id, forum_id, mark_time) VALUES (54, 36, 1254906529)

      Small, but good fix

      search:

       INSERT INTO

      replace with:

       INSERT IGNORE INTO

      Attachments

        Activity

          People

            Kellanved Kellanved [X] (Inactive)
            Kostenloses-Forum Kostenloses-Forum [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: