| # |
Apr 12th 2019, 22:06 |
 ricksaccous |
https://stackoverflow.com/questions/18725941/mysql-order-by-best-match |
| # |
Apr 12th 2019, 22:06 |
ricksaccous |
I think I found an answer to my second question |
| # |
Apr 12th 2019, 22:03 |
ricksaccous |
ex WAGE is more similar to WAGE rather than WAGEING or something |
| # |
Apr 12th 2019, 22:03 |
ricksaccous |
also let's say that I wanted to order like query based on similarity |
| # |
Apr 12th 2019, 22:02 |
ricksaccous |
how would i end up doing that |
| # |
Apr 12th 2019, 22:02 |
ricksaccous |
ex i want to order by matched elements where x = y first |
| # |
Apr 12th 2019, 22:02 |
ricksaccous |
but i wanted to order giving one set of conditions priority |
| # |
Apr 12th 2019, 22:01 |
ricksaccous |
suppose I had two sets of conditions i wanted to query by |
| # |
Apr 12th 2019, 22:01 |
ricksaccous |
this is kind of a weird question but probably just highlights my unfamiliarity with SQL |
| # |
Apr 12th 2019, 21:05 |
ricksaccous |
yep no problem |
| # |
Apr 12th 2019, 21:05 |
abdualelah.mdy |
thanks |
| # |
Apr 12th 2019, 21:04 |
abdualelah.mdy |
worked now |
| # |
Apr 12th 2019, 20:53 |
ricksaccous |
sure |
| # |
Apr 12th 2019, 20:53 |
abdualelah.mdy |
i will try to disable it then bake |
| # |
Apr 12th 2019, 20:52 |
ricksaccous |
are you trying to extend the plugin model? |
| # |
Apr 12th 2019, 20:52 |
ricksaccous |
and you're answer might just be setting them correctly |
| # |
Apr 12th 2019, 20:52 |
ricksaccous |
i remember it has config settings though |
| # |
Apr 12th 2019, 20:52 |
ricksaccous |
yeah i don't really want to look into what that plugin does right now, lol |
| # |
Apr 12th 2019, 20:51 |
ricksaccous |
oh you are messing with that plugin |
| # |
Apr 12th 2019, 20:50 |
abdualelah.mdy |
@ricksaccous |
| # |
Apr 12th 2019, 20:50 |
abdualelah.mdy |
I deleted all associations. but the issue is the same |
| # |
Apr 12th 2019, 20:49 |
slackebot |
Error: [RuntimeException] Cake\ORM\Table association "Users" of type "manyToOne" to "CakeDC\Users\Model\Table\UsersTable" doesn't match the expected class "App\Model\Table\UsersTable". You can't have an association of the same name with a different target "className" option anywhere in your app. in C:\xampp\htdocs\bookedServer\vendor\cakephp\cakep |
| # |
Apr 12th 2019, 20:49 |
abdualelah.mdy |
One moment while associations are detected. Exception: Cake\ORM\Table association "Users" of type "manyToOne" to "CakeDC\Users\Model\Table\UsersTable" doesn't match the expected class "App\Model\Table\UsersTable". You can't have an association of the same name with a different target "className" option anywhere in your app. in [C:\xampp\htdocs\bookedServer\vendor\cakephp\cakephp\src\ORM\Association.php, line 475] 2019-04-12 20:48:28 |
| # |
Apr 12th 2019, 20:43 |
ricksaccous |
just have to name them differently |
| # |
Apr 12th 2019, 20:43 |
ricksaccous |
if you want, you can have both of them, |
| # |
Apr 12th 2019, 20:42 |
abdualelah.mdy |
? |
| # |
Apr 12th 2019, 20:42 |
abdualelah.mdy |
so i need to keep one of them |
| # |
Apr 12th 2019, 20:42 |
ricksaccous |
the first param given to a relationship definer is the association name |
| # |
Apr 12th 2019, 20:42 |
ricksaccous |
$this->belongsTo('AssociationName'); |
| # |
Apr 12th 2019, 20:41 |
ricksaccous |
you can't do |
| # |
Apr 12th 2019, 20:41 |
ricksaccous |
so if you do $this->hasMany('AssociationName'); |
| # |
Apr 12th 2019, 20:41 |
ricksaccous |
associations on a table should be uniquely named |
| # |
Apr 12th 2019, 20:41 |
ricksaccous |
@abdualelah.mdy basically your association should be named differently |
| # |
Apr 12th 2019, 20:40 |
abdualelah.mdy |
any help with this issue ? |
| # |
Apr 12th 2019, 19:55 |
abdualelah.mdy |
@hollistergraham123 3.7 |
| # |
Apr 12th 2019, 19:52 |
hollistergraham123 |
This returns all equipment regardless of wether the location’s equipment has any due maintenance. What am I missing to get it to return only location’s where their associated equipment have maintenance due |
| # |
Apr 12th 2019, 19:50 |
hollistergraham123 |
I am trying to write a three table deep query. I need the final output to be [locations => [equipments => [maintenances]]]. I just want to return the locations and equipment and maintenance data where maintenance due is between a range |
| # |
Apr 12th 2019, 19:44 |
hollistergraham123 |
@abdualelah.mdy Which version of cake are you using? |
| # |
Apr 12th 2019, 19:04 |
abdualelah.mdy |
Exception: Cake\ORM\Table association "Users" of type "manyToOne" to "Cake\ORM\Table" doesn't match the expected class "App\Model\Table\UsersTable". You can't have an association of the same name with a different target "className" option anywhere in your app. in [C:\xampp\htdocs\bookedServer\vendor\cakephp\cakephp\src\ORM\Association.php, line 475]--> full error |
| # |
Apr 12th 2019, 19:03 |
abdualelah.mdy |
? |
| # |
Apr 12th 2019, 18:56 |
abdualelah.mdy |
and how to solve it |