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

phpBB DB Error: Deleting a retained post from deleted user

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Cannot Reproduce
    • 3.1.3
    • None
    • None
    • PHP 5.4.37, MySQL lnd 5.0.10, Chrome 41.0.2272.89

    Description

      Steps to reproduce

      1) create an user account
      2) make a post, approved
      3) Have Admin delete newly created account and select "retain posts" option
      4) Have admin/moderator delete the post created in step 2
      5) Click Permanently delete this post
      6) phpBB database error showing SQL of trying to do user_posts = user_posts - 1 on the user that was deleted

      The post was deleted, but the error message showed and error containing SQL code (this should also be hidden by default which could allow someone to learn tables and field names).

      After going back to the topic, the post was deleted.

      I've done this a few times and sometimes it errors out and sometimes it doesn't. I haven't been able to figure out why some deleted user posts gives this error and why others continue to work.

      Attachments

        Activity

          People

            Marc Marc
            shurijo shurijo [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: