What version of phpBB are you using? phpBB 3.1.1
What is your board's URL? localhost
Who do you host your board with? none
How did you install your board? Please select your answer
What is the most recent action performed on your board? Please select your answer
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
What styles do you currently have installed? Prosilver
What language(s) is your board currently using? American English
Which database type/version are you using? PostgreSQL
What is your level of experience? Experienced with PHP and phpBB
When did your problem begin? After upgrade from 3.0.12 to 3.1.1. This is a test configuration on localhost.
Please describe your problem. I wish to reduce the size of my test database by pruning inactive users. In Prune users, I selected the following parameters:
Last active: Before 2014-06-30
Delete pruned user posts: Yes
Deactivate or delete: Delete
After waiting 15 minutes, I received the confirmation page listing 33526 members, all boxes are checked.
Then, are you sure you wish to carry out this operation? Yes
I am immediately taken the the Forums --> Prune forum entry screen in the administration control panel. There are no messages, no prune operation is performed.
The prune operation has failed silently. No other problems are experienced.
PostgreSQL database size: 12 GB
Total posts: 2076723
Total topics: 136982
Total members 37742
I could not locate this problem in the Area51 bug tracker. Has anyone experienced a similar problem? If so, I will report it as a bug.
I attempted a similar operation on my 3.0.12 database. The prune operation starts, then fails 2 hours later with:
Code: Select all
General Error SQL ERROR [ postgres ] ERROR: stack depth limit exceeded HINT: Increase the configuration parameter "max_stack_depth" (currently 2048kB), after ensuring the platform's stack depth limit is adequate.  SQL SELECT search_key FROM search_results WHERE search_keywords...(a very long message) BACKTRACE FILE: (not given by php) LINE: (not given by php) CALL: msg_handler() FILE: [ROOT]/includes/db/dbal.php LINE: 754 CALL: trigger_error() FILE: [ROOT]/includes/db/postgres.php LINE: 211 CALL: dbal->sql_error() FILE: [ROOT]/includes/search/search.php LINE: 283 CALL: dbal_postgres->sql_query() FILE: [ROOT]/includes/search/fulltext_native.php LINE: 1337 CALL: search_backend->destroy_cache() FILE: [ROOT]/includes/functions_admin.php LINE: 868 CALL: fulltext_native->index_remove() FILE: [ROOT]/includes/functions_user.php LINE: 496 CALL: delete_posts() FILE: [ROOT]/includes/acp/acp_prune.php LINE: 261 CALL: user_delete() FILE: [ROOT]/includes/acp/acp_prune.php LINE: 44 CALL: acp_prune->prune_users() FILE: [ROOT]/includes/functions_module.php LINE: 507 CALL: acp_prune->main() FILE: [ROOT]/adm/index.php LINE: 74 CALL: p_master->load_active()
Generated by SRT Generator