Log message #4184294

# At Username Text
# Apr 24th 2019, 08:37 asdfgh should i "normalize" it ?
# Apr 24th 2019, 08:37 asdfgh i can have 1-2019-01-01 or 12345678-2019-01-01 in this way the length vary
# Apr 24th 2019, 08:37 asdfgh the hash will be longer but all the hashes will have the same length
# Apr 24th 2019, 08:36 asdfgh i have to hash stupid things like ID-DATE somethin like 1235-2019-01-01 the question is, should i hash it or not? i mean does it matter to have a field with the same length in mysql ?
# Apr 24th 2019, 08:36 asdfgh hello
# Apr 24th 2019, 08:02 COOurb how can I use innerJoinWith with query?
# Apr 24th 2019, 07:54 COOurb I need to use Max() function, but it happens thatonly such objects can have it. So I think I can call function right from class
# Apr 24th 2019, 07:53 COOurb ?
# Apr 24th 2019, 07:53 COOurb what type of objectand
# Apr 24th 2019, 07:53 COOurb what find() returns?
# Apr 24th 2019, 07:46 remy Hello, Is there more information about CVE-2019-11458? We're trying to evaluate the impact on our users, but the release notes are a bit terse. > The vulnerability affects applications that open serialized content from user input. > SmtpTransport had the potential to create a harmful side-effect in its destructor should an untrusted value ever be deserialized. Anyone has an example on where/how this could be done?
# Apr 24th 2019, 07:40 COOurb because distinction doesn't recognize order
# Apr 24th 2019, 07:40 COOurb it doesn't work
# Apr 24th 2019, 07:40 COOurb nope
# Apr 24th 2019, 07:39 COOurb aha, thanx
# Apr 24th 2019, 07:21 conehead Sort by date and then apply an distinct for your value? https://book.cakephp.org/3.0/en/orm/query-builder.html#selecting-data
# Apr 24th 2019, 07:06 COOurb hwo to do it in query builder?
# Apr 24th 2019, 07:06 COOurb I need to select last (by date) entry from table for every velue of some field
# Apr 24th 2019, 07:03 ra7bi Yes i got it
# Apr 24th 2019, 07:03 conehead Oh and you wouldnt need the join table anymore
# Apr 24th 2019, 07:02 conehead Although it sounds like you could use hasMany as well. But then, the `photos` table would have to have the field `user_id`. Now as you configured it, photos may be "owned" by multiple users
# Apr 24th 2019, 07:00 ra7bi i had a problem with the type of relation , it must be `belongsToMany `
# Apr 24th 2019, 07:00 conehead Sweet. What did the trick? I am always here and ask questions myself. Looks like I was able to help someone else for the first time ;)
# Apr 24th 2019, 06:59 ra7bi Thanks a lot
# Apr 24th 2019, 06:57 ra7bi let me confirm that
# Apr 24th 2019, 06:57 ra7bi i guess it works now
# Apr 24th 2019, 06:57 ra7bi wow
# Apr 24th 2019, 06:56 ra7bi `UsersPhotos` hasMany `Photos ` Relation between UsersPhotos and Photos table
# Apr 24th 2019, 06:56 conehead You wouldnt need a join table for hasMany
# Apr 24th 2019, 06:55 conehead Hm shouldnt it be belongsToMany?
# Apr 24th 2019, 06:55 ra7bi and the relation type = hasmany
# Apr 24th 2019, 06:55 ra7bi user_id
# Apr 24th 2019, 06:54 conehead is the name of the fields `User_id` oder `user_id`? Should be all lower cased
# Apr 24th 2019, 06:53 ra7bi @conehead i changed the name as you mentioned but , data get stored in photos and users but nothing stored in photos_users
# Apr 24th 2019, 06:52 COOurb I have inner join and max(0 function
# Apr 24th 2019, 06:52 COOurb hi, I need to get last occurrence of entry based on it's field value, like "max(date)". I have sql expression but dunno how to convert into query buildeer "call chain"
# Apr 24th 2019, 06:43 conehead @ra7bi As far as I know...tables would need to be named: `users`, `photos_users`, `photos`. See: https://book.cakephp.org/3.0/en/intro/conventions.html#database-conventions So you would probably at least have to change the join_table when defining your association. See here: https://book.cakephp.org/3.0/en/orm/associations.html#belongstomany-associations
# Apr 24th 2019, 06:17 ra7bi Please help .and thanks
# Apr 24th 2019, 06:17 ra7bi ``` Users -------> UsersPhoto <-------- Photos ``` Like this
# Apr 24th 2019, 06:16 ra7bi do cake will understand this type of relation or i need to write the code myself
# Apr 24th 2019, 06:15 ra7bi Hello , i need a help , i've three tables ``` Users , UsersPhotos , Photos ``` i want to insert User data with photos and `UsersPhotos` FYI UsersPhotos have User_id , Photo_id coz it's many to many relation