Log message #4161576

# At Username Text
# Jul 24th 2018, 10:10 lorenzo @neon1024 if you told it to dpro the fk, but it attempted to drop an index instead, that’s a bug
# Jul 24th 2018, 10:09 lorenzo ci= case insensitive
# Jul 24th 2018, 10:09 lorenzo use a citext column type
# Jul 24th 2018, 10:08 dereuromark lorenzo: how? it doesnt seem to be true
# Jul 24th 2018, 10:08 lorenzo same as postgres can do both easily :P
# Jul 24th 2018, 10:08 neon1024 I’m just changing the db directly
# Jul 24th 2018, 10:08 dereuromark but meh/
# Jul 24th 2018, 10:08 dereuromark mysql can do both easily :slightly_smiling_face:
# Jul 24th 2018, 10:08 neon1024 I’ve stopped using migrations now
# Jul 24th 2018, 10:08 lorenzo yes, you have to be aware that it is case sensitive, unlike mysql
# Jul 24th 2018, 10:08 neon1024 @lorenzo Yeah, stuff like `->dropForeignKey('script_id', 'slots_scripts_fk')`
# Jul 24th 2018, 10:07 dereuromark best example: email addresses, tons of bugs because of this, partially even security issues
# Jul 24th 2018, 10:07 lorenzo @neon1024 is it oyu trying to drop the index yourself?
# Jul 24th 2018, 10:07 dereuromark haha, that by default this is a bad default for human input, and if you want to, there is no proper way here
# Jul 24th 2018, 10:07 neon1024 Then a whole bunch of errors about invalid stream
# Jul 24th 2018, 10:07 lorenzo @dereuromark you mean that it is properly case sensitive?
# Jul 24th 2018, 10:07 neon1024 You get this if a FK fails
# Jul 24th 2018, 10:07 neon1024 File uploaded https://cakesf.slack.com/files/U1BT622HW/FBV4SHSV6/screen_shot_2018-07-24_at_11.06.40.png / https://slack-files.com/T053DPNCM-FBV4SHSV6-5ae4ed839e
# Jul 24th 2018, 10:06 dereuromark only some buggy extension, i really dont like it
# Jul 24th 2018, 10:06 dereuromark doesnt still have a proper working solution here
# Jul 24th 2018, 10:06 neon1024 Just fiddly with migrations
# Jul 24th 2018, 10:06 dereuromark postgres is shit from the case sensitivity perspective :slightly_smiling_face:
# Jul 24th 2018, 10:06 lorenzo what’s the problem with foreign keys @neon1024?
# Jul 24th 2018, 10:05 lorenzo the problem is that mysql does not let you rollback schema changes
# Jul 24th 2018, 10:05 lorenzo use postgres, that’s a better experience
# Jul 24th 2018, 09:36 neon1024 Which means that you get lots of failed and partially run migrations, and huge spaffs of error output
# Jul 24th 2018, 09:36 neon1024 Using foreignKey constraints makes using Migrations super hard work and pretty furstrating
# Jul 24th 2018, 09:34 neon1024 Why doesn’t the migrations plugin fail nicely?
# Jul 24th 2018, 09:09 neon1024 Morning all
# Jul 24th 2018, 08:49 saeideng and then `return $this->response `
# Jul 24th 2018, 08:49 saeideng `$this->response = $this->response->withHeader('.....')`
# Jul 24th 2018, 08:48 saeideng `->withHeader(`
# Jul 24th 2018, 08:47 scottmkroberts I just need a way to set a header before redirecting
# Jul 24th 2018, 08:40 scottmkroberts I found the issue. I’m using Turbolinks so I need to pass a header along with the redirect for it to work.
# Jul 24th 2018, 08:20 saeideng `redirect()` uses http header for redirecting
# Jul 24th 2018, 08:19 saeideng I dont understand your mean
# Jul 24th 2018, 08:18 saeideng `$this->redirect('target')`
# Jul 24th 2018, 08:18 saeideng infact cake 4 is very similar to cake 3.6 and 3.7 , and migrate to cake 4 would be easy
# Jul 24th 2018, 08:16 saeideng cake 3.6 and 4.0 is same except in methods type hints and a bit more
# Jul 24th 2018, 08:15 saeideng but you can start with cake 3
# Jul 24th 2018, 08:15 scottmkroberts I assumed that $this->redirect would take you to a page and change the url to the page you are on.