vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   psiStats 2006 (The New vBStats for vBulletin 3.5.x - 3.8.x) (https://vborg.vbsupport.ru/showthread.php?t=104213)

PoetJA-1975 10-06-2006 12:13 AM

hmmm - I've had psiStats on JPiC for over 24 hours now - and I don't believe it's updated once since install - You did give me an idea though...

About the cron... I checked in my ADMIN CP for scheduled tasks and didn't see the psiStats Update cron added, though I'm sure I uploaded it in the original installation...

So I went to AdminCP ------> Scheduled Tasks -----> Add New Scheduled Task and added the cron manually.

Question: What are the correct variables I should use to make the cron update every 15 minutes?

Jacquii.

akanevsky 10-06-2006 12:53 AM

Quote:

Originally Posted by PoetJA-1975
hmmm - I've had psiStats on JPiC for over 24 hours now - and I don't believe it's updated once since install - You did give me an idea though...

About the cron... I checked in my ADMIN CP for scheduled tasks and didn't see the psiStats Update cron added, though I'm sure I uploaded it in the original installation...

So I went to AdminCP ------> Scheduled Tasks -----> Add New Scheduled Task and added the cron manually.

Question: What are the correct variables I should use to make the cron update every 15 minutes?

Jacquii.

Hmm, it should have been added. The is_newer_version() function of vBulletin seems to be buggy though... Anyway, please run the following query to create the cron:

[SQL]INSERT INTO `cron` VALUES (NULL, 1136665500, -1, -1, -1, 'a:1:{i:0;i:25;}', './includes/cron/psistats_update.php', 1, 'psiStats 2006 Update (15-Minute Interval)')[/SQL]

PoetJA-1975 10-09-2006 03:27 AM

Well - I did the query and the cron updates - But I've seen numerous DB errors:

Quote:

Database error in vBulletin 3.5.4:

Invalid SQL:
LOCK TABLES psistats_cache READ, psistats_data READ;

MySQL Error : Access denied for user '********' to database '*******'
Error Number : 1044
Date : Sunday, October 8th 2006 @ 10:34:41 PM
Script : http://jpicforum.info/cron.php?&rand=39200
Referrer : http://jpicforum.info/search.php?searchid=3347
IP Address : ************
Username : Unregistered
Classname : vB_Database
I actually have spent the last hour or so reading this entire thread. Seems others have had similar probs and one of the solutions was to comment out a line in ...includes/functions_cron.php

PHP Code:

$vbulletin->db->close(); 

In 3.5.4 that line is nowhere to be seen. So at the risk of appearing like a complete and utter dummy - Is there anything I can possibly to do to make the elements I talked about earlier actually show up in the stats? Is there a way that I can make the cron function work appropriately for my 3.5.4?

ALSO concern: sure this prolly has been answered - but the IP Address and Username in the Database error is different a lot of times and I'm wondering - WTF???

At anyrate - I'd love to have this working for my board, as it is a fabulous idea and could really help me in future promotional activities!

So HELP! And if you call me a dummy - I'm actually inclined to nod my head in a gesture of YEP lol - Don't know much about the coding thing - But seriously - would love to have this one working ;)

Thanx again for providing such a wonderful addition - Just want it working properly!

Jacquii.

akanevsky 10-09-2006 10:53 AM

Quote:

In 3.5.4 that line is nowhere to be seen. So at the risk of appearing like a complete and utter dummy - Is there anything I can possibly to do to make the elements I talked about earlier actually show up in the stats? Is there a way that I can make the cron function work appropriately for my 3.5.4?
Please read the FAQ post, 2nd in this thread. :)

Quote:

ALSO concern: sure this prolly has been answered - but the IP Address and Username in the Database error is different a lot of times and I'm wondering - WTF???
Different IP - People have different IPs.
Different Username - People have different Usernames, too. It doesn't only happen for you.

PoetJA-1975 10-09-2006 11:10 AM

OH - But I think I'm special ;)
OK OK OK - I suppose I will contact my webhost about the lock table DB error.
At anyrate - thanx for not cursing me out and adding to your ignore list LOL
I will let you know the status when I hear back from my webhost - Thanx for taking the time to remind me about the faq :P

Jacquii.

PoetJA-1975 10-10-2006 03:40 AM

Hey PSIONIC - thanx very much! It's working 100% now and is an AWESOME addition to JPiC!

Really nice work - cheers!

Jacquii.

jwashburn 10-26-2006 12:52 PM

Quote:

Originally Posted by 3z3k3l
Wow can someone tell me what happened?
I have 1500 email messages from this database error, I logged in via phpmyadmin and empted the table and things seem to be back to normal.
I have made no changes to the site in the past 24-48 hours, it looks like a bot or something messed with the stats somehow.

Will this happen again? Anyone know what happened, thanks!


I have the exact same problem and the table are gone completley. I have tried making them by hand with no luck. I have tried the diable hooks plan, but then I get new errors. I still cant get into my admincp to fix it.

I am down for 2 days now.

Any ideas on how to get it out

akanevsky 10-26-2006 05:53 PM

I cannot help unless you post the specific error message that you are seeing.

akanevsky 11-02-2006 01:30 AM

<a href="https://vborg.vbsupport.ru/showthread.php?t=130551" target="_blank">Please vote fot psiStats 2006 in the November 2006 Mod of The Month Contest! Thanks.</a>

JohnBee 11-06-2006 08:50 PM

What is the Human Referer option(link) in the Stats selections?
Whenever I click on it I get an invalid page. I installed the Human Referer Hack but it did not change the outcome.


All times are GMT. The time now is 10:09 PM.

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.01812 seconds
  • Memory Usage 1,747KB
  • 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_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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