•  
      request #8484 Service usage statistics CSV export triggers errors when TV3 tables are not present
    Infos
    #8484
    Thomas Gerbet (tgerbet)
    2015-10-15 15:02
    2015-10-13 10:24
    8612
    Details
    Service usage statistics CSV export triggers errors when TV3 tables are not present
    On a new Tuleap instance where TV3 tables are not present when a site admin try to export statistics the following errors are triggered:
    Notice: DB error ==> SELECT artifact_group_list.group_id, COUNT(artifact.artifact_id) AS result FROM artifact_group_list, artifact WHERE ( open_date >= 1441065600 AND open_date < 1444694400 AND artifact_group_list.group_artifact_id = artifact.group_artifact_id ) GROUP BY artifact_group_list.group_id @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 95 in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 155
    Call Stack
    # Time Memory Function Location
    1 0.0001 637400 {main}( ) ../services_usage.php:0
    2 0.0503 6832016 Statistics_ServicesUsageDao->getNumberOfOpenArtifactsBetweenStartDateAndEndDate( ) ../services_usage.php:141
    3 0.0503 6832448 DataAccessObject->retrieve( ) ../Statistics_ServicesUsageDao.class.php:310
    4 0.0505 6833488 DataAccessObject->handleError( ) ../DataAccessObject.class.php:95
    5 0.0505 6834928 trigger_error ( ) ../DataAccessObject.class.php:155

    ( ! ) Warning: Invalid argument supplied for foreach() in /usr/share/tuleap/plugins/statistics/include/Statistics_Services_UsageFormatter.class.php on line 96
    Call Stack
    # Time Memory Function Location
    1 0.0001 637400 {main}( ) ../services_usage.php:0
    2 0.0506 6832144 Statistics_Services_UsageFormatter->buildDatas( ) ../services_usage.php:141
    3 0.0506 6832840 Statistics_Services_UsageFormatter->addValuesFromQueryResultForTitle( ) ../Statistics_Services_UsageFormatter.class.php:68

    ( ! ) Notice: DB error ==> SELECT artifact_group_list.group_id, COUNT(artifact.artifact_id) AS result FROM artifact_group_list, artifact WHERE ( close_date >= 1441065600 AND close_date < 1444694400 AND artifact_group_list.group_artifact_id = artifact.group_artifact_id ) GROUP BY artifact_group_list.group_id @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 95 in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 155
    Call Stack
    # Time Memory Function Location
    1 0.0001 637400 {main}( ) ../services_usage.php:0
    2 0.0507 6832760 Statistics_ServicesUsageDao->getNumberOfClosedArtifactsBetweenStartDateAndEndDate( ) ../services_usage.php:142
    3 0.0507 6833200 DataAccessObject->retrieve( ) ../Statistics_ServicesUsageDao.class.php:321
    4 0.0509 6834240 DataAccessObject->handleError( ) ../DataAccessObject.class.php:95
    5 0.0509 6835704 trigger_error ( ) ../DataAccessObject.class.php:155

    ( ! ) Warning: Invalid argument supplied for foreach() in /usr/share/tuleap/plugins/statistics/include/Statistics_Services_UsageFormatter.class.php on line 96
    Call Stack
    # Time Memory Function Location
    1 0.0001 637400 {main}( ) ../services_usage.php:0
    2 0.0510 6832896 Statistics_Services_UsageFormatter->buildDatas( ) ../services_usage.php:142
    3 0.0510 6833592 Statistics_Services_UsageFormatter->addValuesFromQueryResultForTitle( ) ../Statistics_Services_UsageFormatter.class.php:68
    Site admin
    Empty
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Empty
    Closed
    2015-10-15
    Attachments
    Empty
    References

    Follow-ups

    User avatar
    Integrated into Tuleap 8.7.99.19

    • Status changed from Under review to Closed
    • Close date set to 2015-10-15