| # |
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 |
| # |
Jul 2nd 2018, 11:14 |
birdy247 |
its just a varchar |
| # |
Jul 2nd 2018, 11:14 |
josbeir |
probably when setting a field with data thats not compatible with the field type |
| # |
Jul 2nd 2018, 11:13 |
birdy247 |
The collation |
| # |
Jul 2nd 2018, 11:13 |
birdy247 |
Is this to do with encoding? |
| # |
Jul 2nd 2018, 11:13 |
birdy247 |
The guy is using a Mac |
| # |
Jul 2nd 2018, 11:12 |
birdy247 |
Incorrect string value: '\xE2\x80\xAD077. |
| # |
Jul 2nd 2018, 11:12 |
birdy247 |
Getting an odd SQL error on prod, but I cant replicate it |
