質問 > その他 > EC-CUBE4.0 インストール後、bin/console eccube:installでエラー |
その他
フラット表示 | 前のトピック | 次のトピック |
投稿者 | スレッド |
---|---|
kazz_oga |
投稿日時: 2018/12/4 16:45
対応状況: 確認中
|
一人前 登録日: 2013/8/5 居住地: 東京都北区赤羽西 投稿: 144 |
EC-CUBE4.0 インストール後、bin/console eccube:installでエラー ▼テンプレート
[EC-CUBE] EC-CUBE4.0 新規インストール [レンタルサーバ] ローカル環境(mac mini) [OS] MacOS 10.14.1 [PHP] 7.2 [データベース] mySQL 8.0.12 [WEBサーバ] apache 2.4 [ブラウザ] safari [導入プラグインの有無] 無し [カスタマイズの有無] 無し [現象] ■インストール後、DBをmySQLにするためbin/console bin/console eccube:installを実施。 -> dtb_memberにエラーが発生し、http::/127.0.0.1:8000/adminも動作せず。 databaseへのドロップについては -> [OK] Database schema dropped successfully! ■bin/console bin/console eccube:install実施前はhttp::/127.0.0.1:8000/adminの表示あり 以下、bin/console bin/console eccube:installのログ ------------------------ ogawa-mac-mini:ec-cube_4.0_org kazz_oga$ bin/console eccube:install EC-CUBE Installer Interactive Wizard ==================================== If you prefer to not use this interactive wizard, define the environment valiables as follows: $ export APP_ENV=dev $ export APP_DEBUG=1 $ export DATABASE_URL=database_url $ export DATABASE_SERVER_VERSION=server_version $ export MAILER_URL=mailer_url $ export ECCUBE_AUTH_MAGIC=auth_magic ... and more $ php bin/console eccube:install --no-interaction Database Url [sqlite:///var/eccube.db]: > mysql://eccube_db_user:*****************@localhost/eccube_4.0_org Database Server version [auto]: > 8.0 Mailer Url [null://localhost]: > Auth Magic [sTP50qNIfyKOB21v]: > ! ! [CAUTION] Execute the installation process. All data is initialized. ! Is it OK? (yes/no) [yes]: > yes Run doctrine:database:create --if-not-exists... Database `eccube_4.0_org` for connection named default already exists. Skipped. Run doctrine:schema:drop --force... Dropping database schema... [OK] Database schema dropped successfully! Run doctrine:schema:create... [ERROR] The command "bin/console doctrine:schema:create" failed. Exit Code: 1(General error) Working directory: /Users/kazz_oga/localhost/htdocs/ec-cube_4.0_org Output: ================ ! [CAUTION] This operation should not be executed in a production environment! Creating database schema... Error Output: ================ In ToolsException.php line 34: Schema-Tool failed with Error 'An exception occurred while executing 'ALTER TABLE dtb_news ADD CONSTRAINT FK_EA4C351761220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (id)': SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user 'eccube_db_user'@'localhost' for table 'eccube_4.0_org.dtb_m ember'' while executing DDL: ALTER TABLE dtb_news ADD CONSTRAINT FK_EA4C351 761220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (id) In AbstractMySQLDriver.php line 113: An exception occurred while executing 'ALTER TABLE dtb_news ADD CONSTRAINT FK_EA4C351761220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (id)': SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user 'eccube_db_user'@'localhost' for table 'eccube_4.0_org.dtb_m ember' In PDOConnection.php line 109: SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user 'eccube_db_user'@'localhost' for table 'eccube_4.0_org.dtb_m ember' In PDOConnection.php line 107: SQLSTATE[42000]: Syntax error or access violation: 1142 REFERENCES command denied to user 'eccube_db_user'@'localhost' for table 'eccube_4.0_org.dtb_m ember' doctrine:schema:create [--dump-sql] [--em [EM]] [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--] <command> |
フラット表示 | 前のトピック | 次のトピック |
題名 | 投稿者 | 日時 |
---|---|---|
» EC-CUBE4.0 インストール後、bin/console eccube:installでエラー | kazz_oga | 2018/12/4 16:45 |
Re: EC-CUBE4.0 インストール後、bin/console eccube:installでエラー | nyorai | 2018/12/7 9:17 |
Re: EC-CUBE4.0 インストール後、bin/console eccube:installでエラー | kazz_oga | 2018/12/7 10:11 |
Re: EC-CUBE4.0 インストール後、bin/console eccube:installでエラー | sw_sn | 2018/12/7 14:48 |
Re: EC-CUBE4.0 インストール後、bin/console eccube:installでエラー | kazz_oga | 2018/12/7 17:00 |