vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Improve performance on thread view updating (https://vborg.vbsupport.ru/showthread.php?t=78232)

mute 06-17-2005 05:33 PM

Does anyone know if this made its way into 3.5.0?

lazee 06-29-2005 01:21 AM

I used this one smooth and help my board alot with no problem ,but today when i notice that the thead didn't count when people view , i ran the cron job theadview in schedules and i got this error :
Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO threadviewsaggregate SELECT threadid , COUNT(*) AS views FROM threadviews GROUP BY threadid
mysql error: Duplicate entry '40' for key 1

mysql error number: 1062

Date: Tuesday 28th of June 2005 08:09:36 PM
Script: http://xx.com/forum/admincp/cronadmi...ncron&cronid=2
Referer: http://xx.com/forum/admincp/index.php?

anyone got any idea why i got this and how to fix ,thank in advance . I used to run the threadview before and nerver got this error . before this error, i didn't restore db or install anything .

kmike 06-29-2005 04:27 AM

You should empty threadviewsaggregate table. It is cleared at the end of cron script run, but it didn't happen at some point for some reason. Theoretically, it can happen when you shutdown http server in the middle of cron job run.

lazee 07-03-2005 07:05 PM

Thank Kmike .it working after i empty the threadview.. . I think i did restart the apache that was cause the problem like you said .

michaelbenson 09-23-2005 05:48 AM

Erm, where exactly is this threadviews.php file?
I have tried looking around and i am using 3.0.9 has it since been removed?

Andreas 09-23-2005 06:53 AM

includes/cron


All times are GMT. The time now is 01:16 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.00994 seconds
  • Memory Usage 1,717KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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