Search engines/keywords views show There is no data to report


(randy) #1

I’m sure the data is getting to the database tables:

mysql> select * from piwik_archive_blob_2012_03;
±----------±-------------------------------±-------±-----------±-----------±-------±--------------------±----------------------+
| idarchive | name | idsite | date1 | date2 | period | ts_archived | value |
±----------±-------------------------------±-------±-----------±-----------±-------±--------------------±----------------------+
| 1081 | Referers_type | 1 | 2012-03-01 | 2012-04-09 | 5 | 2012-04-09 13:15:57 | xK´2´ªÎ´Ò5´ö³® Ä |
| 1081 | Referers_keywordBySearchEngine | 1 | 2012-03-01 | 2012-04-09 | 5 | 2012-04-09 13:15:57 | xK´2´ªÎ´Ò5´ö³® Ä |
| 1081 | Referers_searchEngineByKeyword | 1 | 2012-03-01 | 2012-04-09 | 5 | 2012-04-09 13:15:57 | xK´2´ªÎ´Ò5´ö³® Ä |
| 1081 | Referers_keywordByCampaign | 1 | 2012-03-01 | 2012-04-09 | 5 | 2012-04-09 13:15:57 | xK´2´ªÎ´Ò5´ö³® Ä |
| 1081 | Referers_urlByWebsite | 1 | 2012-03-01 | 2012-04-09 | 5 | 2012-04-09 13:15:57 | xK´2´ªÎ´Ò5´ö³® Ä |
±----------±-------------------------------±-------±-----------±-----------±-------±--------------------±----------------------+
5 rows in set (0.00 sec)

mysql> select * from piwik_archive_numeric_2012_03 where idarchive = 1081;
±----------±--------------±-------±-----------±-----------±-------±--------------------±------+
| idarchive | name | idsite | date1 | date2 | period | ts_archived | value |
±----------±--------------±-------±-----------±-----------±-------±--------------------±------+
| 1081 | done.Referers | 1 | 2012-03-01 | 2012-04-09 | 5 | 2012-04-09 13:15:57 | 3 |
±----------±--------------±-------±-----------±-----------±-------±--------------------±------+
1 row in set (0.00 sec)

Note the date2 field is ‘2012-04-09’ for both piwik_archive_*_2012_03
tables. Could that be the problem?


(randy) #2

running version 1.7.1. Note the mentioned tables did not have
any data in them until we did a grant FILE on .


(Matthieu Aubry) #3

If you select only “month of march” do you see any keyword data ?


(randy) #4

Entered Mar 1 - Mar 31, still displays ‘There is no data for this report.’ 5 times
under Referers->Search Engines & Keywords’.

Randy


(randy) #5

Actually 6 times.


(Matthieu Aubry) #6

I mean if you click on any day in March, then click on “Month”, does it show any data?


(randy) #7

Selected each day individually from Mar 1 - Apr 11 with each ‘day’, ‘week’, ‘month’,
and ‘year’ checkboxes checked. All returned 'There is not data for this report’
except two cases.

Mar 30 selected with ‘week’ checked.
Mar 30 selected with ‘month’ checked.

In both cases, the ‘loading data’ hung for about 20 minutes each time before
I killed the application.

Interestingly enough, the key word searches I performed on my web sites
to test search engine monitoring were done on Mar 30.

Looks like its a database retrieval/conversion to display problem.


(randy) #8

Another funny thing, I did the same tests on a report and received the
emails right away. There was no data in the emails, but the
process didn’t ‘hang’ like it does in the browser.


(randy) #9

the last (9th post) from Eleanor62 did not get posted correctly.
Please repost, it says her account is deactivated.


(randy) #10

Just a side note, the auto increment on idsite in the piwik_site table is set
to increase by 10 in version 1.7.1. It was 1 in version 1.6.7


(randy) #11

did some more testing on the following problem from a couple posts ago.

referencing ->
Mar 30 selected with ‘week’ checked.
Mar 30 selected with ‘month’ checked.

In both cases, the ‘loading data’ hung for about 20 minutes each time before
I killed the application.

Interestingly enough, the key word searches I performed on my web sites
to test search engine monitoring were done on Mar 30.

new testing->
1st time:select Mar 30 with ‘week’ or ‘month’ checked = quickly returns no data to report
2nd time:select Mar 30 with ‘week’ or ‘month’ checked = hangs for long time 'Loading data’
3rd time:same as 1st
4th time:same as 2nd
5th time:same as 1st and 3rd
6th time:same as 2nd and 4th

seems to be alternating between quickly returning no data to report
and hanging for long time loading data.