| # |
Dec 21st 2017, 12:59 |
 jkpatel291289 |
$this->paginate['contain'] = ['States']; |
| # |
Dec 21st 2017, 12:58 |
jkpatel291289 |
$this->paginate['fields'] = [ 'Customers.id', 'Customers.name', 'States.name', 'Customers.contact_number', ]; |
| # |
Dec 21st 2017, 12:46 |
obinoob |
johan me too but it might be on this specific version not sure lol |
| # |
Dec 21st 2017, 12:45 |
obinoob |
neon1024 definitely mysql version ;) |
| # |
Dec 21st 2017, 12:45 |
johan |
I guess the simple answer is: don't do it. |
| # |
Dec 21st 2017, 12:45 |
johan |
I can remember "ON UPDATE CURRENT_TIMESTAMP" being on multiple columns in the same table being a problem as far back as MySQL 5.5, maybe even before that. |
| # |
Dec 21st 2017, 12:44 |
neon1024 |
Perhaps a different version of MySQL. I know that 5.7 made some updates to GROUP BY to make it more strict and inline with “proper databases”, so perhaps there are other changes |
| # |
Dec 21st 2017, 12:40 |
obinoob |
yes I agree however I'm pretty sure I've done exactly the same before in many tables... |
| # |
Dec 21st 2017, 12:39 |
neon1024 |
Sounds pretty explanatory |
| # |
Dec 21st 2017, 12:38 |
obinoob |
neon1024 I've removed the timestamp(0) param but mysql still complain for ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause |
| # |
Dec 21st 2017, 12:38 |
neon1024 |
Oh right |
| # |
Dec 21st 2017, 12:37 |
obinoob |
neon1024 not exactly a problem, I'm just trying to establish mysql default behaviour in fact it's not a problem for cakephp I guess :) anyway I think it's more related with mysql version... |
| # |
Dec 21st 2017, 12:24 |
neon1024 |
obinoob, You’ve added one? What’s wrong with the Timestamp behaviour? Or, I should say, how does your use-case differ? Perhaps there is an enhancement possible with the Timestamp behaviour |
| # |
Dec 21st 2017, 12:24 |
johan |
Sup David :slightly_smiling_face: |
| # |
Dec 21st 2017, 12:23 |
neon1024 |
Heya @johan |
| # |
Dec 21st 2017, 12:20 |
obinoob |
johan yes I agree I've added a behaviour for created and updated actions |
| # |
Dec 21st 2017, 12:20 |
johan |
In fact, you probably don't even need it for `created`. |
| # |
Dec 21st 2017, 12:19 |
johan |
In that case I'd remove the `ON UPDATE CURRENT_TIMESTAMP` part from the `updated`'s declaration. The Cake behaviour should be taking care of that for you anyway :slightly_smiling_face: |
| # |
Dec 21st 2017, 12:18 |
obinoob |
johan yes and I get this ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause |
| # |
Dec 21st 2017, 12:17 |
obinoob |
not entirely sure but I think it's due to the timestamp syntax right? |
| # |
Dec 21st 2017, 12:17 |
johan |
Have you tried just using TIMESTAMP instead of TIMESTAMP(0) ? |
| # |
Dec 21st 2017, 12:16 |
obinoob |
this is the sql https://gist.github.com/obinoob/efd29cc4dc15a0c4aa553e4b8a3eafa6 |
| # |
Dec 21st 2017, 12:16 |
obinoob |
hi, I'm getting the following error while alter database. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(0) NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `active`, ADD COLUMN `updated` TIME' at line 2 |
| # |
Dec 21st 2017, 11:22 |
neon1024 |
I must remember that processing a remote sites HTML using PHP domDocument is a real pain in the ass :( |
| # |
Dec 21st 2017, 10:58 |
neon1024 |
:thumbsup: |
| # |
Dec 21st 2017, 10:58 |
jotpe |
works perfect, thanks @neon1024 |
| # |
Dec 21st 2017, 10:57 |
neon1024 |
Or you can just add the symlink command to your composer post install scripts |
| # |
Dec 21st 2017, 10:57 |
neon1024 |
Plus if you use a relative path you can then commit the symlinks to Git as well if you want to |
| # |
Dec 21st 2017, 10:56 |
neon1024 |
Or at least, it used to ;) |
| # |
Dec 21st 2017, 10:56 |
neon1024 |
It prevents CakePHP doing an extra request to process the plugin prefix |
| # |
Dec 21st 2017, 10:55 |
neon1024 |
`$ bin/cake plugin assets symlink` |
| # |
Dec 21st 2017, 10:55 |
jotpe |
ok |
| # |
Dec 21st 2017, 10:55 |
neon1024 |
Symlink the resources into your webroot folder instead |
| # |
Dec 21st 2017, 10:55 |
neon1024 |
Don’t do it |
| # |
Dec 21st 2017, 10:53 |
jotpe |
any ideas? |
| # |
Dec 21st 2017, 10:51 |
jotpe |
i did <?= $this->Html->css('FoundationUI.foundation.css') ?> in the layout, since i want to include it in any view. unfortunately i get a 404 for the css, and the href is /foundation_u_i/css/foundation.css |
| # |
Dec 21st 2017, 10:50 |
jotpe |
hey guys. I have a plugin called FoundationUI with a default layout and want to include css from the plugins webroot/css |
| # |
Dec 21st 2017, 10:34 |
makallio85 |
lul, sounds like burden in programming perspective :) Dont tell her |
| # |
Dec 21st 2017, 10:28 |
ludovic.barman |
@neon1024 Awesome thanks a lot! |
| # |
Dec 21st 2017, 10:21 |
dereuromark |
I dont think cells need much anyway, looking at the code |
| # |
Dec 21st 2017, 10:21 |
dereuromark |
We understand |