Log message #4212878

# At Username Text
# Nov 8th, 12:16 frank @dev.cyrusjayson Could you try `'GaveFruits' => function ….` instead of `'GaveFruits', function ….` (arrow vs comma)
# Nov 8th, 12:08 slackebot1 [CORE/src/ORM/EagerLoader.php, line 410]``` but if I remove the ->where([‘user_id’ => 1]) everything is working so I think the problem is in ->where but based on the documentation, I am fopllowing it correctly
# Nov 8th, 12:08 dev.cyrusjayson I have this query ``` $fruits = $this->Fruits->find('all') ->contain(['GaveFruits',function (Query $q){ return $q ->select(['id', 'name']) ->where(['user_id' => 1]); }]); ``` and I get this error ```Warning (2): Illegal offset type in isset or empty
# Nov 8th, 12:01 pieceof whoami
# Nov 8th, 11:01 dev.cyrusjayson @frank noted on that. thanks
# Nov 8th, 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, 10:52 dev.cyrusjayson sorry. it all works. thanks mate. that fucking cache save the day
# Nov 8th, 10:45 graziel what do you mean not working? you get error or something?
# Nov 8th, 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, 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, 10:31 dev.cyrusjayson ok
# Nov 8th, 10:31 graziel bin/cake orm_cache clear
# Nov 8th, 10:31 dev.cyrusjayson how?
# Nov 8th, 10:31 graziel try clearing orm cache
# Nov 8th, 10:31 dev.cyrusjayson do I need to compile something?
# Nov 8th, 10:30 dev.cyrusjayson what is going on. kinda frustrating
# Nov 8th, 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, 10:29 dev.cyrusjayson it is not a field. it is association in users model
# Nov 8th, 10:28 slackebot1 'foreignKey' => 'user_id' ]); $this->hasMany('Suborders', [ 'foreignKey' => 'order_id' ]); } ```
# Nov 8th, 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, 10:28 dev.cyrusjayson ```
# Nov 8th, 10:28 slackebot1 $validator; } ```
# Nov 8th, 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, 10:27 challgren ‘user’ isn’t though
# Nov 8th, 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, 10:27 challgren is the field accessible?
# Nov 8th, 10:26 dev.cyrusjayson it just seems cake don’t know user_id added
# Nov 8th, 10:26 dev.cyrusjayson there is no error though
# Nov 8th, 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, 10:25 challgren Check `$entity>errors()`
# Nov 8th, 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, 10:12 jotpe Hey :wave:
# Nov 8th, 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, 09:25 spriz I would assume the performance of such query is not great :) :)
# Nov 8th, 09:25 roel Oh thanks :)
# Nov 8th, 09:24 roel @spriz the date columns can be `null`
# Nov 8th, 09:19 spriz @roel but one way could be this: https://gist.github.com/Spriz/3862a1bee5a8d67ef7b85434e61be9ad
# Nov 8th, 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, 09:13 spriz @roel does the date column really have `0` and not `null` in the DB?
# Nov 8th, 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, 08:59 roel The query is as follows: