I've just started having problems with Supertracker with the following error message when I view the catalog side of the website (admin works fine). Other users from different regions can view the catalog with no problems
I presume it's something to do with the apostophe in "Cotes d'Azur" but I don't know where it's being generated from, I've checked the GeoLiteCity.dat file but can't find it
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 'Azur', 'Carros', '', '','/boutique/','/boutique/index.php','2012-07-23 13:49:26'' 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 ('109.210.88.122','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_8) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.57 Safari/536.11','fr', 'France', 'Provence-Alpes-Cote d'Azur', 'Carros', '', '','/boutique/','/boutique/index.php','2012-07-23 13:49:26','2012-07-23 13:49:26','Unknown')
[TEP STOP]
Many Thanks
Simon