Log message #4212874

# At Username Text
# Nov 8th 2019, 11:01 dev.cyrusjayson @frank noted on that. thanks
# Nov 8th 2019, 10:59 frank @dev.cyrusjayson You can remove the foreignKey from the association definition. As you’re following the conventions Cake will know to use user_id for Users.
# Nov 8th 2019, 10:52 dev.cyrusjayson sorry. it all works. thanks mate. that fucking cache save the day
# Nov 8th 2019, 10:45 graziel what do you mean not working? you get error or something?
# Nov 8th 2019, 10:38 dev.cyrusjayson This works! thank you. ``` $this->paginate = [ 'contain' => ['Customers', 'Statuses', 'Users'] ]; $orders = $this->paginate($this->Orders); $this->set(compact('orders')); ``` but my association not working. see below ``` $this->belongsTo('Users', [ 'foreignKey' => 'user_id' ]); ```
# Nov 8th 2019, 10:34 dereuromark Going to release TinyAuth next generation auth plugin if someone wants to give early feedback before I release the major? Ideally the ones already using it and checking BC etc.
# Nov 8th 2019, 10:31 dev.cyrusjayson ok
# Nov 8th 2019, 10:31 graziel bin/cake orm_cache clear
# Nov 8th 2019, 10:31 dev.cyrusjayson how?
# Nov 8th 2019, 10:31 graziel try clearing orm cache
# Nov 8th 2019, 10:31 dev.cyrusjayson do I need to compile something?
# Nov 8th 2019, 10:30 dev.cyrusjayson what is going on. kinda frustrating
# Nov 8th 2019, 10:30 dev.cyrusjayson even here I can’t see the user_id ``` $this->paginate = [ 'contain' => ['Customers', 'Statuses', 'Users'] ]; $orders = $this->paginate($this->Orders); $this->set(compact('orders')); ```
# Nov 8th 2019, 10:29 dev.cyrusjayson it is not a field. it is association in users model
# Nov 8th 2019, 10:28 slackebot1 'foreignKey' => 'user_id' ]); $this->hasMany('Suborders', [ 'foreignKey' => 'order_id' ]); } ```
# Nov 8th 2019, 10:28 dev.cyrusjayson ``` public function initialize(array $config) { parent::initialize($config); $this->setTable('orders'); $this->setDisplayField('id'); $this->setPrimaryKey('id'); $this->belongsTo('Customers', [ 'foreignKey' => 'customer_id' ]); $this->belongsTo('Statuses', [ 'foreignKey' => 'status_id' ]); $this->belongsTo('Users', [
# Nov 8th 2019, 10:28 dev.cyrusjayson ```
# Nov 8th 2019, 10:28 slackebot1 $validator; } ```
# Nov 8th 2019, 10:28 dev.cyrusjayson ``` public function validationDefault(Validator $validator) { $validator ->integer('id') ->allowEmptyString('id', null, 'create'); $validator ->scalar('name') ->maxLength('name', 255) ->allowEmptyString('name'); $validator ->scalar('code') ->maxLength('code', 45) ->allowEmptyString('code'); return
# Nov 8th 2019, 10:27 challgren ‘user’ isn’t though
# Nov 8th 2019, 10:27 dev.cyrusjayson yes ``` protected $_accessible = [ 'user_id' => true, 'name' => true, 'customer_id' => true, 'status_id' => true, 'remarks' => true, 'is_paid' => true, 'date_created' => true, 'customer' => true, 'status' => true, 'suborders' => true ]; ```
# Nov 8th 2019, 10:27 challgren is the field accessible?
# Nov 8th 2019, 10:26 dev.cyrusjayson it just seems cake don’t know user_id added
# Nov 8th 2019, 10:26 dev.cyrusjayson there is no error though
# Nov 8th 2019, 10:26 dev.cyrusjayson I cant see it also. and I have association that gives user as null. but the user_id is not also there
# Nov 8th 2019, 10:25 challgren Check `$entity>errors()`
# Nov 8th 2019, 10:25 dev.cyrusjayson I added new field name user_id in table [11:14 AM] it is not saving [11:14 AM] even I was passing the data
# Nov 8th 2019, 10:12 jotpe Hey :wave:
# Nov 8th 2019, 09:31 dereuromark If they can be null why are they relevant for the query? ;) i think this is a design issue in most cases.
# Nov 8th 2019, 09:25 spriz I would assume the performance of such query is not great :) :)
# Nov 8th 2019, 09:25 roel Oh thanks :)
# Nov 8th 2019, 09:24 roel @spriz the date columns can be `null`
# Nov 8th 2019, 09:19 spriz @roel but one way could be this: https://gist.github.com/Spriz/3862a1bee5a8d67ef7b85434e61be9ad
# Nov 8th 2019, 09:14 noel @martonmiklosqdev I suggest you use xdebug in that case. Not sure why the line numbers aren't showing up correctly for you. This happens to me in JavaScript quite often and it's very annoying. I've never seen it in PHP.
# Nov 8th 2019, 09:13 spriz @roel does the date column really have `0` and not `null` in the DB?
# Nov 8th 2019, 08:59 roel `SELECT * FROM `<table>` WHERE `<fk_id>` IN (1,2)` ` ORDER BY GREATEST(COALESCE(`<date_column_1>`, 0), COALESCE(`<date_column_2>`, 0)) DESC` ` LIMIT 10`
# Nov 8th 2019, 08:59 roel The query is as follows:
# Nov 8th 2019, 08:59 roel Hello everyone, I have a SQL query that I would like to convert to a cakephp (3.6) query, but I have no clue how to do it and if it is even possible.
# Nov 8th 2019, 08:19 javier.villanueva I think that your models are different than the models im thinking
# Nov 8th 2019, 08:18 javier.villanueva morning all
# Nov 8th 2019, 06:36 conehead Morning!