Updating Table problem, 'null' default value (only on Windows- mariadb)

Question

Updating Table problem, 'null' default value (only on Windows- mariadb)

Closed this issue 4 years ago · 7 comments

When i try to add/remove/update some field from Builder -> Database I get error, because my default nullable value is string null ( 'null' ) not just null. And i get error for fields that is not string (exp. Invalid default value for the integer column 'temp_old_id'. The allowed formats are '10', '-10'.)
This only happens on windows os, linux working fine.
When i try to change from 'null' to just null, than it recognize that field as changed, and i don't wont that.

Answer 1 · 2020-02-19T17:21:41.000Z

reuniors commented 4 years ago

Answer 2 · 2020-02-20T02:05:58.000Z

@reunior This is the same issue as reported in some comments here: #295. I will take a look at this along with the initial issue in that report.

Answer 3 · 2020-02-22T20:51:28.000Z

@reunior This is the same issue as reported in some comments here: #295. I will take a look at this along with the initial issue in that report.

Ok, great. Thanks

Answer 4 · 2020-03-04T22:46:18.000Z

Hi, this problem (same of the #295) occur also on linux (my dev env is on raspberry)

PHP 7.3.11-1deb10u1 (cli) (built: Oct 26 2019 14:14:18) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.11, Copyright (c) 1998-2018 Zend Technologies
with Zend OPcache v7.3.11-1deb10u1, Copyright (c) 1999-2018, by Zend Technologies

DB: 10.3.17-MariaDB-0+deb10u1 Raspbian 10

OctoberCms Build 465
Builder 1.026

Answer 5 · 2020-03-18T19:58:12.000Z

Hi, try this plugin https://octobercms.com/plugin/cubecamp-doctrine , may be help you

Answer 6 · 2020-03-18T21:58:42.000Z

hi @pittss, I did a quick test, it seems to work!
Thank you

Answer 7 · 2020-03-20T19:18:17.000Z

Hi, try this plugin https://octobercms.com/plugin/cubecamp-doctrine , may be help you

Great, thank you!

@bennothommo use this fix(plugin) to solve this problem!