[Piwik-svn] r326 - trunk/plugins/Actions

[svnmaster at piwik.org]

Author: matt
Date: 2008-03-08 17:39:44 +0100 (Sat, 08 Mar 2008)
New Revision: 326

Modified:
   trunk/plugins/Actions/Actions.php
Log:
- fixing ambiguous field name mysql select join

Modified: trunk/plugins/Actions/Actions.php
===================================================================
--- trunk/plugins/Actions/Actions.php	2008-03-08 16:31:19 UTC (rev 325)
+++ trunk/plugins/Actions/Actions.php	2008-03-08 16:39:44 UTC (rev 326)
@@ -9,7 +9,6 @@
  * @package Piwik_Actions
  */
 	
-
 /**
  * 
  * @package Piwik_Actions
@@ -98,10 +97,10 @@
 		 */
 		$query = "SELECT 	name,
 							type,
-							count(distinct idvisit) as nb_visits, 
+							count(distinct t1.idvisit) as nb_visits, 
 							count(*) as nb_hits							
-				 	FROM (".$archiveProcessing->logTable." 
-						LEFT JOIN ".$archiveProcessing->logVisitActionTable." USING (idvisit))
+				 	FROM (".$archiveProcessing->logTable." as t1
+						LEFT JOIN ".$archiveProcessing->logVisitActionTable." as t2 USING (idvisit))
 							LEFT JOIN ".$archiveProcessing->logActionTable." USING (idaction)
 				 	WHERE visit_server_date = ?
 				 		AND idsite = ?