vb.org Archive - Thread Count

Page 10 of 10

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Thread Count (https://vborg.vbsupport.ru/showthread.php?t=74473)

mrpibbny

07-18-2005 01:28 AM

I have 2,600 threads, that isn't the problem. I wish I was better at this stuff. :ninja:

tanyeri24

10-12-2005 02:01 AM

also works under 3.5.0 ?

MajorFm.com

10-12-2005 04:02 PM

Was the ever a fix for this? we cant all be wrong...?

hotwheels

12-20-2005 07:44 AM

I just installed it tonite on 3.07 and it worked perfectly....

Quote:

Join Date: Jul 2005
hotwheels's Garage
Location: Cheyenne, Wyoming
Last Seen: 1 Minute Ago (04:34 AM)
Posts: 8,079
Threads: 1205
Time spent in forums: 2 Weeks 2 Days 14 hours 16 minutes 44 seconds
Average time: 2 hours 24 minutes 11 seconds

when you guy's are running the update counter, are you going mysite.com/forum/admincp/misc.php?do=threadcount ? I ran it this way and it has you log in, then it does an automatic update. Mine was forums/admincp but it worked.

hotwheels

here is a random member i checked, just to see if it is working:

Quote:

Join Date: Oct 2005
1993SE's Garage
Location: Laramie, Wy
Last Seen: 18 Minutes Ago (04:28 AM)
Posts: 510
Threads: 28
Time spent in forums: 1 Day 23 hours 50 minutes 19 seconds
Average time: 56 minutes 57 seconds

PIKenPIK

12-30-2005 06:18 PM

same probs here on VB 3.07.
like the others same DB error:

Quote:

Invalid SQL: SELECT userid FROM user ORDER BY userid DESC LIMIT -1000, 1000
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1000, 1000' at line 1

mysql error number: 1064

Date: Friday 30th of December 2005 08:53:55 PM
Script: http://www.www.xxxxxxxx.xx/forums/ad...ge=1000&page=2
Referer: http://www.xxxxxxxx.xx/forums/adminc...do=threadcount
Username: PIKenPIK
IP Address: XXXXXXXXXXX

First page seems to go well, starting with the 2nd 1.000 threads doesn't work.

Changing in misc.php: $perpage = 1000 into $perpage = 250 gives the same ...

I'm sure it's no memory prob ..... I've done major hacks and 20.000 members on the forum (done lots of maintenance with +1.000 "things" without problems) ...

Can this be fixed?

Really need the hack for further (promotion)plans.

XXX
PnP

//edit: i don't have a table prefix. (so that's not the prob).

b00k	01-02-2006 11:12 PM

Quote:

Originally Posted by Zachery

d'oh how could i forget that

for now use this

Code:

<div>

                                                $vbphrase[posts]: $post[posts]

                                        </div>

add under

Code:

<div>

                                                $vbphrase[threads]: $post[threads]

                                        </div>

for those unsure, add this to your postbit_template. Once you do this and run the update it wil start counting NEW THREADS.

sybakaos

04-02-2006 06:00 PM

Those having problems with thread updates (misc.php step) set

$perpage = 1000;

To the number of threads you have. For example, I have a forums with 140k threads. I changed the code to:

$perpage = 140000;

This is -not- a fix for this hack but a way to omit the (possible) faulty code for forums over 1000 threads..

Enjoy!

mrpibbny

06-03-2006 06:12 PM

I get the following error when I access the last instruction -

Quote:

Database error in vBulletin 3.0.8:

Invalid SQL: UPDATE user SET threads = 0 WHERE userid = 180
mysql error: Unknown column 'threads' in 'field list'

mysql error number: 1054

Date: Saturday 03rd of June 2006 03:06:41 PM
Script: http://c0h0rt.org/forum/admincp/misc.php?do=threadcount
Referer:
Username: stackzilla
IP Address: 24.195.194.67

Any thoughts as to what I did wrong?

4Prometheus

11-21-2006 11:20 PM

Where is INSTALL?

Thank you very much for taking the time and trouble to share a working hack.

Happy Holidays!

Peace.

All times are GMT. The time now is 08:20 AM.

Page 10 of 10

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01325 seconds Memory Usage 1,740KB 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 (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (9)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
Messages: