653 replies to this topic

[apolyshow]

Fix it now , and everything looks fine.

[Toasted]

Im getting the following error:

Fatal error: Call to a member function count_contents() on a non-object in mysite.com/admin/includes/classes/supertracker.php on line 122


How do I fix this?

Edited by Toasted, 27 July 2011, 20:44.

[Toasted]

Heres my code

Line 101 //Having worked out if we have a new or existing user session lets record some details....!
if ($existing_session) {
//Existing tracked session, so just update relevant existing details
$tracking_data = tep_db_fetch_array($result);
$tracking_id = $tracking_data['tracking_id'];
$products_viewed=$tracking_data['products_viewed'];
$added_cart = $tracking_data['added_cart'];
$completed_purchase = $tracking_data['completed_purchase'];
$num_clicks = $tracking_data['num_clicks']+1;
$categories_viewed = unserialize($tracking_data['categories_viewed']);
$cart_contents = unserialize($tracking_data['cart_contents']);
$cart_total = $tracking_data['cart_total'];
$order_id = $tracking_data['order_id'];
if (isset($customer_id)) $cust_id=$customer_id;
else $cust_id=$tracking_data['customer_id'];

$current_page=addslashes(tep_db_input(urldecode($_SERVER['PHP_SELF'])));
$last_click = date('Y-m-d H:i:s');


Line 121 //Find out if the customer has added something to their cart for the first time
Line 122 if (($added_cart!='true') && ($cart->count_contents()>0)) $added_cart = 'true';

//Has a purchase just been completed?
if ((strstr($current_page, 'checkout_success.php'))&& ($completed_purchase!='true')) {
$completed_purchase='true';
$order_q = "select orders_id from orders where customers_id = '" . $cust_id . "' ORDER BY date_purchased DESC";
$order_result = tep_db_query($order_q);
if (tep_db_num_rows($order_result) > 0) {
$order_row = tep_db_fetch_array($order_result);
Line 131 $order_id = $order_row['orders_id'];
}
}

[countrygirlcandles]

I am getting alot of these errors at the top of my main page any ideas on how to fix it?

[27-Jul-2011 18:25:37] PHP Deprecated: Function eregi() is deprecated in /home/country/public_html/includes/classes/supertracker.php on line 216

[26-Jul-2011 16:41:56] PHP Deprecated: Function eregi() is deprecated in /home/country/public_html/includes/classes/supertracker.php on line 42

[ftrippie]

Hi,
This addon is working perfectly for me for my spanish site. But now trying to watch the site from the Netherlands, it fails with a SQL error:
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 's-heerenberg', '', '','/noneedtoknow.html','/product_info.php','2011-12-26 1' at line 1

INSERT INTO `supertracker` (`ip_address`, `browser_string`, `country_code`, `country_name`, `country_region`, `country_city`, `referrer`,`referrer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`,`browser`) VALUES ('ip-noneedtoknow','Mozilla/5.0 (Windows NT 5.1; rv:6.0) Gecko/20100101 Firefox/6.0','nl', 'Netherlands', 'Gelderland', ''s-heerenberg', '', '','/noneedtoknow.html','/product_info.php','2011-12-26 11:41:55','2011-12-26 11:41:55','Mozilla Firefox')

I think I know exactly where it comes from; the city it found starts with a comma ('s-heerenberg) and therefore confuses the comma-delimited input. Anybody knows how to solve that (check and remove commas from the inputfields)?

Cheers!

[ftrippie]

Right, sorted already. Just added it to be stripped in the /includes/classes/supertracker.php:

$city_name= preg_replace('/[\']/', '', $city_name);

Cheers

[vmjarala]

Hi!
I am posting this at the risk of sounding like a complete newbie. BUT I followed the links on the installation file and only got to MaxMind to poke around and not find the downloads nor how to create an account. I was only able to dowload the CSV version of CityLite. In reading through many pages of this forum, all I could do was confirm that I actually need the binary version to upload, am I right in thinking this?

What really obvious part did I miss?

THANKS!
Veroncia

[vmjarala]

Sorry! I had to post to this thread, so then I could turn around and find what I needed.

[rabon33]

vmjarala, on 12 January 2012, 21:34, said:

Hi!
I am posting this at the risk of sounding like a complete newbie. BUT I followed the links on the installation file and only got to MaxMind to poke around and not find the downloads nor how to create an account. I was only able to dowload the CSV version of CityLite. In reading through many pages of this forum, all I could do was confirm that I actually need the binary version to upload, am I right in thinking this?

What really obvious part did I miss?

THANKS!
Veroncia

http://www.maxmind.com/app/geoip_country
http://www.maxmind.com/app/geolitecity

[DunWeb]

countrygirlcandles, on 27 July 2011, 23:47, said:

I am getting alot of these errors at the top of my main page any ideas on how to fix it?

[27-Jul-2011 18:25:37] PHP Deprecated: Function eregi() is deprecated in /home/country/public_html/includes/classes/supertracker.php on line 216

[26-Jul-2011 16:41:56] PHP Deprecated: Function eregi() is deprecated in /home/country/public_html/includes/classes/supertracker.php on line 42

Deprecated ereg error correction:

Line 42 is this:

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

Change it to this:

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

Line 216 is this:

if (eregi($pattern, $user_agent))

change it to this:

if (preg_match('/$pattern/', '/$user_agent/'))



Chris

[JoshBowe]

Hi guys, I'm getting a MySQL error when a customer visits the site and their location contains an apostrophe, such as:


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 'ka Oblast'', 'Kharkov', '', '','/','/index.php','2012-02-23 11:36:33','2012-02-2' at line 1

INSERT INTO `supertracker` (`ip_address`, `browser_string`, `country_code`, `country_name`, `country_region`, `country_city`, `referrer`,`referrer_query_string`,`landing_page`,`exit_page`,`time_arrived`,`last_click`,`browser`) VALUES ('193.178.250.242','Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.56 Safari/535.11','ua', 'Ukraine', 'Kharkivs'ka Oblast'', 'Kharkov', '', '','/','/index.php','2012-02-23 11:36:33','2012-02-23 11:36:33','Safari')

[TEP STOP]

Has anyone got a solution? Thanks.

[JoshBowe]

Any ideas?

[spc456]

@JoshBowe
I am sorry to bother you, please let me know how do I start a Post.

I have an installation question for Supertracker but I don't know where to post the question:

On Step 1 of installation instruction:

UPLOAD the "catalog" folder to the corresponding folders:
1) catalog/images/st_no_image.jpg
2) catalog/supertracker_setup_db.php
3) catalog/includes/classes/supertracker.php
4) catalog/includes/geoip.inc
5) catalog/includes/geoipregionvars.php

6) admin/supertracker.php <-- is this a typo?
On my isntallation of oscommerce_2.3.1. I don't have www.mysite.com/admin/ but I have www.mysite.com/catalog/admin/
Should it be: catalog/admin/supertracker.php ?

7) catalog/admin/includes/languages/english/supertracker.php
8) catalog/admin/includes/languages/espanol/supertracker.php
9) catalog/admin/includes/languages/french/supertracker.php
10) catalog/admin/includes/languages/german/supertracker.php

11) admin/images/geo_flags/flags <-- is this a typo?
Same question here?

I would appreciate very much if you can help.

Regards,

spc456

[JoshBowe]

/catalog/ is just a typo. It should be uploaded to /admin/ as you assumed. The second one with the flag images is not a typo though.