I downloaded this new Free VQMOD called Google Analytics E-commerce conversion[vQmod] and it does not seem to be working properly. I have contacted the developer but to no avail.
The error message I seem to be getting is:
2013-03-18 18:08:02 - PHP Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /store/vqmod/vqcache/vq2-catalog_controller_checkout_success.php on line 15
This is the code that is having an error:
Code: Select all
//Get order detail for Google analytics
$order_query = mysql_query("SELECT * FROM `order` WHERE order_id = ".mysql_real_escape_string($this->session->data['order_id'])."");
if(mysql_num_rows($order_query) == 1){
$this->data['analytics'] = TRUE;
$order_result = mysql_fetch_assoc($order_query);