| # |
Mar 7th 2018, 10:14 |
 willem |
baking a migration |
| # |
Mar 7th 2018, 10:14 |
neon1024 |
Could be that you need to organise your migrations code so that the foreign keys are written first, so the next queries pass the constraints |
| # |
Mar 7th 2018, 10:14 |
neon1024 |
Do you use `change()` or `up()` and `down()` ? |
| # |
Mar 7th 2018, 10:13 |
willem |
have a staging env. thats where it fails |
| # |
Mar 7th 2018, 10:13 |
willem |
Cake 3.5.1 / “cakephp/migrations”: “~1.0" (not sure wher to find the exact verion number) |
| # |
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 |