| # |
Mar 12th 2018, 22:28 |
xinobi |
thank you very much for your help and have a nice meal :) |
| # |
Mar 12th 2018, 22:27 |
 savant |
good luck :slightly_smiling_face: |
| # |
Mar 12th 2018, 22:27 |
savant |
im off for dinner, let me know if you figure it out |
| # |
Mar 12th 2018, 22:27 |
savant |
same in your controller code |
| # |
Mar 12th 2018, 22:27 |
savant |
find out where in your view you are using plural Users |
| # |
Mar 12th 2018, 22:27 |
savant |
not the joinType or strategy |
| # |
Mar 12th 2018, 22:27 |
savant |
thats the source of your trouble |
| # |
Mar 12th 2018, 22:27 |
savant |
note that I removed the extra `s` |
| # |
Mar 12th 2018, 22:26 |
savant |
I’m _guessing_ that you should refer to them in the UserEmails and UserPhones method |
| # |
Mar 12th 2018, 22:26 |
savant |
but your table class refers to UserEmails and UserPhones: https://pastebin.com/jmMZvibg |
| # |
Mar 12th 2018, 22:26 |
savant |
you have UsersEmails and UsersPhones |
| # |
Mar 12th 2018, 22:26 |
savant |
https://pastebin.com/5nkEH2c5 <-- from your Controller code |
| # |
Mar 12th 2018, 22:25 |
savant |
in others UserEmails |
| # |
Mar 12th 2018, 22:25 |
xinobi |
https://pastebin.com/HFkZNpvD in my view <?= $this->Paginator->sort('UserEmails.address', h('E-Mail')) ?> |
| # |
Mar 12th 2018, 22:25 |
savant |
yeah in some cases you are referring to UsersEmails |
| # |
Mar 12th 2018, 22:25 |
savant |
ah |
| # |
Mar 12th 2018, 22:25 |
savant |
what is in your view? |
| # |
Mar 12th 2018, 22:25 |
savant |
not UsersEmails |
| # |
Mar 12th 2018, 22:25 |
savant |
the table class is UserEmails |
| # |
Mar 12th 2018, 22:24 |
savant |
based on what you showed me |
| # |
Mar 12th 2018, 22:24 |
savant |
_also_ it looks like that would be correct |
| # |
Mar 12th 2018, 22:24 |
savant |
whats the query generated |
| # |
Mar 12th 2018, 22:22 |
xinobi |
savant this is the error Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'UsersEmails.address' in 'order clause' |
| # |
Mar 12th 2018, 22:17 |
savant |
what is the _exact_ error you ge |
| # |
Mar 12th 2018, 22:17 |
xinobi |
savant the first query runs fine except for pagination query if I hit sort column I get the column not found mysql error |
| # |
Mar 12th 2018, 22:16 |
savant |
does that include profiles you want? |
| # |
Mar 12th 2018, 22:16 |
savant |
what happens when you run the first query |
| # |
Mar 12th 2018, 22:11 |
xinobi |
I can't see all the users that don't have a complete profile ex: if user misses email, phone or address is left out of retrieved pagination query results |
| # |
Mar 12th 2018, 22:10 |
savant |
what are the issues you are having? |
| # |
Mar 12th 2018, 22:10 |
savant |
okay so on _this_ page |
| # |
Mar 12th 2018, 22:09 |
xinobi |
savant https://pastebin.com/jdsLkK9U |
| # |
Mar 12th 2018, 21:59 |
savant |
and gist the query for me please |
| # |
Mar 12th 2018, 21:59 |
savant |
and then make the query |
| # |
Mar 12th 2018, 21:59 |
savant |
make the joinType LEFT |
| # |
Mar 12th 2018, 21:58 |
xinobi |
savant with the current setup ->setJoinType('INNER') ->setStrategy('join'); I don't get any sort query error I just can't see users that do not have email or address or phone associated |
| # |
Mar 12th 2018, 21:55 |
savant |
for that particular pagination query |
| # |
Mar 12th 2018, 21:55 |
savant |
and show me the query it makes |
| # |
Mar 12th 2018, 21:55 |
savant |
then run the page |
| # |
Mar 12th 2018, 21:55 |
savant |
What I want you to do is use join+LEFT in your models |
| # |
Mar 12th 2018, 21:53 |
xinobi |
savant you asked me to show you the query error so i've had to change to 'select' in order to get all the registries including the ones with missing emails or addresses etc |
| # |
Mar 12th 2018, 21:53 |
savant |
be back in an hour |