Log message #4116875

# At Username Text
# Feb 13th 2018, 15:21 meder but i wonder if i can use an internal thing
# Feb 13th 2018, 15:21 meder well it's aws to aws
# Feb 13th 2018, 15:21 meder wonder if it's something with that db setup
# Feb 13th 2018, 15:21 hmic make sure your dns is setup correctly, so the hostname of the db can be resolved fast
# Feb 13th 2018, 15:21 meder hm. really weird
# Feb 13th 2018, 15:20 hmic meder, i dont think so. i'm and many others using differnet datasources, some even switch between them dynamically
# Feb 13th 2018, 15:20 hmic you can achive that like: $year = array_combine(range(2001, 2018), range(2001, 2018))
# Feb 13th 2018, 15:20 meder i specified a different db host for a specific table - it takes 10 seconds to write to. could this be a cake bug with concurrent dbs or has anyone ran into smoething similar?
# Feb 13th 2018, 15:18 saeideng https://github.com/FriendsOfCake/bootstrap-ui
# Feb 13th 2018, 15:18 hmic second: thats it! $year needs to look like: ['2017' => '2017', '2018' => '2018', ...]
# Feb 13th 2018, 15:18 clementcrownrise @hmic , how ?
# Feb 13th 2018, 15:17 hmic clementcrownrise, first of: use bootstrap-ui plugin if using bootstrap!
# Feb 13th 2018, 15:17 clementcrownrise 'options'=> $year)); ?></div>
# Feb 13th 2018, 15:17 clementcrownrise like this <div class="col-md-4 mb-3"> <?php echo $this->Form->control('yearofexaminationpassed', array('type'=>'select','label'=>'Year of Examination Passed',
# Feb 13th 2018, 15:16 clementcrownrise hi, how can I achieve a select box that has years as drop down in cakephp ?
# Feb 13th 2018, 15:16 saeideng search and find a query to apply to current connection
# Feb 13th 2018, 15:15 saeideng maybe related to `GLOBAL ... `
# Feb 13th 2018, 15:10 neon1024 We’ll see what happens to the ticket I suppose!
# Feb 13th 2018, 15:10 hmic probably they dont either
# Feb 13th 2018, 15:09 neon1024 I’ve no idea how to configure MySQL user permissions or MySQL modes in Ansible ;)
# Feb 13th 2018, 15:06 hmic dep(p)op should be a great meme in germany *FG*
# Feb 13th 2018, 15:05 neon1024 And our depops guy is on holiday
# Feb 13th 2018, 15:05 neon1024 Not without permission though :(
# Feb 13th 2018, 15:03 saeideng or like the https://github.com/cakephp/cakephp/blob/master/src/Database/Driver/Mysql.php#L77-L81
# Feb 13th 2018, 15:03 saeideng https://github.com/cakephp/cakephp/blob/master/src/Database/Driver/Mysql.php#L106-L110
# Feb 13th 2018, 15:02 saeideng that run before queries
# Feb 13th 2018, 15:02 saeideng neon1024 yes you can add your query into `'init'`
# Feb 13th 2018, 14:51 loginews thanks neon
# Feb 13th 2018, 14:51 loginews ok. I may have switched to another layout in that particular ctp file's main controller. Will check.
# Feb 13th 2018, 14:50 hmic it works the same in all files - you will see on the link neon1024 provided...
# Feb 13th 2018, 14:50 loginews well, I didn't know because in the first files I put it, it worked.... I will read your link.
# Feb 13th 2018, 14:50 neon1024 Here, https://github.com/cakephp/app/blob/master/src/Template/Layout/default.ctp#L24
# Feb 13th 2018, 14:49 loginews it's the tab name at the top of the browser.
# Feb 13th 2018, 14:49 neon1024 That’s the default string appending in the layout
# Feb 13th 2018, 14:49 loginews I have used $this->assign('title','mytitle') near the top of several ctp files. It works. But in one index.ctp file, mytitle is appended to Cakephp: the rapid development framework... What could have gone wrong ?
# Feb 13th 2018, 14:45 neon1024 Feels more like a sidestep than a fix
# Feb 13th 2018, 14:45 neon1024 So far I’ve just updated my init `'init' => ['SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,"ONLY_FULL_GROUP_BY",""))'],`
# Feb 13th 2018, 14:44 neon1024 Just not sure if I should disable the mode, or really try and fix my query
# Feb 13th 2018, 14:44 neon1024 The one I remember was like this, https://github.com/cakephp/app/blob/master/config/app.default.php#L258
# Feb 13th 2018, 14:44 neon1024 I’d read that issue, but didn’t see a solution
# Feb 13th 2018, 14:44 neon1024 Oh, thanks @saeideng