vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB5 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=262)
-   -   Remove post through database and reset Topics and Posts count (https://vborg.vbsupport.ru/showthread.php?t=322969)

nmohapata123 07-04-2016 09:32 AM
Remove post through database and reset Topics and Posts count
 
Hi All,

I need to remove post from database,it can be by deleting post from node table but facing only one problem, that topics and posts count remains unchanged,

Need help to reset Topics and Posts Count in database table.

Thanks in Advance

Replicant 07-04-2016 11:27 AM
Deleting a post from the node table is not the way to do it. There are other tables involved that need to be deleted and or updated as well. You should use the system API to delete from the database. Then the post counts and so forth would be automatically updated.

nmohapata123 07-05-2016 04:16 AM
Quote:
Originally Posted by Replicant (Post 2572757)
Deleting a post from the node table is not the way to do it. There are other tables involved that need to be deleted and or updated as well. You should use the system API to delete from the database. Then the post counts and so forth would be automatically updated.
can you please tell me about other tables associated with node.

Paul M 07-05-2016 09:03 AM
Why do you need to try and do it via the database (which is a very bad idea) and not just through the front end ?


All times are GMT. The time now is 12:59 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.01912 seconds
  • Memory Usage 1,712KB
  • 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)bbcode_quote_printable
  • (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