I just added Supertracker to my site.
The instructions did not include:
- ALTER TABLE `supertracker` ADD `agent` VARCHAR(255) NULL;
It would probably help some people to have this call added to the supertracker_setup_db.php the call to add the agent to the supertracker table.
if (tep_db_num_rows($check_result) < 1){
//First time user, so just install the new database schema
$insert_query = "CREATE TABLE `supertracker` (
`tracking_id` bigint(20) 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 '',
`exit_page` varchar(100) NOT NULL default '',
`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',
`agent` varcgar(255) NOT NULL default '',
PRIMARY KEY (`tracking_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;";
@$insert_result = tep_db_query($insert_query);
if ($insert_result) echo 'New Supertracker Database Table Successfully Created';
else echo 'There was a problem in trying to create the database. You may need to do this manually using the following SQL code: <br>' . $insert_query;
Just a suggestion... help some of the people from having a problem :)