Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 23 Oct 2009, 01:44
SnapOff Racing SnapOff Racing is offline
 
Join Date: Apr 2006
How does the postparsed table work?

I'm wondering how the postparsed table works because I ran the query TRUNCATE TABLE `postparsed` to clear it out so that I could rebuild it. Then went into my AdminCP -> Maintenance -> Rebuild Post Cache but it keeps rebuilding the cache with duplicate values. Like there are 3 rows for the same exact postid. Do I need to run like an AUTO_INCREMENT=1 query on the table or something??
Reply With Quote
  #2  
Old 23 Oct 2009, 01:46
Adrian Schneider's Avatar
Adrian Schneider Adrian Schneider is offline
 
Join Date: Jul 2004
Its per style... so if you have 3 styles, you may end up with 3 values for each post.
Reply With Quote
  #3  
Old 23 Oct 2009, 01:52
SnapOff Racing SnapOff Racing is offline
 
Join Date: Apr 2006
Ahhhhh ok that makes sense then. I will just TRUNCATE the table, Rebuild Post cache and then run a query to remove the unneeded rows.

Do you know if there is a way that vb clears out un-used post cache that hasn't been used in like X amount of days? Like a cron job or something?

Thanks for the help!

Last edited by SnapOff Racing; 23 Oct 2009 at 02:07.
Reply With Quote
  #4  
Old 23 Oct 2009, 07:04
Adrian Schneider's Avatar
Adrian Schneider Adrian Schneider is offline
 
Join Date: Jul 2004
There's an option in the AdminCP that determines how long cached posts stick around for. I think it's called "Cached Posts Lifespan" or something similar.

When viewing a post, it'll see if the cache is too old, and then regenerate a new one if it is.
Reply With Quote
  #5  
Old 23 Oct 2009, 07:23
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
Just truncate the table. Posts will be automatically rebuilt and cached by themselves on first view.
__________________
View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #6  
Old 23 Oct 2009, 18:40
SnapOff Racing SnapOff Racing is offline
 
Join Date: Apr 2006
Thanks Guys!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 22:27.

Layout Options | Width: Wide Color: