# |
Mar 4th 2018, 03:56 |
savant |
night meowls |
# |
Mar 4th 2018, 03:56 |
neothermic |
these hours are paid, even if they're obscure hours :P |
# |
Mar 4th 2018, 03:56 |
neothermic |
I should, but I'm a night owl, and I've got a feature to finish before monday |
# |
Mar 4th 2018, 03:55 |
savant |
at 4am, you should consider sleeping |
# |
Mar 4th 2018, 03:55 |
savant |
haha |
# |
Mar 4th 2018, 03:55 |
neothermic |
it's 4am, I think I have an excuse ;) |
# |
Mar 4th 2018, 03:54 |
neothermic |
me, trying to be smarter than the framework |
# |
Mar 4th 2018, 03:54 |
savant |
what was the issue? |
# |
Mar 4th 2018, 03:54 |
neothermic |
hah, solved it |
# |
Mar 4th 2018, 03:42 |
neothermic |
oh, wait, hmm |
# |
Mar 4th 2018, 03:41 |
savant |
the generated form element is fine |
# |
Mar 4th 2018, 03:41 |
savant |
;) |
# |
Mar 4th 2018, 03:41 |
savant |
okay then I cant really help |
# |
Mar 4th 2018, 03:41 |
neothermic |
not really, they're a bit complex. (yay for JS-generated form elements) :P |
# |
Mar 4th 2018, 03:40 |
savant |
can you show the form and the code that you are calling to save it? |
# |
Mar 4th 2018, 03:39 |
neothermic |
So, calling Consent->saveAssociated on this data: ```array('Consent' => array( 'id' => '8' ),'Topic' => array((int) 1 => '1',(int) 2 => '2'))``` Doesn't seem to write data to the consents_topics table, despite the two models having a HABTM relationship defined. Am I missing something? :| |
# |
Mar 4th 2018, 03:34 |
savant |
mrr mrr |
# |
Mar 4th 2018, 03:33 |
neothermic |
mrr, HABTM data.. mrr |
# |
Mar 4th 2018, 03:13 |
mikesmoniker |
Cheers! Good night. |
# |
Mar 4th 2018, 03:12 |
savant |
cool beans :slightly_smiling_face: |
# |
Mar 4th 2018, 03:12 |
mikesmoniker |
Calling toArray() instead of execute()->fetchAll() gets me what I want though. |
# |
Mar 4th 2018, 03:09 |
mikesmoniker |
Well actually I guess it’s not quite working.. the query results aren’t keyed by my select() keys, it’s just a numeric array. But it’s progress. |
# |
Mar 4th 2018, 03:08 |
mikesmoniker |
Thank you. |
# |
Mar 4th 2018, 03:08 |
savant |
thanks :slightly_smiling_face: |
# |
Mar 4th 2018, 03:07 |
mikesmoniker |
Sure. It might take me a bit to figure out a small reproducible example, but I’ll see what I can do. |
# |
Mar 4th 2018, 03:07 |
savant |
mind filing an issue so we can investigate? |
# |
Mar 4th 2018, 03:07 |
savant |
That sounds like maybe a bug |
# |
Mar 4th 2018, 03:06 |
mikesmoniker |
But `'learners' => $query->newExpr()->add('COUNT(*)')` works fine. |
# |
Mar 4th 2018, 03:06 |
mikesmoniker |
Yeah. |
# |
Mar 4th 2018, 03:05 |
savant |
still fails? |
# |
Mar 4th 2018, 03:05 |
mikesmoniker |
Well, Slack mangled that, but yeah. |
# |
Mar 4th 2018, 03:05 |
mikesmoniker |
Also, if I remove learners from select and the join/groupby it still fails, even though the resulting SQL is: `SELECT (COUNT(*)) AS `count` FROM targets Targets WHERE customer_id = 112;` |
# |
Mar 4th 2018, 03:05 |
savant |
i wonder whats so special about the count |
# |
Mar 4th 2018, 03:05 |
savant |
thats interesting |
# |
Mar 4th 2018, 03:04 |
mikesmoniker |
Yeah. |
# |
Mar 4th 2018, 03:00 |
savant |
does bucket work? |
# |
Mar 4th 2018, 03:00 |
savant |
what happens if you remove that? |
# |
Mar 4th 2018, 02:51 |
mikesmoniker |
It looks like `$this->_typeMap['learners']` exists but `$row['learners']` does not. $row is a numerically keyed array. |
# |
Mar 4th 2018, 02:45 |
savant |
@markstory any idea what might be going on above? |
# |
Mar 4th 2018, 02:45 |
mikesmoniker |
3.5.11 |
# |
Mar 4th 2018, 02:45 |
savant |
seems the `learners` column is not in the type map |