Geeklog Forums

Since I updated geeklog to 1.3.9. I am not getting any referers in my vstats. I test it in google and nothing is showing up. It was working in 1.3.8 sr4. Is anyone else having problems? I am not getting an errors in my logs.

anyone?

I didn't upgrade to the final 1.3.9 till now, but on 1.3.9. rc1 the stats works as usual.

geKow

My stats seem to be working as well

I'm still getting referrer information but I've just seen it blow up when someone tried to comment a story that had a " ' " in the title. The Referrer field caused an error because the string is not being SQL escaped properly. Needs a fix IMHO. Error SQL included below.

Note: this is exactly the same sort of problem exhibited by the filemanagement plugin. It throws SQL errors on any filename entry that includes a "'" in the title (not filename - title). I've flagged this to the author but I guess he's busy with all the Forum stuff.

Maybe I'll have to fix them myself...



Tue Apr 6 17:10:05 2004 - 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 're%20some%20pics!&type=article', request='GET', page='comment.p. SQL in question: INSERT INTO gl_userstats Set uid='6', username='TestUser', user_agent='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)', ip='111.222.333.444', host='www.geeklog.net', browser='MSIE', version='6.0', platform='Windows NT 5.1', date='20040406', dayofweek='Tuesday', month='Apr', monthn='04', day='06', year='2004', hour='17', minute='10', referer='http://www.kiwisim.net.nz/article.php?story=2004040616211667', query_string='sid=2004040616211667&pid=507&title=Still%20no%20Mini-mod%20-%20but%20here're%20some%20pics!&type=article', request='GET', page='comment.php'