Moving a topic to another forum prompts a database error

[siwode]

My forum has these two topic threads that won't move to another forum. Other topics can be moved to another forum....

so..Can this error be fixed?

Code: Select all

SQL ERROR [ mysqli ]

BIGINT UNSIGNED value is out of range in '(`mywebsql`.`phpbb_forums`.`forum_posts_approved` - 7)' [1690]

SQL

UPDATE phpbb_forums SET forum_posts_approved = forum_posts_approved - 7, forum_topics_approved = forum_topics_approved - 1 WHERE forum_id = 15

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1031
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 211
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 353
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/includes/mcp/mcp_main.php
LINE: 761
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/includes/mcp/mcp_main.php
LINE: 112
CALL: mcp_move_topic()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: mcp_main->main()

FILE: [ROOT]/includes/functions_module.php
LINE: 1006
CALL: p_master->load_active()

FILE: [ROOT]/mcp.php
LINE: 211
CALL: p_master->load()

[siwode]

Another problem is that the number of online users on my forum is very unstable, showing an average of 100 users per day, which is not a true reflection of the number of online users. In a very short period of time my database table phpbb_sessions explodes. mysql then dips into the server CPU How can I solve this problem?...

[rxu]

Can this error be fixed?

You might want to try syncronizing the forum via ACP/Forums/Manage forums tool clicking the "refresh" icon in the appropriate forum row, like on the screenshot.

Снимок экрана 2025-05-07 115302.png