| # |
Jul 2nd 2018, 13:44 |
 itmpls |
uh. what? |
| # |
Jul 2nd 2018, 13:43 |
johnwayne |
@lorenzo thank you, I have make another association in Model. |
| # |
Jul 2nd 2018, 13:43 |
joshualuckers |
4000, long as in 30+ minutes. All of them changed |
| # |
Jul 2nd 2018, 13:41 |
itmpls |
iirc, you don't have to specify everything/all associations if your'e not modifying some of them |
| # |
Jul 2nd 2018, 13:41 |
itmpls |
are all of them being changed? |
| # |
Jul 2nd 2018, 13:41 |
itmpls |
how many associations? |
| # |
Jul 2nd 2018, 13:41 |
itmpls |
define a 'long while' ? |
| # |
Jul 2nd 2018, 13:40 |
joshualuckers |
I'm having an entity with a lot of associations. When I save the entity it takes a long while because of ```if ($entity->getErrors()) { return false; }``` in ORM/Table.php. Is it possible to skip getErrors()? |
| # |
Jul 2nd 2018, 12:51 |
lorenzo |
if you want automatic fields selection, you can use `contain()` |
| # |
Jul 2nd 2018, 12:51 |
lorenzo |
that’s why |
| # |
Jul 2nd 2018, 12:50 |
lorenzo |
it will not select the fields for a join unless you tell it to |
| # |
Jul 2nd 2018, 12:48 |
johnwayne |
Items are related with addresses (inner join), but I need only in one case left join so I can make another relation in model with another alias (for left join) but I am wondering why this doesnt work or why RAW statement is correct and execution in cakephp is wrong |
| # |
Jul 2nd 2018, 12:47 |
johnwayne |
But it is interesting if I use ->select(columns) then it is working |
| # |
Jul 2nd 2018, 12:43 |
lorenzo |
if `Items` is associated to `Addresses` it is better if you just use `leftJoinWith` instead of a plain `join` |
| # |
Jul 2nd 2018, 12:42 |
lorenzo |
the result will be in `$item->get('Addresses')` |
| # |
Jul 2nd 2018, 12:37 |
johnwayne |
I have problem with left join query..... here is the query https://paste.ofcode.org/wPHtRrybdw5B6ERfTarW55 If I execute RAW SQL statement directly in DB (from cakephp query) I am getting left join (relevant addresses if there is address_id by items), but in cakephp as final result there is no data from Addresses (left join is always empty) |
| # |
Jul 2nd 2018, 12:30 |
josbeir |
nm '-v' does the trick |
| # |
Jul 2nd 2018, 12:30 |
josbeir |
is there an argument for phpunit to list skipped/incomplete tests? |
| # |
Jul 2nd 2018, 12:03 |
Martin` |
now I've imported 800 new stores, and page does not load anymore. not a surprise |
| # |
Jul 2nd 2018, 12:02 |
Martin` |
gets path of every store |
| # |
Jul 2nd 2018, 12:02 |
Martin` |
I've seen the old version of this page (in cakephp 1.3), but it loads the depth of every store during loading of the page :P |
| # |
Jul 2nd 2018, 12:01 |
Martin` |
hmm that is a good idea :) |
| # |
Jul 2nd 2018, 11:59 |
dereuromark |
similar to what countercache behavior does etc |
| # |
Jul 2nd 2018, 11:59 |
dereuromark |
usually when you save it as post work to be done |
| # |
Jul 2nd 2018, 11:56 |
Martin` |
I think I can manage that :P |
| # |
Jul 2nd 2018, 11:54 |
Martin` |
hmm ok, just have to do that during the rending of the view then I think? |
| # |
Jul 2nd 2018, 11:52 |
dereuromark |
you can cache the depth into the root elements |
| # |
Jul 2nd 2018, 11:48 |
Martin` |
I mixed dutch en english :P |
| # |
Jul 2nd 2018, 11:47 |
Martin` |
tree of all the supermarkets in the netherlands |
| # |
Jul 2nd 2018, 11:47 |
Martin` |
I've a database with a tree of alle supermarkkets in the netherlands. now I want to paginate this data but it is to much to load all in one. but I want to show it as a tree in view. I think the best way to get this is to order at lft. but how can I find out how deep an item is? |
| # |
Jul 2nd 2018, 11:38 |
birdy247 |
@dereuromark :slightly_smiling_face: |
| # |
Jul 2nd 2018, 11:37 |
dereuromark |
I got some shells to fix these things in Setup plugin |
| # |
Jul 2nd 2018, 11:37 |
edgaras.jan |
or even better utf8mb4 |
| # |
Jul 2nd 2018, 11:36 |
birdy247 |
now to change it.. |
| # |
Jul 2nd 2018, 11:35 |
josbeir |
all should be utf8 |
| # |
Jul 2nd 2018, 11:35 |
josbeir |
i'm pretty sure it is :P |
| # |
Jul 2nd 2018, 11:35 |
birdy247 |
latin1 |
| # |
Jul 2nd 2018, 11:35 |
birdy247 |
Think this is the issue |
| # |
Jul 2nd 2018, 11:35 |
birdy247 |
File uploaded https://cakesf.slack.com/files/U0T295QA3/FBHH8L9DK/image.png / https://slack-files.com/T053DPNCM-FBHH8L9DK-80b23ccff2 |
| # |
Jul 2nd 2018, 11:35 |
birdy247 |
SHOW VARIABLES LIKE 'char%'; |
| # |
Jul 2nd 2018, 11:35 |
birdy247 |
@josbeir |
