| # |
Jul 12th 2017, 07:17 |
 johnwayne |
And this is in Query in Cakephp -> https://paste.ofcode.org/8zZBZFSri5dQZLrkXvpF3Y |
| # |
Jul 12th 2017, 07:16 |
johnwayne |
https://paste.ofcode.org/xFGkLJgYHVYLESBbxPTVY6 |
| # |
Jul 12th 2017, 07:16 |
johnwayne |
here is the query |
| # |
Jul 12th 2017, 07:16 |
johnwayne |
i need to write SQL statement in CakePhp but how can I write GROUP BY IF NULL (condition) in cakephp |
| # |
Jul 12th 2017, 07:15 |
johnwayne |
I need query expert here :) |
| # |
Jul 12th 2017, 07:04 |
johnwayne |
Morning |
| # |
Jul 11th 2017, 23:31 |
akkaweb |
@ericadeefox I created the plugin. Are you experiencing issues? |
| # |
Jul 11th 2017, 20:52 |
sturm |
I had to change `pdo_mysql.default_socket` from `/tmp/mysql.sock` to `/Applications/MAMP/tmp/mysql/mysql.sock` so PHP could be “plugged-in” to MySQL. |
| # |
Jul 11th 2017, 20:51 |
sturm |
Yep, that was it. |
| # |
Jul 11th 2017, 20:41 |
akkaweb |
when dealing with CakePHP routes, it seems if two match (ie. one in the application route and one in a plugin), the plugin route takes precedence. Is that the case always? Is it possible to change that so when using Router::url the url generated is actually the one in the application route? |
| # |
Jul 11th 2017, 20:36 |
sturm |
Could the fact that `pdo_mysql.default_socket` in phpinfo() is referencing `/tmp/mysql.sock` be part of the problem? |
| # |
Jul 11th 2017, 20:16 |
sturm |
I’m certain the username and password are correct, as well as the db name. The only other line I had to add was `'port' => 8889,` since I’m running MySQL via MAMP. (Although I’m not using MAMP’s version of PHP.) |
| # |
Jul 11th 2017, 20:15 |
sturm |
Database Configuration |
| # |
Jul 11th 2017, 20:14 |
ericadeefox |
^^where are you at in the Bookmarker tutorial? |
| # |
Jul 11th 2017, 20:13 |
sturm |
My only guess is that PHP doesn’t ‘see’ MySQL or something. |
| # |
Jul 11th 2017, 20:12 |
sturm |
``` CakePHP is NOT able to connect to the database. Connection to database could not be established: SQLSTATE[HY000] [2002] No such file or directory ``` |
| # |
Jul 11th 2017, 20:11 |
sturm |
Well, I didn’t expect to hit a roadblock *this* early in the bookmarker tutorial. |
| # |
Jul 11th 2017, 19:10 |
manuweg |
Thanks for your time! |
| # |
Jul 11th 2017, 19:10 |
manuweg |
just needed to set the path[] config |
| # |
Jul 11th 2017, 19:09 |
manuweg |
OK it got it working thanks |
| # |
Jul 11th 2017, 19:05 |
admad |
https://github.com/markstory/asset_compress/blob/master/config/asset_compress.sample.ini#L37 |
| # |
Jul 11th 2017, 19:05 |
lilhermit |
Is there anyway in :cakephp: 3.x to natively query json fields? |
| # |
Jul 11th 2017, 19:04 |
manuweg |
ok |
| # |
Jul 11th 2017, 19:04 |
admad |
refer to the sample ini |
| # |
Jul 11th 2017, 19:04 |
admad |
paths[] like files[] |
| # |
Jul 11th 2017, 19:04 |
admad |
*no |
| # |
Jul 11th 2017, 19:04 |
admad |
not |
| # |
Jul 11th 2017, 19:04 |
manuweg |
do you mean like [js] |
| # |
Jul 11th 2017, 19:03 |
manuweg |
I don't have any values set in [paths] |
| # |
Jul 11th 2017, 19:03 |
admad |
no, relative to values you set in paths[] |
| # |
Jul 11th 2017, 19:02 |
manuweg |
like ../../theme/etc |
| # |
Jul 11th 2017, 19:02 |
manuweg |
relative to jquery-combined? |
| # |
Jul 11th 2017, 19:02 |
manuweg |
it works for building the file with the shell |
| # |
Jul 11th 2017, 19:01 |
admad |
check the same ini file again |
| # |
Jul 11th 2017, 19:01 |
admad |
you need specify paths[] and then use relative paths in files[] |
| # |
Jul 11th 2017, 19:01 |
manuweg |
ok |
| # |
Jul 11th 2017, 19:01 |
admad |
i don't think you can use WEBROOT in files[] that way |
| # |
Jul 11th 2017, 19:00 |
manuweg |
I am open to suggestions if there is a better way to compress my assets |
| # |
Jul 11th 2017, 18:59 |
manuweg |
despite the fact that the compiled file already exists |
| # |
Jul 11th 2017, 18:59 |
manuweg |
Seems to be looking for the files listed in the config file for some reason |
| # |
Jul 11th 2017, 18:57 |
manuweg |
https://gist.github.com/manuweg/2e047ee7bef6d17bfd4ad4a5d1525efb |