# |
Feb 8th 2020, 12:56 |
dsar |
Nice ;) |
# |
Feb 8th 2020, 12:56 |
jan-willem |
Working on a new side-project to keep track of the scores of a card-game 8) |
# |
Feb 8th 2020, 12:55 |
dsar |
Ok then |
# |
Feb 8th 2020, 12:55 |
dsar |
This is available since 3.3 |
# |
Feb 8th 2020, 12:55 |
jan-willem |
4.03 |
# |
Feb 8th 2020, 12:55 |
dsar |
What version of CakePHP do you have? |
# |
Feb 8th 2020, 12:55 |
jan-willem |
A, perfect. Missed that one indeed. |
# |
Feb 8th 2020, 12:52 |
dsar |
https://book.cakephp.org/4/en/orm/validation.html#association-count-rules |
# |
Feb 8th 2020, 12:52 |
dsar |
I don't understand precisely, do you mean something like this? |
# |
Feb 8th 2020, 12:26 |
jan-willem |
What is the best approach to limit the amount to create an associations? I know there is the limit option in the association, but this doesn't limit in creating a new association (correct me if I'm wrong :$ ) Should I handle this in the validation itself? |
# |
Feb 8th 2020, 03:45 |
savant |
There aren’t that many people in the slack @lpj145 because we’re all busy being productive in cakephp ;) |
# |
Feb 8th 2020, 03:18 |
challgren |
CLI vs Apache Env might be different just a FYI |
# |
Feb 8th 2020, 03:15 |
wizardfix |
checking... |
# |
Feb 8th 2020, 03:15 |
wizardfix |
OK maybe my env() isn't working as I just substituted it for hard coded values |
# |
Feb 8th 2020, 03:14 |
challgren |
You need to first make sure the cake app can connect to the db |
# |
Feb 8th 2020, 03:13 |
challgren |
Yes |
# |
Feb 8th 2020, 03:13 |
wizardfix |
I created the tables from an SQL file I wrote, can I just convert that into a migration file somehow maybe? |
# |
Feb 8th 2020, 03:11 |
wizardfix |
is that set in app.php? |
# |
Feb 8th 2020, 03:07 |
challgren |
Does the user have all privs in mariadb? |
# |
Feb 8th 2020, 03:05 |
wizardfix |
V 3.8 btw :) |
# |
Feb 8th 2020, 02:59 |
slackebot |
/opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Console/CommandRunner.php(385): Cake\Console\Shell->runCommand(Array, true) #17 /opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Console/CommandRunner.php(162): Cake\Console\CommandRunner->runShell(Object(Bake\Shell\BakeShell), Array) #18 /opt/lampp/htdocs/trportal/bin/cake.php(12): Cake\Console\CommandRunner->run(Array) #19 {main}``` |
# |
Feb 8th 2020, 02:59 |
slackebot |
/opt/lampp/htdocs/trportal/vendor/cakephp/bake/src/Shell/Task/SimpleBakeTask.php(91): Migrations\Shell\Task\MigrationSnapshotTask->bake('Initial') #14 /opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Console/Shell.php(531): Bake\Shell\Task\SimpleBakeTask->main('Initial') #15 /opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Console/Shell.php(524): Cake\Console\Shell->runCommand(Array, false, Array) #16 |
# |
Feb 8th 2020, 02:59 |
slackebot |
Migrations\Shell\Task\MigrationSnapshotTask->templateData() #11 /opt/lampp/htdocs/trportal/vendor/cakephp/migrations/src/Shell/Task/SimpleMigrationTask.php(95): Bake\Shell\Task\SimpleBakeTask->bake('Initial') #12 /opt/lampp/htdocs/trportal/vendor/cakephp/migrations/src/Shell/Task/MigrationSnapshotTask.php(47): Migrations\Shell\Task\SimpleMigrationTask->bake('Initial') #13 |
# |
Feb 8th 2020, 02:59 |
slackebot |
/opt/lampp/htdocs/trportal/vendor/cakephp/migrations/src/TableFinderTrait.php(51): Cake\Database\Schema\Collection->listTables() #9 /opt/lampp/htdocs/trportal/vendor/cakephp/migrations/src/Shell/Task/MigrationSnapshotTask.php(75): Migrations\Shell\Task\MigrationSnapshotTask->getTablesToBake(Object(Cake\Database\Schema\CachedCollection), Array) #10 /opt/lampp/htdocs/trportal/vendor/cakephp/bake/src/Shell/Task/SimpleBakeTask.php(104): |
# |
Feb 8th 2020, 02:59 |
slackebot |
/opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Core/Retry/CommandRetry.php(67): Cake\Database\Connection->Cake\Database\{closure}() #6 /opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Database/Connection.php(305): Cake\Core\Retry\CommandRetry->run(Object(Closure)) #7 /opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Database/Schema/Collection.php(63): Cake\Database\Connection->execute('SHOW TABLES FRO...', Array) #8 |
# |
Feb 8th 2020, 02:59 |
slackebot |
/opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Core/Retry/CommandRetry.php(67): Cake\Database\Connection->Cake\Database\{closure}() #3 /opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Database/Connection.php(352): Cake\Core\Retry\CommandRetry->run(Object(Closure)) #4 /opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Database/Connection.php(301): Cake\Database\Connection->query('SHOW TABLES FRO...') #5 |
# |
Feb 8th 2020, 02:59 |
slackebot |
/opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php on line 38 Stack Trace: #0 /opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php(38): PDOStatement->execute(NULL) #1 /opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Database/Connection.php(349): Cake\Database\Statement\MysqlStatement->execute() #2 |
# |
Feb 8th 2020, 02:59 |
slackebot |
server version for the right syntax to use near '' at line 1 in [/opt/lampp/htdocs/trportal/vendor/cakephp/cakephp/src/Database/Statement/MysqlStatement.php, line 38] 2020-02-08 02:55:41 Error: [PDOException] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 in |
# |
Feb 8th 2020, 02:59 |
wizardfix |
Trying to generate a migration file from my existing MariaDB MySQL database tables as documented at https://book.cakephp.org/migrations/2/en/index.html but getting this error. Is there some shim I need to make Cake generate correct SQL? ```$ bin/cake bake migration_snapshot -v Initial Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB |
# |
Feb 7th 2020, 23:40 |
lpj145 |
today is a sad day for me, for all the core members: peoples can love the job's you made. |
# |
Feb 7th 2020, 23:40 |
dsar |
Uhm, 3 years to move all projects out from cake, I guess these are small-medium size projects |
# |
Feb 7th 2020, 23:38 |
lpj145 |
by then, cake still have time. |
# |
Feb 7th 2020, 23:37 |
lpj145 |
thanks for the conversation @dsar for me is good, i'm need a 3 years for move all project out from cake.. |
# |
Feb 7th 2020, 23:35 |
dsar |
The fact that cakephp devs are very active on issues, it is a VERY good things |
# |
Feb 7th 2020, 23:34 |
lpj145 |
:,) maybe is problem of frameworks... |
# |
Feb 7th 2020, 23:34 |
dsar |
I reported some issues in cakephp and they replied really fast |
# |
Feb 7th 2020, 23:33 |
dsar |
I reported only three bugs (the other were already reported), they are still there and nobody replied |
# |
Feb 7th 2020, 23:33 |
dsar |
I think most users of Symfony don't use it in an advanced way, there are lot of bugs (it's a huge monster in complexity as a project) |
# |
Feb 7th 2020, 23:25 |
lpj145 |
at this time, i'm working on two plugins, one for streams, another for expressivies queries urls... |
# |
Feb 7th 2020, 23:30 |
lpj145 |
i think cake need to improve the form hear comunity, and, help comunity to help cake. ,:) |
# |
Feb 7th 2020, 23:31 |
dsar |
Every framework has it's own pros and cons |