Plötzlich keine Daten mehr


#1

Hallo Leute,

nachdem ich auf die neuste Version von piwik (1.5) von 1.4 geupdatet hatte hatte ich erstmal den neuen Bug mit dem “Nesting level too deep”. Nach dem ich dann, wie im Bug Tracker beschrieben den Patch angewendet hatte kamen Fehler ala:


Notice: Undefined offset:  4 in  /srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php

Darauf hin habe ich mir noch mal 1.5 runtergeladen und alle Dateien überschrieben. Das hatte auch dann keine Fehler mehr gemeldet.

Nun schaute ich heut morgen in mein Piwik und sah das plötzlich keine Daten mehr angezeigt werden.

In der Übersicht steht überall aufeinmal nur noch “0”:

[attachment 240 piwik.jpg]

Wenn ich in die einzelnen Seiten reinschaue sind auch noch die Statistiken für die älteren Monate sichtbar, allerdings nicht für den laufenden Monat.

Die Archivierung lasse ich über einen CronJob laufen und habe sie für den Browser deaktiviert. Als Zeitinterval habe ich 1800 Sekunden eingestellt und der CronJob läuft einmal die Stunde.

Im Dashboard sieht man unter den “Besuchern in Echtzeit” das auch noch Besucher registriert werden (innerhalb der letzten 24 Std und in den letzten 30 mins).

Woran kann das liegen? Wie bekomme ich die Daten wieder angezeigt?


#2

Nagut, nun hab ich mal den cron noch mal manuell durch jagen lassen, anscheind ist der nicht mehr richtig aktiv, muss ich gleich mal kontrollieren…

Allerdings hatte er mir den üblichen Nesting fehler gemeldet, den ich mit dem Patch behoben habe.

Nun erhalte ich allerdings doch wieder haufenweise fehler… aber dafür die Daten augenscheinlich wieder sichtbar…

Fehler sind folgende:


Notice:</strong> <i>Undefined offset:  4</i> in <b>/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php</b> on line <b>668</b>
Notice:</strong> <i>Undefined offset:  5</i> in <b>/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php</b> on line <b>669</b>
Notice:</strong> <i>Undefined offset:  6</i> in <b>/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php</b> on line <b>670</b>
Notice:</strong> <i>Undefined offset:  7</i> in <b>/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php</b> on line <b>671</b>

Dies taucht 3-4 mal auf, natürlich noch mit dem Backtrace (habe ich aufgrund der Übersicht mal nicht gepostet). Allerdings anscheinend - soweit ich das bemerken kann - nur bei meiner neusten SiteId.

Lasse mir nun per cron die Daten loggen damit ich es mal komplett habe und berichte wieder, falls jemand bisdahin nicht schon ne lösung hat.


(Peterbo) #3

GoSnA, wenn du möchtest, kannst du mir mal deine FTP-Zugangsdaten und Zugangsdaten zu Piwik schicken. Dann kann ich mir das genauer ansehen.

~Peter (Piwik Team)


#4

Wegen Zugangsdaten muss ich erstmal was umstellen :wink:

Aber hier ein Update, da nun die Fehler wieder kamen:

Also der Fehler trat nun wirklich nur bei der neusten Site auf.

Auszug:


*schnipp*

Archiving period = day for idsite = 8...

<div style='word-wrap: break-word; border: 3px solid red; padding:4px; width:70%; background-color:#FFFF96;'>
	    <strong>There is an error. Please report the message and full backtrace in the <a href='?module=Proxy&action=redirect&url=http://forum.piwik.org' target='_blank'>Piwik forums</a> (please do a Search first as it might have been reported already!).<br /><br/>
	    Notice:</strong> <i>Undefined offset:  4</i> in <b>/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php</b> on line <b>668</b>
<br /><br />Backtrace --><div style="font-family:Courier;font-size:10pt">#0  Piwik_ErrorHandler(Array([0] => 8 [1] => Undefined offset: 4 [2] => /srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php [3] => 668 [4] => Array ([newRowToAdd] => Array ([custom_var_k2] => Kategorie [custom_var_v2] => Kreditkarten / Cash [1] => 1 [2] => 1 [3] => 83 [4] => 83 [5] => 7305 [6] => 0 [7] => 0 ) [oldRowToUpdate] => Array ([1] => 4 [2] => 4 [3] => 88 ) [onlyMetricsAvailableInActionsTable] => )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php:668]#1  Piwik_ArchiveProcessing_Day->updateInterestStats(Array([0] => Array ([custom_var_k2] => Kategorie [custom_var_v2] => Kreditkarten / Cash [1] => 1 [2] => 1 [3] => 83 [4] => 83 [5] => 7305 [6] => 0 [7] => 0 ) [1] => Array ([1] => 4 [2] => 4 [3] => 88 )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/CustomVariables/CustomVariables.php:165]#2  Piwik_CustomVariables->archiveDayAggregate(Array([0] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected] => day [subperiods:protected] => Array () [subperiodsProcessed:protected] => 1 [date:protected] => P...#3  Piwik_CustomVariables->archiveDay(Array([0] => Piwik_Event_Notification Object ([_notificationName] => ArchiveProcessing_Day.compute [_notificationObject] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected...#4  call_user_func_array(Array([0] => Array ([0] => Piwik_CustomVariables Object ([archiveProcessing] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected] => day [subperiods:protected] => Array () [subperiodsPr...#5  Event_Dispatcher->postNotification(Array([0] => Piwik_Event_Notification Object ([_notificationName] => ArchiveProcessing_Day.compute [_notificationObject] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protecte...#6  Piwik_PostEvent(Array([0] => ArchiveProcessing_Day.compute [1] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected] => day [subperiods:protected] => Array () [subperiodsProcessed:protected] => 1 [date:prote...#7  Piwik_ArchiveProcessing_Day->compute(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing.php:429]#8  Piwik_ArchiveProcessing->launchArchiving(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Single.php:217]#9  Piwik_Archive_Single->prepareArchive(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Single.php:246]#10  Piwik_Archive_Single->get(Array([0] => nb_visits [1] => numeric) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Single.php:424]#11  Piwik_Archive_Single->getNumeric(Array([0] => nb_visits) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Array.php:89]#12  Piwik_Archive_Array->getNumeric(Array([0] => nb_visits) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/VisitsSummary/API.php:110]#13  Piwik_VisitsSummary_API->getNumeric(Array([0] => 8 [1] => day [2] => last52 [3] => [4] => nb_visits) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/VisitsSummary/API.php:116]#14  Piwik_VisitsSummary_API->getVisits(Array([0] => 8 [1] => day [2] => last52 [3] => ) called at [:]#15  call_user_func_array(Array([0] => Array ([0] => Piwik_VisitsSummary_API Object () [1] => getVisits ) [1] => Array ([0] => 8 [1] => day [2] => last52 [3] => )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/API/Proxy.php:179]#16  Piwik_API_Proxy->call(Array([0] => Piwik_VisitsSummary_API [1] => getVisits [2] => Array ([token_auth] => bd693eff906e66b20cb674614924f6c4 [--] => [module] => API [method] => VisitsSummary.getVisits [idSite] => 8 [period] => day [date] => last52 [format] => xml [filter_limit] => 50 )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/API/Request.php:121]#17  Piwik_API_Request->process(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/API/Controller.php:27]#18  Piwik_API_Controller->index(Array() called at [:]#19  call_user_func_array(Array([0] => Array ([0] => Piwik_API_Controller Object ([pluginName:protected] => API [strDate:protected] => [date:protected] => [idSite:protected] => 8 [site:protected] => ) [1] => index ) [1] => Array ()) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/FrontController.php:127]#20  Piwik_FrontController->dispatch(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/index.php:53]</div><br />
 </pre></div><br />
<div style='word-wrap: break-word; border: 3px solid red; padding:4px; width:70%; background-color:#FFFF96;'>
	    <strong>There is an error. Please report the message and full backtrace in the <a href='?module=Proxy&action=redirect&url=http://forum.piwik.org' target='_blank'>Piwik forums</a> (please do a Search first as it might have been reported already!).<br /><br/>
	    Notice:</strong> <i>Undefined offset:  5</i> in <b>/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php</b> on line <b>669</b>
<br /><br />Backtrace --><div style="font-family:Courier;font-size:10pt">#0  Piwik_ErrorHandler(Array([0] => 8 [1] => Undefined offset: 5 [2] => /srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php [3] => 669 [4] => Array ([newRowToAdd] => Array ([custom_var_k2] => Kategorie [custom_var_v2] => Kreditkarten / Cash [1] => 1 [2] => 1 [3] => 83 [4] => 83 [5] => 7305 [6] => 0 [7] => 0 ) [oldRowToUpdate] => Array ([1] => 4 [2] => 4 [3] => 88 [4] => 83 ) [onlyMetricsAvailableInActionsTable] => )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php:669]#1  Piwik_ArchiveProcessing_Day->updateInterestStats(Array([0] => Array ([custom_var_k2] => Kategorie [custom_var_v2] => Kreditkarten / Cash [1] => 1 [2] => 1 [3] => 83 [4] => 83 [5] => 7305 [6] => 0 [7] => 0 ) [1] => Array ([1] => 4 [2] => 4 [3] => 88 [4] => 83 )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/CustomVariables/CustomVariables.php:165]#2  Piwik_CustomVariables->archiveDayAggregate(Array([0] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected] => day [subperiods:protected] => Array () [subperiodsProcessed:protected] => 1 [date:protected] => P...#3  Piwik_CustomVariables->archiveDay(Array([0] => Piwik_Event_Notification Object ([_notificationName] => ArchiveProcessing_Day.compute [_notificationObject] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected...#4  call_user_func_array(Array([0] => Array ([0] => Piwik_CustomVariables Object ([archiveProcessing] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected] => day [subperiods:protected] => Array () [subperiodsPr...#5  Event_Dispatcher->postNotification(Array([0] => Piwik_Event_Notification Object ([_notificationName] => ArchiveProcessing_Day.compute [_notificationObject] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protecte...#6  Piwik_PostEvent(Array([0] => ArchiveProcessing_Day.compute [1] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected] => day [subperiods:protected] => Array () [subperiodsProcessed:protected] => 1 [date:prote...#7  Piwik_ArchiveProcessing_Day->compute(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing.php:429]#8  Piwik_ArchiveProcessing->launchArchiving(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Single.php:217]#9  Piwik_Archive_Single->prepareArchive(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Single.php:246]#10  Piwik_Archive_Single->get(Array([0] => nb_visits [1] => numeric) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Single.php:424]#11  Piwik_Archive_Single->getNumeric(Array([0] => nb_visits) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Array.php:89]#12  Piwik_Archive_Array->getNumeric(Array([0] => nb_visits) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/VisitsSummary/API.php:110]#13  Piwik_VisitsSummary_API->getNumeric(Array([0] => 8 [1] => day [2] => last52 [3] => [4] => nb_visits) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/VisitsSummary/API.php:116]#14  Piwik_VisitsSummary_API->getVisits(Array([0] => 8 [1] => day [2] => last52 [3] => ) called at [:]#15  call_user_func_array(Array([0] => Array ([0] => Piwik_VisitsSummary_API Object () [1] => getVisits ) [1] => Array ([0] => 8 [1] => day [2] => last52 [3] => )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/API/Proxy.php:179]#16  Piwik_API_Proxy->call(Array([0] => Piwik_VisitsSummary_API [1] => getVisits [2] => Array ([token_auth] => bd693eff906e66b20cb674614924f6c4 [--] => [module] => API [method] => VisitsSummary.getVisits [idSite] => 8 [period] => day [date] => last52 [format] => xml [filter_limit] => 50 )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/API/Request.php:121]#17  Piwik_API_Request->process(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/API/Controller.php:27]#18  Piwik_API_Controller->index(Array() called at [:]#19  call_user_func_array(Array([0] => Array ([0] => Piwik_API_Controller Object ([pluginName:protected] => API [strDate:protected] => [date:protected] => [idSite:protected] => 8 [site:protected] => ) [1] => index ) [1] => Array ()) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/FrontController.php:127]#20  Piwik_FrontController->dispatch(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/index.php:53]</div><br />
 </pre></div><br />
<div style='word-wrap: break-word; border: 3px solid red; padding:4px; width:70%; background-color:#FFFF96;'>
	    <strong>There is an error. Please report the message and full backtrace in the <a href='?module=Proxy&action=redirect&url=http://forum.piwik.org' target='_blank'>Piwik forums</a> (please do a Search first as it might have been reported already!).<br /><br/>
	    Notice:</strong> <i>Undefined offset:  6</i> in <b>/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php</b> on line <b>670</b>
<br /><br />Backtrace --><div style="font-family:Courier;font-size:10pt">#0  Piwik_ErrorHandler(Array([0] => 8 [1] => Undefined offset: 6 [2] => /srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php [3] => 670 [4] => Array ([newRowToAdd] => Array ([custom_var_k2] => Kategorie [custom_var_v2] => Kreditkarten / Cash [1] => 1 [2] => 1 [3] => 83 [4] => 83 [5] => 7305 [6] => 0 [7] => 0 ) [oldRowToUpdate] => Array ([1] => 4 [2] => 4 [3] => 88 [4] => 83 [5] => 7305 ) [onlyMetricsAvailableInActionsTable] => )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php:670]#1  Piwik_ArchiveProcessing_Day->updateInterestStats(Array([0] => Array ([custom_var_k2] => Kategorie [custom_var_v2] => Kreditkarten / Cash [1] => 1 [2] => 1 [3] => 83 [4] => 83 [5] => 7305 [6] => 0 [7] => 0 ) [1] => Array ([1] => 4 [2] => 4 [3] => 88 [4] => 83 [5] => 7305 )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/CustomVariables/CustomVariables.php:165]#2  Piwik_CustomVariables->archiveDayAggregate(Array([0] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected] => day [subperiods:protected] => Array () [subperiodsProcessed:protected] => 1 [date:protected] => P...#3  Piwik_CustomVariables->archiveDay(Array([0] => Piwik_Event_Notification Object ([_notificationName] => ArchiveProcessing_Day.compute [_notificationObject] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected...#4  call_user_func_array(Array([0] => Array ([0] => Piwik_CustomVariables Object ([archiveProcessing] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected] => day [subperiods:protected] => Array () [subperiodsPr...#5  Event_Dispatcher->postNotification(Array([0] => Piwik_Event_Notification Object ([_notificationName] => ArchiveProcessing_Day.compute [_notificationObject] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protecte...#6  Piwik_PostEvent(Array([0] => ArchiveProcessing_Day.compute [1] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected] => day [subperiods:protected] => Array () [subperiodsProcessed:protected] => 1 [date:prote...#7  Piwik_ArchiveProcessing_Day->compute(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing.php:429]#8  Piwik_ArchiveProcessing->launchArchiving(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Single.php:217]#9  Piwik_Archive_Single->prepareArchive(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Single.php:246]#10  Piwik_Archive_Single->get(Array([0] => nb_visits [1] => numeric) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Single.php:424]#11  Piwik_Archive_Single->getNumeric(Array([0] => nb_visits) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Array.php:89]#12  Piwik_Archive_Array->getNumeric(Array([0] => nb_visits) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/VisitsSummary/API.php:110]#13  Piwik_VisitsSummary_API->getNumeric(Array([0] => 8 [1] => day [2] => last52 [3] => [4] => nb_visits) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/VisitsSummary/API.php:116]#14  Piwik_VisitsSummary_API->getVisits(Array([0] => 8 [1] => day [2] => last52 [3] => ) called at [:]#15  call_user_func_array(Array([0] => Array ([0] => Piwik_VisitsSummary_API Object () [1] => getVisits ) [1] => Array ([0] => 8 [1] => day [2] => last52 [3] => )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/API/Proxy.php:179]#16  Piwik_API_Proxy->call(Array([0] => Piwik_VisitsSummary_API [1] => getVisits [2] => Array ([token_auth] => bd693eff906e66b20cb674614924f6c4 [--] => [module] => API [method] => VisitsSummary.getVisits [idSite] => 8 [period] => day [date] => last52 [format] => xml [filter_limit] => 50 )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/API/Request.php:121]#17  Piwik_API_Request->process(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/API/Controller.php:27]#18  Piwik_API_Controller->index(Array() called at [:]#19  call_user_func_array(Array([0] => Array ([0] => Piwik_API_Controller Object ([pluginName:protected] => API [strDate:protected] => [date:protected] => [idSite:protected] => 8 [site:protected] => ) [1] => index ) [1] => Array ()) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/FrontController.php:127]#20  Piwik_FrontController->dispatch(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/index.php:53]</div><br />
 </pre></div><br />
<div style='word-wrap: break-word; border: 3px solid red; padding:4px; width:70%; background-color:#FFFF96;'>
	    <strong>There is an error. Please report the message and full backtrace in the <a href='?module=Proxy&action=redirect&url=http://forum.piwik.org' target='_blank'>Piwik forums</a> (please do a Search first as it might have been reported already!).<br /><br/>
	    Notice:</strong> <i>Undefined offset:  7</i> in <b>/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php</b> on line <b>671</b>
<br /><br />Backtrace --><div style="font-family:Courier;font-size:10pt">#0  Piwik_ErrorHandler(Array([0] => 8 [1] => Undefined offset: 7 [2] => /srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php [3] => 671 [4] => Array ([newRowToAdd] => Array ([custom_var_k2] => Kategorie [custom_var_v2] => Kreditkarten / Cash [1] => 1 [2] => 1 [3] => 83 [4] => 83 [5] => 7305 [6] => 0 [7] => 0 ) [oldRowToUpdate] => Array ([1] => 4 [2] => 4 [3] => 88 [4] => 83 [5] => 7305 [6] => 0 ) [onlyMetricsAvailableInActionsTable] => )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing/Day.php:671]#1  Piwik_ArchiveProcessing_Day->updateInterestStats(Array([0] => Array ([custom_var_k2] => Kategorie [custom_var_v2] => Kreditkarten / Cash [1] => 1 [2] => 1 [3] => 83 [4] => 83 [5] => 7305 [6] => 0 [7] => 0 ) [1] => Array ([1] => 4 [2] => 4 [3] => 88 [4] => 83 [5] => 7305 [6] => 0 )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/CustomVariables/CustomVariables.php:165]#2  Piwik_CustomVariables->archiveDayAggregate(Array([0] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected] => day [subperiods:protected] => Array () [subperiodsProcessed:protected] => 1 [date:protected] => P...#3  Piwik_CustomVariables->archiveDay(Array([0] => Piwik_Event_Notification Object ([_notificationName] => ArchiveProcessing_Day.compute [_notificationObject] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected...#4  call_user_func_array(Array([0] => Array ([0] => Piwik_CustomVariables Object ([archiveProcessing] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected] => day [subperiods:protected] => Array () [subperiodsPr...#5  Event_Dispatcher->postNotification(Array([0] => Piwik_Event_Notification Object ([_notificationName] => ArchiveProcessing_Day.compute [_notificationObject] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protecte...#6  Piwik_PostEvent(Array([0] => ArchiveProcessing_Day.compute [1] => Piwik_ArchiveProcessing_Day Object ([idArchive:protected] => 14520 [periodId:protected] => 1 [timestampDateStart:protected] => [dateStart:protected] => [dateEnd:protected] => [tableArchiveNumeric:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_numeric [generatedTableName:protected] => piwik_archive_numeric_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [tableArchiveBlob:protected] => Piwik_TablePartitioning_Monthly Object ([tableName:protected] => archive_blob [generatedTableName:protected] => piwik_archive_blob_2011_06 [timestamp:protected] => 1308842130 [idSite:protected] => 8 ) [minDatetimeArchiveProcessedUTC:protected] => 1308833130 [compressBlob:protected] => 1 [temporaryArchive:protected] => 1 [idsite] => 8 [period] => Piwik_Period_Day Object ([label:protected] => day [subperiods:protected] => Array () [subperiodsProcessed:protected] => 1 [date:prote...#7  Piwik_ArchiveProcessing_Day->compute(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/ArchiveProcessing.php:429]#8  Piwik_ArchiveProcessing->launchArchiving(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Single.php:217]#9  Piwik_Archive_Single->prepareArchive(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Single.php:246]#10  Piwik_Archive_Single->get(Array([0] => nb_visits [1] => numeric) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Single.php:424]#11  Piwik_Archive_Single->getNumeric(Array([0] => nb_visits) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/Archive/Array.php:89]#12  Piwik_Archive_Array->getNumeric(Array([0] => nb_visits) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/VisitsSummary/API.php:110]#13  Piwik_VisitsSummary_API->getNumeric(Array([0] => 8 [1] => day [2] => last52 [3] => [4] => nb_visits) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/VisitsSummary/API.php:116]#14  Piwik_VisitsSummary_API->getVisits(Array([0] => 8 [1] => day [2] => last52 [3] => ) called at [:]#15  call_user_func_array(Array([0] => Array ([0] => Piwik_VisitsSummary_API Object () [1] => getVisits ) [1] => Array ([0] => 8 [1] => day [2] => last52 [3] => )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/API/Proxy.php:179]#16  Piwik_API_Proxy->call(Array([0] => Piwik_VisitsSummary_API [1] => getVisits [2] => Array ([token_auth] => bd693eff906e66b20cb674614924f6c4 [--] => [module] => API [method] => VisitsSummary.getVisits [idSite] => 8 [period] => day [date] => last52 [format] => xml [filter_limit] => 50 )) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/API/Request.php:121]#17  Piwik_API_Request->process(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/plugins/API/Controller.php:27]#18  Piwik_API_Controller->index(Array() called at [:]#19  call_user_func_array(Array([0] => Array ([0] => Piwik_API_Controller Object ([pluginName:protected] => API [strDate:protected] => [date:protected] => [idSite:protected] => 8 [site:protected] => ) [1] => index ) [1] => Array ()) called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/core/FrontController.php:127]#20  Piwik_FrontController->dispatch(Array() called at [/srv/www/vhosts/xxxx.de/subdomains/piwik/httpdocs/index.php:53]</div><br />
 </pre></div><br /><?xml version="1.0" encoding="utf-8" ?>
<results>
	<result date="2011-05-03" />
	<result date="2011-05-04" />
	<result date="2011-05-05" />

*schnapp*

Das XML Ergebnis zeigt er danach trotzdem wieder an.

Soweit ich es allerdings mitbekommen hat passiert der gleiche Fehler auch bei der Archivierung der Perioden “week, month, year”, so das ich dieses haufen ganze 4 mal bekomme.


#5

Wo ich mir die Daten mal etwas genauer anschaue, glaube ich das es an den CustomVariables liegen könnte, weil die neue Site ist die einzige die solche Verwendet…

die Funktion in der Betroffenen Datei wird anscheinden dem Backtrack zufolge mit folgenden Parametern aufgerufen


	[newRowToAdd] => Array (
		[custom_var_k2] => Kategorie 
		[custom_var_v2] => Kreditkarten / Cash 
		[1] => 1 
		[2] => 1 
		[3] => 83 
		[4] => 83 
		[5] => 7305 
		[6] => 0 
		[7] => 0 
	)
	[oldRowToUpdate] => Array (
		[1] => 4 
		[2] => 4 
		[3] => 88 
	)

In den Betroffenen Zeilen:


		$oldRowToUpdate[Piwik_Archive::INDEX_MAX_ACTIONS] 		 	= (float)max($newRowToAdd[Piwik_Archive::INDEX_MAX_ACTIONS], $oldRowToUpdate[Piwik_Archive::INDEX_MAX_ACTIONS]);
		$oldRowToUpdate[Piwik_Archive::INDEX_SUM_VISIT_LENGTH]		+= $newRowToAdd[Piwik_Archive::INDEX_SUM_VISIT_LENGTH];
		$oldRowToUpdate[Piwik_Archive::INDEX_BOUNCE_COUNT] 			+= $newRowToAdd[Piwik_Archive::INDEX_BOUNCE_COUNT];
		$oldRowToUpdate[Piwik_Archive::INDEX_NB_VISITS_CONVERTED] 	+= $newRowToAdd[Piwik_Archive::INDEX_NB_VISITS_CONVERTED];

diese Indexe (Constanten) sind ja in der Archive.php zugeweisen:


	const INDEX_MAX_ACTIONS = 4;
	const INDEX_SUM_VISIT_LENGTH = 5;
	const INDEX_BOUNCE_COUNT = 6;
	const INDEX_NB_VISITS_CONVERTED = 7;

Nun will piwik diese Indexe von “oldRowToUpdate” benutzen, welche es aber nicht gibt.
Nun verstehe ich allerdings nicht, wieso er dann in diesen Zeilen den Index nicht einfach anlegt, weil laut meinen PHP Kenntnissen wird in einem solchen Fall doch normalerweise höhstens eine Notice ausgeworfen und bei einer Zuweisung eines Wertes einfach erstellt.
Und in den oberen Zeilen die ja laut “$newRowToAdd[Piwik_Archive::INDEX_NB_VISITS]” auch abgearbeitet werden funktioniert es ja auch…


(Peterbo) #6

Bestätige bitte kurz, dass die Zeile 642 in ArchiveProcessing/Day.phpso aussieht:


public function updateInterestStats( $newRowToAdd, &$oldRowToUpdate, $onlyMetricsAvailableInActionsTable = false)

Und Zeile 651:


if($onlyMetricsAvailableInActionsTable)


#7

ja tun Sie

Zeile 642:


	public function updateInterestStats( $newRowToAdd, &$oldRowToUpdate, $onlyMetricsAvailableInActionsTable = false)

und 651:


    		if($onlyMetricsAvailableInActionsTable)

Edit: Aber wenn ich den Bugtrace beurteilen kann wird $onlyMetricsAvailableInActionsTable nicht gesetzt


(Peterbo) #8

Richtig. Aber wieso aus der Abfrage keine 7 Felder erzeugt werden, ist sehr merkwürdig. In der Abfrage (Zeile 268) wird eindeutig ein Ergebnis erzeugt, dass 7 Indexe besitzt.


"SELECT 	$select,
							count(distinct idvisitor) as `". Piwik_Archive::INDEX_NB_UNIQ_VISITORS ."`, 
							count(*) as `". Piwik_Archive::INDEX_NB_VISITS ."`,
							sum(visit_total_actions) as `". Piwik_Archive::INDEX_NB_ACTIONS ."`, 
							max(visit_total_actions) as `". Piwik_Archive::INDEX_MAX_ACTIONS ."`, 
							sum(visit_total_time) as `". Piwik_Archive::INDEX_SUM_VISIT_LENGTH ."`,
							sum(case visit_total_actions when 1 then 1 else 0 end) as `". Piwik_Archive::INDEX_BOUNCE_COUNT ."`,
							sum(case visit_goal_converted when 1 then 1 else 0 end) as `". Piwik_Archive::INDEX_NB_VISITS_CONVERTED ."`
				FROM ".Piwik_Common::prefixTable('log_visit')." AS log_visit
				WHERE visit_last_action_time >= ?
						AND visit_last_action_time <= ?
						AND idsite = ?
						$where
						$segment
				GROUP BY $groupBy
				ORDER BY NULL";

Oder sieht das bei dir anders aus?


#9

Da steht folgendes, sieht auf dem ersten Blick gleich aus:


$query = "SELECT 	$select,
					count(distinct idvisitor) as `". Piwik_Archive::INDEX_NB_UNIQ_VISITORS ."`, 
					count(*) as `". Piwik_Archive::INDEX_NB_VISITS ."`,
					sum(visit_total_actions) as `". Piwik_Archive::INDEX_NB_ACTIONS ."`, 
					max(visit_total_actions) as `". Piwik_Archive::INDEX_MAX_ACTIONS ."`, 
					sum(visit_total_time) as `". Piwik_Archive::INDEX_SUM_VISIT_LENGTH ."`,
					sum(case visit_total_actions when 1 then 1 else 0 end) as `". Piwik_Archive::INDEX_BOUNCE_COUNT ."`,
					sum(case visit_goal_converted when 1 then 1 else 0 end) as `". Piwik_Archive::INDEX_NB_VISITS_CONVERTED ."`
		FROM ".Piwik_Common::prefixTable('log_visit')." AS log_visit
		WHERE visit_last_action_time >= ?
				AND visit_last_action_time <= ?
				AND idsite = ?
				$where
				$segment
		GROUP BY $groupBy
		ORDER BY NULL";