Log message #4155013

# At Username Text
# 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
# Jul 2nd 2018, 11:17 birdy247 but in the DB, there is no collation
# Jul 2nd 2018, 11:17 josbeir and his?
# Jul 2nd 2018, 11:16 birdy247 in my datasources, encding is utf8
# Jul 2nd 2018, 11:16 josbeir set it to utf8 and see if that solves the issue
# Jul 2nd 2018, 11:16 josbeir collation is mostly for sorts etc
# Jul 2nd 2018, 11:15 josbeir check the encoding of the field
# Jul 2nd 2018, 11:15 birdy247 but in dev, there is
# Jul 2nd 2018, 11:14 birdy247 I notice that on our prod db, there is no collation set
# Jul 2nd 2018, 11:14 josbeir encoding is also a possibility