### Log message #4267563

# Jul 13th 2021, 16:29 tyler.adam.lazenby it does that
# Jul 13th 2021, 16:28 tyler.adam.lazenby even if I truncate it
# Jul 13th 2021, 16:25 tyler.adam.lazenby yes
# Jul 13th 2021, 16:25 kevin.pfeifer does your `id` column have a `AUTO_INCREMENT` on it?
# Jul 13th 2021, 16:23 tyler.adam.lazenby if I remove the duplicate
# Jul 13th 2021, 16:23 tyler.adam.lazenby the email is duplicated yes but the seed still fails
# Jul 13th 2021, 16:23 tyler.adam.lazenby nevermind
# Jul 13th 2021, 16:23 tyler.adam.lazenby goddamnit
# Jul 13th 2021, 16:23 tyler.adam.lazenby oh wait
# Jul 13th 2021, 16:22 tyler.adam.lazenby ```\$data = [ [ 'name' =&gt; 'Email', 'description' =&gt; 'Emails sent to contact', ], [ 'name' =&gt; 'Text', 'description' =&gt; 'Texts sent to contact', ], [ 'name' =&gt; 'Other', 'description' =&gt; 'Other histories', ], [ 'name' =&gt; 'Email', 'description' =&gt; 'Email sent to contact', ] ];```
# Jul 13th 2021, 16:22 tyler.adam.lazenby But my seed doesn't even reference the primary key
# Jul 13th 2021, 16:22 tyler.adam.lazenby but the issue now is that I am running into this
# Jul 13th 2021, 16:22 tyler.adam.lazenby I am running seeds and I had to drop the data from the table so that I could reseed in test
# Jul 13th 2021, 16:22 tyler.adam.lazenby I am also running into something else
# Jul 13th 2021, 15:57 dereuromark based on the current activity just reporting might not get it fixed any time soon I would recommend a PR directly, if you want to have this rather sooner than later.
# Jul 13th 2021, 15:54 tyler.adam.lazenby should I report that?
# Jul 13th 2021, 15:50 dereuromark sounds like a bug then
# Jul 13th 2021, 15:48 richard oh
# Jul 13th 2021, 15:47 tyler.adam.lazenby `bin/cake bake migration_snapshot Initial`
# Jul 13th 2021, 15:47 richard how exactly did you create it via the migrations plugin
# Jul 13th 2021, 15:46 tyler.adam.lazenby but the first was actually created by the migrations plugin
# Jul 13th 2021, 15:46 tyler.adam.lazenby ```->addColumn('updated', 'datetime', [ 'default' =&gt; 'CURRENT_TIMESTAMP', 'limit' =&gt; null, 'null' =&gt; false, ])```
# Jul 13th 2021, 15:46 tyler.adam.lazenby It will work if I mass change it to this
# Jul 13th 2021, 15:45 tyler.adam.lazenby ```->addColumn('updated', 'datetime', [ 'default' =&gt; 'current_timestamp()', 'limit' =&gt; null, 'null' =&gt; false, ])```
# Jul 13th 2021, 15:45 kevin.pfeifer I can&rsquo;t find any valid php function which is called `current_timestamp()` Or do you mean the MySQL function?
# Jul 13th 2021, 15:41 tyler.adam.lazenby Is there a reason why the default value for datetime `current_timestamp()` is (a) generated by the snapshot command in migrations and (b) the system considers that invalid?
# Jul 13th 2021, 14:59 tyler.adam.lazenby gosh dang it, I have to use an app_local file
# Jul 13th 2021, 14:57 richard tired of doing sudo mysql then creating dbs/etc
# Jul 13th 2021, 14:57 richard I was thinking as some sort of dev ops chain but honestly i haven&rsquo;t done that either, it&rsquo;s something i want to start doing more often though
# Jul 13th 2021, 14:56 tyler.adam.lazenby init script huh? I have never done one of those
# Jul 13th 2021, 14:55 richard also might be weird, yeah, so you&rsquo;re better off just doing that part yourself as some sort of init script or something
# Jul 13th 2021, 14:55 tyler.adam.lazenby yeah, but the thing about that is... migrations rufuses to run if it can't find a database connection
# Jul 13th 2021, 14:55 richard i don&rsquo;t think there is a db-agnostic way to do it though
# Jul 13th 2021, 14:54 richard @tyler.adam.lazenby you can run any query in a migration technically, so yeah
# Jul 13th 2021, 14:45 tyler.adam.lazenby so question... can migrations be programed to create a db or do I need to do that manually
# Jul 13th 2021, 13:46 erwane If data are encoded with default flags, you can change it after i think. toPhp decode all data (escaped or not) toDatabase recode them with flags. I'm hot sure this should add bug. BUT this should be an option in JsonType, not default.
# Jul 13th 2021, 13:43 dereuromark yeah, as expected the impact is rather small. but none the less, sounds like a more consistent data storage if done with the right flags from the beginning. one should however not change those in the middle (if data already exists).
# Jul 13th 2021, 13:42 erwane ```decode 1119 escaped: 0.001491s decode 1663 unescaped: 0.001954s```
# Jul 13th 2021, 13:42 erwane After more tests, not sure there is a large impact on speed.
# Jul 13th 2021, 13:38 erwane weird result :S