Hello Everyone - i installed this mod to my Zen Cart installation v1.3.7 and for some reason i cant install part of the SQL file
i split it up into parts and the following sections went through ok
Code:
SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Super Tracker' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Super Tracker', 'Super Tracker Configuration', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
(NULL, 'Excluding IP\'s', 'XTRACKING_EXCLUDED_IPS', '127.0.0.1', 'Comma Separate List of IPs which should not be recorded, for instance, your own PCs IP address, or that of your server if you are using Cron Jobs, etc', @configuration_group_id, 1, NOW(), NULL, NULL),
(NULL, 'Excluding UserAgent\'s', 'XTRACKING_EXCLUDED_UA', 'ServiceUptime.robot', 'Comma Separate List of UserAgent\'s substring which should not be recorded', @configuration_group_id, 2, NOW(), NULL, NULL),
(NULL, 'Excluding bot\'s', 'XTRACKING_EXCLUDE_BOTS', 'true', 'IP\'s Excluding from logging', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
but i could not insert the last part:
Code:
DROP TABLE IF EXISTS `supertracker`;
CREATE TABLE `supertracker` (
`tracking_id` bigint(32) NOT NULL auto_increment,
`ip_address` varchar(15) NOT NULL default '',
`browser_string` varchar(255) NOT NULL default '',
`country_code` char(2) NOT NULL default '',
`country_name` varchar(100) NOT NULL default '',
`customer_id` int(11) NOT NULL default '0',
`order_id` int(11) NOT NULL default '0',
`referrer` varchar(255) NOT NULL default '',
`referrer_query_string` varchar(255) NOT NULL default '',
`landing_page` varchar(255) NOT NULL default '',
`landing_page_name` varchar(255) NOT NULL,
`exit_page` varchar(255) default NULL,
`exit_page_name` varchar(255) NOT NULL,
`time_arrived` datetime NOT NULL default '0000-00-00 00:00:00',
`last_click` datetime NOT NULL default '0000-00-00 00:00:00',
`num_clicks` int(11) NOT NULL default '1',
`added_cart` varchar(5) NOT NULL default 'false',
`completed_purchase` varchar(5) NOT NULL default 'false',
`categories_viewed` varchar(255) NOT NULL default '',
`products_viewed` varchar(255) NOT NULL default '',
`cart_contents` mediumtext NOT NULL,
`cart_total` int(11) NOT NULL default '0',
PRIMARY KEY (`tracking_id`),
KEY `ip_address` (`ip_address`),
KEY `last_click` (`last_click`),
KEY `customer_id` (`customer_id`),
KEY `browser_string` (`browser_string`),
KEY `cart_total` (`cart_total`)
) ENGINE=MyISAM;
i get the following error...
Code:
1064 You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 1
in:
[CREATE TABLE supertracker ( tracking_id bigint(32) NOT NULL auto_increment, ip_address varchar(15) NOT NULL default '', browser_string varchar(255) NOT NULL default '', country_code char(2) NOT NULL default '', country_name varchar(100) NOT NULL default '', customer_id int(11) NOT NULL default '0', order_id int(11) NOT NULL default '0', referrer varchar(255) NOT NULL default '', referrer_query_string varchar(255) NOT NULL default '', landing_page varchar(255) NOT NULL default '', landing_page_name varchar(255) NOT NULL, exit_page varchar(255) default NULL, exit_page_name varchar(255) NOT NULL, time_arrived datetime NOT NULL default '0000-00-00 00:00:00', last_click datetime NOT NULL default '0000-00-00 00:00:00', num_clicks int(11) NOT NULL default '1', added_cart varchar(5) NOT NULL default 'false', completed_purchase varchar(5) NOT NULL default 'false', categories_viewed varchar(255) NOT NULL default '', products_viewed varchar(255) NOT NULL default '', cart_contents mediumtext NOT NULL, cart_total int(11) NOT NULL default '0', PRIMARY KEY (tracking_id), KEY ip_address (ip_address), KEY last_click (last_click), KEY customer_id (customer_id), KEY browser_string (browser_string), KEY cart_total (cart_total) ) ENGINE=MyISAM;]
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.
Bookmarks