vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Prune users (https://vborg.vbsupport.ru/showthread.php?t=325106)

sonic83 05-19-2017 06:35 AM

Prune users
 
Hello friends, I want to prune users of my forum but they are more than 10,000 and gives error. From what I read in vbulletin this happens when there are too many. They all have the same registration date so I can not make smaller groups and delete them.

I've thought about deleting them from the database, emptying tables that allude to users, except the admin row.

My question is, apart from the table "USER", are there more tables that I must also empty to avoid incompatibilities?

Thank you

snakes1100 05-19-2017 07:41 AM

Raise max_input_vars in php.ini to accommodate pruning that many users, may want to raise max_execution_time as well while doing that many at once.

Paul M 05-19-2017 10:13 AM

Dont go deleting records from the database, the chance you may break something isnt worth it.

Use a query to move blocks of them to a usergroup thats empty, and then prune them properly.

sonic83 05-21-2017 10:10 AM

thank you sirs


All times are GMT. The time now is 06:03 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00964 seconds
  • Memory Usage 1,706KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (4)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete