diff options
| author | mattpiwik <matthieu.aubry@gmail.com> | 2012-06-01 18:52:28 +0400 |
|---|---|---|
| committer | mattpiwik <matthieu.aubry@gmail.com> | 2012-06-01 18:52:28 +0400 |
| commit | 66fb831a27beb45900fcb777f7fbdc6233c4361f (patch) | |
| tree | b75011473ce266af67d97d50b01661d633d72f5d | |
| parent | 45a55f3c8e3ee5e0769167b10514d59de4697b40 (diff) | |
Better fix for http://forum.piwik.org/read.php?2,89440
git-svn-id: http://dev.piwik.org/svn/trunk@6442 59fd770c-687e-43c8-a1e3-f5a4ff64c105
| -rw-r--r-- | core/ArchiveProcessing.php | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/core/ArchiveProcessing.php b/core/ArchiveProcessing.php index e0b152de7f..b337644301 100644 --- a/core/ArchiveProcessing.php +++ b/core/ArchiveProcessing.php @@ -684,10 +684,17 @@ abstract class Piwik_ArchiveProcessing $db = Zend_Registry::get('db'); $table = $this->tableArchiveNumeric->getTableName(); $locked = self::PREFIX_SQL_LOCK . Piwik_Common::generateUniqId(); - + $date = date("Y-m-d H:i:s"); Piwik_LockTables("$table AS tb1", $table); $db->exec("INSERT INTO $table " - ." SELECT ifnull(max(idarchive),0)+1, '$locked',".(int)$this->idsite.",'','',0,'',0 " + ." SELECT ifnull(max(idarchive),0)+1, + '".$locked."', + ".(int)$this->idsite.", + '".$date."', + '".$date."', + 0, + '".$date."', + 0 " ." FROM $table as tb1"); Piwik_UnlockAllTables(); $id = $db->fetchOne("SELECT idarchive FROM $table WHERE name = ? LIMIT 1", $locked); |