vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Problem with soft delete query (https://vborg.vbsupport.ru/showthread.php?t=212098)

vbplusme 04-24-2009 05:32 PM

Problem with soft delete query
 
Hello and Greetings,

I found a query:

Code:

DELETE FROM " . TABLE_PREFIX . "post WHERE visible = '2'
It does indeed remove a soft post from the database but it does not clear the post from the thread. What do I need to do to tell vB that the soft delete post is gone?

TIA

Lynne 04-24-2009 05:53 PM

What do you mean "clear it from the thread"? Is it still showing up in the showthread page or do you mean it is still listed as the last post of the thread or ??

vbplusme 04-25-2009 12:01 AM

Its a test "thread" ... I looked at this thing for hours thinking that it was a "post", oops! Just check the posts that I deleted with the query and they are indeed gone.

Edit: In case this is not clear, if you are trying to get rid of "soft deletes" via a CRON hack, you have to do two queries, one to get rid of the "posts" and another if you want to delete "threads". For example, a member creates a thread, adds a post then figures out its a mistake and deletes it. If you use the query above it only removes the "post". You have to run a second query to remove the soft delete on the thread:

Code:

DELETE FROM " . TABLE_PREFIX . "thread WHERE visible = '2'

HTH


All times are GMT. The time now is 08:49 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.01581 seconds
  • Memory Usage 1,707KB
  • 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
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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