Verify if NO_AUTO_VALUE_ON_ZERO mode is disabled during installation

XMLWordPrintable

    • 2

      Problem Definition

      When we run Bamboo with NO_AUTO_VALUE_ON_ZERO mode enabled in MySQL, we see Couldn't update the branch view. Try reloading the page. when we access any plan branch status page from the dropdown.

      Suggested Solution

      Add an upgrade task to validate if NO_AUTO_VALUE_ON_ZERO mode is disabled.

      Workaround

      We can verify if this mode is turned on by running this on the MySQL instance running the Bamboo database.

      SELECT @@SQL_MODE, @@GLOBAL.SQL_MODE;

      The first mode is the mode for the session, the second is the global settings for MySQL. If the GLOBAL mode contains NO_AUTO_VALUE_ON_ZERO, it has to be removed.

            Assignee:
            Unassigned
            Reporter:
            Jeyanthan I (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: