vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Show Thread Enhancements - [AJAX] Post Thank You Hack (https://vborg.vbsupport.ru/showthread.php?t=165673)

BirdOPrey5 03-03-2012 12:07 AM

This has to modify the post table so it can take a long time. It's possible it may even time out.

I would suggest closing your forum before trying to install again.

You can open the xml file and you will see the queries it tries to run during install- you may try running them manually.

Gladius2007 03-03-2012 02:57 AM

Thanks for the response - I actually "fixed" it by rerunning the install - that went through the ACP skin reload and the final steps in like 2 seconds and everything SEEMS to be working now (*knocks on wood*). Maybe it initially timed out just before completing, or was it the fact that I didn't tick YES on overwrite? I thought that that was relevant only for upgrades, but I did it the second time around for obvious reasons...

Simon Lloyd 03-03-2012 04:13 PM

Like BOP5 said it does take a long time if you have a large post table, if it timed out then ticking the overwrite was the right thing to do although it may not have completed the whole post table, but if it appears to be working then all well and good :)

Gladius2007 03-03-2012 06:54 PM

Hm, is there any easy way to check if it properly processed the whole post table?

BirdOPrey5 03-03-2012 07:08 PM

Check using phpmyadmin (or whatever you want) to check if you have this field in the post table: post_thanks_amount

Also make sure every entry is set to 0 or a number. You can sort the results by this field and make sure there aren't any empty entries.

Gladius2007 03-03-2012 07:53 PM

Is there a query I could run to check this? I've got over 15k user records...

BirdOPrey5 03-03-2012 08:02 PM

In phomyadmin simply "browse" the table... Click on the field name post_thanks_amount and it will sort the column from lowest to highest value. Make sure the first value is zero.

Then click on the post_thanks_amount field again, now it will sort results from highest to lowest... Make sure again that there is a number in that box too.

If the highest and lowest values are both numbers you are good.

Gladius2007 03-03-2012 10:00 PM

Hm... I've got a separate table "vb_post_thanks" and it contains the usernames of the members who have given thanks...

Inside the post table / post_thanks_amount / all I see is this:

Code:

Rows        post_thanks_amount Ascending
764596        0
1        1
1        5

Note that only two users have received thanks so far... so does that look right?

BirdOPrey5 03-03-2012 11:12 PM

The default value for post_thanks_amount was 0 so I think every post (except the 2 that got thanks) should show 0.

But if it's working, don't worry about it.

Gladius2007 03-03-2012 11:38 PM

Ok, thanks.


All times are GMT. The time now is 03:07 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.05081 seconds
  • Memory Usage 1,733KB
  • 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_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete