Thanks Paul, Nicely done.

Thanks! :)

I check that set Enable Spider Display is allreadt set to 'Yes' in vBulletin Options
and i also visit the online.php page (and the spiders are displayed ok)
but i get:
Total guests that have visited the forum in the last 24 hours: 609
Visitors (609)

The previous version is worked ok, but with the update i got stuck with this problem.

Any help ?:(

As I have previously mentioned a few times, if you want me to look at a specific problem then unless you provide me with access to your forum (admin access, with the ability to run sql queries) then there is nothing I can do. I cannot investigate problems that are not reproducable on my system.

Stats are showing visits from the 3 major search engines, but these do not show up in the visitors for the mod. Any suggestions on what to check?

Or a way to send a spoofed bot visit to the site and see what shows up?

As above, I am fine with that. Just PM me if you are interested in looking at the site - thanks

****turned this off, back on, changed a babies popy diaper and now it is working. Your mileage with or without the diaper may vary. Thanks for another great mod Paul

As much as I like the functionality of this mod, it had such a performance hit on my board I had to disable it. My board felt sluggish recently, so I paid closer attention to the Microstats at the bottom saying how many seconds & queries it took to create the page. With this plug-in enabled, it would sometimes take 4 or 5 seconds to display my forum home page, (with only 14 queries). It was never less than 3 seconds.

After disabling this hack, it is back down to between 0.4 and 1.0 seconds to create the home page, with 13 queries. This hack reported that I was getting about 2000 guests visiting per day (vast majority were spiders), and my server load never reports over 0.8, so it likely wasn't a server load problem.

Any suggestions on indexing certain tables to improve performance?

Hmm, looking at this on my homepage, mysql is not using the index for some reason, even though it exists. By forcing it the query is quicker.

Change the SQL call (in Plugin 3) to this and let me know what happens ;

That did it. Page load time is back under a second, with the mod enabled. Thx for the quick fix.

Good, I'll release that as an update tomorrow.

Investigating that has highlighted some index issues in a few other mods as well, so I've a few updates to issue ......

v1.13 - as per posts #327 to #329, I have changed the SQL to force MySQL to use the index on forumhome - it wasn't being used - on forums with a large number of guests this will speed up the query this runs.

downloaded, updated - thanks for the update

<font color="SeaGreen">UPDATED!</font>

PS. Paul just a question: the better way to update is first unistall the previous version and after this re-install the hack or simply overwrite?

why this isnt working with 3.6.2 :( ?

Why are you using an older version of vB where there is a new & security bug fixed version available :S.

/me updated thanx

I just upgraded this mod now I have this:
I don't think so!!

Bob

All updated. Thanks. :)

Updated. Works like charm..

That didn't upgrade properly I would say, do an uninstall/install to clear the table.

I can't get it to display the yahoo bots etc.

It only says
Visitors (457)

I have all the the options checked to "yes" in the vBoptions

Got this when I tried to uninstall:Bob

Now I cannot access ther forum at allBob

Paul,

I think one of the mods you updated today may have caused this. I disabled all them and now I have access to the forum again.

I'll try to reproduce it and see if I can tie it down to the problem.

Bob

I have the same problem on my dev site. I cannot uninstall this mod. I now cannot run with it enabled either as it causes the db error above. The only way I can now run the forum is with this disabled.

Bob

I have managed to sort this out. I suspect something went wrong importing the updated product. I manually removed the vb_guest table and then imported one from an earlier backup. Then did the uninstall and reinstall.

Time for a drink...

Bob

I tried disabling it then putting it back on, didn't do anything :(

Something is not right here, after just over an hour after removing and reinstalling I have this:
Bob

I have just tried to uninstall this again, guess what, again - And the forum was not accessible again, until I disabled the product. The table had been removed from the database but because I could not totally remove the product it generated lots of db errors.
..to quote just a few.

I had to reimport the table from an earlier backup and then I could uninstall the product cleanly. I am not reinstalling this again as something is just not right.

Bob :mad:

^You've posted about 7 times ina row :|

Yes, how observant. It is because I am getting a series of problems and as soon as I think it is fixed, it's not. It's called going round in circles. If you read them in sequence, and note the time stamps you may understand.

Bob

I had some trouble as well, and mine had to do with the spider watchers hack. I removed it, re-added, and now all is happy now.

So..... maybe I should wait to upgrade until this gets sorted out.

Works fine for me :)

Whatever you uninstall problem is/was, it's related to your forum setup, I can happily uninstall/install this on my forum.

I can't even imagine what's calling the db alter class.

I'm still puzzled why you thought this was odd ;

I can't see anything wrong with them

Help would be appreciated :(

Nothing unusual about that. Yahoo enjoys sending a TON of bots at sites. When I changed subdomains after first installing vB, I literally had around 200 bots at once crawling the site.

See below for my current visitor list, what you see is not unusual, as has been stated earlier.

I do have one question - is a Visitor (or "Lurker" in my setup) - simply a non-member who's hit the forum or can it also include an undefined spider? If so - it could only be those 2 types of visitors that make up the total visitor number, right?

Thanks and keep up the good work.

Thanks Paul

Updated

@funkmeister - "Visitor" is any guest not specifically listed (detected) as a spider.