Geeklog Forums

Hi everyone,

I am relatively new to geeklog but have been using it pretty solid for a week or two, and have got filemgmt and forum plugins working fine. I am having issues with the GUS plugin though, and when I try and install via the admin section of geeklog, my /logs/error.log file gives me this error:

Tue 19 Jul 2005 13:38:12 BST - Installing the GUS plugin
Tue 19 Jul 2005 13:38:12 BST - Creating GUS admin group
Tue 19 Jul 2005 13:38:12 BST - GUS group ID is 51
Tue 19 Jul 2005 13:38:12 BST - Saving group_id to vars table for use during uninstall
Tue 19 Jul 2005 13:38:12 BST - 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 'ON DUPLICATE KEY UPDATE value=51' at line 3. SQL in question:
Tue 19 Jul 2005 13:38:12 BST - Removing the GUS plugin...
Tue 19 Jul 2005 13:38:12 BST - DELETE FROM gl_plugins WHERE pi_name = 'gus' LIMIT 1
Tue 19 Jul 2005 13:38:12 BST - Removing tables
Tue 19 Jul 2005 13:38:12 BST - DROP TABLE IF EXISTS gl_gus_userstats
Tue 19 Jul 2005 13:38:12 BST - DROP TABLE IF EXISTS gl_gus_user_agents
Tue 19 Jul 2005 13:38:12 BST - DROP TABLE IF EXISTS gl_gus_ignore_ip
Tue 19 Jul 2005 13:38:12 BST - DROP TABLE IF EXISTS gl_gus_ignore_user
Tue 19 Jul 2005 13:38:12 BST - DROP TABLE IF EXISTS gl_gus_ignore_page
Tue 19 Jul 2005 13:38:12 BST - DROP TABLE IF EXISTS gl_gus_vars
Tue 19 Jul 2005 13:38:12 BST - Removing gus block
Tue 19 Jul 2005 13:38:12 BST - DELETE FROM gl_blocks WHERE name='gus_block' LIMIT 1
Tue 19 Jul 2005 13:38:12 BST - Removing gus admin group
Tue 19 Jul 2005 13:38:12 BST - DELETE FROM gl_groups WHERE grp_id =
Tue 19 Jul 2005 13:38:12 BST - DELETE FROM gl_vars WHERE name = 'gus_group_id'
Tue 19 Jul 2005 13:38:12 BST - Removing root users from admin of gus
Tue 19 Jul 2005 13:38:12 BST - DELETE FROM gl_group_assignments WHERE ug_main_grp_id =
Tue 19 Jul 2005 13:38:12 BST - Removing group id in vars
Tue 19 Jul 2005 13:38:12 BST - DELETE FROM gl_vars WHERE value =
Tue 19 Jul 2005 13:38:12 BST - Removing feature 'gus.admin' and rights

Everything LOOKS OK, although I believe I am using version 3.x.x of MySql as supplied with my Linux install, but hasn't stopped anything else working.

Any ideas? Any more information required?

Many thanks in advance,

Curly

Argh! I guess I should read the MySQL manual more carefully:



Sigh.

To fix it for your install, go to the install.php file and remove the 'ON DUPLICATE KEY UPDATE' clause. Change line 112 from:

to:

And then try to install again.

Let me know how that goes.

- Andy

Works a treat! You're a star, and the plugin is excellent too, many thanks!

Curly

Curly,

Thanks for the report.

I'll put up a fixed version in the next day or so...

- Andy

I have fixed this and cleaned up the user agent table a bit in v1.3.1.

As usual, you can find out more or download it through my geeklog software page.

- Andy