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

Mod CP lists Global Announcements when moderating forum

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • 3.0.5
    • 3.0.4
    • None
    • PHP Environment:
      Database:

      When moderating a forum, the ModCP lists global topics when moderating.

      This causes some bad errors. For instance when I went to mass move all the posts in a forum to another section, I recieved the uninformative:


      SQL ERROR [ postgres ]

      ERROR: new row for relation "phpbb_forums" violates check constraint "phpbb_forums_forum_posts_check" []

      SQL

      UPDATE phpbb_forums SET forum_posts = forum_posts - 56, forum_topics_real = forum_topics_real - 13, forum_topics = forum_topics - 13 WHERE forum_id = 14

      BACKTRACE

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

      FILE: includes/mcp/mcp_main.php
      LINE: 715
      CALL: dbal_postgres->sql_query()

      FILE: includes/mcp/mcp_main.php
      LINE: 93
      CALL: mcp_move_topic()

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

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

      The forum only has 55 actual posts in there, with 1 global announcement. The Mod CP should handle this without having the DB die in an uninteresting way.

            Acyd Burn Meik Sievertsen [X] (Inactive)
            overlordq2 overlordq2
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: