Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Supertracker


apolyshow

Recommended Posts

Hello to all of you. I have install supertreacker 3.5 for osc 2.3.1 and now i am not able to see the flags in the reports. Everything else works fine except the flags. Do you have any ideas?

Thank you very much.

One amateur made the Arc, 5.000 pro made the Titanic...

Link to comment
Share on other sites

  • 3 months later...

I have an error in MyphpAdmin (supertracker_setup_db.php returned the same error) when creating the supertracker table:

 

"#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 'TYPE=MyISAM AUTO_INCREMENT=1' at line 26"

 

On 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 '',

`browser` varchar(100) NOT NULL default '',

`country_code` char(2) NOT NULL default '',

`country_name` varchar(100) NOT NULL default '',

`country_region` varchar(100) NOT NULL default '',

`country_city` 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',

PRIMARY KEY (`tracking_id`)

) TYPE=MyISAM AUTO_INCREMENT=1 ;

 

Did anyone have the same problem?

Link to comment
Share on other sites

  • 3 weeks later...

Hmm, i get the same error as Hans when running the SQL code, and my MySQL server is running 5.5.15

 

Any solution to this ?

 

Thanks,

 

Regards,

Emil

 

I have an error in MyphpAdmin (supertracker_setup_db.php returned the same error) when creating the supertracker table:

 

"#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 'TYPE=MyISAM AUTO_INCREMENT=1' at line 26"

 

On 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 '',

`browser` varchar(100) NOT NULL default '',

`country_code` char(2) NOT NULL default '',

`country_name` varchar(100) NOT NULL default '',

`country_region` varchar(100) NOT NULL default '',

`country_city` 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',

PRIMARY KEY (`tracking_id`)

) TYPE=MyISAM AUTO_INCREMENT=1 ;

 

Did anyone have the same problem?

Link to comment
Share on other sites

Fixed the issue with replacing TYPE with ENGINE in line 26.

 

Later you will get an error with the supertracker.php file in catalog/includes/classes

 

Simply delete the bot section. Goes between

 

// Bot "something" Start

 

// Bot "something" End.

 

Ofc, now it will track bots also, but you can also fix the error instead :)

 

Besides that: Working on 2.3.x

Link to comment
Share on other sites

  • 2 months later...

There is a deprecated ereg error in /includes/classes/supertracker.php on line 42 which is:

 

 

if (eregi($bot, $agent)) {

 

to make this PHP 5.3 compatible change it to:

 

if (preg_match('/$bot/', '/$agent/')) {

 

 

 

 

Chris

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...