PHPUnit 3.6.10 by Sebastian Bergmann.

Configuration read from /home/aparup/mcode/integration/phpunit.xml

...........FFFFFFFFF

Time: 01:06, Memory: 106.75Mb

There were 9 failures:

1) statslib_daily_testcase::test_statslib_cron_daily with data set #1 (
+----------------------+----------------------+----------------------+----------------------+
| log                                                                                       |
+----------------------+----------------------+----------------------+----------------------+
|         time         |        userid        |        course        |        action        |
+----------------------+----------------------+----------------------+----------------------+
|      1272686410      |          1           |          1           |         view         |
+----------------------+----------------------+----------------------+----------------------+

, 
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_daily                                                                                                                             |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |       timeend        |        roleid        |       stattype       |        stat1         |        stat2         |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |        logins        |          0           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          5           |      enrolments      |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          0           |      enrolments      |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          8           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |       activity       |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          6           |       activity       |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+


+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_user_daily                                                                                                                                               |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |        userid        |        roleid        |       timeend        |      statsreads      |     statswrites      |       stattype       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          1           |          0           |      1272758400      |          1           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          0           |          0           |      1272758400      |          0           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+

)
Incorrect number of results returned for stats_daily
Cron output:
Running daily statistics gathering, starting at 1272672000:
Temporary tables created
Enrolments calculated
0:0 Error writing to database (Invalid column name 'courseid'.
INSERT INTO #u_temp_stats_user_daily
                            (stattype, timeend, courseid, userid, statsreads)

                SELECT 'logins', 1272758400 AS timeend, 1 AS courseid,
                        userid, COUNT(id) AS statsreads
                  FROM #u_temp_log1 l
                 WHERE action = 'login'
              GROUP BY timeend, courseid, userid
                HAVING COUNT(id) > 0
[array (
)])
...error occurred, completed 0 days of statistics in 0 s.

Failed asserting that 0 matches expected 7.

/home/aparup/mcode/integration/lib/tests/statslib_test.php:266
/home/aparup/mcode/integration/lib/tests/statslib_test.php:586
/home/aparup/mcode/integration/lib/phpunit/classes/advanced_testcase.php:76

To re-run:
 phpunit statslib_daily_testcase lib/tests/statslib_test.php

2) statslib_daily_testcase::test_statslib_cron_daily with data set #2 (
+----------------------+----------------------+----------------------+----------------------+
| log                                                                                       |
+----------------------+----------------------+----------------------+----------------------+
|         time         |        userid        |        course        |        action        |
+----------------------+----------------------+----------------------+----------------------+
|      1272686410      |          3           |          1           |        login         |
+----------------------+----------------------+----------------------+----------------------+

, 
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_daily                                                                                                                             |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |       timeend        |        roleid        |       stattype       |        stat1         |        stat2         |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |        logins        |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          5           |      enrolments      |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          0           |      enrolments      |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          8           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |       activity       |          0           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+


+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_user_daily                                                                                                                                               |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |        userid        |        roleid        |       timeend        |      statsreads      |     statswrites      |       stattype       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          3           |          0           |      1272758400      |          1           |          0           |        logins        |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          3           |          0           |      1272758400      |          0           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          0           |          0           |      1272758400      |          0           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+

)
Incorrect number of results returned for stats_daily
Cron output:
Running daily statistics gathering, starting at 1272672000:
Temporary tables created
Enrolments calculated
0:0 Error writing to database (Invalid column name 'courseid'.
INSERT INTO #u_temp_stats_user_daily
                            (stattype, timeend, courseid, userid, statsreads)

                SELECT 'logins', 1272758400 AS timeend, 1 AS courseid,
                        userid, COUNT(id) AS statsreads
                  FROM #u_temp_log1 l
                 WHERE action = 'login'
              GROUP BY timeend, courseid, userid
                HAVING COUNT(id) > 0
[array (
)])
...error occurred, completed 0 days of statistics in 0 s.

Failed asserting that 0 matches expected 6.

/home/aparup/mcode/integration/lib/tests/statslib_test.php:266
/home/aparup/mcode/integration/lib/tests/statslib_test.php:586
/home/aparup/mcode/integration/lib/phpunit/classes/advanced_testcase.php:76

To re-run:
 phpunit statslib_daily_testcase lib/tests/statslib_test.php

3) statslib_daily_testcase::test_statslib_cron_daily with data set #3 (
+----------------------+----------------------+----------------------+----------------------+
| log                                                                                       |
+----------------------+----------------------+----------------------+----------------------+
|         time         |        userid        |        course        |        action        |
+----------------------+----------------------+----------------------+----------------------+
|      1272686410      |          1           |          1           |        login         |
+----------------------+----------------------+----------------------+----------------------+
|      1272686420      |          1           |          2           |         view         |
+----------------------+----------------------+----------------------+----------------------+

, 
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_daily                                                                                                                             |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |       timeend        |        roleid        |       stattype       |        stat1         |        stat2         |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |        logins        |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          5           |      enrolments      |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          0           |      enrolments      |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          8           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |       activity       |          0           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          0           |       activity       |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          6           |       activity       |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+


+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_user_daily                                                                                                                                               |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |        userid        |        roleid        |       timeend        |      statsreads      |     statswrites      |       stattype       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          1           |          0           |      1272758400      |          1           |          0           |        logins        |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |          1           |          0           |      1272758400      |          1           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          1           |          0           |      1272758400      |          0           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          0           |          0           |      1272758400      |          0           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+

)
Incorrect number of results returned for stats_daily
Cron output:
Running daily statistics gathering, starting at 1272672000:
Temporary tables created
Enrolments calculated
0:0 Error writing to database (Invalid column name 'courseid'.
INSERT INTO #u_temp_stats_user_daily
                            (stattype, timeend, courseid, userid, statsreads)

                SELECT 'logins', 1272758400 AS timeend, 1 AS courseid,
                        userid, COUNT(id) AS statsreads
                  FROM #u_temp_log1 l
                 WHERE action = 'login'
              GROUP BY timeend, courseid, userid
                HAVING COUNT(id) > 0
[array (
)])
...error occurred, completed 0 days of statistics in 0 s.

Failed asserting that 0 matches expected 8.

/home/aparup/mcode/integration/lib/tests/statslib_test.php:266
/home/aparup/mcode/integration/lib/tests/statslib_test.php:586
/home/aparup/mcode/integration/lib/phpunit/classes/advanced_testcase.php:76

To re-run:
 phpunit statslib_daily_testcase lib/tests/statslib_test.php

4) statslib_daily_testcase::test_statslib_cron_daily with data set #4 (
+----------------------+----------------------+----------------------+----------------------+
| log                                                                                       |
+----------------------+----------------------+----------------------+----------------------+
|         time         |        userid        |        course        |        action        |
+----------------------+----------------------+----------------------+----------------------+
|      1272686410      |          1           |          1           |        login         |
+----------------------+----------------------+----------------------+----------------------+
|      1272686420      |          1           |          2           |         view         |
+----------------------+----------------------+----------------------+----------------------+
|      1272686430      |          1           |          2           |       add post       |
+----------------------+----------------------+----------------------+----------------------+

, 
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_daily                                                                                                                             |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |       timeend        |        roleid        |       stattype       |        stat1         |        stat2         |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |        logins        |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          5           |      enrolments      |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          0           |      enrolments      |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          8           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |       activity       |          0           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          0           |       activity       |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          6           |       activity       |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+


+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_user_daily                                                                                                                                               |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |        userid        |        roleid        |       timeend        |      statsreads      |     statswrites      |       stattype       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          1           |          0           |      1272758400      |          1           |          0           |        logins        |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |          1           |          0           |      1272758400      |          1           |          1           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          1           |          0           |      1272758400      |          0           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          0           |          0           |      1272758400      |          0           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+

)
Incorrect number of results returned for stats_daily
Cron output:
Running daily statistics gathering, starting at 1272672000:
Temporary tables created
Enrolments calculated
0:0 Error writing to database (Invalid column name 'courseid'.
INSERT INTO #u_temp_stats_user_daily
                            (stattype, timeend, courseid, userid, statsreads)

                SELECT 'logins', 1272758400 AS timeend, 1 AS courseid,
                        userid, COUNT(id) AS statsreads
                  FROM #u_temp_log1 l
                 WHERE action = 'login'
              GROUP BY timeend, courseid, userid
                HAVING COUNT(id) > 0
[array (
)])
...error occurred, completed 0 days of statistics in 0 s.

Failed asserting that 0 matches expected 8.

/home/aparup/mcode/integration/lib/tests/statslib_test.php:266
/home/aparup/mcode/integration/lib/tests/statslib_test.php:586
/home/aparup/mcode/integration/lib/phpunit/classes/advanced_testcase.php:76

To re-run:
 phpunit statslib_daily_testcase lib/tests/statslib_test.php

5) statslib_daily_testcase::test_statslib_cron_daily with data set #5 (
+----------------------+----------------------+----------------------+----------------------+
| log                                                                                       |
+----------------------+----------------------+----------------------+----------------------+
|         time         |        userid        |        course        |        action        |
+----------------------+----------------------+----------------------+----------------------+
|      1272686410      |          3           |          1           |        login         |
+----------------------+----------------------+----------------------+----------------------+
|      1272686420      |          3           |          2           |         view         |
+----------------------+----------------------+----------------------+----------------------+

, 
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_daily                                                                                                                             |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |       timeend        |        roleid        |       stattype       |        stat1         |        stat2         |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |        logins        |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          5           |      enrolments      |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          0           |      enrolments      |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          8           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |       activity       |          0           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          0           |       activity       |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          5           |       activity       |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+


+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_user_daily                                                                                                                                               |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |        userid        |        roleid        |       timeend        |      statsreads      |     statswrites      |       stattype       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          3           |          0           |      1272758400      |          1           |          0           |        logins        |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |          3           |          0           |      1272758400      |          1           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          3           |          0           |      1272758400      |          0           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          0           |          0           |      1272758400      |          0           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+

)
Incorrect number of results returned for stats_daily
Cron output:
Running daily statistics gathering, starting at 1272672000:
Temporary tables created
Enrolments calculated
0:0 Error writing to database (Invalid column name 'courseid'.
INSERT INTO #u_temp_stats_user_daily
                            (stattype, timeend, courseid, userid, statsreads)

                SELECT 'logins', 1272758400 AS timeend, 1 AS courseid,
                        userid, COUNT(id) AS statsreads
                  FROM #u_temp_log1 l
                 WHERE action = 'login'
              GROUP BY timeend, courseid, userid
                HAVING COUNT(id) > 0
[array (
)])
...error occurred, completed 0 days of statistics in 0 s.

Failed asserting that 0 matches expected 8.

/home/aparup/mcode/integration/lib/tests/statslib_test.php:266
/home/aparup/mcode/integration/lib/tests/statslib_test.php:586
/home/aparup/mcode/integration/lib/phpunit/classes/advanced_testcase.php:76

To re-run:
 phpunit statslib_daily_testcase lib/tests/statslib_test.php

6) statslib_daily_testcase::test_statslib_cron_daily with data set #6 (
+----------------------+----------------------+----------------------+----------------------+
| log                                                                                       |
+----------------------+----------------------+----------------------+----------------------+
|         time         |        userid        |        course        |        action        |
+----------------------+----------------------+----------------------+----------------------+
|      1272686410      |          3           |          1           |        login         |
+----------------------+----------------------+----------------------+----------------------+
|      1272686420      |          3           |          2           |         view         |
+----------------------+----------------------+----------------------+----------------------+
|      1272686430      |          3           |          2           |       add post       |
+----------------------+----------------------+----------------------+----------------------+

, 
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_daily                                                                                                                             |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |       timeend        |        roleid        |       stattype       |        stat1         |        stat2         |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |        logins        |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          5           |      enrolments      |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          0           |      enrolments      |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          8           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |       activity       |          0           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          0           |       activity       |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          5           |       activity       |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+


+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_user_daily                                                                                                                                               |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |        userid        |        roleid        |       timeend        |      statsreads      |     statswrites      |       stattype       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          3           |          0           |      1272758400      |          1           |          0           |        logins        |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |          3           |          0           |      1272758400      |          1           |          1           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          3           |          0           |      1272758400      |          0           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          0           |          0           |      1272758400      |          0           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+

)
Incorrect number of results returned for stats_daily
Cron output:
Running daily statistics gathering, starting at 1272672000:
Temporary tables created
Enrolments calculated
0:0 Error writing to database (Invalid column name 'courseid'.
INSERT INTO #u_temp_stats_user_daily
                            (stattype, timeend, courseid, userid, statsreads)

                SELECT 'logins', 1272758400 AS timeend, 1 AS courseid,
                        userid, COUNT(id) AS statsreads
                  FROM #u_temp_log1 l
                 WHERE action = 'login'
              GROUP BY timeend, courseid, userid
                HAVING COUNT(id) > 0
[array (
)])
...error occurred, completed 0 days of statistics in 0 s.

Failed asserting that 0 matches expected 8.

/home/aparup/mcode/integration/lib/tests/statslib_test.php:266
/home/aparup/mcode/integration/lib/tests/statslib_test.php:586
/home/aparup/mcode/integration/lib/phpunit/classes/advanced_testcase.php:76

To re-run:
 phpunit statslib_daily_testcase lib/tests/statslib_test.php

7) statslib_daily_testcase::test_statslib_cron_daily with data set #7 (
+----------------------+----------------------+----------------------+----------------------+
| log                                                                                       |
+----------------------+----------------------+----------------------+----------------------+
|         time         |        userid        |        course        |        action        |
+----------------------+----------------------+----------------------+----------------------+
|      1272686410      |          4           |          1           |        login         |
+----------------------+----------------------+----------------------+----------------------+
|      1272686420      |          4           |          1           |         view         |
+----------------------+----------------------+----------------------+----------------------+
|      1272686430      |          4           |          2           |         view         |
+----------------------+----------------------+----------------------+----------------------+

, 
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_daily                                                                                                                             |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |       timeend        |        roleid        |       stattype       |        stat1         |        stat2         |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |        logins        |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          5           |      enrolments      |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          0           |      enrolments      |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          8           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |       activity       |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          0           |       activity       |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          6           |       activity       |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          8           |       activity       |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+


+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_user_daily                                                                                                                                               |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |        userid        |        roleid        |       timeend        |      statsreads      |     statswrites      |       stattype       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          4           |          0           |      1272758400      |          1           |          0           |        logins        |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |          4           |          0           |      1272758400      |          1           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          4           |          0           |      1272758400      |          1           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          0           |          0           |      1272758400      |          0           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+

)
Incorrect number of results returned for stats_daily
Cron output:
Running daily statistics gathering, starting at 1272672000:
Temporary tables created
Enrolments calculated
0:0 Error writing to database (Invalid column name 'courseid'.
INSERT INTO #u_temp_stats_user_daily
                            (stattype, timeend, courseid, userid, statsreads)

                SELECT 'logins', 1272758400 AS timeend, 1 AS courseid,
                        userid, COUNT(id) AS statsreads
                  FROM #u_temp_log1 l
                 WHERE action = 'login'
              GROUP BY timeend, courseid, userid
                HAVING COUNT(id) > 0
[array (
)])
...error occurred, completed 0 days of statistics in 0 s.

Failed asserting that 0 matches expected 9.

/home/aparup/mcode/integration/lib/tests/statslib_test.php:266
/home/aparup/mcode/integration/lib/tests/statslib_test.php:586
/home/aparup/mcode/integration/lib/phpunit/classes/advanced_testcase.php:76

To re-run:
 phpunit statslib_daily_testcase lib/tests/statslib_test.php

8) statslib_daily_testcase::test_statslib_cron_daily with data set #8 (
+----------------------+----------------------+----------------------+----------------------+
| log                                                                                       |
+----------------------+----------------------+----------------------+----------------------+
|         time         |        userid        |        course        |        action        |
+----------------------+----------------------+----------------------+----------------------+
|      1272686410      |          3           |          1           |        login         |
+----------------------+----------------------+----------------------+----------------------+
|      1272686420      |          3           |          1           |         view         |
+----------------------+----------------------+----------------------+----------------------+

, 
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_daily                                                                                                                             |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |       timeend        |        roleid        |       stattype       |        stat1         |        stat2         |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |        logins        |          1           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          5           |      enrolments      |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          2           |      1272758400      |          0           |      enrolments      |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          8           |      enrolments      |          4           |          1           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          0           |       activity       |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |      1272758400      |          8           |       activity       |          1           |          0           |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+


+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
| stats_user_daily                                                                                                                                               |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|       courseid       |        userid        |        roleid        |       timeend        |      statsreads      |     statswrites      |       stattype       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          3           |          0           |      1272758400      |          1           |          0           |        logins        |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          3           |          0           |      1272758400      |          1           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+
|          1           |          0           |          0           |      1272758400      |          0           |          0           |       activity       |
+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+----------------------+

)
Incorrect number of results returned for stats_daily
Cron output:
Running daily statistics gathering, starting at 1272672000:
Temporary tables created
Enrolments calculated
0:0 Error writing to database (Invalid column name 'courseid'.
INSERT INTO #u_temp_stats_user_daily
                            (stattype, timeend, courseid, userid, statsreads)

                SELECT 'logins', 1272758400 AS timeend, 1 AS courseid,
                        userid, COUNT(id) AS statsreads
                  FROM #u_temp_log1 l
                 WHERE action = 'login'
              GROUP BY timeend, courseid, userid
                HAVING COUNT(id) > 0
[array (
)])
...error occurred, completed 0 days of statistics in 0 s.

Failed asserting that 0 matches expected 7.

/home/aparup/mcode/integration/lib/tests/statslib_test.php:266
/home/aparup/mcode/integration/lib/tests/statslib_test.php:586
/home/aparup/mcode/integration/lib/phpunit/classes/advanced_testcase.php:76

To re-run:
 phpunit statslib_daily_testcase lib/tests/statslib_test.php

9) statslib_daily_testcase::test_statslib_cron_daily_no_default_profile_id
Incorrect number of results returned for stats_daily
Cron output:
Running daily statistics gathering, starting at 1272672000:
Temporary tables created
Enrolments calculated
0:0 Error writing to database (Invalid column name 'courseid'.
INSERT INTO #u_temp_stats_user_daily
                            (stattype, timeend, courseid, userid, statsreads)

                SELECT 'logins', 1272758400 AS timeend, 1 AS courseid,
                        userid, COUNT(id) AS statsreads
                  FROM #u_temp_log1 l
                 WHERE action = 'login'
              GROUP BY timeend, courseid, userid
                HAVING COUNT(id) > 0
[array (
)])
...error occurred, completed 0 days of statistics in 0 s.

Failed asserting that 0 matches expected 6.

/home/aparup/mcode/integration/lib/tests/statslib_test.php:266
/home/aparup/mcode/integration/lib/tests/statslib_test.php:615
/home/aparup/mcode/integration/lib/phpunit/classes/advanced_testcase.php:76

To re-run:
 phpunit statslib_daily_testcase lib/tests/statslib_test.php

FAILURES!
Tests: 20, Assertions: 132, Failures: 9.