| # |
Dec 31st 2018, 00:03 |
 rightscoreanalysis |
what am I doing wrong |
| # |
Dec 31st 2018, 00:03 |
rightscoreanalysis |
even when I use join conditions that do not match I am getting results when I should be getting 0 |
| # |
Dec 31st 2018, 00:03 |
rightscoreanalysis |
i have Properties model and PropertyPeriods, I am queryinging Properties and joining on PropertyPeriods |
| # |
Dec 30th 2018, 21:05 |
sdevore |
I would rename the old ones and rebake and then merge them (maybe by hand). But to be honest mostly I just manually update them, but I’ve been doing this stuff for a really long time on and off… |
| # |
Dec 30th 2018, 20:17 |
tomas.saghy |
I see I need to check 4.x branch :slightly_smiling_face: |
| # |
Dec 30th 2018, 20:16 |
tomas.saghy |
thanks for the example for `allowEmptyString` |
| # |
Dec 30th 2018, 19:24 |
dereuromark |
check the wiki page |
| # |
Dec 30th 2018, 19:24 |
dereuromark |
not really |
| # |
Dec 30th 2018, 19:21 |
k4t |
will we get any big change in ORM in Cake 4.0? |
| # |
Dec 30th 2018, 19:07 |
k4t |
fair enough |
| # |
Dec 30th 2018, 18:02 |
dereuromark |
sry, i dont do json without ext |
| # |
Dec 30th 2018, 17:56 |
k4t |
gi @dereuromark could you please check this? https://gist.github.com/K4T/1a2972e2e93fa1bb542a63a683675a26 I am using CRUD plugin and I would like to have urls without .json extension to work exactly like urls with .json extension (e.g. /api/v1/users/2 should gave me the same respone as /api/v1/users/2.json). In attached GIST you will find my current code and how current responses looks now. |
| # |
Dec 30th 2018, 17:18 |
k4t |
you can not rebake them again as you lost your entity/table modifications |
| # |
Dec 30th 2018, 17:18 |
k4t |
to reflect new database tables structure? |
| # |
Dec 30th 2018, 17:17 |
k4t |
do you update them manually? |
| # |
Dec 30th 2018, 17:17 |
k4t |
what with old baked models now? |
| # |
Dec 30th 2018, 17:17 |
k4t |
how do you handle follwing scenario: you have some tables in db, u baked models based on current tables structure. Now you added to the database tables some new columns, removed old ones etc |
| # |
Dec 30th 2018, 17:16 |
k4t |
hi guys |
| # |
Dec 30th 2018, 14:34 |
challgren |
Can you gist the structure for accounts and accounting_records please |
| # |
Dec 30th 2018, 14:32 |
challgren |
Now that I’m reading what your trying to accomplish |
| # |
Dec 30th 2018, 14:32 |
challgren |
I think your query might be a bit overkill |
| # |
Dec 30th 2018, 14:31 |
kitcat711 |
got it in debugkit I think |
| # |
Dec 30th 2018, 14:28 |
challgren |
https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#debugging-queries-and-resultsets the debug should be outputting the bound parameters and its not |
| # |
Dec 30th 2018, 14:27 |
kitcat711 |
yes |
| # |
Dec 30th 2018, 14:23 |
challgren |
Do you have debugkit enabled? |
| # |
Dec 30th 2018, 14:23 |
kitcat711 |
but same result xith debug($query) or sql($query) |
| # |
Dec 30th 2018, 14:22 |
kitcat711 |
https://gist.github.com/Kitcat711/6b440733f5566b243c946bdf047a99fa |
| # |
Dec 30th 2018, 14:20 |
challgren |
Ahh ok |
| # |
Dec 30th 2018, 14:20 |
kitcat711 |
Here I must debug to file for it is called through the api of the app => nothing on the screen |
| # |
Dec 30th 2018, 14:19 |
challgren |
I think debug outputs to browser and log depending on settings |
| # |
Dec 30th 2018, 14:19 |
kitcat711 |
gonna gist the debug |
| # |
Dec 30th 2018, 14:19 |
kitcat711 |
well ERROR is just appearing because this is in the log error |
| # |
Dec 30th 2018, 14:14 |
challgren |
do debug($query); please and gist that |
| # |
Dec 30th 2018, 14:14 |
challgren |
Hmm so you are getting a SQL error |
| # |
Dec 30th 2018, 14:11 |
kitcat711 |
which looks like the very same to me |
| # |
Dec 30th 2018, 14:11 |
slackebot |
Accounts.master = :c2) GROUP BY Accounts.id ORDER BY Accounts.number ASC 2018-12-30 14:09:49 Error: Api/AccountRecordsController : getTabs |
| # |
Dec 30th 2018, 14:11 |
kitcat711 |
2018-12-30 14:09:49 Error: SELECT Accounts.id AS `Accounts__id`, Accounts.lessor_id AS `Accounts__lessor_id`, Accounts.number AS `Accounts__number`, Accounts.name AS `Accounts__name`, Accounts.parent_id AS `Accounts__parent_id`, ar.balance AS `ar__balance` FROM accounts Accounts LEFT JOIN accounting_records ar ON (Accounts.number = ar.account_number AND Accounts.lessor_id = ar.lessor_id AND ar.id = :c0) WHERE (Accounts.lessor_id = :c1 OR |
| # |
Dec 30th 2018, 14:11 |
kitcat711 |
got only that: |
| # |
Dec 30th 2018, 14:08 |
kitcat711 |
checking back |
| # |
Dec 30th 2018, 14:08 |
challgren |
it doesnt give you parameters? |
| # |
Dec 30th 2018, 14:08 |
kitcat711 |
Actually, @challgren, debug($query) provides the same log that sql($query) |