Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-4541

SQL-error while deleting multiple pages

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • 3.0.0
    • 3.0.RC1
    • None
    • PHP Environment: 4.x
      Database: PostgreSQL 7.3

      While I was deleting my trash-forum, trought moderator's control panel. I was able delete few pages before I got this message:

      Yleinen virhe
      SQL ERROR [ postgres ]

      ERROR: new row for relation "olympus_users" violates check constraint
      "olympus_users_user_posts" []

      SQL

      UPDATE olympus_users SET user_posts = user_posts - 221 WHERE user_id = 1

      BACKTRACE

      FILE: includes/db/postgres.php
      LINE: 177
      CALL: dbal_postgres->sql_error()

      FILE: includes/functions_admin.php
      LINE: 664
      CALL: dbal_postgres->sql_query()

      FILE: includes/functions_admin.php
      LINE: 523
      CALL: delete_posts()

      FILE: includes/mcp/mcp_main.php
      LINE: 774
      CALL: delete_topics()

      FILE: includes/mcp/mcp_main.php
      LINE: 111
      CALL: mcp_delete_topic()

      FILE: includes/functions_module.php
      LINE: 460
      CALL: mcp_main->main()

      FILE: mcp.php
      LINE: 231
      CALL: p_master->load_active()

      Ole hyvja ilmoita ttkeskustelufoorumin ylitle, tai webmasterille:

            Kellanved Kellanved [X] (Inactive)
            |rocky |rocky
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: