-
Bug
-
Resolution: Fixed
-
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.