バージョン選択

フォーラム

メニュー

オンライン状況

51 人のユーザが現在オンラインです。 (40 人のユーザが フォーラム を参照しています。)
登録ユーザ: 0
ゲスト: 51
もっと...

サイト内検索

質問 > フロント機能 > フロント画面、ページ管理画面にシステムエラーがでる

フロント機能

新規スレッドを追加する

スレッド表示 | 新しいものから 前のトピック | 次のトピック | 下へ
投稿者 スレッド
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)]
468
投稿日時: 2018/8/7 19:09
対応状況: −−−
登録日: 2008/10/26
居住地:
投稿: 3217
Re: フロント画面、ページ管理画面にシステムエラーがでる
DBのdtb_page_layoutテーブルのカラム「meta_tags」が見つからないというエラーが出ているようです。
3.0.10と3.0.16では、DB構造が少し異なる為、
そのままデータベースを利用すると、今回のようなエラーが発生するかと思います。
(どこが異なるのか比較しないと正確な差異は分かりませんが...)
エラーを見つけて、1つずつカラムを修正していく必要があるかもしれません。


----------------
株式会社シロハチ
■ECCUBE2系、3系構築カスタマイズご相談ください。
EC-CUBE3マニュアル
blog

sie
投稿日時: 2018/8/8 10:40
対応状況: −−−
新米
登録日: 2018/8/7
居住地:
投稿: 9
Re: フロント画面、ページ管理画面にシステムエラーがでる
ご返信ありがとうございます。
カラムを修正したら無事エラーは消えました。
重ねてご指摘ありがとうございます。
色々検討しながら進めていこうと思います。
スレッド表示 | 新しいものから 前のトピック | 次のトピック | トップ


 



ログイン


EC-CUBE公式 Amazon Payプラグイン

統計情報

総メンバー数は88,288名です
総投稿数は109,688件です

投稿数ランキング

1
seasoft
7365
2
468
3217
3
AMUAMU
2712
4
nanasess
2303
5
umebius
2085
6
yuh
1818
7
h_tanaka
1610
8
red
1567
9
mcontact
1240
10
tsuji
958
11
fukap
907
12
shutta
835
13
tao_s
796
14 ramrun 789
15 karin 689
16 sumida 641
17
homan
633
18 DELIGHT 572
19
patapata
502
20
flealog
485


ネットショップの壺

EC-CUBEインテグレートパートナー

Copyright© EC-CUBE CO.,LTD. All Rights Reserved.