I will verify & fix the problems on the weekend.

Sadly it caused a database error for my IE visitors so I've got it disabled for now, might reinstall later if it's fixed.

I have database errors too the last few days, although I can't confirm that it is from this hack.

Have you undone class_core file edits?

See http://www.vbulletin.com/forum/bugs3...iew&bugid=2056

Bob

Uh huh. Thought so. So it's not an error on my side :) Thanks, Bob.

That fix didn't sort my little issue though. :/

I've found out the errors i'm getting:
That has nothing to do with the UNLOCK error. That has been fixed btw.
I don't get this error on any other cron of vB function and my default user has all the rights it needs as far as I know.
What could be wrong?

Hi,

I have found 1 problem with the install. Forgive me if I am wrong.

In product-psistats.xml, line 38.
That doesn?t work for me because I already have more than 14 cron jobs.
Surely the insert should not give an ID number.

And as for the lock until a solution is found I had to disable

Because I don?t have those permissions and I don?t know where to disable it in the options.

Thanks.

FFMG

8)

Great sollution FFMG, that does the trick.
Does anybody know what the risc is for disableing those two commands?

You are right. I just did a phpadmin dump of the row and forgot to remove the id insert ;)

I love how everyone asks "anybody". Really. Who can know better than the author of the hack?

hehehehehhehe i have to agree with you on that lol

Well, maybe someone else who knows php/mysql?
But you're right. Do YOU know the riscs?

Also, Firefox isn't showing on the browserpage.

And we have most visitors from New Zealand it seemes. And we're a Dutch board. OK, we have a member in NZ and he has posted, but not more then all our Dutch members together. Any idea why those countrystats show almost no visitors from the Netherlands?

I think this is because the code.
Is not restricted to your hack alone.
So it is more a general questions, what could happen if the lines are commented out.

You obviously placed them there for a reason, we are just curious what the downside of commenting those out might be.
Seen that I cannot lock my tables I don?t have a choice really. I must comment them out.

FFMG

i asked that same question in this earlier post https://vborg.vbsupport.ru/showpost....&postcount=156

There are no riscs. But what happens is, there is potentially a lot of data to be parsed in the cache. While it is being parsed, another instance of the script may access the same data and parse it too. What lock tables does, it ensures that only one instance of the script may access certain tables until they are unlocked, or until the script is finished.

That has already been reported.

I uninstalled the old version I had, and installed 1.3.1. First the cron was not created, so I created it myself. Secondly, the psistats.php comes up fine, but the only thing that is actually being updated is Style Usage, General and Top Threads & Forums. The others do not work. I also ran the cron manually to see if that would update the non working sections and they still come up with no results:
http://linuxgangster.org/forums/psistats.php

It seems to be working fine; I can see countries and OS.

Maybe the cron was not run properly or something sill.

Did you also remove the changes on class_core.php? When I updated I also forgot about those changes.

FFMG

Ok this is really odd. I checked my email and had like 50 db errors saying psistats_country was not there. Then I check back on the psistats.php and its magically working. I didn't do one thing to fix it.

hum, hum...

:)

FFMG

my guess now is that its probably my php caching program

At this point, the error about psistats_country comes from class_core.php ONLY. Make sure you remove the whole piece of code in class_core.php (it is enclosed with my name in comment, so you'll easily find it).

I removed that right after the install, but apparently the php caching program didn't pick the change up right away ;) Anyway this maybe a good heads up to users who use mmcache or some other sort of php cache or accelerator

Hi Psionic

I have been monitoring the stats for the crawlers...
Yours are way off m8...

From monday i have had google in 249 times, Yahoo 99 time and msn 148 times...

Your stats are showing Since install about 1 week Google + adsense 33, MSN a and yahoo 40....

So as you can see yours stats for this is way out, how i dont know... :surprised:

You can see this yourself here

My crawler block was 2655 for google on monday, 1359 for yahoo and 2858 for MSN, I keep a written log of the 3 main spiders, this is just for my curiosity, this is how i know whats what....

Any thoughts on this?

Regards

Bashy

Suggestion:

What about picking up stats on other OS'es. From the looks of it, its not reporting anything for FreeBSD, NetBSD, Open or any other BSD. In fact, I don't think its picking up others like Solaris, Irix etc.

And yes, before someone ask alot of people come to my site with *BSD and odd unix's. Half of our members are BSD users (www.bsdgangster.org)

The stats do NOT count hits. They count stats once in an hour, which means that only one hit per hour counts for each host. :)

As for BSD, gimme list of agent identifiers for those OSes and I'll gladly add them.

I think this is what you want:

aix = "IBM AIX"
atheos = "Atheos"
amiga = "AmigaOS"
darwin = "Darwin"
osf = "Digital"
free-bsd = "FreeBSD"
hp-ux = "HPUX"
net-bsd = "NetBSD"
open-bsd = "OpenBSD"
palm = "PalmOS"
photon = "QNX Photon"
symbian = "SymbianOS"
unixware = "UnixWare"
open-vms = "OpenVMS"
sun = "SunOs"
beos = "BeOS"
os/2 = "Os2"
irix = "IRIX"
plan9 = "plan9"
unix = "Unix"
x11 = "Unix"

I believe that covers most of the popular OS'es out there

Let me know if you want a larger list of browsers and spiders, I got that information as well (altavista,alltheweb,euroseek,hotbot,lycos)

how long does it take before stats show i had it installed for a bit now and i dont see any of these stats, Display Colors & Resolutions | Countries & Regions | Browsers & Operating Systems | Referring Sites

It should be no more then 1 hour before the stats show up.

Go into your vbulletin admin "Scheduled Task->Scheduled Task manager" section and look to see if "psiStats 2006 Hourly Update" is there. If its not, you need to add it. Here are the details:
Title: psiStats 2006 Hourly Update
Day of the Week: *
Day of the Month: *
Hour: *
Minute: 15 - - -
Log Entries: No
Filename: ./includes/cron/psistats_update.php

After that, give it about 15 minutes and browse your site, then go back to this section and manually run it. You should have some stats show up after that, if you do not you got something else going on.

Natas

ok i tried that and when i run it i get a error

Database error in vBulletin 3.5.3:

Invalid SQL:
LOCK TABLES psistats_cache READ, psistats_data READ;

MySQL Error : Access denied for user: 'xxxxxxxxxxxx' to database 'xxxxxxxxxxxx'
Error Number : 1044
Date : Wednesday, January 11th 2006 @ 08:31:19 AM
Script : http://www.xxxxxxx.com/admincp/crona...cron&cronid=17
Referrer : http://www.xxxxxxxx.com/admincp/cronadmin.php?do=modify
IP Address : xx.xxx.xxx.xx
Username : xxxxxxxxxx
Classname : vb_database

thats a odd error to get, In fact I'm surprised you have not got that error with other tables. Make sure the db user has full rights to your vb database. That's all I can really say, unless that error is just reporting something totally wrong

yeah i made sure i have full permissions i have also checked to make sure all files are there on install and everything is there it just dont seem to run the cron

anyone know how to fix that error? cause all it keeps doing is emailing me telling me of that error everytime it trys to run...

Is this happening even after you have done the vB bug fix in my post #166

Bob

is that a bug fix i just see it saying go to vbulletin.com to check out the errors they are having... its only this mod when it runs the cron

only thing i seen on that post was to remove this $vbulletin->db->close(); is that true?

well never mind thats not even in my file so it aint that...

It is only in vB 3.5.3

Bob

and thats what im running Your version of vBulletin (3.5.3) is up-to-date.