| # |
Jul 10th 2019, 07:48 |
 lorenzo |
on mobile now |
| # |
Jul 10th 2019, 07:47 |
inoas |
jose_zap / lorenzo around by chance ;)? |
| # |
Jul 10th 2019, 07:47 |
inoas |
do I need to wrap the inneJoin in a subquery? |
| # |
Jul 10th 2019, 07:45 |
inoas |
should I use sub queries and use exists/notexists? |
| # |
Jul 10th 2019, 07:43 |
inoas |
LEFT JOIN seems to return records even if there is no match |
| # |
Jul 10th 2019, 07:43 |
inoas |
aka INNER JOIN or NULL |
| # |
Jul 10th 2019, 07:43 |
inoas |
however if there is no matching relation I want to still return the parent query result |
| # |
Jul 10th 2019, 07:43 |
inoas |
so I got some innerJoin/matchings going - thus if I put a field=value condition only records with that condition would return |
| # |
Jul 10th 2019, 07:42 |
inoas |
hello |
| # |
Jul 10th 2019, 07:24 |
felix.robaglia |
Actually it works as the input gets autocomplete=off, but it completes it anyways |
| # |
Jul 10th 2019, 07:21 |
felix.robaglia |
I tried 'autocomplete' => 'off' but it doesn't seem to work |
| # |
Jul 10th 2019, 07:21 |
felix.robaglia |
Hello ! Is there an easy way to set autocomplete to off with form control ? this is my line of code : $this->Form->control('password', ['label' => 'password']); |
| # |
Jul 9th 2019, 18:51 |
brian493 |
shame I had to rewrite my code in PDO to find that out haha |
| # |
Jul 9th 2019, 18:51 |
brian493 |
ended up just removing my auto-increment id (really don't need it for what I'm doing to this data) and now cake transactions work |
| # |
Jul 9th 2019, 18:50 |
brian493 |
you'd think making a non-transaction capable call would throw a fatal error, not silently exit the transaction and continue running queries |
| # |
Jul 9th 2019, 18:49 |
brian493 |
dang |
| # |
Jul 9th 2019, 18:49 |
brian493 |
figured it out, I was resetting auto increment which basically breaks transactions in mysql |
| # |
Jul 9th 2019, 18:43 |
devito |
is it possable to set up a mysql tunnel in 3.x? |
| # |
Jul 9th 2019, 18:43 |
half2me |
bit the weird part is it doesnt fail when the atomicity is false |
| # |
Jul 9th 2019, 18:34 |
genellern |
Yeah, I also had the same issue when it had to rollback a transaction, I'll try it again on Friday and let you know what I find |
| # |
Jul 9th 2019, 18:17 |
gunner1095 |
I doubt it would take more than a couple of hours to diagnose. Anyway, good luck! Sorry I couldn't help. |
| # |
Jul 9th 2019, 18:15 |
brian493 |
it'll take me longer to diagnose cake than it will to rewrite my code with PDO :P I was just hoping there was something obvious someone here might point out |
| # |
Jul 9th 2019, 18:14 |
gunner1095 |
If you have debug kit installed you can view the sql logs there. If not, you could enable query logging and then examine the log files to see if there are any clues. |
| # |
Jul 9th 2019, 18:13 |
brian493 |
I'm just using PDO directly |
| # |
Jul 9th 2019, 18:13 |
brian493 |
I have transactions working on other (non-cake) apps on this machine |
| # |
Jul 9th 2019, 18:12 |
brian493 |
idk |
| # |
Jul 9th 2019, 18:12 |
gunner1095 |
And there are no hints to what the problem is in the query log, or debug log? |
| # |
Jul 9th 2019, 18:11 |
brian493 |
it's problematic because I'm generating about a million rows and it takes a while and I don't want my users to see incomplete data while the script runs |
| # |
Jul 9th 2019, 18:10 |
brian493 |
but it don't work, just runs all my queries as if there was no transaction |
| # |
Jul 9th 2019, 18:10 |
brian493 |
$conn = $this->Model->getDataSource(); |
| # |
Jul 9th 2019, 18:10 |
brian493 |
according to the docs cake2 is the exact same except the first line is different |
| # |
Jul 9th 2019, 18:10 |
gunner1095 |
That's it. |
| # |
Jul 9th 2019, 18:10 |
gunner1095 |
$conn->commit(); |
| # |
Jul 9th 2019, 18:10 |
gunner1095 |
sql stuff |
| # |
Jul 9th 2019, 18:09 |
gunner1095 |
$conn->begin(); |
| # |
Jul 9th 2019, 18:09 |
gunner1095 |
$conn = ConnectionManager::get('default'); |
| # |
Jul 9th 2019, 18:09 |
gunner1095 |
In cake 3 I just do... |
| # |
Jul 9th 2019, 18:07 |
brian493 |
I'll just rewrite my code with PDO it's not a huge deal |
| # |
Jul 9th 2019, 18:07 |
brian493 |
idk what I'm doing wrong I'm following the directions verbatim but they just act as if I'm not in a transaction |
| # |
Jul 9th 2019, 18:06 |
gunner1095 |
Transactions are pretty straight forward in cake 3, not sure about 2. |
| # |
Jul 9th 2019, 18:05 |
brian493 |
ok, failing that anybody know on hand how to just access the PDO object directly so I can write my own code? |