Version 1.3.0 seems to be slowing my page loading time... :ermm:

EDIT: Psionic didnt appreciate it

My apologies

Bashy

That can't be happening, it's just two simple insert queries..
The most likely reason is the improper ajax code, I am researching that...

It indeed is. And I do not appreciate it.

Yes, most likely. If I look at "Who's Online", then I see all users (and guests) are "viewing" the stats, even those who have no permission to do so.

I am going to uninstall until this is fixed.

Did this now got this error:Bob

Are the quotes correct?

Bob

This is definately not recording the stats for the Display Colours & Resolutions any more since the update all the rest is fine and working well!

Bashy

Mine is logging stats OK, just get that 'LOCK TABLES' SQL error each time cron runs.

Bob

Please stop posting messages about the same errors. I already said that I'll fix those. Also, if you "are going to uninstall", I don't need to know about that. Thanks.

Look, we all appreciate your hack. It is nothing personal. I am looking forward to the fix as these stats are very useful.

quick fix for that is to add the psistats_update.php to vbulletin scheduled task
set for 1 hour

Its not in the instructions but maybe it was supposed to be :P

The cron gets added automatically.

Cheers msimplay

But as Psionic says, it was automaticaly created :)

Bashy

Re-upload ./psistats.php
Re-upload ./includes/cron/psistats_update.php
Re-do template change: headinclude

Done.

Thanks! :) Will try it now...

Yup, I can confirm it works great for me now! :up:

Excellent Psionic....

All seems to be working very well...
Congrats on a job well done :)

Regards

Bashy

I had to uninstall, may be i missed one version number and no changelog is available, so i got a lot of sql-errors because of missing sql-tables.

What a pitty, because the hack is great and worked great til this release. :

It's working fine, trust me. You probably have forgotten to undo the class_core changes.
Wheneever you upgrade any of my hacks, you must follow through each "new version" announcement that came out since the release of the version that you have installed.

I will try a fresh install.

Thanks for your work. I am still getting this error
Any ideas please?

Bob

I have no idea. That doesn't happen for me on vB 3.5.2... But I'll see what's the matter with 3.5.3.

O.k., fresh install works fine til now!

Never had this many unknown browers before.

Bob

Majority unknown browsers is normal.

Well I just made a fresh installation on 3.5.3 and most of the fields are blank. The only sections with data are: General | Style Usage | Top Threads & Forums.

That's how it's supposed to be. The other stats are to be collected in time :)

In psistats_update.php
Should this be:
without the underscrore?
I have made this change and manually run the cron and not had the error email.

Bob

Ah, I should have figured that when I saw the cron. Looking very nice though. I decided to give it its own navbar link to show it off better.

Psionic Vision
Not work "?do=home"

Invalid SQL:

SELECT userid, username, usergroupid, membergroupids, joindate, lastpost, pmtotal, referrerid
FROM user
ORDER BY joindate DESC;

MySQL Error : Lost connection to MySQL server during query

I had to add the Cron manually; the Plugin XML did not do the job!

No, without underscore the code doesn't make any sense. The underscore should be there. I don't know yet why it's causing the error. Looking into it...

It did for me.

Your last update didn't come with any upgrade instructions... do you have to uninstall the product first and then add the new product, or just overwrite? Which files have changed do you upload the lot and overwrite or delete the previous etc

I overwrote product and all files and i get the error:

hope that helps you to debug

Awesome hack :)
Installed.
Had to add the cron manualy though ;)

the unknown browser is firefox,yet in earlier versions this was showing firefox ok

OK, the stats are logged in the psistats_cache table.
But the psistats_data table isn't updated.
I have the cron in place, but it seemes to do nothing.
So all is working well accept the hourly update.

Unfortunately I'm not the one who gets the database error emails. And I can't reache the guy who does. So at this moment I don't know what error causes the data table not to be updated.

Weird, previously this hack was perfectly working, now I upgraded from 1.3.0 to 1.3.1 and nearly all my stats are gone, it just doesn't show anything. The "standard" stats seem to work perfectly, such as the top posts etc but the stats that are collected; countries etc don't appear at all.

Same problem here

Well, with a fresh install on 3.5.3 it's been nearly a day now and there's still no data on those aforementioned sections so I added a cron job in the admin cp. But when I try to run psistats_update.php via the scheduled tasks manager I get;

Invalid SQL:
LOCK TABLES psistats_cache READ, psistats_data READ;

MySQL Error : Access denied for user: 'username@%' to database 'databasename'
Error Number : 1044
Date : Monday, January 9th 2006 @ 09:51:26 AM
Script : http://www.domain.com/etc/admincp/cr...cron&cronid=19
Referrer :
Classname : vb_database

Evidently the problem appears to be that it's adding "@%" to the username.

EDIT: nvm,fixed it.