@heidarymr opened this Issue on September 27th 2014

when i want to access to piwik i see this error:
Mysqli prepare error: SELECT command denied to user 'piwik'@'localhost' for column 'idsite' in table 'piwik_report'

i try to login with username and password that stored in "config/config.ini.php" file via phpmyadmin and execute this query:
SELECT * FROM piwik_report
and i see this result:
MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0002 sec )

@mattab commented on October 2nd 2014 Owner

Enable the plugin ScheduledReport in the Piwik > Settings > Plugins. this should fix it

@heidarymr commented on October 3rd 2014

hi and tnx
can u give me url to set ScheduledReport?
after i login to piwik i can see only this error:
'''Mysqli prepare error: SELECT command denied to user 'piwik'@'localhost' for column 'idsite' in table 'piwik_report''''

i go to this page handly:
'''http://piwik.xx/index.php?module=CoreAdminHome&action=generalSettings&idSite=1&period=day&date=yesterday'''

but i see same error again

@heidarymr commented on October 3rd 2014

i check this url:
http://piwik.xx/index.php?module=CorePluginsAdmin&action=plugins&idSite=1&period=day&date=yesterday&activated=
and get this error:
Action 'plugins' not found in the controller 'Piwik_CorePluginsAdmin_Controller'.

my piwik version <2
can u give me a command line soloution?

@mattab commented on October 6th 2014 Owner

please upgrade to latest piwik

@heidarymr commented on October 12th 2014

i install piwik in another server, then migrate my database data then upgrade database
i login to piwik and now view the report
but for all of my website, from 14 September all visite,visitor,pageview and... equal to zero (check picture)
untitled
i check database and number of row of table piwik_log_link_visit_action growth every seconds.(piwik track code work fine)(Other tables are fixed.)

@mattab commented on October 17th 2014 Owner

@heidarymr setup the cron : http://piwik.org/docs/setup-auto-archiving/ this should fix it

@heidarymr commented on October 18th 2014

$ /usr/bin/php /var/www/vhosts/piwik.xx/httpdocs/console core:archive --url=http://piwik.xx

[root@piwik.xx ~]# /usr/bin/php /var/www/vhosts/piwik.xx/httpdocs/console core:archive --url=http://piwik.xx
INFO CoreConsole[2014-10-18 08:21:43] [7738b] ---------------------------
INFO CoreConsole[2014-10-18 08:21:43] [7738b] INIT
INFO CoreConsole[2014-10-18 08:21:43] [7738b] Piwik is installed at: http://piwik.xx/index.php
INFO CoreConsole[2014-10-18 08:21:43] [7738b] Running Piwik 2.7.0 as Super User
INFO CoreConsole[2014-10-18 08:21:44] [7738b] ---------------------------
INFO CoreConsole[2014-10-18 08:21:44] [7738b] NOTES
INFO CoreConsole[2014-10-18 08:21:44] [7738b] - If you execute this script at least once per hour (or more often) in a crontab, you may disable 'Browser trigger archiving' in Piwik UI > Settings > General Settings.
INFO CoreConsole[2014-10-18 08:21:44] [7738b] See the doc at: http://piwik.org/docs/setup-auto-archiving/
INFO CoreConsole[2014-10-18 08:21:44] [7738b] - Reports for today will be processed at most every 3600 seconds. You can change this value in Piwik UI > Settings > General Settings.
INFO CoreConsole[2014-10-18 08:21:44] [7738b] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
INFO CoreConsole[2014-10-18 08:21:44] [7738b] - Archiving was last executed without error 26s ago
INFO CoreConsole[2014-10-18 08:21:44] [7738b] - Will process 0 websites with new visits since 25s
INFO CoreConsole[2014-10-18 08:21:45] [7738b] ---------------------------
INFO CoreConsole[2014-10-18 08:21:45] [7738b] START
INFO CoreConsole[2014-10-18 08:21:45] [7738b] Starting Piwik reports archiving...
INFO CoreConsole[2014-10-18 08:21:45] [7738b] Done archiving!
INFO CoreConsole[2014-10-18 08:21:45] [7738b] ---------------------------
INFO CoreConsole[2014-10-18 08:21:45] [7738b] SUMMARY
INFO CoreConsole[2014-10-18 08:21:45] [7738b] Total visits for today across archived websites: 0
INFO CoreConsole[2014-10-18 08:21:45] [7738b] Archived today's reports for 0 websites
INFO CoreConsole[2014-10-18 08:21:45] [7738b] Archived week/month/year for 0 websites
INFO CoreConsole[2014-10-18 08:21:45] [7738b] Skipped 10 websites: no new visit since the last script execution
INFO CoreConsole[2014-10-18 08:21:45] [7738b] Skipped 0 websites day archiving: existing daily reports are less than 3600 seconds old
INFO CoreConsole[2014-10-18 08:21:45] [7738b] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
INFO CoreConsole[2014-10-18 08:21:45] [7738b] Total API requests: 0
INFO CoreConsole[2014-10-18 08:21:45] [7738b] done: 0/0, 0 vtoday, 0 wtoday, 0 wperiods, 0 req, 117 ms, no error
INFO CoreConsole[2014-10-18 08:21:45] [7738b] Time elapsed: 0.117s
INFO CoreConsole[2014-10-18 08:21:45] [7738b] ---------------------------
INFO CoreConsole[2014-10-18 08:21:45] [7738b] SCHEDULED TASKS
INFO CoreConsole[2014-10-18 08:21:45] [7738b] Starting Scheduled tasks...
INFO CoreConsole[2014-10-18 08:21:45] [7738b] Error: period 1is undefined.
INFO CoreConsole[2014-10-18 08:21:45] [7738b] done
INFO CoreConsole[2014-10-18 08:21:45] [7738b] ---------------------------

@heidarymr commented on October 21st 2014

my problem not solved yet!!!

@mattab commented on October 21st 2014 Owner

Try to execute this command and can you paste output or on gists ? http://piwik.org/faq/log-analytics-tool/#faq_17994

@heidarymr commented on October 21st 2014

i execute command and got this error yet:
Error: period 1is undefined

output:

/usr/bin/php /var/www/vhosts/piwik.xx/httpdocs/console co re:archive --force-all-websites --force-all-periods=315576000 --force-date-last- n=1000 --url=http://piwik.xx

INFO CoreConsole[2014-10-21 08:48:23] [a75a3] ---------------------------
INFO CoreConsole[2014-10-21 08:48:23] [a75a3] INIT
INFO CoreConsole[2014-10-21 08:48:23] [a75a3] Piwik is installed at: http://piwik.xx/index.php
INFO CoreConsole[2014-10-21 08:48:23] [a75a3] Running Piwik 2.8.1 as Super User
INFO CoreConsole[2014-10-21 08:48:23] [a75a3] ---------------------------
INFO CoreConsole[2014-10-21 08:48:23] [a75a3] NOTES
INFO CoreConsole[2014-10-21 08:48:23] [a75a3] - Reports for today will be proces sed at most every 3600 seconds. You can change this value in Piwik UI > Settings > General Settings.
INFO CoreConsole[2014-10-21 08:48:23] [a75a3] - Reports for the current week/mon th/year will be refreshed at most every 3600 seconds.
INFO CoreConsole[2014-10-21 08:48:23] [a75a3] - Archiving was last executed with out error 14s ago
INFO CoreConsole[2014-10-21 08:48:23] [a75a3] - Will process all 10 websites
INFO CoreConsole[2014-10-21 08:48:23] [a75a3] ---------------------------
INFO CoreConsole[2014-10-21 08:48:23] [a75a3] START
INFO CoreConsole[2014-10-21 08:48:23] [a75a3] Starting Piwik reports archiving.. .
INFO CoreConsole[2014-10-21 08:48:28] [a75a3] Archived website id = 1, period = day, 0 visits in last last1000 days, 0 visits today, Time elapsed: 5.364s
INFO CoreConsole[2014-10-21 08:48:31] [a75a3] Archived website id = 1, period = week, 0 visits in last last1000 weeks, 0 visits this week, Time elapsed: 2.382s
INFO CoreConsole[2014-10-21 08:48:32] [a75a3] Archived website id = 1, period = month, 0 visits in last last1000 months, 0 visits this month, Time elapsed: 1.05 4s
INFO CoreConsole[2014-10-21 08:48:32] [a75a3] Archived website id = 1, period = year, 0 visits in last last1000 years, 0 visits this year, Time elapsed: 0.531s
INFO CoreConsole[2014-10-21 08:48:32] [a75a3] Archived website id = 1, 4 API req uests, Time elapsed: 9.339s [1/10 done]
INFO CoreConsole[2014-10-21 08:48:40] [a75a3] Archived website id = 2, period = day, 4471011 visits in last last1000 days, 0 visits today, Time elapsed: 7.398s
INFO CoreConsole[2014-10-21 08:48:42] [a75a3] Archived website id = 2, period = week, 4471011 visits in last last1000 weeks, 0 visits this week, Time elapsed: 2.457s
INFO CoreConsole[2014-10-21 08:48:43] [a75a3] Archived website id = 2, period = month, 4471011 visits in last last1000 months, 6 visits this month, Time elapsed: 1.179s
INFO CoreConsole[2014-10-21 08:48:44] [a75a3] Archived website id = 2, period = year, 4471011 visits in last last1000 years, 2691472 visits this year, Time elapsed: 0.682s
INFO CoreConsole[2014-10-21 08:48:44] [a75a3] Archived website id = 2, 4 API requests, Time elapsed: 11.722s [2/10 done]
INFO CoreConsole[2014-10-21 08:48:52] [a75a3] Archived website id = 3, period = day, 9505 visits in last last1000 days, 0 visits today, Time elapsed: 7.712s
INFO CoreConsole[2014-10-21 08:48:54] [a75a3] Archived website id = 3, period = week, 9505 visits in last last1000 weeks, 0 visits this week, Time elapsed: 2.607s
INFO CoreConsole[2014-10-21 08:48:56] [a75a3] Archived website id = 3, period = month, 9505 visits in last last1000 months, 2 visits this month, Time elapsed: 1.188s
INFO CoreConsole[2014-10-21 08:48:56] [a75a3] Archived website id = 3, period = year, 9505 visits in last last1000 years, 5373 visits this year, Time elapsed: 0.546s
INFO CoreConsole[2014-10-21 08:48:56] [a75a3] Archived website id = 3, 4 API requests, Time elapsed: 12.063s [3/10 done]
INFO CoreConsole[2014-10-21 08:49:03] [a75a3] Archived website id = 4, period = day, 1091 visits in last last1000 days, 0 visits today, Time elapsed: 6.688s
INFO CoreConsole[2014-10-21 08:49:05] [a75a3] Archived website id = 4, period = week, 1091 visits in last last1000 weeks, 0 visits this week, Time elapsed: 2.463s
INFO CoreConsole[2014-10-21 08:49:06] [a75a3] Archived website id = 4, period = month, 1091 visits in last last1000 months, 0 visits this month, Time elapsed: 1.207s
INFO CoreConsole[2014-10-21 08:49:07] [a75a3] Archived website id = 4, period = year, 1091 visits in last last1000 years, 222 visits this year, Time elapsed: 0.521s
INFO CoreConsole[2014-10-21 08:49:07] [a75a3] Archived website id = 4, 4 API requests, Time elapsed: 10.888s [4/10 done]
INFO CoreConsole[2014-10-21 08:49:12] [a75a3] Archived website id = 5, period = day, 22669 visits in last last1000 days, 1 visits today, Time elapsed: 4.852s
INFO CoreConsole[2014-10-21 08:49:14] [a75a3] Archived website id = 5, period = week, 22669 visits in last last1000 weeks, 2 visits this week, Time elapsed: 1.899s
INFO CoreConsole[2014-10-21 08:49:15] [a75a3] Archived website id = 5, period = month, 22669 visits in last last1000 months, 12 visits this month, Time elapsed: 0.892s
INFO CoreConsole[2014-10-21 08:49:15] [a75a3] Archived website id = 5, period = year, 22669 visits in last last1000 years, 22669 visits this year, Time elapsed: 0.508s
INFO CoreConsole[2014-10-21 08:49:15] [a75a3] Archived website id = 5, 4 API requests, Time elapsed: 8.159s [5/10 done]
INFO CoreConsole[2014-10-21 08:49:20] [a75a3] Archived website id = 6, period = day, 3330 visits in last last1000 days, 0 visits today, Time elapsed: 4.528s
INFO CoreConsole[2014-10-21 08:49:22] [a75a3] Archived website id = 6, period = week, 3330 visits in last last1000 weeks, 0 visits this week, Time elapsed: 2.229s
INFO CoreConsole[2014-10-21 08:49:23] [a75a3] Archived website id = 6, period = month, 3330 visits in last last1000 months, 4 visits this month, Time elapsed: 1.094s
INFO CoreConsole[2014-10-21 08:49:24] [a75a3] Archived website id = 6, period = year, 3330 visits in last last1000 years, 3330 visits this year, Time elapsed: 0.655s
INFO CoreConsole[2014-10-21 08:49:24] [a75a3] Archived website id = 6, 4 API requests, Time elapsed: 8.514s [6/10 done]
INFO CoreConsole[2014-10-21 08:49:28] [a75a3] Archived website id = 7, period = day, 694 visits in last last1000 days, 0 visits today, Time elapsed: 4.301s
INFO CoreConsole[2014-10-21 08:49:30] [a75a3] Archived website id = 7, period = week, 694 visits in last last1000 weeks, 0 visits this week, Time elapsed: 1.890s
INFO CoreConsole[2014-10-21 08:49:31] [a75a3] Archived website id = 7, period = month, 694 visits in last last1000 months, 0 visits this month, Time elapsed: 1.007s
INFO CoreConsole[2014-10-21 08:49:31] [a75a3] Archived website id = 7, period = year, 694 visits in last last1000 years, 694 visits this year, Time elapsed: 0.502s
INFO CoreConsole[2014-10-21 08:49:31] [a75a3] Archived website id = 7, 4 API requests, Time elapsed: 7.706s [7/10 done]
INFO CoreConsole[2014-10-21 08:49:35] [a75a3] Archived website id = 8, period = day, 33 visits in last last1000 days, 0 visits today, Time elapsed: 3.175s
INFO CoreConsole[2014-10-21 08:49:36] [a75a3] Archived website id = 8, period = week, 33 visits in last last1000 weeks, 0 visits this week, Time elapsed: 1.665s
INFO CoreConsole[2014-10-21 08:49:37] [a75a3] Archived website id = 8, period = month, 33 visits in last last1000 months, 0 visits this month, Time elapsed: 0.896s
INFO CoreConsole[2014-10-21 08:49:38] [a75a3] Archived website id = 8, period = year, 33 visits in last last1000 years, 33 visits this year, Time elapsed: 0.521s
INFO CoreConsole[2014-10-21 08:49:38] [a75a3] Archived website id = 8, 4 API requests, Time elapsed: 6.265s [8/10 done]
INFO CoreConsole[2014-10-21 08:49:41] [a75a3] Archived website id = 9, period = day, 144 visits in last last1000 days, 0 visits today, Time elapsed: 3.036s
INFO CoreConsole[2014-10-21 08:49:42] [a75a3] Archived website id = 9, period = week, 144 visits in last last1000 weeks, 0 visits this week, Time elapsed: 1.788s
INFO CoreConsole[2014-10-21 08:49:43] [a75a3] Archived website id = 9, period = month, 144 visits in last last1000 months, 0 visits this month, Time elapsed: 0.909s
INFO CoreConsole[2014-10-21 08:49:44] [a75a3] Archived website id = 9, period = year, 144 visits in last last1000 years, 144 visits this year, Time elapsed: 0.519s
INFO CoreConsole[2014-10-21 08:49:44] [a75a3] Archived website id = 9, 4 API requests, Time elapsed: 6.259s [9/10 done]
INFO CoreConsole[2014-10-21 08:49:46] [a75a3] Archived website id = 10, period = day, 13 visits in last last1000 days, 0 visits today, Time elapsed: 2.448s
INFO CoreConsole[2014-10-21 08:49:48] [a75a3] Archived website id = 10, period = week, 13 visits in last last1000 weeks, 2 visits this week, Time elapsed: 1.794s
INFO CoreConsole[2014-10-21 08:49:49] [a75a3] Archived website id = 10, period = month, 13 visits in last last1000 months, 5 visits this month, Time elapsed: 0.879s
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] Archived website id = 10, period = year, 13 visits in last last1000 years, 13 visits this year, Time elapsed: 0.508s
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] Archived website id = 10, 4 API requests, Time elapsed: 5.636s [10/10 done]
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] Done archiving!
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] ---------------------------
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] SUMMARY
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] Total visits for today across archived websites: 1
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] Archived today's reports for 10 websites
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] Archived week/month/year for 10 websites
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] Skipped 0 websites: no new visit since the last script execution
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] Skipped 0 websites day archiving: existing daily reports are less than 3600 seconds old
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] Total API requests: 40
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] done: 10/10 100%, 1 vtoday, 10 wtoday, 10 wperiods, 40 req, 86557 ms, no error
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] Time elapsed: 86.557s
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] ---------------------------
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] SCHEDULED TASKS
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] Starting Scheduled tasks...
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] Error: period 1is undefined.
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] done
INFO CoreConsole[2014-10-21 08:49:50] [a75a3] ---------------------------

@mattab commented on October 21st 2014 Owner

Open All Websites dashboard in Piwik: http://piwik.org/docs/manage-websites/#all-websites-dashboard

then select YEAR period. it should show the data

This Issue was closed on October 21st 2014
Powered by GitHub Issue Mirror