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


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

MySQL using deprecated NO_ZERO_DATE

Scheduled Pinned Locked Moved Unsolved Support
mysql
4 Posts 2 Posters 249 Views
    • 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.
  • murgeroM Offline
    murgeroM Offline
    murgero App Dev
    wrote on last edited by girish
    #1

    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
    0
  • girishG Do not disturb
    girishG Do not disturb
    girish Staff
    wrote on last edited by
    #2

    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.

    murgeroM 1 Reply Last reply
    1
  • murgeroM Offline
    murgeroM Offline
    murgero App Dev
    wrote on last edited by
    #3

    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
    0
  • murgeroM Offline
    murgeroM Offline
    murgero App Dev
    replied to girish on last edited by
    #4

    @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
    0

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.