質問 > フロント機能 > フロント画面、ページ管理画面にシステムエラーがでる |
フロント機能
フラット表示 | 前のトピック | 次のトピック |
投稿者 | スレッド |
---|---|
sie |
投稿日時: 2018/8/7 18:42
対応状況: 解決済
|
新米 登録日: 2018/8/7 居住地: 投稿: 9 |
フロント画面、ページ管理画面にシステムエラーがでる ▼テンプレート
[EC-CUBE] EC-CUBEのバージョン、新規インストールかアップデートか、等 [レンタルサーバ] レンタルサーバ名 さくらインターネット [OS] 使用しているOS名、バージョン FreeBSD 9.1-RELEASE-p24 amd64 [PHP] 使用しているPHPのバージョン 5.4.45 [データベース] 使用しているDB名、バージョン MySQL 5.5 [WEBサーバ] 使用しているWEBサーバ名、バージョン [ブラウザ] 使用しているブラウザ名、バージョン [導入プラグインの有無] あれば導入プラグインを記載 [カスタマイズの有無] あればカスタマイズ内容を記載(できるだけ具体的に) [現象] 再現手順や、どのような現象が発生しているかなど、具体的に 3.0.10をhttp://ドメイン/●●/で使っていたのですが、ページ全体を整理するためバックアップをとって一度サーバーを空にしました。 そして、さくらのクイックインストールで3.0.16をインストールしました。データベースは以前からのものを初期化せずに設定しています。 クイックインストールではhttp://ドメイン/☆☆/htmlとでてしまうのでhttp://ドメインにするために以下の作業を行いました。 https://qiita.com/pugiemonn/items/0371efb7c3c05b7e3be7 インストール直後からフロント画面とページ管理画面にシステムエラーがでてしまいます。 管理画面は見ることができて以下のログがでています。 どなた様かご教授願えませんでしょうか? [2018-08-07 17:57:32,336424] eccube.INFO [dfb07c97] [53105049] [3] [LogListener:logResponse:96] - < 200 [GET, /***/setting/system/system?mode=info, 125.174.192.159, http://****/***/setting/system/system, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] [2018-08-07 17:57:32,287892] eccube.INFO [dfb07c97] [53105049] [3] [LogListener:logRequest:83] - > GET /***/setting/system/system?mode=info [GET, /***/setting/system/system?mode=info, 125.174.192.159, http://****/***/setting/system/system, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] [2018-08-07 17:57:32,258063] eccube.INFO [NULL] [53105049] [NULL] [RouterListener:onKernelRequest:146] - Matched route "admin_setting_system_system". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Admin\\Setting\\System\\SystemController::index","_route":"admin_setting_system_system"},"request_uri":"http://****/***/setting/system/system?mode=info"} [GET, /***/setting/system/system?mode=info, 125.174.192.159, http://****/***/setting/system/system, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] [2018-08-07 17:57:31,538771] eccube.INFO [dfb07c97] [9b039253] [3] [LogListener:logResponse:96] - < 200 [GET, /***/setting/system/system, 125.174.192.159, http://****/***/setting/shop, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] [2018-08-07 17:57:31,465150] eccube.INFO [dfb07c97] [9b039253] [3] [LogListener:logRequest:83] - > GET /***/setting/system/system [GET, /***/setting/system/system, 125.174.192.159, http://****/***/setting/shop, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] [2018-08-07 17:57:31,438660] eccube.INFO [NULL] [9b039253] [NULL] [RouterListener:onKernelRequest:146] - Matched route "admin_setting_system_system". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Admin\\Setting\\System\\SystemController::index","_route":"admin_setting_system_system"},"request_uri":"http://****/***/setting/system/system"} [GET, /***/setting/system/system, 125.174.192.159, http://****/***/setting/shop, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] [2018-08-07 17:57:25,849331] eccube.INFO [dfb07c97] [165eb232] [3] [LogListener:logResponse:96] - < 200 [GET, /***/setting/shop, 125.174.192.159, http://****/***/setting/system/log, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] [2018-08-07 17:57:25,264551] eccube.INFO [dfb07c97] [165eb232] [3] [LogListener:logRequest:83] - > GET /***/setting/shop [GET, /***/setting/shop, 125.174.192.159, http://****/***/setting/system/log, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] [2018-08-07 17:57:25,204435] eccube.INFO [NULL] [165eb232] [NULL] [RouterListener:onKernelRequest:146] - Matched route "admin_setting_shop". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Admin\\Setting\\Shop\\ShopController::index","_route":"admin_setting_shop"},"request_uri":"http://****/***/setting/shop"} [GET, /***/setting/shop, 125.174.192.159, http://****/***/setting/system/log, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] [2018-08-07 17:57:20,611206] eccube.INFO [dfb07c97] [38e1efc2] [NULL] [LogListener:logResponse:96] - < 500 [GET, /, 125.174.192.159, NULL, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd0_.meta_tags' in 'field list' at /home/**/www/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd0_.meta_tags' in 'field list' at /home/**/www/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd0_.meta_tags' in 'field list' at /home/**/www/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} [GET, /, 125.174.192.159, NULL, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd0_.meta_tags' in 'field list' (uncaught exception) at /home/**/www/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT d0_.page_id AS page_id0, d0_.page_name AS page_name1, d0_.url AS url2, d0_.file_name AS file_name3, d0_.edit_flg AS edit_flg4, d0_.author AS author5, d0_.description AS description6, d0_.keyword AS keyword7, d0_.update_url AS update_url8, d0_.create_date AS create_date9, d0_.update_date AS update_date10, d0_.meta_robots AS meta_robots11, d0_.meta_tags AS meta_tags12, d1_.page_id AS page_id13, d1_.target_id AS target_id14, d1_.block_id AS block_id15, d1_.block_row AS block_row16, d1_.anywhere AS anywhere17, d2_.block_id AS block_id18, d2_.block_name AS block_name19, d2_.file_name AS file_name20, d2_.create_date AS create_date21, d2_.update_date AS update_date22, d2_.logic_flg AS logic_flg23, d2_.deletable_flg AS deletable_flg24, d0_.device_type_id AS device_type_id25, d1_.block_id AS block_id26, d1_.page_id AS page_id27, d2_.device_type_id AS device_type_id28 FROM dtb_page_layout d0_ LEFT JOIN dtb_block_position d1_ ON d0_.page_id = d1_.page_id AND (d0_.page_id = d1_.page_id) LEFT JOIN dtb_block d2_ ON d1_.block_id = d2_.block_id WHERE d0_.device_type_id = ? AND d0_.url = ? ORDER BY d1_.target_id ASC, d1_.block_row ASC' with params [10, \"homepage\"]: [2018-08-07 17:57:20,603321] eccube.CRITICAL [dfb07c97] [38e1efc2] [NULL] [LogListener:logException:112] - Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT d0_.page_id AS page_id0, d0_.page_name AS page_name1, d0_.url AS url2, d0_.file_name AS file_name3, d0_.edit_flg AS edit_flg4, d0_.author AS author5, d0_.description AS description6, d0_.keyword AS keyword7, d0_.update_url AS update_url8, d0_.create_date AS create_date9, d0_.update_date AS update_date10, d0_.meta_robots AS meta_robots11, d0_.meta_tags AS meta_tags12, d1_.page_id AS page_id13, d1_.target_id AS target_id14, d1_.block_id AS block_id15, d1_.block_row AS block_row16, d1_.anywhere AS anywhere17, d2_.block_id AS block_id18, d2_.block_name AS block_name19, d2_.file_name AS file_name20, d2_.create_date AS create_date21, d2_.update_date AS update_date22, d2_.logic_flg AS logic_flg23, d2_.deletable_flg AS deletable_flg24, d0_.device_type_id AS device_type_id25, d1_.block_id AS block_id26, d1_.page_id AS page_id27, d2_.device_type_id AS device_type_id28 FROM dtb_page_layout d0_ LEFT JOIN dtb_block_position d1_ ON d0_.page_id = d1_.page_id AND (d0_.page_id = d1_.page_id) LEFT JOIN dtb_block d2_ ON d1_.block_id = d2_.block_id WHERE d0_.device_type_id = ? AND d0_.url = ? ORDER BY d1_.target_id ASC, d1_.block_row ASC' with params [10, "homepage"]: [2018-08-07 17:57:20,522976] eccube.INFO [dfb07c97] [38e1efc2] [NULL] [LogListener:logRequest:83] - > GET / [GET, /, 125.174.192.159, NULL, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] [2018-08-07 17:57:20,520897] eccube.INFO [dfb07c97] [38e1efc2] [NULL] [AnonymousAuthenticationListener:handle:62] - Populated the TokenStorage with an anonymous Token. [GET, /, 125.174.192.159, NULL, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] [2018-08-07 17:57:20,518308] eccube.INFO [NULL] [38e1efc2] [NULL] [RouterListener:onKernelRequest:146] - Matched route "homepage". {"route_parameters":{"_controller":"\\Eccube\\Controller\\TopController::index","_route":"homepage"},"request_uri":"https://****/"} [GET, /, 125.174.192.159, NULL, Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko] [2018-08-07 17:57:06,570285] eccube.INFO [720b2c18] [18aaed81] [NULL] [LogListener:logResponse:96] - < 500 [GET, /, 18.208.170.155, NULL, Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0)] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd0_.meta_tags' in 'field list' at /home/**/www/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71, Doctrine\\DBAL\\Driver\\PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd0_.meta_tags' in 'field list' at /home/**/www/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd0_.meta_tags' in 'field list' at /home/**/www/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} [GET, /, 18.208.170.155, NULL, Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0)] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'd0_.meta_tags' in 'field list' (uncaught exception) at /home/**/www/store/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 71 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT d0_.page_id AS page_id0, d0_.page_name AS page_name1, d0_.url AS url2, d0_.file_name AS file_name3, d0_.edit_flg AS edit_flg4, d0_.author AS author5, d0_.description AS description6, d0_.keyword AS keyword7, d0_.update_url AS update_url8, d0_.create_date AS create_date9, d0_.update_date AS update_date10, d0_.meta_robots AS meta_robots11, d0_.meta_tags AS meta_tags12, d1_.page_id AS page_id13, d1_.target_id AS target_id14, d1_.block_id AS block_id15, d1_.block_row AS block_row16, d1_.anywhere AS anywhere17, d2_.block_id AS block_id18, d2_.block_name AS block_name19, d2_.file_name AS file_name20, d2_.create_date AS create_date21, d2_.update_date AS update_date22, d2_.logic_flg AS logic_flg23, d2_.deletable_flg AS deletable_flg24, d0_.device_type_id AS device_type_id25, d1_.block_id AS block_id26, d1_.page_id AS page_id27, d2_.device_type_id AS device_type_id28 FROM dtb_page_layout d0_ LEFT JOIN dtb_block_position d1_ ON d0_.page_id = d1_.page_id AND (d0_.page_id = d1_.page_id) LEFT JOIN dtb_block d2_ ON d1_.block_id = d2_.block_id WHERE d0_.device_type_id = ? AND d0_.url = ? ORDER BY d1_.target_id ASC, d1_.block_row ASC' with params [10, \"homepage\"]: [2018-08-07 17:57:06,562491] eccube.CRITICAL [720b2c18] [18aaed81] [NULL] [LogListener:logException:112] - Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'SELECT d0_.page_id AS page_id0, d0_.page_name AS page_name1, d0_.url AS url2, d0_.file_name AS file_name3, d0_.edit_flg AS edit_flg4, d0_.author AS author5, d0_.description AS description6, d0_.keyword AS keyword7, d0_.update_url AS update_url8, d0_.create_date AS create_date9, d0_.update_date AS update_date10, d0_.meta_robots AS meta_robots11, d0_.meta_tags AS meta_tags12, d1_.page_id AS page_id13, d1_.target_id AS target_id14, d1_.block_id AS block_id15, d1_.block_row AS block_row16, d1_.anywhere AS anywhere17, d2_.block_id AS block_id18, d2_.block_name AS block_name19, d2_.file_name AS file_name20, d2_.create_date AS create_date21, d2_.update_date AS update_date22, d2_.logic_flg AS logic_flg23, d2_.deletable_flg AS deletable_flg24, d0_.device_type_id AS device_type_id25, d1_.block_id AS block_id26, d1_.page_id AS page_id27, d2_.device_type_id AS device_type_id28 FROM dtb_page_layout d0_ LEFT JOIN dtb_block_position d1_ ON d0_.page_id = d1_.page_id AND (d0_.page_id = d1_.page_id) LEFT JOIN dtb_block d2_ ON d1_.block_id = d2_.block_id WHERE d0_.device_type_id = ? AND d0_.url = ? ORDER BY d1_.target_id ASC, d1_.block_row ASC' with params [10, "homepage"]: [2018-08-07 17:57:06,482823] eccube.INFO [720b2c18] [18aaed81] [NULL] [LogListener:logRequest:83] - > GET / [GET, /, 18.208.170.155, NULL, Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0)] [2018-08-07 17:57:06,480761] eccube.INFO [NULL] [18aaed81] [NULL] [AnonymousAuthenticationListener:handle:62] - Populated the TokenStorage with an anonymous Token. [GET, /, 18.208.170.155, NULL, Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0)] [2018-08-07 17:57:06,478289] eccube.INFO [NULL] [18aaed81] [NULL] [RouterListener:onKernelRequest:146] - Matched route "homepage". {"route_parameters":{"_controller":"\\Eccube\\Controller\\TopController::index","_route":"homepage"},"request_uri":"http://****/"} [GET, /, 18.208.170.155, NULL, Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0)] |
フラット表示 | 前のトピック | 次のトピック |
題名 | 投稿者 | 日時 |
---|---|---|
» フロント画面、ページ管理画面にシステムエラーがでる | sie | 2018/8/7 18:42 |
Re: フロント画面、ページ管理画面にシステムエラーがでる | 468 | 2018/8/7 19:09 |
Re: フロント画面、ページ管理画面にシステムエラーがでる | sie | 2018/8/8 10:40 |