Statistics and Roles issue after 1.6.4 -> 1.7.1+ Upgrade

Statistics and Roles issue after 1.6.4 -> 1.7.1+ Upgrade

by Ann Adamcik -
Number of replies: 7
Hi all,

We recently upgraded from 1.6.4 to 1.7.1+. When we go to Administration->Reports->Statistics, both the graph and the report table show only Students and Non-Editing Teachers. In the mdl_stats_daily table, all entries have a roleid of 4 or 5. It looks like maybe the upgrade converted the old stats entries for teachers to non-editing teachers?

Has anyone else encountered this?

-Ann
Average of ratings: -
In reply to Ann Adamcik

Re: Statistics and Roles issue after 1.6.4 -> 1.7.1+ Upgrade

by Charlie Owen -
We saw this as well, upgrading from 1.6.1 to 1.7.1+. Maybe time to file a bug report?
In reply to Charlie Owen

Re: Statistics and Roles issue after 1.6.4 -> 1.7.1+ Upgrade

by Joe Griffin -
I have a related problem which I can't sort.

When I try the Reports-> Statistics I get:

There is no available data to display, sorry.

Any ideas?
In reply to Charlie Owen

Re: Statistics and Roles issue after 1.6.4 -> 1.7.1+ Upgrade

by Ann Adamcik -
In reply to Ann Adamcik

Re: Statistics and Roles issue after 1.6.4 -> 1.7.1+ Upgrade

by Ann Adamcik -
We ran into this one too. We had db tables from the object module and trouble ticket blocks, but we hadn't installed the files for those when we moved to 1.7.

Make sure you don't have any old modules hanging around, and then try running admin/cron.php again.

See http://tracker.moodle.org/browse/MDL-7385.
There's also some info, and a patch at the bottom of http://tracker.moodle.org/browse/MDL-5973 that might be helpful.

-Ann
In reply to Ann Adamcik

Re: Statistics and Roles issue after 1.6.4 -> 1.7.1+ Upgrade

by Matt Gibson -
I have the same problem, but without the old modules hanging about.

Cron runs stats, but no data is ever produced. I ran cron just now and got this:

Running daily statistics gathering...
starting at 1173744000
got up to 1173744000
Completed 0 days
Cron script completed correctly
Execution took 1.556485 seconds

That timestamp corresponds to two days ago. Stats has never run at all and all the stats tables are empty. I'm at a loss as to why and have checked the bugs above thoroughly. Where can I look for more debuging info?

Matt
In reply to Ann Adamcik

Re: Statistics and Roles issue after 1.6.4 -> 1.7.1+ Upgrade

by Steve Giesel -
We also had the "There is no available data to display, sorry." message problem. No old modules were lurking, etc. but the minute we updated to the latest 1.7 stable branch (yesterday 9am us cdt) they started working. Or i should say after cron ran last night we have statistics this morning. We're running Windows 2003 server, IIS 6, MSSQL 2005, PHP 5.1.2.
In reply to Steve Giesel

Re: Statistics and Roles issue after 1.6.4 -> 1.7.1+ Upgrade

by Matt Gibson -
Mine has also started working now, but I had to later it so that it only kept logs from the last month or so, then alter statslastdaily and statslastweekly to 0 before running cron manually. just upgraded to 1.8.