Log message #4154998

# At Username Text
# 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
# Jul 2nd 2018, 10:43 unclezoot good morning - when initiating the Time helper, where is the correct place to configure the 'niceFormat' property?
# Jul 2nd 2018, 10:40 cielo2 ok, i read about ->toList(), but in my case, how i can aply this ?
# Jul 2nd 2018, 10:36 cielo2 how can i solve this ?
# Jul 2nd 2018, 10:35 cielo2 i migrate from php5.6 to php7.2 and a classical row goes on error: "$this->set('books', $this->paginate($query, ['limit' => 10]));"
# Jul 2nd 2018, 10:34 saeideng php 7.2
# Jul 2nd 2018, 10:33 saeideng first use `->toList()` before using `count()`
# Jul 2nd 2018, 10:27 lorenzo when doing what?
# Jul 2nd 2018, 10:20 cielo2 somebody has a solution for: cakephp3 Parameter must be an array or an object that implements Countable ?