[Smitty]

Originally Posted by Onkel_Tom

I can't undestand!
We tested this version on more than one vB and all went fine. Also PcFreak do a lot of bugfixing before release and after release.
Did you really use the latest scripts ?
Or did you correct uninstall of the old vB2 version ?

Some guys didn't uninstall der vB 2 version correct and so they get database errors from the old one and not from the new version 3 !

Well, one problem was with the 'posts since last visit' function. See: Issue with "Since Last Visit" Search

I was also getting database errors from referrer entries. I went through the uninstall of version 2 pretty thoroughly, I think. Example:

Database error in vBulletin 3.0.6:

Invalid SQL:
SELECT counter
FROM statistic_searchengine_keywords
WHERE keywords = '\iso rules for lead free solder\'

mysql error: You have an error in your SQL syntax near ''\iso rules for lead free solder\'
' at line 4

mysql error number: 1064

Date: Wednesday 26th of January 2005 07:03:59 PM
Script: http://elsmar.com/Forums/showthread.php?t=8031
Referer: http://search.yahoo.com/bin/search?p=\'iso%20rules%20for%20lead%20free%20solde r\'
Username: Unregistered

At this point I'm pretty busy with a few things and want to make sure the 'posts since last visit' function is working correctly without this 'hack'. This weekend I'll take a look at everything and see if I did something wrong in editing the files. Actually, version 2 was OK for me. There are some things in it I did like better as to presentation. And, as I said earlier, including bots / spiders in stats like visitors on the main page dilute the information. Bots and spiders come and go while my main interest is in the people who visit.

Most of this isn't an isssue for me over all - I saw this as something for forum users more than anything else - I have a log analysis program I use on the site as a whole which segrates things like bot / spiders vs. 'people' - And most everything else I need.

I like the idea. I think it's a very nice 'hack'. And I'm not disappointed. A lot of time and hard work went into it. But for me, it'll be something I have to look more closely at - And to do that I have to find some time.

Note that I'm not a programmer so I'm not really very good at debugging. As the old saying goes, I know enough to be dangerous.