| # |
Jun 25th 2018, 01:05 |
 hippo |
@mikesmoniker thanks, looks like it might work, will let you kno! |
| # |
Jun 25th 2018, 00:55 |
mikesmoniker |
Something like that sounds close. |
| # |
Jun 25th 2018, 00:54 |
mikesmoniker |
Wouldn’t something like `'approx_price_paid' => $query->newExpr()->add('approximate count(pricepaid)')` in your ORM query `select()` work? |
| # |
Jun 25th 2018, 00:40 |
hippo |
looking at how `DISTINCT` is done makes me think there is no easy way |
| # |
Jun 25th 2018, 00:28 |
hippo |
Anyone know how to easily add the approximate here to a query (using the query builder, I don't want to do custom SQL): `select approximate count(pricepaid) from sales;` |
| # |
Jun 24th 2018, 17:21 |
saeideng |
https://book.cakephp.org/3.0/en/orm/query-builder.html |
| # |
Jun 24th 2018, 17:21 |
saeideng |
$query = $articles->find(); $query->select(['count' => $query->func()->count('*')]); |
| # |
Jun 24th 2018, 17:15 |
D-rex |
I have a table thats setup with user_id,tweet_id column. im grouping them based on the tweet_id. $this->LikedTweets->find()->group(['LikedTweets.tweet_id']); How can I count the grouped results for a like counter? |
| # |
Jun 24th 2018, 17:11 |
mub |
ok,thank you @slackbot4 |
| # |
Jun 24th 2018, 17:06 |
saeideng |
also if you didn't see this result in console , use `composer install` for complete install |
| # |
Jun 24th 2018, 17:05 |
saeideng |
and it make `tmp` `log` writeable for you |
| # |
Jun 24th 2018, 17:04 |
saeideng |
when you trying to install with composer |
| # |
Jun 24th 2018, 17:04 |
saeideng |
cake have a shell to change this value |
| # |
Jun 24th 2018, 17:02 |
mub |
refering cakephp 3.x documentation |
| # |
Jun 24th 2018, 17:02 |
mub |
i installed using composer @slackbot4 |
| # |
Jun 24th 2018, 17:01 |
saeideng |
notice is clear |
| # |
Jun 24th 2018, 17:01 |
saeideng |
`composer create-project --prefer-dist cakephp/app my_app_name` |
| # |
Jun 24th 2018, 17:00 |
saeideng |
install with composer |
| # |
Jun 24th 2018, 17:00 |
mub |
but, now showing notice "Notice (1024): Please change the value of 'Security.salt' in ROOT/config/app.php to a salt value specific to your application. [CORE/src/Error/Debugger.php, line 963]" |
| # |
Jun 24th 2018, 16:59 |
saeideng |
worked ? |
| # |
Jun 24th 2018, 16:59 |
mub |
thank you, @hmic |
| # |
Jun 24th 2018, 16:59 |
saeideng |
for test |
| # |
Jun 24th 2018, 16:57 |
saeideng |
see user of `/opt/lampp/htdocs` |
| # |
Jun 24th 2018, 16:55 |
hmic |
s/chmopd/chmod/ |
| # |
Jun 24th 2018, 16:55 |
hmic |
chmod 777 tmp/ -R; chmopd 777 logs/ -R |
| # |
Jun 24th 2018, 16:54 |
mub |
how can i resolve this issue? |
| # |
Jun 24th 2018, 16:46 |
saeideng |
I guess your user for php/apache and dir is not same |
| # |
Jun 24th 2018, 16:42 |
hmic |
and logs dir too, like the other error on that page suggests |
| # |
Jun 24th 2018, 16:42 |
hmic |
make sure your tmp is writeable |
| # |
Jun 24th 2018, 16:41 |
hmic |
debugkit cant create the sqlite file |
| # |
Jun 24th 2018, 16:41 |
mub |
Added screenshot @savant |
| # |
Jun 24th 2018, 16:41 |
mub |
https://www.filepicker.io/api/file/2VMv7UGcQFSc2WOmFn6C?signature=713702853ede64124eb1286fb48ef8369336f1fc38d6250aec1cd681329b6dbeandpolicy=eyJleHBpcnkiOjE1Mjk4NjA4MjB9 |
| # |
Jun 24th 2018, 16:37 |
mub |
ok |
| # |
Jun 24th 2018, 16:36 |
savant |
mub: can you screenshot the error for us? |
| # |
Jun 24th 2018, 16:36 |
hmic |
for debugkit which uses sqlite to work, make sure tmp is writable too |
| # |
Jun 24th 2018, 16:36 |
hmic |
to me root/root and my_db does not sound quite right |
| # |
Jun 24th 2018, 16:35 |
hmic |
is your database connection setup correctly? edit the configuration or set the DATABASE_URL env var accordingly! |
| # |
Jun 24th 2018, 16:35 |
mub |
i am not sure, which one is using... sorry |
| # |
Jun 24th 2018, 16:35 |
mub |
oh... no i am trying to install cakphp 3 first time... |
| # |
Jun 24th 2018, 16:33 |
hmic |
are you using debugkit? or set the environment variable DATABASE_URL? |
| # |
Jun 24th 2018, 16:32 |
mub |
this is my db connection |