[Piwik-svn] r369 - trunk/modules

[svnmaster at piwik.org]

Author: matt
Date: 2008-03-13 09:59:52 +0100 (Thu, 13 Mar 2008)
New Revision: 369

Modified:
   trunk/modules/Access.php
Log:
- fixing Uncaught exception: 'SQLSTATE[23000]: Integrity constraint violation:
1052 Column 'idsite' in field list is ambiguous'

Modified: trunk/modules/Access.php
===================================================================
--- trunk/modules/Access.php	2008-03-12 17:14:55 UTC (rev 368)
+++ trunk/modules/Access.php	2008-03-13 08:59:52 UTC (rev 369)
@@ -103,9 +103,9 @@
 				
 				// we join with site in case there are rows in access for an idsite that doesn't exist anymore
 				// (backward compatibility ; before we deleted the site without deleting rows in _access table)
-				$accessRaw = $db->fetchAll("SELECT access, idsite 
-								  FROM ".Piwik::prefixTable('access').
-									" JOIN ".Piwik::prefixTable('site')." USING (idsite) ".
+				$accessRaw = $db->fetchAll("SELECT access, t2.idsite 
+								  FROM ".Piwik::prefixTable('access'). " as t1 
+									JOIN ".Piwik::prefixTable('site')." as t2 USING (idsite) ".
 								" WHERE login=?", $this->identity);
 	
 				foreach($accessRaw as $access)