Log message #4154989

# At Username Text
# 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 ?
# Jul 2nd 2018, 10:19 cielo2 hi all
# Jul 2nd 2018, 10:10 tunafish I'll discuss things with my team when we get to it. Thanks for the help!
# Jul 2nd 2018, 10:08 tunafish True, true
# Jul 2nd 2018, 10:08 josbeir best to make specific methods for the secure stuff and use those
# Jul 2nd 2018, 10:07 josbeir i get what you are trying to achieve @tunafish but if you are going to define that stuff in a too explicit way it will eventually work against you in the long run
# Jul 2nd 2018, 10:06 slackebot4 !
# Jul 2nd 2018, 10:06 slackebot4 Command sent from Slack by josbeir:
# Jul 2nd 2018, 10:06 tunafish Best. Method. Ever. :P
# Jul 2nd 2018, 10:06 josbeir saveMethod => 'safeSave' :P