# |
Nov 6th 2019, 00:03 |
daniel.upshaw |
Lol |
# |
Nov 6th 2019, 00:03 |
daniel.upshaw |
Oops |
# |
Nov 6th 2019, 00:02 |
daniel.upshaw |
```/* * The actual directory name for the application directory. Normally * named 'src'. */ define('APP_DIR', 'src'); /* * Path to the application's directory. */ define('APP', CMS_CORE_PATH . DS . APP_DIR . DS);``` |
# |
Nov 6th 2019, 00:02 |
daniel.upshaw |
Yes it appears to be in the code |
# |
Nov 5th 2019, 23:53 |
daniel.upshaw |
Fair |
# |
Nov 5th 2019, 23:53 |
dereuromark |
still alpha |
# |
Nov 5th 2019, 23:53 |
dereuromark |
u never know |
# |
Nov 5th 2019, 23:53 |
daniel.upshaw |
Yah, I mean it's such a basic thing I'm sure it won't be present in a fresh app install |
# |
Nov 5th 2019, 23:51 |
dereuromark |
verified in minutes, and then hopefully it becomes a bit easier to track down the rest |
# |
Nov 5th 2019, 23:51 |
dereuromark |
still good to exclude such things as core bugs |
# |
Nov 5th 2019, 23:50 |
daniel.upshaw |
This is really bare bones though.. I'm trying to work with a basic `require cakephp/cakephp` |
# |
Nov 5th 2019, 23:50 |
daniel.upshaw |
That'll be the way to go |
# |
Nov 5th 2019, 23:50 |
daniel.upshaw |
Oddly, it's only some of the templates, specifically Error templates |
# |
Nov 5th 2019, 23:50 |
dereuromark |
see if you can replicate with fresh 4.x app |
# |
Nov 5th 2019, 23:49 |
daniel.upshaw |
I wouldn't put it past a config issue... but I did normalize things to Cake4 as closely as I could |
# |
Nov 5th 2019, 23:45 |
dereuromark |
sounds like a config issue, or a bug |
# |
Nov 5th 2019, 23:42 |
daniel.upshaw |
Any ideas offhand why Cake4 branch would look for any templates in `src/templates`? |
# |
Nov 5th 2019, 23:19 |
slackebot1 |
variable does have the contain ``` $query = $this->Table->find( 'all' ) ->contain( ['Table2'] ); ``` The contain also works if i remove my function from above (to show related information in my index page) but i dont know how i can perform a custom where in which both my tables are being searched with concatinated fields |
# |
Nov 5th 2019, 23:19 |
slackebot1 |
->like( $conc2, "%$search%" ) ->like( $conc3, "%$search%" ) ->like( $conc4, "%$search%" ); } ); } ``` But all I get is a ``` Column not found: 1054 Unknown column 'Table2.first_name' in 'where clause' ``` due to the fact, that the Query doesn't join. This functions resides in my index() function of my Table1Controller and the initialization of the $query |
# |
Nov 5th 2019, 23:19 |
slackebot1 |
'Table2.last_name' => 'literal' ] ); $conc4 = $q->func() ->concat( [ 'Table2.last_name' => 'literal', ' ', 'Table2.first_name' => 'literal' ] ); return $exp->or( [ 'Table1.company LIKE' |
# |
Nov 5th 2019, 23:19 |
slackebot1 |
=> "%$search%", 'Table1.first_name LIKE' => "%$search%", 'Table1.last_name LIKE' => "%$search%", 'Table1.city LIKE' => "%$search%", 'Table2.first_name LIKE' => "%$search%", 'Table2.last_name LIKE' => "%$search%" ] ) ->like( $conc1, "%$search%" ) |
# |
Nov 5th 2019, 23:19 |
slackebot1 |
'Table1.last_name' => 'literal', ' ', 'Table1.first_name' => 'literal' ] ); // Concatenated EasybillCustomersContacts Name $conc3 = $q->func() ->concat( [ 'Table2.first_name' => 'literal', ' ', |
# |
Nov 5th 2019, 23:19 |
slackebot1 |
*/ // Concatenated EasybillCustomers Name $conc1 = $q->func() ->concat( [ 'Table1.first_name' => 'literal', ' ', 'Table1.last_name' => 'literal' ] ); $conc2 = $q->func() ->concat( [ |
# |
Nov 5th 2019, 23:19 |
kevin.pfeifer |
i try to do something like that ``` // Change query if a search parameter is given in GET data if ( $search ) { // Search for concat fields in cakephp >=3 // https://stackoverflow.com/questions/35405261/search-with-concat-fields-in-cakephp-3 $query->where( function( $exp, $q ) use ( $search ) { /** * @var QueryExpression $exp * @var Query $q |
# |
Nov 5th 2019, 21:56 |
phantomwatson |
Ah, nevermind for my question. `Table::getDependent()` was right in front of me the whole time. |
# |
Nov 5th 2019, 21:50 |
phantomwatson |
I might be misunderstanding what you're trying to do. |
# |
Nov 5th 2019, 21:49 |
phantomwatson |
@kevin.pfeifer, does it work to specify a join and include the table name in the field name, e.g. `concat(['title' => 'Articles.title', 'author' => 'Authors.name'])`? |
# |
Nov 5th 2019, 21:47 |
phantomwatson |
Does anyone happen to know how to query a table or entity and determine which associations are marked as dependent? |
# |
Nov 5th 2019, 21:35 |
kevin.pfeifer |
i found that, but this only works for the same table https://stackoverflow.com/questions/35405261/search-with-concat-fields-in-cakephp-3 |
# |
Nov 5th 2019, 21:34 |
kevin.pfeifer |
someones know how I can use connected tables inside a custom QueryExpression for a concatenated where search? |
# |
Nov 5th 2019, 21:23 |
daniel.upshaw |
Just getting used to the new folder structure... still confusing why it was searching in `src/` if the folder is moved |
# |
Nov 5th 2019, 21:21 |
daniel.upshaw |
Yeah oddly it wanted to find that template in `src/templates` |
# |
Nov 5th 2019, 21:17 |
daniel.upshaw |
Doesn't seem to be `paths.php` |
# |
Nov 5th 2019, 21:14 |
daniel.upshaw |
That's probably it lol |
# |
Nov 5th 2019, 21:14 |
daniel.upshaw |
I'll make sure my config files are up-to-date with 4 |
# |
Nov 5th 2019, 21:12 |
daniel.upshaw |
Where core and pages are basic plugins |
# |
Nov 5th 2019, 21:12 |
daniel.upshaw |
```Error: [Cake\View\Exception\MissingTemplateException] Template file 'Error/error500.php' could not be found. The following paths were searched: - core/src/templates/plugin/Pages/ - pages/templates/ - core/src/templates/ - vendor/cakephp/cakephp/templates/ ``` |
# |
Nov 5th 2019, 21:11 |
daniel.upshaw |
I noticed sometimes it searches for templates in `src/templates`, and sometimes `templates` |
# |
Nov 5th 2019, 21:11 |
daniel.upshaw |
Jumping onto Cake4 :slightly_smiling_face: |
# |
Nov 5th 2019, 17:35 |
karmicdice |
Adios! Thanks for being patient... just learning my way to contrib more to the framework in near future. :slightly_smiling_face: Learning... |
# |
Nov 5th 2019, 17:33 |
karmicdice |
Haha! It is close to mid-night here, just wanted to be quick. |