•  
      request #7652 Agile Dashboard
    Infos
    #7652
    Jithin Karkera (jithink)
    2017-02-03 15:58
    2014-12-01 14:48
    7649
    Details
    Agile Dashboard
    While Agile Dashboard is clicked its not opening going to a different URL:
    /plugins/agiledashboard/?group_id=104
    Where as it should be directed. :
    plugins/agiledashboard/?group_id=104&action=show-top&pane=topplanning

    Seems to be some sort of an issues while update. Can someone please have a look and update as this is super critical.
    Agile Dashboard
    All
    CentOS 6
    • [ ] enhancement
    • [ ] internal improvement
    Manuel Vacelet (vaceletm)
    Stage
    Empty
    Closed
    2017-02-03
    Attachments
    Empty
    References
    References list is empty

    Follow-ups

    User avatar
    Given that there is no answer since 2 years, I close this request.

    • Status changed from Waiting for information to Closed
    • Close date set to 2017-02-03
    User avatar
    i did that that is giving me the error.

    [root@gprojects httpd]# /usr/lib/forgeupgrade/bin/forgeupgrade --config=/etc/codendi/forgeupgrade/config.ini update
    INFO - Process all pre up checks
    INFO - OK: b201411281005_create_plugin_agiledashboard_configuration_table
    INFO - PreUp checks OK
    INFO - Start running migrations...
    PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Calcutta' for 'IST/5.0/no DST' instead in /usr/share/forgeupgrade/lib/log4php/helpers/LoggerDatePatternConverter.php on line 51
    INFO - Processing b201411281005_create_plugin_agiledashboard_configuration_table
    PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Calcutta' for 'IST/5.0/no DST' instead in /usr/share/forgeupgrade/lib/log4php/helpers/LoggerDatePatternConverter.php on line 51
    INFO - PreUp OK
    INFO - Add table plugin_agiledashboard_configuration
    INFO - plugin_agiledashboard_configuration already exists
    PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Calcutta' for 'IST/5.0/no DST' instead in /usr/share/forgeupgrade/lib/log4php/helpers/LoggerDatePatternConverter.php on line 51
    ERROR - An error occured while adding values in table plugin_agiledashboard_configuration: 42S02, 1146, Table 'tuleap.plugin_agiledashboard_kanban' doesn't exist
    User avatar
    It seems that some tables are missing.

    Please run on your server /usr/lib/forgeupgrade/bin/forgeupgrade --config=/etc/codendi/forgeupgrade/config.ini update
    User avatar
    Failed to execute SQL : SQL DESC plugin_agiledashboard_kanban_configuration; failed : Table 'tuleap.plugin_agiledashboard_kanban_configuration' doesn't exist

    i am unable to find the table in the tuleap database.
    User avatar
    Thanks for the update.

    Can you please provide me the output of the SQL requests ?

    DESC plugin_agiledashboard_kanban_configuration;
    SELECT * FROM plugin_agiledashboard_kanban_configuration;

    Thanks
    User avatar
    [Tue Dec 02 23:19:20 2014] [error] [client 183.87.39.130] PHP Notice: DB error ==> SELECT tracker.id, tracker.name, kanban_config.name used\n FROM tracker\n LEFT JOIN plugin_agiledashboard_kanban_configuration AS kanban_config\n ON (tracker.id = kanban_config.tracker_id)\n WHERE group_id = 104\n ORDER BY tracker.name ASC @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 92 in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 152, referer: https://gprojects.gurujiworld.in/projects/SSK12SSCMH/
    [Tue Dec 02 23:19:20 2014] [error] [client 183.87.39.130] PHP Notice: DB error ==> SELECT *\n FROM plugin_agiledashboard_kanban_configuration\n WHERE project_id = 104\n ORDER BY name ASC @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 92 in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 152, referer: https://gprojects.gurujiworld.in/projects/SSK12SSCMH/
    [Tue Dec 02 23:19:20 2014] [error] [client 183.87.39.130] PHP Warning: Invalid argument supplied for foreach() in /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/KanbanFactory.class.php on line 35, referer: https://gprojects.gurujiworld.in/projects/SSK12SSCMH/
    [Tue Dec 02 23:19:25 2014] [error] [client 183.87.39.130] File does not exist: /usr/share/tuleap/plugins/agiledashboard/www/js/angular/vendor, referer: https://gprojects.gurujiworld.in/plugins/agiledashboard/?group_id=104
    [Tue Dec 02 23:19:44 2014] [error] [client 183.87.39.130] PHP Notice: DB error ==> SELECT tracker.id, tracker.name, kanban_config.name used\n FROM tracker\n LEFT JOIN plugin_agiledashboard_kanban_configuration AS kanban_config\n ON (tracker.id = kanban_config.tracker_id)\n WHERE group_id = 104\n ORDER BY tracker.name ASC @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 92 in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 152, referer: https://gprojects.gurujiworld.in/plugins/agiledashboard/?group_id=104
    [Tue Dec 02 23:19:44 2014] [error] [client 183.87.39.130] PHP Notice: DB error ==> SELECT *\n FROM plugin_agiledashboard_kanban_configuration\n WHERE project_id = 104\n ORDER BY name ASC @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 92 in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 152, referer: https://gprojects.gurujiworld.in/plugins/agiledashboard/?group_id=104
    [Tue Dec 02 23:19:44 2014] [error] [client 183.87.39.130] PHP Warning: Invalid argument supplied for foreach() in /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/KanbanFactory.class.php on line 35, referer: https://gprojects.gurujiworld.in/plugins/agiledashboard/?group_id=104
    [Tue Dec 02 23:19:45 2014] [error] [client 183.87.39.130] File does not exist: /usr/share/tuleap/plugins/agiledashboard/www/js/angular/vendor, referer: https://gprojects.gurujiworld.in/plugins/agiledashboard/?group_id=104

    new error log pos the update.
    User avatar
    [root@gprojects httpd]# /usr/lib/forgeupgrade/bin/forgeupgrade --config=/etc/codendi/forgeupgrade/config.ini update
    INFO - Process all pre up checks
    INFO - OK: b201411281005_create_plugin_agiledashboard_configuration_table
    INFO - PreUp checks OK
    INFO - Start running migrations...
    PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Calcutta' for 'IST/5.0/no DST' instead in /usr/share/forgeupgrade/lib/log4php/helpers/LoggerDatePatternConverter.php on line 51
    INFO - Processing b201411281005_create_plugin_agiledashboard_configuration_table
    PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Calcutta' for 'IST/5.0/no DST' instead in /usr/share/forgeupgrade/lib/log4php/helpers/LoggerDatePatternConverter.php on line 51
    INFO - PreUp OK
    INFO - Add table plugin_agiledashboard_configuration
    INFO - plugin_agiledashboard_configuration already exists
    PHP Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Calcutta' for 'IST/5.0/no DST' instead in /usr/share/forgeupgrade/lib/log4php/helpers/LoggerDatePatternConverter.php on line 51
    ERROR - An error occured while adding values in table plugin_agiledashboard_configuration: 42S02, 1146, Table 'tuleap.plugin_agiledashboard_kanban' doesn't exist


    This is the error which has come while updating now.

    Can you help
    User avatar
    [Tue Dec 02 22:41:38 2014] [error] [client 183.87.39.130] PHP Notice: DB error ==> SELECT project_id\n FROM plugin_agiledashboard_kanban\n WHERE project_id = 104 @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 92 in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 152, referer: https://gprojects.gurujiworld.in/projects/SSK12SSCMH/
    [Tue Dec 02 22:41:38 2014] [error] [client 183.87.39.130] PHP Fatal error: Call to a member function count() on a non-object in /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/KanbanManager.class.php on line 33, referer: https://gprojects.gurujiworld.in/projects/SSK12SSCMH/
    [Tue Dec 02 22:45:38 2014] [error] [client 183.87.39.130] PHP Notice: DB error ==> SELECT project_id\n FROM plugin_agiledashboard_kanban\n WHERE project_id = 107 @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 92 in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 152, referer: https://gprojects.gurujiworld.in/projects/SSK12CBSE/
    [Tue Dec 02 22:45:38 2014] [error] [client 183.87.39.130] PHP Fatal error: Call to a member function count() on a non-object in /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/KanbanManager.class.php on line 33, referer: https://gprojects.gurujiworld.in/projects/SSK12CBSE/
    [Tue Dec 02 22:45:55 2014] [error] [client 183.87.39.130] PHP Notice: DB error ==> SELECT project_id\n FROM plugin_agiledashboard_kanban\n WHERE project_id = 103 @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 92 in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 152, referer: https://gprojects.gurujiworld.in/projects/GEMSERP/
    [Tue Dec 02 22:45:55 2014] [error] [client 183.87.39.130] PHP Fatal error: Call to a member function count() on a non-object in /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/KanbanManager.class.php on line 33, referer: https://gprojects.gurujiworld.in/projects/GEMSERP/
    [Tue Dec 02 22:53:38 2014] [error] [client 183.87.39.130] PHP Notice: DB error ==> SELECT project_id\n FROM plugin_agiledashboard_kanban\n WHERE project_id = 101 @@ /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php at line 92 in /usr/share/tuleap/src/common/dao/include/DataAccessObject.class.php on line 152, referer: https://gprojects.gurujiworld.in/projects/ITS/
    [Tue Dec 02 22:53:38 2014] [error] [client 183.87.39.130] PHP Fatal error: Call to a member function count() on a non-object in /usr/share/tuleap/plugins/agiledashboard/include/AgileDashboard/KanbanManager.class.php on line 33, referer: https://gprojects.gurujiworld.in/projects/ITS/


    Please check this is the from the error log at last i was able to get this.

    I did the update as per the shown but it didn't have anything to update.
    User avatar
    You have to run this command in addition of yum update (this is mandatory in order to have a functional Tuleap).

    Please run this command and retry to access the Agile Dashboard.
    User avatar
    Hi I don't use this command i use the yum update command.

    Also i tried to collect the log but was not able to collect.
    User avatar
    Sorry didn't get your second comment.

    ust to be sure: Do you process the forgeupgrade on the update ?
    User avatar
    Can you provide more lines after [02/Dec/2014:14:48:11 +0530] GET /plugins/agiledashboard/?group_id=104 HTTP/1.1500 ? So I can see the full error stack trace.

    Just to be sure: Do you process the forgeupgrade on the update ?
    User avatar
    <p>192.168.2.182 - - [02/Dec/2014:14:48:03 +0530] &quot;GET /themes/common/images/ic/toggle_plus.png HTTP/1.1&quot; 200 220 192.168.2.182 - - [02/Dec/2014:14:48:03 +0530] &quot;GET /themes/Dawn/images/pointer_down.png HTTP/1.1&quot; 200 184 192.168.2.182 - - [02/Dec/2014:14:48:03 +0530] &quot;GET /themes/Dawn/images/pointer_right.png HTTP/1.1&quot; 200 187 192.168.2.182 - - [02/Dec/2014:14:48:03 +0530] &quot;POST /sparklines.php HTTP/1.1&quot; 204 - 192.168.2.182 - - [02/Dec/2014:14:48:06 +0530] &quot;GET /plugins/projectlinks/themes/default/css/style.css HTTP/1.1&quot; 200 125 192.168.2.182 - - [02/Dec/2014:14:48:05 +0530] &quot;GET /projects/SSK12SSCMH/ HTTP/1.1&quot; 200 34090 192.168.2.182 - - [02/Dec/2014:14:48:07 +0530] &quot;GET /plugins/IM/themes/default/images/icons/blank.png HTTP/1.1&quot; 200 191 192.168.2.182 - - [02/Dec/2014:14:48:07 +0530] &quot;GET /themes/Dawn/images/ic/notes16.png HTTP/1.1&quot; 200 208 192.168.2.182 - - [02/Dec/2014:14:48:07 +0530] &quot;GET /themes/Dawn/images/ic/mail16b.png HTTP/1.1&quot; 200 867 192.168.2.182 - - [02/Dec/2014:14:48:07 +0530] &quot;GET /themes/Dawn/images/ic/file.png HTTP/1.1&quot; 200 1096 192.168.2.182 - - [02/Dec/2014:14:48:07 +0530] &quot;GET /themes/Dawn/images/ic/ftp16b.png HTTP/1.1&quot; 200 766 192.168.2.182 - - [02/Dec/2014:14:48:07 +0530] &quot;GET /themes/Dawn/images/ic/clipboard-list.png HTTP/1.1&quot; 200 640 192.168.2.182 - - [02/Dec/2014:14:48:07 +0530] &quot;GET /plugins/docman/themes/default/images/ic/text.png HTTP/1.1&quot; 200 309 192.168.2.182 - - [02/Dec/2014:14:48:07 +0530] &quot;POST /plugins/IM/?action=get_presence HTTP/1.1&quot; 200 863 192.168.2.182 - - [02/Dec/2014:14:48:07 +0530] &quot;POST /widgets/widget.php?owner=g104&amp;action=ajax&amp;name[projectlatestsvncommits]=0 HTTP/1.1&quot; 200 109 192.168.2.182 - - [02/Dec/2014:14:48:07 +0530] &quot;GET /plugins/IM/themes/default/images/icons/off_line.gif HTTP/1.1&quot; 200 333 192.168.2.182 - - [02/Dec/2014:14:48:07 +0530] &quot;GET /plugins/IM/themes/default/images/icons/away.gif HTTP/1.1&quot; 200 533 192.168.2.182 - - [02/Dec/2014:14:48:07 +0530] &quot;GET /plugins/IM/themes/default/images/icons/on_line.gif HTTP/1.1&quot; 200 533 192.168.2.182 - - [02/Dec/2014:14:48:11 +0530] &quot;GET /plugins/agiledashboard/?group_id=104 HTTP/1.1&quot; 500 -</p>
    User avatar
    Hello,

    Can you provide us the error logged in /var/log/httpd/error_log ?
    Do you have any errors displayed in the user interface ?

    • Status changed from New to Waiting for information
    User avatar
    It seems Kanban, is creating the issue can someone please check as the tuleap agile dashboard is not showing up.