id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	modified_flg
1060	[管理画面]商品管理（商品並び替え）：vw_products_allclassを使っているためDBエラー	kotani	kotani	"VIEWはすべて削除しましたので、VIEWを使わないよう修正が必要です。[[BR]]


{{{
▼▼▼ デバッグ情報ここから ▼▼▼

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
▲▲▲ エラーメッセージ ▲▲▲


▲▲▲ デバッグ情報ここまで ▲▲▲
}}}
"	バグ指摘	closed	中	EC-CUBE2.11.0	管理画面	2.11.0 β	修正済