Ticket #1060 (closed バグ指摘: 修正済)
[管理画面]商品管理(商品並び替え):vw_products_allclassを使っているためDBエラー
Reported by: | kotani | Owned by: | kotani |
---|---|---|---|
Priority: | 中 | Milestone: | EC-CUBE2.11.0 |
Component: | 管理画面 | Version: | 2.11.0 β |
Keywords: | Cc: | ||
修正済み: |
Description
VIEWはすべて削除しましたので、VIEWを使わないよう修正が必要です。
▼▼▼ デバッグ情報ここから ▼▼▼ http://192.168.56.103/eccube211/admin/products/product_rank.php? SERVER_ADDR: 192.168.56.103 REMOTE_ADDR: 192.168.56.1 USER_AGENT: Mozilla/5.0 (Windows; U; Windows NT 6.1; ja; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13 /mnt/working_copy/eccube211/html/admin/products/product_rank.php 34:LC_Page_Admin_Products_ProductRank_Ex->process /mnt/working_copy/eccube211/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ProductRank_Ex.php 56:LC_Page_Admin_Products_ProductRank->process /mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php 59:LC_Page_Admin_Products_ProductRank->action /mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php 102:LC_Page_Admin_Products_ProductRank->lfGetProduct /mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php 126:SC_Query->count /mnt/working_copy/eccube211/data/class/SC_Query.php 138:SC_Query->getOne /mnt/working_copy/eccube211/data/class/SC_Query.php 595:SC_Query->prepare /mnt/working_copy/eccube211/data/class/SC_Query.php 870:trigger_error ▼▼▼ エラーメッセージ ▼▼▼ https://192.168.56.103/eccube211/admin/products/product_rank.php SERVER_ADDR: 192.168.56.103 REMOTE_ADDR: 192.168.56.1 USER_AGENT: Mozilla/5.0 (Windows; U; Windows NT 6.1; ja; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13 SQL: SELECT COUNT(*) FROM vw_products_allclass AS allcls WHERE del_flg = 0 AND category_id = ? MDB2 Error: no such table prepare: [Error message: Unable to create prepared statement handle] [Last executed query: EXECUTE mdb2_statement_pgsql_33975171cfa1474ffc637aed0b11ee9d368fe7666] [Native message: ERROR: relation "vw_products_allclass" does not exist] /mnt/working_copy/eccube211/html/admin/products/product_rank.php 34:LC_Page_Admin_Products_ProductRank_Ex->process /mnt/working_copy/eccube211/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_ProductRank_Ex.php 56:LC_Page_Admin_Products_ProductRank->process /mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php 59:LC_Page_Admin_Products_ProductRank->action /mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php 102:LC_Page_Admin_Products_ProductRank->lfGetProduct /mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php 126:SC_Query->count /mnt/working_copy/eccube211/data/class/SC_Query.php 138:SC_Query->getOne /mnt/working_copy/eccube211/data/class/SC_Query.php 595:SC_Query->prepare /mnt/working_copy/eccube211/data/class/SC_Query.php 867:MDB2_Driver_pgsql->prepare /mnt/working_copy/eccube211/data/module/MDB2/Driver/pgsql.php 967:MDB2_Driver_Common->raiseError /mnt/working_copy/eccube211/data/module/MDB2.php 1497:PEAR->raiseError /mnt/working_copy/eccube211/data/module/PEAR.php 557:MDB2_Error->MDB2_Error /mnt/working_copy/eccube211/data/module/MDB2.php 1009:PEAR_Error->PEAR_Error ▲▲▲ エラーメッセージ ▲▲▲ ▲▲▲ デバッグ情報ここまで ▲▲▲
Change History
Note: See
TracTickets for help on using
tickets.