Page 1 of 1

Google Analytics VQMOD: mysql_num_rows() expects parameter 1

Posted: Tue Mar 19, 2013 3:04 am
by FuelCells

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);
I would really appreciate any help I can get!