User tracking mod

[OutdoorsInteriors]

I previously was running zen 1.3.6 with user tracking no problem. Just upgraded to zen 1.3.7 and ran the new user tracking install. I'm getting the following error from myphpadmin. I see in zen admin tools I have the "user tracking config" but when I select that there is nothing showing. Please Help!!!!!!!

Thanks
OI

Error

SQL query:
INSERT INTO configuration_group( `configuration_group_id` , `configuration_group_title` , `configuration_group_description` , `sort_order` , `visible` )
VALUES ( 999, 'User Tracking Config', 'User Tracking', 31, 1 ) ;


MySQL said:
#1062 - Duplicate entry '999' for key 1

[Ajeh]

The configuration_group_id is protected ... meaning you cannot have more than 1 record with the same configuration_group_id ...

You are trying to add to configuration_group_id 999 so look via phpMyAdmin and see if this value is already used by this add-on or used by something else ...

[OutdoorsInteriors]

Hi Linda aka (Ajeh),

Yes I'm looking in phpmyadmin and I do have a table "configuration_group". I also tried the same SQL query to update from Zen - admin/tools and get a little more info but really same error.

1062 Duplicate entry '999' for key 1
in:
[INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (999, 'User Tracking Config', 'User Tracking', 31, 1);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


I'm not real good ad SQL but any suggestions?

Thanks your a lifesaver

OI..:)

[OutdoorsInteriors]

Linda,

Below is the user tracking SQL script that was run that is generating these errors.


DROP TABLE IF EXISTS user_tracking;
CREATE TABLE user_tracking (
`customer_id` int(11) default NULL,
`click_id` int(11) default NULL,
`full_name` varchar(64) NOT NULL default '',
`session_id` varchar(32) NOT NULL default '',
`ip_address` varchar(15) NOT NULL default '',
`time_entry` varchar(14) NOT NULL default '',
`time_last_click` varchar(14) NOT NULL default '',
`last_page_url` varchar(128) NOT NULL default '',
`referer_url` varchar(254) NOT NULL default '',
`page_desc` varchar(64) NOT NULL default '',
`customers_host_address` varchar(64) NOT NULL default ''
) TYPE=MyISAM;


DELETE FROM configuration where configuration_group_id = '999';
INSERT INTO configuration_group (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES (999, 'User Tracking Config', 'User Tracking', 31, 1);
INSERT INTO configuration VALUES ('', 'User Tracking (ADMIN)', 'ADMIN_CONFIG_USER_TRACKING', 'true', 'Check the ADMINs behaviour ? (each click will be recorded)', 999, 2, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'User Tracking (exclude this IP-Address)', 'CONFIG_USER_TRACKING_EXCLUDED', 'your IP', 'Do NOT record this IP Address<br>(like webmaster/owners/Beta-testers)', 999, 10, '2003-03-04 23:08:38', '2003-02-09 21:20:07', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking (Session Limit)', 'CONFIG_USER_TRACKING_SESSION_LIMIT', '50', 'Displaying the latest # sessions of this 24 hour period.<br>(SET to 999999 for unlimited per 24 hour period)<br>NOTE:<BR>Watch you space !', 999, 15, '2003-03-03 11:19:13', '2003-02-09 21:20:07', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking (your favorite WHOIS URL)', 'USER_TRACKING_WHOIS_URL', 'http://www.dnsstuff.com/tools/whois.ch?ip=', 'Put here you favorite WHOIS tracking site<br>(the IP will follow automaticly after this url)', 999, 50, '2003-03-03 11:19:13', '2003-03-11 11:40:01', NULL, NULL);
INSERT INTO configuration VALUES ('', 'User Tracking Visitors', 'ZEN_CONFIG_USER_TRACKING', 'true', 'Check the Customers/Guests behaviour ? (each click will be recorded)', 999, 1, '2003-03-03 11:19:26', '2003-02-09 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES ('', 'User Tracking (Show Product Category when tracking product clicks)', 'ZEN_CONFIG_SHOW_USER_TRACKING_CATEGORY', 'true', 'Show Product Category when tracking product clicks', 999, 60, '2006-12-05 11:19:26', '2006-12-05 21:20:07', NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

[OutdoorsInteriors]

OK, the user tracking mod that is in download area does not work for us who previously had user tracking installed with zen 1.3.6. The SQL patch gives errors, but somehow I was able to get around with a previous SQL patch by another user. This mod really nees to be taken off the download pages.

While I can see user tracking information. I also have 2 selections of "user tracking". One if the admin configuration and one in tools. In both of these cases I get no options at all but a blank screen. I reloaded files but still same issue.

Any advice?


Thanks OI

[Woodymon]

OK, the user tracking mod that is in download area does not work for us who previously had user tracking installed with zen 1.3.6. The SQL patch gives errors, but somehow I was able to get around with a previous SQL patch by another user. This mod really nees to be taken off the download pages.

Background:

There are two different "base" versions of the mod from different "developers" (pinghead and JeffD) and the upgrade SQL for one version does not necessarily apply to the other version and each version supports slightly different features.

(JeffD was in the process of combining those features and putting together SQL updates for all the various past versions, but JeffD disappeared from the scene. And pinghead is no longer developing his version).

Originally (when the mod was ported to Zen Cart and released by Open-operations, which both pinghead and JeffD based there later versions on) you were suppose to see User Tracking Config in the Config menu and User Tracking in the Tools menu. Then along the way one of the versions changed this to also place User tracking under the Config menu. This was a bad move causing much confusion for upgraders.

So that is why it is important to know which version of the mod you are upgrading from (on your 1.36 shop) and which version you upgraded to (on your 137 shop).

While I can see user tracking information. I also have 2 selections of "user tracking". One if the admin configuration and one in tools. In both of these cases I get no options at all but a blank screen. I reloaded files but still same issue.

Others reported observing the same issue (including yours truly) and solved issue, as I did also. But at this moment I don't recall the steps involved. I did and found the solution(s) in this thread.

I do remember andrew (a_berezin) posted a SQL fix to this thread that helped.

Also if you have Admin Profiles installed there is another special fix you may want to try (see Admin Profiles readme).

Hope some of this helps.

Woody

[Woodymon]

Thanks Woody ;)

<?php if (ZEN_CONFIG_USER_TRACKING == 'true' && !$spider_flag && function_exists('zen_update_user_tracking')) { zen_update_user_tracking(); } ?>

This one was just what I needed. Where do I find the other version, and which is the best if you know?

YMMV in what you consider best. I use JeffD's latest version (12-04-06) on Zen Cart 1.37.

pinghead's last version released 08-31-06 is still available in ZC Downloads area (look down the list of previous versions and see author: Pinghead).

[OutdoorsInteriors]

I do have user tracking showing but again I have user tracking in both the config and admin areas which show nothing. Also when I go to user tracking and view details I have to log into admin tool again. This mod needs a major rework.

Thanks for the suggestions

OI

[sirryche]

load the mod from the downloads page and installed it on one site and had no problem. then loaded into my live site and in the user config there is nothing.. both sites are set up the same zen 1.3.7 installed sql files the same way on both data bases, installed files in footers. help....

[bumba000]

Is there a step by step somewhere? WOW this is crazy!
If there isnt or no one knows ,
Will someone who does know Exactly how to install this thing please break it down for me?
is there a default db table name in this thing that i can just create a new db with that name? What is that default db name ?
Im gonna go clean up my tracks now to get ready for my new clean install, Whatever that may consist of.
Most of the directions given in the readme I for some reason do not understand.
any help, thank you.
John