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

[svnmaster at piwik.org]

Author: matt
Date: 2008-03-09 20:21:26 +0100 (Sun, 09 Mar 2008)
New Revision: 337

Modified:
   trunk/plugins/Actions/Actions.php
Log:
- fixing "Uncaught exception: 'SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'idaction' in group statement is ambiguous'"

Modified: trunk/plugins/Actions/Actions.php
===================================================================
--- trunk/plugins/Actions/Actions.php	2008-03-09 01:31:01 UTC (rev 336)
+++ trunk/plugins/Actions/Actions.php	2008-03-09 19:21:26 UTC (rev 337)
@@ -101,10 +101,10 @@
 							count(*) as nb_hits							
 				 	FROM (".$archiveProcessing->logTable." as t1
 						LEFT JOIN ".$archiveProcessing->logVisitActionTable." as t2 USING (idvisit))
-							LEFT JOIN ".$archiveProcessing->logActionTable." USING (idaction)
+							LEFT JOIN ".$archiveProcessing->logActionTable." as t3 USING (idaction)
 				 	WHERE visit_server_date = ?
 				 		AND idsite = ?
-				 	GROUP BY idaction";
+				 	GROUP BY t3.idaction";
 		$query = $archiveProcessing->db->query($query, array( $archiveProcessing->strDateStart, $archiveProcessing->idsite ));
 				
 		$modified = $this->updateActionsTableWithRowQuery($query);