Log message #4199094

# At Username Text
# Aug 20th 2019, 20:16 maymeow cool let me try "::)
# Aug 20th 2019, 20:16 maymeow i need create default user menu and this is tree
# Aug 20th 2019, 20:15 ricksaccous and use the data already in the table
# Aug 20th 2019, 20:15 ricksaccous you can bake a seed
# Aug 20th 2019, 20:15 ricksaccous but i don' tknow if seeds work across db structures, i'm guessing they do
# Aug 20th 2019, 20:14 ricksaccous you can seed anything
# Aug 20th 2019, 20:14 maymeow and one more thing.. is there any way how to seed tree structure?
# Aug 20th 2019, 20:12 maymeow for mysql doesnt matter ...
# Aug 20th 2019, 20:11 slackebot $query->distinct(['Posts.created', 'Posts.sender_name'])->combine('sender_name', 'sender_name'); } ```
# Aug 20th 2019, 20:11 maymeow @ricksaccous what i found for example if you ordering something by created field postgres will return error if you selecting distinct on another field so you have to select on both and mssql will return error when you selecting distinct on both :) ``` if ($conn['driver'] == Sqlserver::class) { $senders = $query->distinct(['Posts.sender_name'])->combine('sender_name', 'sender_name'); } else { $senders =
# Aug 20th 2019, 20:06 daniel.upshaw Thanks for the info @admad :slightly_smiling_face:
# Aug 20th 2019, 20:06 ricksaccous weird
# Aug 20th 2019, 20:06 maymeow @ricksaccous it dont have problem when i use postgres or MSSQL
# Aug 20th 2019, 20:05 ricksaccous yeah that makes more sense @maymeow i don't see how inserting a class makes sense from a migrations standpoint so i don't know how it was working before but glad it's working now
# Aug 20th 2019, 20:04 admad so basically anything you can do with chronos instance you can with frozentime
# Aug 20th 2019, 20:04 maymeow dont know if its good idea but forkink for me :)
# Aug 20th 2019, 20:04 admad @daniel.upshaw frozentime wraps chronos and all some i18n formatting features
# Aug 20th 2019, 20:03 maymeow refresh ... updated
# Aug 20th 2019, 20:03 ricksaccous heh intersting
# Aug 20th 2019, 20:03 daniel.upshaw Now I'm curious about that lol
# Aug 20th 2019, 20:03 daniel.upshaw But seems the docs always mention `FrozenTime`
# Aug 20th 2019, 20:03 daniel.upshaw And active too: https://github.com/cakephp/chronos
# Aug 20th 2019, 20:02 daniel.upshaw This is the first I'd seen Chronos actually... looks interesting
# Aug 20th 2019, 20:02 maymeow old file in git... just changed it in notebook
# Aug 20th 2019, 20:02 maymeow sorry
# Aug 20th 2019, 20:01 daniel.upshaw Not using `FrozenTime`?
# Aug 20th 2019, 20:00 maymeow changed `'created' => \Cake\Chronos\Date::now(),` to `'created' => \Cake\Chronos\Date::now()->toDateTimeString(),` and its now working
# Aug 20th 2019, 19:59 maymeow @ricksaccous https://gist.github.com/MayMeow/c03b0cda19e0703bede81190fa13c56e
# Aug 20th 2019, 19:56 ricksaccous whatever
# Aug 20th 2019, 19:56 ricksaccous or i mean obfuscate them
# Aug 20th 2019, 19:56 ricksaccous feel free to comment out stuff/etc
# Aug 20th 2019, 19:56 ricksaccous can you gist the migration? I'm curious now
# Aug 20th 2019, 19:55 maymeow i think its same CEST... when i change app config to CEST or europe/something even on datasource config still not working
# Aug 20th 2019, 19:54 maymeow my notebook has CEST timezone and mysql has SYSTEM
# Aug 20th 2019, 19:54 ricksaccous so you have the default admin on those?
# Aug 20th 2019, 19:54 ricksaccous weird...
# Aug 20th 2019, 19:54 maymeow i didnt have this problem on dokce or on review server on digital ocean but on my notebook yes
# Aug 20th 2019, 19:54 ricksaccous hehe
# Aug 20th 2019, 19:53 ricksaccous also I still use seeds I just make sure they only run once ;) I do that by doing a find() and if there are results I just skip the seed
# Aug 20th 2019, 19:53 ricksaccous okay well it depends how you are doing the migration
# Aug 20th 2019, 19:53 maymeow migrations can run only once thats why