| # |
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 |
| # |
Jul 2nd 2018, 11:31 |
cielo2 |
https://stackoverflow.com/questions/51134646/cakephp3-php72-paginator-parameter-must-be-an-array-or-an-object-that-impleme |
| # |
Jul 2nd 2018, 11:31 |
cielo2 |
i posted my problem, maybe so we found a solution |
| # |
Jul 2nd 2018, 11:25 |
birdy247 |
ok, so was this an issue when i did the CREATE database my_name; |
| # |
Jul 2nd 2018, 11:20 |
josbeir |
then there is your issue |
| # |
Jul 2nd 2018, 11:20 |
birdy247 |
there is no collation set on the field |
| # |
Jul 2nd 2018, 11:20 |
birdy247 |
I think its an issue with the prod DB |
| # |
Jul 2nd 2018, 11:19 |
josbeir |
also, check in the cake datasource configuration if encoding is set to utf8 |
| # |
Jul 2nd 2018, 11:18 |
josbeir |
you sure the entire table and fields are utf8 on the server where the user is trying do do stuff? |
| # |
Jul 2nd 2018, 11:18 |
josbeir |
i'm pretty sure its an encoding issue |
| # |
Jul 2nd 2018, 11:17 |
birdy247 |
he is a user of our site |
| # |
Jul 2nd 2018, 11:17 |
birdy247 |
"he" is simply submitting a form |
