Graph displays zero visits when visits logged

Support & Bugs
1

All of a sudden on one site the visits graphs is no longer showing any visits even when the visits summary is clearly showing logged visits.

Any ideas what is causing this and how I resolve it ?

Thanks,

Nic

2

Check that you are using: How to Set up Auto-Archiving of Your Reports - Analytics Platform - Matomo ?

3

Yes, auto archiving is enabled Matt and has been since it was installed.
I’ll activate logs and check the cron runs at 5 past the hour, however it looks fine and other crons are running so I don’t suspect the cron.

4

Cron is running Matt, however we have a bnuch of errors.

Looks like the problem might have started after I removed some duplicate funnels on the site in question (not sure how they got duplicated in the first place).

Any ideas how I would resolve ?

====================================

X-Powered-By: PHP/5.3.15
Content-type: text/html

[2013-01-23 09:05:02] [ccf277d1] ---------------------------
[2013-01-23 09:05:02] [ccf277d1] INIT
[2013-01-23 09:05:02] [ccf277d1] Querying Piwik API at: thesite.com
[2013-01-23 09:05:02] [ccf277d1] Running Piwik 1.10.1 as Super User: XXXXXXX
[2013-01-23 09:05:02] [ccf277d1] Notes
[2013-01-23 09:05:02] [ccf277d1] - Reports for today will be processed at most every 1800 seconds. You can change this value in Piwik UI > Settings > General Settings.
[2013-01-23 09:05:02] [ccf277d1] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
[2013-01-23 09:05:02] [ccf277d1] - Archiving was last executed without error 4 days 21 hours ago
[2013-01-23 09:05:02] [ccf277d1] Will process 5 websites with new visits since 4 days 21 hours , IDs: 2, 4, 21, 26, 31
[2013-01-23 09:05:02] [ccf277d1] Will process 3 other websites because the last time they were archived was on a different day (in the website’s timezone) , IDs: 24, 25, 29
[2013-01-23 09:05:02] [ccf277d1] ---------------------------
[2013-01-23 09:05:02] [ccf277d1] START
[2013-01-23 09:05:02] [ccf277d1] Starting Piwik reports archiving…
[2013-01-23 09:05:03] [ccf277d1] ERROR: Got invalid response from API request: thesite.com. Response was ’

There is an error. Please report the message (Piwik 1.10.1) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).

Warning: Invalid argument supplied for foreach() in /home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php on line 659

Backtrace -->

#0 Piwik_ErrorHandler(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php:659]
#1 Piwik_Funnels->storeRefAndNextUrls(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php:319]
#2 Piwik_Funnels->archiveDay(…) called at [:]
#3 call_user_func_array(…) called at [/home/XXXXXXXX/public_html/piwik/libs/Event/Dispatcher.php:284]
#4 Event_Dispatcher->postNotification(…) called at [/home/XXXXXXXX/public_html/piwik/core/PluginsManager.php:723]
#5 Piwik_PostEvent(…) called at [/home/XXXXXXXX/public_html/piwik/core/ArchiveProcessing/Day.php:45]
#6 Piwik_ArchiveProcessing_Day->compute(…) called at [/home/XXXXXXXX/public_html/piwik/core/ArchiveProcessing.php:498]
#7 Piwik_ArchiveProcessing->launchArchiving(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:236]
#8 Piwik_Archive_Single->prepareArchive(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:266]
#9 Piwik_Archive_Single->get(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:462]
#10 Piwik_Archive_Single->getNumeric(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Array.php:93]
#11 Piwik_Archive_Array->getNumeric(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/VisitsSummary/API.php:114]
#12 Piwik_VisitsSummary_API->getNumeric(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/VisitsSummary/API.php:120]
#13 Piwik_VisitsSummary_API->getVisits(…) called at [:]
#14 call_user_func_array(…) called at [/home/XXXXXXXX/public_html/piwik/core/API/Proxy.php:190]
#15 Piwik_API_Proxy->call(…) called at [/home/XXXXXXXX/public_html/piwik/core/API/Request.php:128]
#16 Piwik_API_Request->process(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/API/Controller.php:27]
#17 Piwik_API_Controller->index(…) called at [:]
#18 call_user_func_array(…) called at [/home/XXXXXXXX/public_html/piwik/core/FrontController.php:138]
#19 Piwik_FrontController->dispatch(…) called at [/home/XXXXXXXX/public_html/piwik/index.php:53]


There is an error. Please report the message (Piwik 1.10.1) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).

Notice: Undefined index: idfunnel in /home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php on line 325

Backtrace -->

#0 Piwik_ErrorHandler(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php:325]
#1 Piwik_Funnels->archiveDay(…) called at [:]
#2 call_user_func_array(…) called at [/home/XXXXXXXX/public_html/piwik/libs/Event/Dispatcher.php:284]
#3 Event_Dispatcher->postNotification(…) called at [/home/XXXXXXXX/public_html/piwik/core/PluginsManager.php:723]
#4 Piwik_PostEvent(…) called at [/home/XXXXXXXX/public_html/piwik/core/ArchiveProcessing/Day.php:45]
#5 Piwik_ArchiveProcessing_Day->compute(…) called at [/home/XXXXXXXX/public_html/piwik/core/ArchiveProcessing.php:498]
#6 Piwik_ArchiveProcessing->launchArchiving(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:236]
#7 Piwik_Archive_Single->prepareArchive(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:266]
#8 Piwik_Archive_Single->get(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:462]
#9 Piwik_Archive_Single->getNumeric(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Array.php:93]
#10 Piwik_Archive_Array->getNumeric(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/VisitsSummary/API.php:114]
#11 Piwik_VisitsSummary_API->getNumeric(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/VisitsSummary/API.php:120]
#12 Piwik_VisitsSummary_API->getVisits(…) called at [:]
#13 call_user_func_array(…) called at [/home/XXXXXXXX/public_html/piwik/core/API/Proxy.php:190]
#14 Piwik_API_Proxy->call(…) called at [/home/XXXXXXXX/public_html/piwik/core/API/Request.php:128]
#15 Piwik_API_Request->process(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/API/Controller.php:27]
#16 Piwik_API_Controller->index(…) called at [:]
#17 call_user_func_array(…) called at [/home/XXXXXXXX/public_html/piwik/core/FrontController.php:138]
#18 Piwik_FrontController->dispatch(…) called at [/home/XXXXXXXX/public_html/piwik/index.php:53]


There is an error. Please report the message (Piwik 1.10.1) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).

Notice: Undefined index: idgoal in /home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php on line 326

Backtrace -->

#0 Piwik_ErrorHandler(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php:326]
#1 Piwik_Funnels->archiveDay(…) called at [:]
#2 call_user_func_array(…) called at [/home/XXXXXXXX/public_html/piwik/libs/Event/Dispatcher.php:284]
#3 Event_Dispatcher->postNotification(…) called at [/home/XXXXXXXX/public_html/piwik/core/PluginsManager.php:723]
#4 Piwik_PostEvent(…) called at [/home/XXXXXXXX/public_html/piwik/core/ArchiveProcessing/Day.php:45]
#5 Piwik_ArchiveProcessing_Day->compute(…) called at [/home/XXXXXXXX/public_html/piwik/core/ArchiveProcessing.php:498]
#6 Piwik_ArchiveProcessing->launchArchiving(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:236]
#7 Piwik_Archive_Single->prepareArchive(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:266]
#8 Piwik_Archive_Single->get(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:462]
#9 Piwik_Archive_Single->getNumeric(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Array.php:93]
#10 Piwik_Archive_Array->getNumeric(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/VisitsSummary/API.php:114]
#11 Piwik_VisitsSummary_API->getNumeric(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/VisitsSummary/API.php:120]
#12 Piwik_VisitsSummary_API->getVisits(…) called at [:]
#13 call_user_func_array(…) called at [/home/XXXXXXXX/public_html/piwik/core/API/Proxy.php:190]
#14 Piwik_API_Proxy->call(…) called at [/home/XXXXXXXX/public_html/piwik/core/API/Request.php:128]
#15 Piwik_API_Request->process(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/API/Controller.php:27]
#16 Piwik_API_Controller->index(…) called at [:]
#17 call_user_func_array(…) called at [/home/XXXXXXXX/public_html/piwik/core/FrontController.php:138]
#18 Piwik_FrontController->dispatch(…) called at [/home/XXXXXXXX/public_html/piwik/index.php:53]


a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:245:“SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘GROUP BY log_conversion.idgoal , label’ at line 14”;}’
[2013-01-23 09:05:03] [ccf277d1] WARNING: Empty or invalid response ‘’ for website id 2, Time elapsed: 1.069s, skipping
[2013-01-23 09:05:04] [ccf277d1] Archived website id = 4, period = day, Time elapsed: 0.149s
[2013-01-23 09:05:04] [ccf277d1] Archived website id = 4, period = week, 43 visits, Time elapsed: 0.477s
[2013-01-23 09:05:06] [ccf277d1] Archived website id = 4, period = month, 190 visits, Time elapsed: 2.231s
[2013-01-23 09:05:07] [ccf277d1] Archived website id = 4, period = year, 4748 visits, Time elapsed: 0.436s
[2013-01-23 09:05:07] [ccf277d1] Archived website id = 4, today = 0 visits, 4 API requests, Time elapsed: 3.294s [2/8 done]
[2013-01-23 09:05:07] [ccf277d1] Archived website id = 21, period = day, Time elapsed: 0.154s
[2013-01-23 09:05:07] [ccf277d1] Archived website id = 21, period = week, 75 visits, Time elapsed: 0.390s
[2013-01-23 09:05:09] [ccf277d1] Archived website id = 21, period = month, 245 visits, Time elapsed: 1.668s
[2013-01-23 09:05:09] [ccf277d1] Archived website id = 21, period = year, 2092 visits, Time elapsed: 0.433s
[2013-01-23 09:05:09] [ccf277d1] Archived website id = 21, today = 0 visits, 4 API requests, Time elapsed: 2.647s [3/8 done]
[2013-01-23 09:05:10] [ccf277d1] Archived website id = 26, period = day, Time elapsed: 0.575s
[2013-01-23 09:05:10] [ccf277d1] Archived website id = 26, period = week, 84 visits, Time elapsed: 0.414s
[2013-01-23 09:05:12] [ccf277d1] Archived website id = 26, period = month, 540 visits, Time elapsed: 1.716s
[2013-01-23 09:05:13] [ccf277d1] Archived website id = 26, period = year, 1915 visits, Time elapsed: 0.479s
[2013-01-23 09:05:13] [ccf277d1] Archived website id = 26, today = 4 visits, 4 API requests, Time elapsed: 3.186s [4/8 done]
[2013-01-23 09:05:13] [ccf277d1] Archived website id = 31, period = day, Time elapsed: 0.118s
[2013-01-23 09:05:13] [ccf277d1] Archived website id = 31, period = week, 20 visits, Time elapsed: 0.373s
[2013-01-23 09:05:14] [ccf277d1] Archived website id = 31, period = month, 86 visits, Time elapsed: 1.320s
[2013-01-23 09:05:15] [ccf277d1] Archived website id = 31, period = year, 155 visits, Time elapsed: 0.404s
[2013-01-23 09:05:15] [ccf277d1] Archived website id = 31, today = 0 visits, 4 API requests, Time elapsed: 2.216s [5/8 done]
[2013-01-23 09:05:15] [ccf277d1] Archived website id = 24, period = day, Time elapsed: 0.120s
[2013-01-23 09:05:15] [ccf277d1] Archived website id = 24, period = week, 0 visits, Time elapsed: 0.152s
[2013-01-23 09:05:15] [ccf277d1] Archived website id = 24, period = month, 0 visits, Time elapsed: 0.212s
[2013-01-23 09:05:15] [ccf277d1] Archived website id = 24, period = year, 141 visits, Time elapsed: 0.178s
[2013-01-23 09:05:15] [ccf277d1] Archived website id = 24, today = 0 visits, 4 API requests, Time elapsed: 0.663s [6/8 done]
[2013-01-23 09:05:16] [ccf277d1] Archived website id = 25, period = day, Time elapsed: 0.144s
[2013-01-23 09:05:16] [ccf277d1] Archived website id = 25, period = week, 0 visits, Time elapsed: 0.166s
[2013-01-23 09:05:16] [ccf277d1] Archived website id = 25, period = month, 0 visits, Time elapsed: 0.195s
[2013-01-23 09:05:16] [ccf277d1] Archived website id = 25, period = year, 2 visits, Time elapsed: 0.183s
[2013-01-23 09:05:16] [ccf277d1] Archived website id = 25, today = 0 visits, 4 API requests, Time elapsed: 0.690s [7/8 done]
[2013-01-23 09:05:16] [ccf277d1] Archived website id = 29, period = day, Time elapsed: 0.124s
[2013-01-23 09:05:16] [ccf277d1] Archived website id = 29, period = week, 0 visits, Time elapsed: 0.128s
[2013-01-23 09:05:17] [ccf277d1] Archived website id = 29, period = month, 0 visits, Time elapsed: 0.199s
[2013-01-23 09:05:17] [ccf277d1] Archived website id = 29, period = year, 0 visits, Time elapsed: 0.176s
[2013-01-23 09:05:17] [ccf277d1] Archived website id = 29, today = 0 visits, 4 API requests, Time elapsed: 0.629s [8/8 done]
[2013-01-23 09:05:17] [ccf277d1] Done archiving!
[2013-01-23 09:05:17] [ccf277d1] ---------------------------
[2013-01-23 09:05:17] [ccf277d1] SUMMARY
[2013-01-23 09:05:17] [ccf277d1] Total daily visits archived: 4
[2013-01-23 09:05:17] [ccf277d1] Archived today’s reports for 7 websites
[2013-01-23 09:05:17] [ccf277d1] Archived week/month/year for 7 websites.
[2013-01-23 09:05:17] [ccf277d1] Skipped 1 websites: no new visit since the last script execution
[2013-01-23 09:05:17] [ccf277d1] Skipped 0 websites day archiving: existing daily reports are less than 1800 seconds old
[2013-01-23 09:05:17] [ccf277d1] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
[2013-01-23 09:05:17] [ccf277d1] Total API requests: 28
[2013-01-23 09:05:17] [ccf277d1] done: 7/8 88%, 4 v, 7 wtoday, 7 wperiods, 28 req, 14396 ms, 1 errors. eg. ‘Got invalid response from API request: thesite.com. Response was ’
There is an error. Please report th’
[2013-01-23 09:05:17] [ccf277d1] Time elapsed: 14.396s
[2013-01-23 09:05:17] [ccf277d1] ---------------------------
[2013-01-23 09:05:17] [ccf277d1] SCHEDULED TASKS
[2013-01-23 09:05:17] [ccf277d1] Starting Scheduled tasks…
[2013-01-23 09:05:17] [ccf277d1] No task to run
[2013-01-23 09:05:17] [ccf277d1] done
[2013-01-23 09:05:17] [ccf277d1] ---------------------------
[2013-01-23 09:05:17] [ccf277d1] SUMMARY OF ERRORS
[2013-01-23 09:05:17] [ccf277d1] Error: Got invalid response from API request: thesite.com. Response was ’
There is an error. Please report th
[2013-01-23 09:05:17] [ccf277d1] 1 total errors during this script execution, please investigate and try and fix these errors
[2013-01-23 09:05:17] [ccf277d1] ERROR: 1 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: thesite.com. Response was ’
There is an error. Please report th
Error in the last Piwik archive.php run:
1 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: thesite.com. Response was '

There is an error. Please report th

Here is the full errors output:

INIT
Querying Piwik API at: thesite.com
Running Piwik 1.10.1 as Super User: nicwindley
Notes

  • Reports for today will be processed at most every 1800 seconds. You can change this value in Piwik UI > Settings > General Settings.
  • Reports for the current week/month/year will be refreshed at most every 3600 seconds.
  • Archiving was last executed without error 4 days 21 hours ago
    Will process 5 websites with new visits since 4 days 21 hours , IDs: 2, 4, 21, 26, 31
    Will process 3 other websites because the last time they were archived was on a different day (in the website’s timezone) , IDs: 24, 25, 29

START
Starting Piwik reports archiving…
ERROR: Got invalid response from API request: thesite.com. Response was '


There is an error. Please report the message (Piwik 1.10.1)
and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).


Warning: Invalid argument supplied for foreach() in /home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php on line 659


Backtrace -->


#0 Piwik_ErrorHandler(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php:659]

#1 Piwik_Funnels->storeRefAndNextUrls(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php:319]

#2 Piwik_Funnels->archiveDay(…) called at [:]

#3 call_user_func_array(…) called at [/home/XXXXXXXX/public_html/piwik/libs/Event/Dispatcher.php:284]

#4 Event_Dispatcher->postNotification(…) called at [/home/XXXXXXXX/public_html/piwik/core/PluginsManager.php:723]

#5 Piwik_PostEvent(…) called at [/home/XXXXXXXX/public_html/piwik/core/ArchiveProcessing/Day.php:45]

#6 Piwik_ArchiveProcessing_Day->compute(…) called at [/home/XXXXXXXX/public_html/piwik/core/ArchiveProcessing.php:498]

#7 Piwik_ArchiveProcessing->launchArchiving(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:236]

#8 Piwik_Archive_Single->prepareArchive(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:266]

#9 Piwik_Archive_Single->get(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:462]

#10 Piwik_Archive_Single->getNumeric(…) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Array.php:93]

#11 Piwik_Archive_Array->getNumeric(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/VisitsSummary/API.php:114]

#12 Piwik_VisitsSummary_API->getNumeric(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/VisitsSummary/API.php:120]

#13 Piwik_VisitsSummary_API->getVisits(…) called at [:]

#14 call_user_func_array(…) called at [/home/XXXXXXXX/public_html/piwik/core/API/Proxy.php:190]

#15 Piwik_API_Proxy->call(…) called at [/home/XXXXXXXX/public_html/piwik/core/API/Request.php:128]

#16 Piwik_API_Request->process(…) called at [/home/XXXXXXXX/public_html/piwik/plugins/API/Controller.php:27]

#17 Piwik_API_Controller->index(…) called at [:]

#18 call_user_func_array(…) called at [/home/XXXXXXXX/public_html/piwik/core/FrontController.php:138]

#19 Piwik_FrontController->dispatch(…) called at [/home/XXXXXXXX/public_html/piwik/index.php:53]


There is an error. Please report the message (Piwik 1.10.1) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).

Notice: Undefined index: idfunnel in /home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php on line 325

Backtrace -->

#0 Piwik_ErrorHandler(...) called at [/home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php:325]
#1 Piwik_Funnels->archiveDay(...) called at [:]
#2 call_user_func_array(...) called at [/home/XXXXXXXX/public_html/piwik/libs/Event/Dispatcher.php:284]
#3 Event_Dispatcher->postNotification(...) called at [/home/XXXXXXXX/public_html/piwik/core/PluginsManager.php:723]
#4 Piwik_PostEvent(...) called at [/home/XXXXXXXX/public_html/piwik/core/ArchiveProcessing/Day.php:45]
#5 Piwik_ArchiveProcessing_Day->compute(...) called at [/home/XXXXXXXX/public_html/piwik/core/ArchiveProcessing.php:498]
#6 Piwik_ArchiveProcessing->launchArchiving(...) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:236]
#7 Piwik_Archive_Single->prepareArchive(...) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:266]
#8 Piwik_Archive_Single->get(...) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:462]
#9 Piwik_Archive_Single->getNumeric(...) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Array.php:93]
#10 Piwik_Archive_Array->getNumeric(...) called at [/home/XXXXXXXX/public_html/piwik/plugins/VisitsSummary/API.php:114]
#11 Piwik_VisitsSummary_API->getNumeric(...) called at [/home/XXXXXXXX/public_html/piwik/plugins/VisitsSummary/API.php:120]
#12 Piwik_VisitsSummary_API->getVisits(...) called at [:]
#13 call_user_func_array(...) called at [/home/XXXXXXXX/public_html/piwik/core/API/Proxy.php:190]
#14 Piwik_API_Proxy->call(...) called at [/home/XXXXXXXX/public_html/piwik/core/API/Request.php:128]
#15 Piwik_API_Request->process(...) called at [/home/XXXXXXXX/public_html/piwik/plugins/API/Controller.php:27]
#16 Piwik_API_Controller->index(...) called at [:]
#17 call_user_func_array(...) called at [/home/XXXXXXXX/public_html/piwik/core/FrontController.php:138]
#18 Piwik_FrontController->dispatch(...) called at [/home/XXXXXXXX/public_html/piwik/index.php:53]


There is an error. Please report the message (Piwik 1.10.1) and full backtrace in the Piwik forums (please do a Search first as it might have been reported already!).

Notice: Undefined index: idgoal in /home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php on line 326

Backtrace -->

#0 Piwik_ErrorHandler(...) called at [/home/XXXXXXXX/public_html/piwik/plugins/Funnels/Funnels.php:326]
#1 Piwik_Funnels->archiveDay(...) called at [:]
#2 call_user_func_array(...) called at [/home/XXXXXXXX/public_html/piwik/libs/Event/Dispatcher.php:284]
#3 Event_Dispatcher->postNotification(...) called at [/home/XXXXXXXX/public_html/piwik/core/PluginsManager.php:723]
#4 Piwik_PostEvent(...) called at [/home/XXXXXXXX/public_html/piwik/core/ArchiveProcessing/Day.php:45]
#5 Piwik_ArchiveProcessing_Day->compute(...) called at [/home/XXXXXXXX/public_html/piwik/core/ArchiveProcessing.php:498]
#6 Piwik_ArchiveProcessing->launchArchiving(...) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:236]
#7 Piwik_Archive_Single->prepareArchive(...) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:266]
#8 Piwik_Archive_Single->get(...) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Single.php:462]
#9 Piwik_Archive_Single->getNumeric(...) called at [/home/XXXXXXXX/public_html/piwik/core/Archive/Array.php:93]
#10 Piwik_Archive_Array->getNumeric(...) called at [/home/XXXXXXXX/public_html/piwik/plugins/VisitsSummary/API.php:114]
#11 Piwik_VisitsSummary_API->getNumeric(...) called at [/home/XXXXXXXX/public_html/piwik/plugins/VisitsSummary/API.php:120]
#12 Piwik_VisitsSummary_API->getVisits(...) called at [:]
#13 call_user_func_array(...) called at [/home/XXXXXXXX/public_html/piwik/core/API/Proxy.php:190]
#14 Piwik_API_Proxy->call(...) called at [/home/XXXXXXXX/public_html/piwik/core/API/Request.php:128]
#15 Piwik_API_Request->process(...) called at [/home/XXXXXXXX/public_html/piwik/plugins/API/Controller.php:27]
#16 Piwik_API_Controller->index(...) called at [:]
#17 call_user_func_array(...) called at [/home/XXXXXXXX/public_html/piwik/core/FrontController.php:138]
#18 Piwik_FrontController->dispatch(...) called at [/home/XXXXXXXX/public_html/piwik/index.php:53]


a:2:{s:6:"result";s:5:"error";s:7:"message";s:245:"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY log_conversion.idgoal , label' at line 14";}' WARNING: Empty or invalid response '' for website id 2, Time elapsed: 1.069s, skipping Archived website id = 4, period = day, Time elapsed: 0.149s Archived website id = 4, period = week, 43 visits, Time elapsed: 0.477s Archived website id = 4, period = month, 190 visits, Time elapsed: 2.231s Archived website id = 4, period = year, 4748 visits, Time elapsed: 0.436s Archived website id = 21, period = day, Time elapsed: 0.154s Archived website id = 21, period = week, 75 visits, Time elapsed: 0.390s Archived website id = 21, period = month, 245 visits, Time elapsed: 1.668s Archived website id = 21, period = year, 2092 visits, Time elapsed: 0.433s Archived website id = 26, period = day, Time elapsed: 0.575s Archived website id = 26, period = week, 84 visits, Time elapsed: 0.414s Archived website id = 26, period = month, 540 visits, Time elapsed: 1.716s Archived website id = 26, period = year, 1915 visits, Time elapsed: 0.479s Archived website id = 31, period = day, Time elapsed: 0.118s Archived website id = 31, period = week, 20 visits, Time elapsed: 0.373s Archived website id = 31, period = month, 86 visits, Time elapsed: 1.320s Archived website id = 31, period = year, 155 visits, Time elapsed: 0.404s Archived website id = 24, period = day, Time elapsed: 0.120s Archived website id = 24, period = week, 0 visits, Time elapsed: 0.152s Archived website id = 24, period = month, 0 visits, Time elapsed: 0.212s Archived website id = 24, period = year, 141 visits, Time elapsed: 0.178s Archived website id = 25, period = day, Time elapsed: 0.144s Archived website id = 25, period = week, 0 visits, Time elapsed: 0.166s Archived website id = 25, period = month, 0 visits, Time elapsed: 0.195s Archived website id = 25, period = year, 2 visits, Time elapsed: 0.183s Archived website id = 29, period = day, Time elapsed: 0.124s Archived website id = 29, period = week, 0 visits, Time elapsed: 0.128s Archived website id = 29, period = month, 0 visits, Time elapsed: 0.199s Archived website id = 29, period = year, 0 visits, Time elapsed: 0.176s Done archiving! --------------------------- SUMMARY Total daily visits archived: 4 Archived today's reports for 7 websites Archived week/month/year for 7 websites. Skipped 1 websites: no new visit since the last script execution Skipped 0 websites day archiving: existing daily reports are less than 1800 seconds old Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old Total API requests: 28 done: 7/8 88%, 4 v, 7 wtoday, 7 wperiods, 28 req, 14396 ms, 1 errors. eg. 'Got invalid response from API request: http://piwik.THESITE.com/index.php?module=API&method=VisitsSummary.getVisits&idSite=2&period=day&date=last52&format=php&token_auth=af188df6e1c44ce13e1a6cbeda726dc6&trigger=archivephp. Response was '
There is an error. Please report th' Time elapsed: 14.396s --------------------------- SCHEDULED TASKS Starting Scheduled tasks... No task to run done --------------------------- SUMMARY OF ERRORS Error: Got invalid response from API request: http://piwik.THESITE.com/index.php?module=API&method=VisitsSummary.getVisits&idSite=2&period=day&date=last52&format=php&token_auth=af188df6e1c44ce13e1a6cbeda726dc6&trigger=archivephp. Response was '
There is an error. Please report th 1 total errors during this script execution, please investigate and try and fix these errors ERROR: 1 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: http://piwik.THESITE.com/index.php?module=API&method=VisitsSummary.getVisits&idSite=2&period=day&date=last52&format=php&token_auth=af188df6e1c44ce13e1a6cbeda726dc6&trigger=archivephp. Response was '
There is an error. Please report th
Fatal error: 1 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: http://piwik.THESITE.com/index.php?module=API&method=VisitsSummary.getVisits&idSite=2&period=day&date=last52&format=php&token_auth=af188df6e1c44ce13e1a6cbeda726dc6&trigger=archivephp. Response was '
There is an error. Please report th in /home/XXXXXXXX/public_html/piwik/misc/cron/archive.php on line 566
5

I’ve noticed that mbrstring was missing from the system config so I’ve recompiled apache to include this module now.

6

I’ve got mbstring and Geo IP PECL installed now, however the problem with graphing still remains.

I’m going to try removing the active funnels first, then remove the funnel plugin itself to see if it resolves the problem unless you recommended another course of action Matt.

7

OK, after removing the funnels I created and then disabling the funnels plugin I’m now getting graphs once again. I’ll try re-enabling the funnels plugin to see if it causes the error again.

8

Yes, I re-enabled the funnel plugin and recreated the funnels and all is now working.

Looks like the duplicate funnels caused some kind of funnel ID problem.

9

Nope, with the funnel plugin enabled graphing output fails again.

All funnels have been recreated so there appears to be a problem somwehere with piwik core and the plugin.

This would appear more inline with the upgrade to Piwik 1.10.1.

Any ideas ?

10

should I report this as a bug ?