Skip to main content

Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

    •  
      request #11591 SQLSTATE[42S02] error on kanban dashboard
    Infos
    #11591
    Akli (catzilla)
    2018-06-14 13:45
    2018-06-09 11:40
    11929
    Details
    SQLSTATE[42S02] error on kanban dashboard
    Hello,

    I am experiencing some issues with Kanban feature (Tuleap version 10.1.99.104) adding or displaying new tasks. I have tested it on Firefox 60.0.2, Microsoft Edge 42.17134.1.0.

    The kanban cardwall worked fine the first time I've used it, I was able to add and move tasks. But since today, while I have made no change, It doesn't display the kanban tasks anymore while these tasks are still showing under the trackers/kanban tasks list. It is also impossible to add any new task to the kanban.

    I am getting the following error message:

    An error occured while saving one of your last action.
    We're afraid that you will have to reload the page in order to bring you back to a consistent state.
    Error details
    500 Internal Server Error

    I have checked the rest_api_log on the server, and I keep getting the same error again and again:
    [error] Unhandled exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tuleap.plugin_cardwall_background_color_card_field' doesn't exist:

    Any help on fixing this issue would be very appreciated.

    Regards.

    Akli
    Agile Dashboard
    10.1
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Empty
    Declined
    Empty
    Attachments
    Empty
    References
    References list is empty
    Display settings

    Follow-ups

    User avatar
    Akli (catzilla)2018-06-12 19:08
    Problem fixed. Many thanks for your help Yannis.

    Is it worth including this command in the installation script ?
    User avatar
    Yannis ROSSETTO (rossettoy)2018-06-10 19:25
    Could you please try to run the following command as root on your server and retry?

    /usr/lib/forgeupgrade/bin/forgeupgrade --config=/etc/tuleap/forgeupgrade/config.ini update
    User avatar
    Akli (catzilla)2018-06-10 11:22
    Here is the result of the sql statement:

    mysql> SHOW TABLES LIKE 'plugin_cardwall%';
    +---------------------------------------------------+
    | Tables_in_tuleap (plugin_cardwall%) |
    +---------------------------------------------------+
    | plugin_cardwall_on_top |
    | plugin_cardwall_on_top_column |
    | plugin_cardwall_on_top_column_mapping_field |
    | plugin_cardwall_on_top_column_mapping_field_value |
    | plugin_cardwall_renderer |
    | plugin_cardwall_semantic_cardfields |
    +---------------------------------------------------+
    6 rows in set (0.00 sec)
    User avatar
    Yannis ROSSETTO (rossettoy)2018-06-09 20:19
    Can you provide me the output of the following SQL query:

    SHOW TABLES LIKE 'plugin_cardwall%';
    User avatar
    Akli (catzilla)2018-06-09 18:26

    Yes it is.

    Card Wall 1.117 Electronic card wall for trackers for scrum, kanban, ...

    User avatar
    Yannis ROSSETTO (rossettoy)2018-06-09 14:45
    Ok.

    Is the plugin cardwall installed on your server ? To check that, please go as a site administrator in the plugin section.
    User avatar
    Akli (catzilla)2018-06-09 13:55
    Hi,

    I didn't upgrade, I've made a vanilla installation on a new CentOS 6 machine.
    User avatar
    Akli (catzilla)2018-06-09 11:43
    • Original Submission
      Something went wrong, the follow up content couldn't be loaded
      Only formatting have been changed, you should switch to markup to see the changes
    User avatar
    Akli (catzilla)2018-06-09 11:42
    • Original Submission
      Something went wrong, the follow up content couldn't be loaded
      Only formatting have been changed, you should switch to markup to see the changes