Log message #4266954

# At Username Text
# Jul 1st 2021, 16:16 staccato123 Fair enough, thanks for looking
# Jul 1st 2021, 16:13 kevin.pfeifer can't tell you, sorry :shru
# Jul 1st 2021, 16:11 staccato123 Looking at the query log, all the query needs is "JOIN resources_count ResourcesCounts" adding
# Jul 1st 2021, 16:07 staccato123 error is "Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ResourcesCounts.date' in 'where clause'" as you would expect
# Jul 1st 2021, 16:05 staccato123 https://pastebin.com/YHkq9NZe
# Jul 1st 2021, 16:04 staccato123 *there's
# Jul 1st 2021, 16:04 staccato123 There's SQL. There no JOIN
# Jul 1st 2021, 16:01 kevin.pfeifer or do you get an error?
# Jul 1st 2021, 16:00 kevin.pfeifer is there SQL generated when you look into it via debug kit?
# Jul 1st 2021, 15:59 kevin.pfeifer :thinking_face: so you don’t need to set the extra `className` property because the alias (1st parameter) is the same as the TableObject name
# Jul 1st 2021, 15:55 staccato123 yes
# Jul 1st 2021, 15:55 kevin.pfeifer but the resources_counts Table Class is called `ResourcesCountsTable`?
# Jul 1st 2021, 15:18 staccato123 The only unusualness is that the table for ResourcesCounts is resources_count rather than resources_counts, but I've done a setTable
# Jul 1st 2021, 15:15 staccato123 https://pastebin.com/3nFKFStE
# Jul 1st 2021, 15:13 staccato123 give me a sec
# Jul 1st 2021, 14:47 kevin.pfeifer can you provide code examples of how you define the hasMany and how you use it?
# Jul 1st 2021, 14:46 staccato123 Is there an obvious reason why my hasMany association isn't turning up when I use ->contain() ?
# Jul 1st 2021, 14:45 info315 I'm not using pure SQL, I'm using th eCakePHP Migrations :)
# Jul 1st 2021, 14:45 staccato123 Afternoon
# Jul 1st 2021, 14:43 kevin.pfeifer uh, 5.0 is on the way :scream:
# Jul 1st 2021, 14:42 dereuromark Also see https://github.com/cakephp/cakephp/wiki
# Jul 1st 2021, 14:04 cristianhaunsen `CREATE TABLE a.table`
# Jul 1st 2021, 14:04 edu.garcia Really appreciated Kevin
# Jul 1st 2021, 14:04 cristianhaunsen you can prefix the database name in your query (if you are using pure sql)
# Jul 1st 2021, 13:57 kevin.pfeifer for installation requirements see also 3.x https://book.cakephp.org/3/en/installation.html 4.x https://book.cakephp.org/4/en/installation.html
# Jul 1st 2021, 13:56 kevin.pfeifer according to the composer.json cakephp 3 needs >= 5.6 and < 8.0 https://github.com/cakephp/cakephp/blob/3.x/composer.json#L31 and cakephp 4 >= 7.2 https://github.com/cakephp/cakephp/blob/master/composer.json#L25
# Jul 1st 2021, 13:53 info315 Hm no, I just want to create a few tables to a second database configuration
# Jul 1st 2021, 13:52 edu.garcia Is there a table where I can see PHP x CakePHP versions compatibility
# Jul 1st 2021, 13:51 edu.garcia Hi everyone
# Jul 1st 2021, 13:45 cnizzardini You can call `$this->query($sql);` as well
# Jul 1st 2021, 13:11 kevin.pfeifer I would guess you can achieve that via the alias function of the connection manager https://stackoverflow.com/questions/44428235/change-default-db-in-cakephp3
# Jul 1st 2021, 13:05 info315 Hi, is it possible to change the used Database Connection inside of an Migration?
# Jun 30th 2021, 22:18 rightscoreanalysis ah because my method was statc :)
# Jun 30th 2021, 22:18 rightscoreanalysis Using $this when not in object context
# Jun 30th 2021, 22:17 rightscoreanalysis I did the same: protected $_credentials; then using $this->_crednetialsd
# Jun 30th 2021, 22:17 rightscoreanalysis in the core I can see: protected $_validCiphers = ['aes']; used as: $this->$_validCiphers
# Jun 30th 2021, 20:07 kevin.pfeifer basically PSR-4 says, that a namespace has to correspond with the folder-structure the class is located
# Jun 30th 2021, 20:06 kevin.pfeifer and yes, there is the whole psr-4 autloading standard as well if you want to read into that as well (which you definitely don't need to) https://www.php-fig.org/psr/psr-4/
# Jun 30th 2021, 20:05 kevin.pfeifer here for the app src directory https://github.com/cakephp/app/blob/master/composer.json#L29
# Jun 30th 2021, 20:05 kevin.pfeifer and the same goes for the cakephp core, but just with another namepsace https://github.com/cakephp/cakephp/blob/master/composer.json#L75
# Jun 30th 2021, 20:05 rightscoreanalysis awesome thanks for the pointers