Notice (8): Undefined variable: i_year [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 190]
Notice (8): Undefined variable: i_year [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 195]
Notice (8): Undefined variable: i_year [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 196]
Notice (8): Undefined variable: i_sex_code [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 200]
Notice (8): Undefined variable: i_sex_code [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 202]
Notice (8): Undefined variable: i_season_code [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 208]
Notice (8): Undefined variable: i_season_code [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 210]
Notice (8): Undefined variable: i_maker_code [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 218]
Notice (8): Undefined variable: i_code [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 218]
Notice (8): Undefined variable: i_maker_code [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 219]
Notice (8): Undefined variable: i_maker_code [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 219]
Notice (8): Undefined variable: i_code [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 219]
Notice (8): Undefined variable: b2_name [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 224]
Notice (8): Undefined variable: ic_name [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 225]
Notice (8): Undefined variable: i_code [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 228]
Notice (8): Undefined variable: i_name [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 229]
Notice (8): Undefined variable: i_year [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 230]
Notice (8): Undefined variable: mk_name [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 231]
Notice (8): Undefined variable: teika_zeikomi [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 232]
Notice (8): Undefined variable: mk_cutrate1 [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 233]
Notice (8): Undefined variable: mk_cutrate5 [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 234]
Notice (8): Undefined variable: i_price1_zeikomi [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 235]
Notice (8): Undefined variable: basic_point_rate [/home/common_pc_shops/htdocs/item_page/mod_item_sakuin.php, line 236]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
CakePHP: the rapid development php framework: Errors

Database Error

Error: SQLSTATE[57P01]: Admin shutdown: 7 FATAL: 管理者コマンドにより接続を終了しています server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

SQL Query: SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1~4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('111996') and i_delete is not true;

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
Notice (8): compact() [function.compact]: Undefined variable: subject [CORE/Cake/Utility/ObjectCollection.php, line 128]
(default) 3 queries took 45 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT CASE WHEN i_point_rate IS NOT NULL THEN i_point_rate * 100 WHEN s_basic_point_rate IS NOT NULL THEN s_basic_point_rate END AS basic_point_rate , --割引率 CASE WHEN i_rate IS NOT NULL THEN round((1 - i_rate)* 100) WHEN mk_rate IS NOT NULL THEN round( (1 - mk_rate )* 100) WHEN s_rate IS NOT NULL THEN round((1 - s_rate)* 100) END AS mk_cutrate1, CASE WHEN i_rate5 IS NOT NULL THEN round((1 - i_rate5)* 100) WHEN mk_rate5 IS NOT NULL THEN round((1 - mk_rate5 )* 100) WHEN s_rate5 IS NOT NULL THEN round((1 - s_rate5)* 100) END AS mk_cutrate5, --購入商品数1~4の税込価格 CASE WHEN i_rate IS NOT NULL THEN round(round ( cast((i_price1*i_rate + FLOOR(round(i_price1*i_rate*s_tax)/100))as numeric),1)) WHEN mk_rate IS NOT NULL THEN round(round ( cast((i_price1*mk_rate + FLOOR(round(i_price1*mk_rate*s_tax)/100))as numeric),1)) WHEN s_rate IS NOT NULL THEN round(round ( cast((i_price1*s_rate + FLOOR(round(i_price1*s_rate*s_tax)/100))as numeric),1)) END AS i_price1_zeikomi, CASE WHEN i_open_flag = false THEN cast(i_price1 as text) ELSE 'オープン価格' END AS teika_zeinuki, CASE WHEN i_open_flag = false THEN cast( i_price1+ FLOOR(round(i_price1*s_tax)/100) as text) ELSE 'オープン価格' END AS teika_zeikomi ,i_maker_code ,i_sex_code ,i_season_code ,i_code ,i_name ,i_year ,i_recommend_flag ,i_secret_flag ,i_open_flag ,i_category_code1 ,ic_name ,b2_name ,b2_code ,mk_name ,mk_rate ,mk_show_price ,mk_rate FROM item_info INNER JOIN maker_info AS maker ON (item_info.i_maker_code = maker.mk_code) INNER JOIN bunrui2_info AS bunrui2 ON (item_info.i_category_code2 = bunrui2.b2_code) INNER JOIN itemcode_info AS itemcode ON (item_info.i_item_code = itemcode.ic_code) INNER JOIN setup_info AS setup ON 1=1 WHERE i_identity in('60007') and i_delete is not true; 0017