Ticket #1060 (closed バグ指摘: 修正済)

Opened 10 years ago

Last modified 10 years ago

[管理画面]商品管理(商品並び替え):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

comment:1 Changed 10 years ago by kotani

  • Owner changed from somebody to kotani

comment:2 Changed 10 years ago by kotani

  • Status changed from new to closed
  • Resolution set to 修正済

r20548 で修正しました。

Note: See TracTickets for help on using tickets.