# |
Feb 21st 2020, 15:47 |
kailas |
oh, i see |
# |
Feb 21st 2020, 15:46 |
neon1024 |
@kailas hasMany are done as a separate query and merged in PHP |
# |
Feb 21st 2020, 15:35 |
kailas |
I’m getting a record with a->get($id,[‘contain’=>[‘c’,‘d’,‘e’]); when i look at the sql, i’m not seeing the joins for d and e. if i do a->get($id,[‘contain’=>[‘c’d’,‘e’]); i see no joins at all. feels like something is wrong with my association for d. the association for D is a simple hasMany (a hasMany D). any ideas what to do? |
# |
Feb 21st 2020, 14:31 |
dereuromark |
linux |
# |
Feb 21st 2020, 14:29 |
kaliel |
@dereuromark Are you using vagrant because your os is windows ? |
# |
Feb 21st 2020, 14:25 |
dereuromark |
hehe |
# |
Feb 21st 2020, 14:21 |
admad |
Well it says "No error" so just ignore it :P |
# |
Feb 21st 2020, 14:06 |
javier.villanueva |
uhm... not my case then, but thanks |
# |
Feb 21st 2020, 14:05 |
dereuromark |
in my case it was the local vagrant time wrong, had to restart vagrant |
# |
Feb 21st 2020, 14:04 |
javier.villanueva |
:( only from my local too, to smartsheet api |
# |
Feb 21st 2020, 14:03 |
dereuromark |
I just did :) 5 min ago, well very similar from my local vagrant to googlemaps api |
# |
Feb 21st 2020, 14:02 |
javier.villanueva |
cURL Error (56) OpenSSL SSL_read: No error |
# |
Feb 21st 2020, 14:02 |
javier.villanueva |
Anyone have this error? (in curl post to https) |
# |
Feb 21st 2020, 13:53 |
javier.villanueva |
```function ($row) { return (int)$row['acc_num']; }, ]``` |
# |
Feb 21st 2020, 13:53 |
javier.villanueva |
or |
# |
Feb 21st 2020, 13:52 |
javier.villanueva |
```function ($row) { return intval($row['acc_num']); }, ]``` |
# |
Feb 21st 2020, 12:13 |
matt |
```$this->viewBuilder()->setClassName('CsvView.Csv'); $this->set(compact('deposits', '_serialize', '_header', '_extract', '_enclosure'));``` |
# |
Feb 21st 2020, 12:12 |
matt |
```$_extract = [ // sort code function ($row) { return DepositsUtil::forceEnclosure($row['race']['event']['organiser']['sort_code'], Deposit::EXPORT_ENCLOSURE); },``` |
# |
Feb 21st 2020, 12:11 |
matt |
Hi im using FriendsOfCake/cakephp-csvview but when i export the data it converts the collumns having leading 0s to just the numbers ie 000123 => 123, how can i fix this? |
# |
Feb 21st 2020, 12:10 |
spriz |
imagine if it's a db.t2.medium |
# |
Feb 21st 2020, 12:10 |
spriz |
that's simply a waste of time :) |
# |
Feb 21st 2020, 12:10 |
spriz |
welp, I'd tell clients there's nothing you can do without knowing exactly what hardware that is running |
# |
Feb 21st 2020, 12:09 |
challgren |
Im still waiting for access, so I can only guess |
# |
Feb 21st 2020, 12:09 |
spriz |
at least it's easy to upgrade :) |
# |
Feb 21st 2020, 12:09 |
spriz |
:,) |
# |
Feb 21st 2020, 12:09 |
challgren |
Yeah its AWS so Im guessing they went cheap with the instance |
# |
Feb 21st 2020, 12:09 |
spriz |
then I'd look into configuration of the db :v: |
# |
Feb 21st 2020, 12:08 |
challgren |
But yeah, kind of took over the project so gotta optomize it |
# |
Feb 21st 2020, 12:08 |
spriz |
or you need to tweak the configuraion of the db/table :) |
# |
Feb 21st 2020, 12:08 |
challgren |
Only 1 index |
# |
Feb 21st 2020, 12:07 |
spriz |
I'd guess you have too many indexes if the writes are too heavy |
# |
Feb 21st 2020, 12:07 |
spriz |
if that takes long time it's more of a db issue than cake issue |
# |
Feb 21st 2020, 12:07 |
challgren |
Its more of getting the data into the db |
# |
Feb 21st 2020, 12:06 |
spriz |
knowledge about DB engine starts to mean something tho :) |
# |
Feb 21st 2020, 12:06 |
spriz |
@challgren you can easily urn 100+ m tables with a cake project :thinking_face: |
# |
Feb 21st 2020, 11:21 |
challgren |
Geeze 101 million records in this database now. I think this project out grew cake |
# |
Feb 21st 2020, 11:03 |
admad |
that shell is only meant for php files, not twig |
# |
Feb 21st 2020, 11:01 |
naino |
Hi! Anyone here using Twig template with cakephp i18n extract shell? It doesn't seem to extract strings from my .twig files. |
# |
Feb 21st 2020, 10:56 |
slackebot |
work too. The warning is ```Failed to initialize storage module``` ---- Environment information PHP 7.3 Apache 2.4 (x64) Cake 2.10.x Thanks in advance |
# |
Feb 21st 2020, 10:56 |
le.mao |
I have a warning when update Cake PHP 2.2.5 to Cake PHP 2.10.x as the following ```Warning (2): session_set_save_handler() [<a href='http://php.net/function.session-set-save-handler'>function.session-set-save-handler</a>]: Cannot change save handler when headers already sent [CORE/Cake/Model/Datasource/CakeSession.php, line 599]``` Could you please tell me detail about this error --- In addition, when i use the `session_start()` , it was not |
# |
Feb 21st 2020, 10:44 |
neon1024 |
I remember stuff just randomly exploding |