gothinkster / cakephp-realworld-example-app Goto Github PK

bin/cake migrations migrate gives 'There was a problem connecting to the database: SQLSTATE[HY000] [1045] Access denied for user 'my_app'@'localhost' (using password: YES) in [/home/aoeu/aoeu.com/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/MysqlAdapter.php, line 115] ...' error

Hi All,

I followed the instructions in the docs.

When I entered migrations command into the terminal.
bin\cake migrations migrate

I encountered errors.

Environments : Apache 2.4 on XAMPP , PHP 7.3.9 , how to rectify this issue?

using migration path E:\xampp\htdocs\cakephp-realworld-example-app\config\Migrations using seed path E:\xampp\htdocs\cakephp-realworld-example-app\config\Seeds Exception: There was a problem creating the schema table: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'end_time' in [E:\xampp\htdocs\cakephp-realworld-example-app\vendor\robmorgan\phinx\src\Phinx\Db\Adapter\PdoAdapter.php, line 528] 2019-11-30 19:55:41 Error: [InvalidArgumentException] There was a problem creating the schema table: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'end_time' in E:\xampp\htdocs\cakephp-realworld-example-app\vendor\robmorgan\phinx\src\Phinx\Db\Adapter\PdoAdapter.php on line 528

Env

• OS: OS X EI Capitan 10.11.6（15G1421）
• PHP: PHP 7.0.15 (cli) (built: Jan 22 2017 00:52:27) ( NTS )
• DB: MySQL Ver 14.14 Distrib 5.5.18, for osx10.6 (i386) using readline 5.1

Front

Angular2
https://github.com/gothinkster/angular-realworld-example-app

What's happen

Following validation error occurs

{
    "error": {
        "id": "This field cannot be left empty"
    }
}