Log message #4122651

# At Username Text
# Mar 7th 2018, 10:11 dereuromark willem: you dont have a staging env?
# Mar 7th 2018, 10:10 neon1024 Are you baking a snapshot or a migration?
# Mar 7th 2018, 10:10 neon1024 @willem Which version of CakePHP are you using and which migrations plugin?
# Mar 7th 2018, 10:04 willem What is the best way to use migrations? Ive had a lot of times when i had a large database and modified it then baked a new migrations file, on the other server running migrate would fail midway because of for example foreign key checks. How can i prevent this so the migrations run successfully?
# Mar 7th 2018, 09:52 dereuromark it will easily all be resolved if we started to implement my sort improvements for paginator
# Mar 7th 2018, 09:52 dereuromark ;) that has been this way for a while, also when you switch sorting back to default it doesnt remove but keeps that one. only a small thing IMO, not worth fixing
# Mar 7th 2018, 09:43 neon1024 Actually, I’ll go look it up, and stop being lazy.
# Mar 7th 2018, 09:42 neon1024 Nor do I want to expose my data structure to the url
# Mar 7th 2018, 09:42 neon1024 I don’t have any sorting, so I don’t see any point in adding this pollution to my url
# Mar 7th 2018, 09:42 neon1024 `/guides?page=2andsort=Contents.publishedanddirection=desc`
# Mar 7th 2018, 09:42 neon1024 Why is `$this->Paginator->numbers()` appending query strings?
# Mar 7th 2018, 09:40 neon1024 Just feels like more code to me, and visually obfuscates what’s actually happening
# Mar 7th 2018, 09:40 neon1024 Then again I’ve never found a use for the exp() methods
# Mar 7th 2018, 09:39 neon1024 Sure
# Mar 7th 2018, 09:34 birdy247 with an 'OR' key?
# Mar 7th 2018, 09:33 neon1024 I’d have just used `$query->where()` inside the foreach personally
# Mar 7th 2018, 09:33 neon1024 Blimey how complex!
# Mar 7th 2018, 09:31 birdy247 Seems to work
# Mar 7th 2018, 09:31 birdy247 File uploaded https://cakesf.slack.com/files/U0T295QA3/F9KP76TJ7/-.php / https://slack-files.com/T053DPNCM-F9KP76TJ7-da9fb8d666
# Mar 7th 2018, 09:28 neon1024 Hopefully the Starbucks being built nearby will accept the Starbucks rewards
# Mar 7th 2018, 09:28 neon1024 One of the perils of working in the countryside, there is nowhere to pop out to
# Mar 7th 2018, 09:27 neon1024 I could really go a pastry this morning for some reason
# Mar 7th 2018, 09:26 admad Just adds extra work when upgrading
# Mar 7th 2018, 09:26 admad But silly to use it new code knowing it's already deprecated in newer version
# Mar 7th 2018, 09:24 neon1024 Might not be in the CakePHP version that Birdy is using
# Mar 7th 2018, 09:24 admad Stop using orWhere() it's deprecated
# Mar 7th 2018, 09:23 birdy247 I wondered if there was a more SQL way?
# Mar 7th 2018, 09:23 birdy247 File uploaded https://cakesf.slack.com/files/U0T295QA3/F9K9QUA4R/-.php / https://slack-files.com/T053DPNCM-F9K9QUA4R-8ffd466716
# Mar 7th 2018, 09:23 birdy247 @admad This is my plan, but I am using this
# Mar 7th 2018, 09:21 admad You can by using the callback filter and building query yourself.
# Mar 7th 2018, 09:17 birdy247 but was wondering if its possible to instead (in the query), join firstname and lastname and then perform the Like on that?
# Mar 7th 2018, 09:16 birdy247 I know I can use a OR query and the like
# Mar 7th 2018, 09:16 birdy247 I am using the search plugin, and am wanting to enable a free text search i.e. "firstname lastname"
# Mar 7th 2018, 09:15 birdy247 in our users table we model first_name and last_name
# Mar 7th 2018, 09:13 birdy247 I am just trying to think up a use case...
# Mar 7th 2018, 09:12 birdy247 @admad I see, so its probably designed for the Crud view
# Mar 7th 2018, 08:59 marcusgoede File uploaded https://cakesf.slack.com/files/U260GELVA/F9KQXUZC4/-.php / https://slack-files.com/T053DPNCM-F9KQXUZC4-935c85a6f5
# Mar 7th 2018, 08:59 marcusgoede good morning. anyone has an idea why my collection is not sorted?
# Mar 7th 2018, 08:56 admad @birdy247 no, on add/edit it popular vars for filling select options for related models
# Mar 7th 2018, 08:55 admad @birdy247 hehe, no problem
# Mar 7th 2018, 08:47 birdy247 Is this just a time saver over adding contains in the queries