Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

empty result for piwik_report #6319

Closed
heidarymr opened this issue Sep 27, 2014 · 11 comments
Closed

empty result for piwik_report #6319

heidarymr opened this issue Sep 27, 2014 · 11 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.

Comments

@heidarymr
Copy link

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
Copy link
Member

mattab commented Oct 2, 2014

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

@mattab mattab closed this as completed Oct 2, 2014
@mattab mattab added the worksforme The issue cannot be reproduced and things work as intended. label Oct 2, 2014
@heidarymr
Copy link
Author

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
Copy link
Author

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
Copy link
Member

mattab commented Oct 6, 2014

please upgrade to latest piwik

@heidarymr
Copy link
Author

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
Copy link
Member

mattab commented Oct 17, 2014

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

@heidarymr
Copy link
Author

$ /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
Copy link
Author

my problem not solved yet!!!

@mattab
Copy link
Member

mattab commented Oct 21, 2014

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

@mattab mattab removed the worksforme The issue cannot be reproduced and things work as intended. label Oct 21, 2014
@mattab mattab reopened this Oct 21, 2014
@mattab mattab added the Bug For errors / faults / flaws / inconsistencies etc. label Oct 21, 2014
@heidarymr
Copy link
Author

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
Copy link
Member

mattab commented Oct 21, 2014

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

then select YEAR period. it should show the data

@mattab mattab closed this as completed Oct 21, 2014
@mattab mattab added the worksforme The issue cannot be reproduced and things work as intended. label Oct 21, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc. worksforme The issue cannot be reproduced and things work as intended.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@mattab @heidarymr