Log message #4209453

# At Username Text
# Oct 18th 2019, 13:46 admad @dereuromark bin/cake uses PHP CLI, nothing will show up in webserver logs
# Oct 18th 2019, 13:45 neon1024 Geez, with Boris in Europe, who knows :face_palm:
# Oct 18th 2019, 13:45 dereuromark or is that php directly, i guess it has other logs then
# Oct 18th 2019, 13:45 neon1024 One would use her majesties English dear old bean, but many wouldn’t understand you see wot wot
# Oct 18th 2019, 13:45 dereuromark apache ones?
# Oct 18th 2019, 13:45 luizcmarin where the file?
# Oct 18th 2019, 13:45 luizcmarin do the error logs say sth? where ?
# Oct 18th 2019, 13:44 admad @neon1024 less Queen's English, more internet English needed for you :P
# Oct 18th 2019, 13:44 neon1024 I can only imagine learning English is annoying without having to learn all the slang and internet abbreviations too
# Oct 18th 2019, 13:44 luizcmarin NOTE: It worked perfectly yesterday. Today worked the first time. Then ctrl + c because I wanted to upgrade, but I didn't upgrade and returned to give cake server. It doesn't work anymore. I restarted windows. Anything.
# Oct 18th 2019, 13:44 dereuromark :slightly_smiling_face:
# Oct 18th 2019, 13:44 neon1024 Kids these days lol!
# Oct 18th 2019, 13:43 neon1024 Also smh as ‘shake my head’
# Oct 18th 2019, 13:43 neon1024 I had no idea either until a while ago!
# Oct 18th 2019, 13:43 neon1024 In case you’re not familiar
# Oct 18th 2019, 13:43 neon1024 sth means ‘something’
# Oct 18th 2019, 13:43 dereuromark do the error logs say sth?
# Oct 18th 2019, 13:42 luizcmarin yes. perfect
# Oct 18th 2019, 13:42 dereuromark does it work for 3.x on windows?
# Oct 18th 2019, 13:41 luizcmarin :(
# Oct 18th 2019, 13:41 luizcmarin I tested with bin\cake server
# Oct 18th 2019, 13:41 luizcmarin old image.
# Oct 18th 2019, 13:40 neon1024 Just as @dereuromark suggests
# Oct 18th 2019, 13:40 neon1024 @luizcmarin Did you try it from your project root folder?
# Oct 18th 2019, 13:40 neon1024 Which probably works if you specify all the paths and stuff
# Oct 18th 2019, 13:40 neon1024 I guess he is running cake in /bin, rather than `bin/cake server`
# Oct 18th 2019, 13:38 dereuromark why are yo ustill using invalid bin dir as root? use bin/cake
# Oct 18th 2019, 13:37 luizcmarin not
# Oct 18th 2019, 13:36 neon1024 Does the url still render a page?
# Oct 18th 2019, 13:35 slackebot1 <luizcmarin>
# Oct 18th 2019, 13:35 luizcmarin Does not reload the server. It worked the first time, I gave "ctrl + C" to do something else, I didn't do it, I reloaded it and ... it doesn't work. reboot windows. :(
# Oct 18th 2019, 13:34 luizcmarin cake 4
# Oct 18th 2019, 13:33 luizcmarin hi
# Oct 18th 2019, 13:21 felipe.marinho Solved: ```->add('codcompany', 'Search.Callback', [ 'callback' => function ($query, $args, $filter) { $query->leftJoinWith('Exceptions'); return true; } ]);```
# Oct 18th 2019, 13:08 felipe.marinho This is the query generated... ```SELECT companies.id AS `companies__id`, companies.codcompany AS `companies__codbrid`, companies.name AS `companies__nome` FROM companies companies WHERE ( companies.codcompany like '2' AND exceptions.codcorporativo like '10434015' ) ```
# Oct 18th 2019, 13:04 felipe.marinho because the $query don't relate the Companies and the Exceptions table...
# Oct 18th 2019, 13:03 felipe.marinho ```Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Exceptions.codcompany' in 'where clause'```
# Oct 18th 2019, 13:02 dereuromark also be careful with casing : exceptions. !== Exceptions.
# Oct 18th 2019, 13:02 dereuromark didnt work how? whats the error? or query generated?
# Oct 18th 2019, 13:01 felipe.marinho I tried to create this in the CompaniesTable.php: ```->add('codcompany', 'Search.Like', ['field' => ['exceptions.codcompany']]);;``` But it didn't work :(
# Oct 18th 2019, 13:00 slackebot1 $this->request->query]); $companies = $this->paginate($query, array('limit'=>20));``` I wanna create a filter for the codcompanie in the Exception table.