Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Unsolved MySQL using deprecated NO_ZERO_DATE

    Support
    mysql
    2
    4
    242
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • murgero
      murgero App Dev last edited by girish

      We should unset this default from now on, the feature is deprecated:

      SET GLOBAL sql_mode = replace(@@global.sql_mode, 'NO_ZERO_DATE,', '');

      Unfortunately having it enabled will break some apps now and in the future. This cannot be disabled per database AFAIK so it must be system-wide.

      --
      https://urgero.org
      ~ Professional Nerd. Freelance Programmer. ~
      Matrix: @murgero:urgero.org

      1 Reply Last reply Reply Quote 0
      • girish
        girish Staff last edited by

        Agreed. Same applies to NO_ZERO_IN_DATE. The main issue as you already noted is that apps have to be ported/fixed to not use zero dates. This is a bit outside the scope of Cloudron since we don't control the apps. Note that apps can always enable strict mode (currently, only enabled for trans tables) and not use that feature.

        murgero 1 Reply Last reply Reply Quote 1
        • murgero
          murgero App Dev last edited by

          I don't think it will hurt current apps either if the change is made. My worry is apps in the future will not accommodate Cloudron if this default is left as is.

          That said I am excited to see this issue resolved as I have a few app ideas that can benefit from this.

          --
          https://urgero.org
          ~ Professional Nerd. Freelance Programmer. ~
          Matrix: @murgero:urgero.org

          1 Reply Last reply Reply Quote 0
          • murgero
            murgero App Dev @girish last edited by

            @girish In trying to host an app in the LAMP stack (Specifically GNU Social) and the installation fails due to this still being in use.

            When can this be applied to cloudron? I believe this will fix many apps not able to be hosted otherwise.

            --
            https://urgero.org
            ~ Professional Nerd. Freelance Programmer. ~
            Matrix: @murgero:urgero.org

            1 Reply Last reply Reply Quote 0
            • First post
              Last post
            Powered by NodeBB