Found an error where GUS has problem saving a user agent.

It appears to be with the platform column when it contains brackets.

Here is the error from the Geeklog error log:

Wed 03 Oct 2018 21:51:54 EDT - ip address - 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 'Mozilla',
                version = '5.0',
                platform = '[Robot]'' at line 3 in /plugins/gus/functions.inc:773. SQL in question: INSERT INTO gl_gus_user_agents SET
                user_agent = '\'Mozilla/5.0 (compatible; DuckDuckBot-Https/1.1; https://duckduckgo.com/duckduckbot)\'',
                browser = ''Mozilla',
                version = '5.0',
                platform = '[Robot]'  

This is what Geeklog has done

Still getting the odd duplicate entry for user agents in the error log when the visitor stat is added to the gus tables. . It is not a duplicate as I took the insert statement and was able to insert it via phpmyadmin without any problems. Not sure why this error is happening then .. is it something with the special characters in the user agent?

1062: Duplicate entry 'Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/' for key 'user_agent' in ...\plugins\gus\functions.inc: 781. SQL in question: INSERT INTO gl_gus_user_agents SET
                user_agent = 'Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html£©',
                browser = 'Netscape',
                version = '5.0',
                platform = '[Robot]' 

This is for the Links plugin which most people don't use anymore and is not really relevant to the stats.

See Visitor Statistics by Day

Should maybe use Template Cache or at least move the GUS Cache pages into the Geeklog data directory so they are not accessible directly by the internet.

Hello DEvelopers,

I'm trying to install some plugins with the Geeklog 2.1.2 RC1. With this plugin I will be forwarded to the install URL in the plugin manager, but there is this error message.

E_USER_ERROR(256) - 1071: Specified key was too long; max key length is 1000 bytes @ /xxxxxxxxxxxxxx/system/databases/mysqli.class.php line 459

Could you see this again.

Thanks in advance.

Maybe the plugin needs to be fixed or updated.

P.S. I test the days very much at the Geeklog 2.1.2 RC 1 CMS.

For example in publich_html/gus/ip.php and I am sure else where.

All this should be moved to the language files.

Includes size of IP address in Database.

When the user is deleted and stats are still available for that user we should anonmize it...

If Geeklog username contains a quote Gus insert of stat will result in a sql error.

Usernames are not suppose to have quotes but this can happen with older usernames and those from remote accounts.

Remove embedded HTML and use template files.

Not an issue - just ran across this repo.

I'm surprised GUS still exists and wanted to say thanks to the maintainers for keeping it alive!

It's fun reading my old stuff :-)

10/03/15 15:26:45 - 46.118.115.65 - 1062: Duplicate entry 'Mozilla/4.0 (compatible; MSIE 7.0b; Windows NT 6.0 ; .NET CLR 2.' for key 'user_agent' in C:\inetpub\mysite\plugins\gus\functions.inc:738. SQL in question: INSERT INTO gl_gus_user_agents SET
user_agent = 'Mozilla/4.0 (compatible; MSIE 7.0b; Windows NT 6.0 ; .NET CLR 2.0.50215; SL Commerce Client v1.0; Tablet PC 2.0',
browser = 'MSIE',
version = '7.0',
platform = 'Windows Vista'
10/03/15 15:26:45 - 46.118.115.65 - E_USER_ERROR(256) - An SQL error has occurred. Please see error.log for details. @ c:\inetpub\mysite\system\databases\mysqli.class.php line 279

If ; character is in ignore list when adding or removing item the string will be truncated so for example this user agent when added:

Mozilla/5.0 (Windows NT 5.1; rv:32.0) Gecko/20100101 Firefox/32.0

will be stored as

Mozilla/5.0 (Windows NT 5.1

Happens with any ignore list fields.

This includes autoinstall.

Replace old ways of doing things with new functions:

• COM_CreateHTMLDocument (remove COM_SiteHeader, COM_SiteFooter)
• echo COM_refresh to COM_redirect($_CONF['site_url'] . '/calendar/index.php');
• $topicnavbar = COM_newTemplate(CTL_plugin_templatePath('forum'));
• New Input instead of com_stripslashes, etc.. ( $page = (int) Geeklog\Input::fPost('cpage', 0);)
• = DB_escapeString($pid);
• $message = GLText::remove4byteUtf8Chars($message);

The function ip_to_hostname uses whatever setting is found in $_GUS_CONF['host_lookup'].

This happens for every single visit.

This should only happen on the first visit. ip_to_hostname should chekc if the host is already stored in the database for the ip and use that instead. It will be a lot faster....

Would be nice to know what are the top visited pages are.

Maybe do a list for the last hour, last 6 hours, last 12 hours. last 24 hours... last 1 week