▼▼▼ デバッグ情報ここから ▼▼▼
http://www.gaydvdshop.jp/products/list.php?comp_id=1003?comp_id=1003

SERVER_ADDR: 100.64.0.11
REMOTE_ADDR: 34.229.131.116
USER_AGENT: CCBot/2.0 (https://commoncrawl.org/faq/)

Fatal error(E_USER_ERROR): DB処理でエラーが発生しました。
SQL: [SELECT COUNT(*) FROM             (                 SELECT                      dtb_products.product_id                     ,dtb_products.maker_code                     ,dtb_products.subname1                     ,dtb_products.subname2                     ,dtb_products.subname3                     ,dtb_products.name                     ,dtb_products.sale_type_id                     ,dtb_products.maker_id                     ,dtb_products.label_id                     ,dtb_products.supplier_id                     ,dtb_products.status                     ,dtb_products.release_year                     ,dtb_products.release_month                     ,dtb_products.release_day                     ,dtb_products.release_area                     ,dtb_products.playback_time                     ,dtb_products.good                     ,dtb_products.sell_start_date                     ,dtb_products.sell_end_date                     ,dtb_products.comment1                     ,dtb_products.comment2                     ,dtb_products.comment3                     ,dtb_products.comment4                     ,dtb_products.comment5                     ,dtb_products.comment6                     ,dtb_products.note                     ,dtb_products.main_list_comment                     ,dtb_products.main_list_image                     ,dtb_products.main_comment                     ,dtb_products.main_image                     ,dtb_products.main_large_image                     ,dtb_products.sub_title1                     ,dtb_products.sub_comment1                     ,dtb_products.sub_image1                     ,dtb_products.sub_large_image1                     ,dtb_products.sub_title2                     ,dtb_products.sub_comment2                     ,dtb_products.sub_image2                     ,dtb_products.sub_large_image2                     ,dtb_products.sub_title3                     ,dtb_products.sub_comment3                     ,dtb_products.sub_image3                     ,dtb_products.sub_large_image3                     ,dtb_products.sub_title4                     ,dtb_products.sub_comment4                     ,dtb_products.sub_image4                     ,dtb_products.sub_large_image4                     ,dtb_products.sub_title5                     ,dtb_products.sub_comment5                     ,dtb_products.sub_image5                     ,dtb_products.sub_large_image5                     ,dtb_products.sub_title6                     ,dtb_products.sub_comment6                     ,dtb_products.sub_image6                     ,dtb_products.sub_large_image6                     ,dtb_products.sub_title7                     ,dtb_products.sub_comment7                     ,dtb_products.sub_image7                     ,dtb_products.sub_large_image7                     ,dtb_products.sub_title8                     ,dtb_products.sub_comment8                     ,dtb_products.sub_image8                     ,dtb_products.sub_large_image8                     ,dtb_products.sub_title9                     ,dtb_products.sub_comment9                     ,dtb_products.sub_image9                     ,dtb_products.sub_large_image9                     ,dtb_products.sub_title10                     ,dtb_products.sub_comment10                     ,dtb_products.sub_image10                     ,dtb_products.sub_large_image10                     ,dtb_products.sub_title11                     ,dtb_products.sub_comment11                     ,dtb_products.sub_image11                     ,dtb_products.sub_large_image11                     ,dtb_products.sub_title12                     ,dtb_products.sub_comment12                     ,dtb_products.sub_image12                     ,dtb_products.sub_large_image12                     ,dtb_products.del_flg                     ,dtb_products.creator_id                     ,dtb_products.create_date                     ,dtb_products.update_date                     ,dtb_products.deliv_date_id                     ,T4.product_code_min                     ,T4.product_code_max                     ,T4.price01_min                     ,T4.price01_max                     ,T4.price02_min                     ,T4.price02_max                     ,T4.supplier_price_min                     ,T4.supplier_price_max                     ,T4.stock_min                     ,T4.stock_max                     ,T4.stock_unlimited_min                     ,T4.stock_unlimited_max                     ,T4.sample_movie_flv                     ,T4.sample_movie_webm                     ,T4.sample_movie_mp4                     ,T4.point_rate                     ,T4.deliv_fee                     ,T4.sel_flg                     ,T4.class_count                     ,dtb_maker.name AS maker_name                     ,dtb_maker.kana AS maker_kana                     ,dtb_label.name AS label_name                     ,dtb_label.kana AS label_kana                 FROM dtb_products                     JOIN (                         SELECT product_id,                             MIN(product_code) AS product_code_min,                             MAX(product_code) AS product_code_max,                             MIN(price01) AS price01_min,                             MAX(price01) AS price01_max,                             MIN(price02) AS price02_min,                             MAX(price02) AS price02_max,                             MIN(supplier_price) AS supplier_price_min,                             MAX(supplier_price) AS supplier_price_max,                             MIN(stock) AS stock_min,                             MAX(stock) AS stock_max,                             MIN(stock_unlimited) AS stock_unlimited_min,                             MAX(stock_unlimited) AS stock_unlimited_max,                             MAX(sample_movie_flv) AS sample_movie_flv,                             MAX(sample_movie_webm) AS sample_movie_webm,                             MAX(sample_movie_mp4) AS sample_movie_mp4,                             MAX(point_rate) AS point_rate,                             MAX(deliv_fee) AS deliv_fee,                             MAX(sel_flg) AS sel_flg,                             COUNT(*) as class_count                         FROM dtb_products_class                         WHERE del_flg = 0                          GROUP BY product_id                     ) AS T4                         ON dtb_products.product_id = T4.product_id                     LEFT JOIN dtb_maker                         ON dtb_products.maker_id = dtb_maker.maker_id                     LEFT JOIN dtb_label                         ON dtb_products.label_id = dtb_label.label_id             ) AS alldtl LEFT JOIN dtb_products_class AS pc ON alldtl.product_id = pc.product_id WHERE alldtl.del_flg = 0 AND alldtl.status = 1 AND alldtl.comp_id = ?  AND (alldtl.sell_end_date > ? OR alldtl.sell_end_date is null) AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = alldtl.product_id AND alldtl.del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))   ]
MDB2 Error: no such field
_doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_8cb7e03dff1a7a7bdd97dcd38cc7aecde55433325 FROM 'SELECT COUNT(*) FROM             (                 SELECT                      dtb_products.product_id                     ,dtb_products.maker_code                     ,dtb_products.subname1                     ,dtb_products.subname2                     ,dtb_products.subname3                     ,dtb_products.name                     ,dtb_products.sale_type_id                     ,dtb_products.maker_id                     ,dtb_products.label_id                     ,dtb_products.supplier_id                     ,dtb_products.status                     ,dtb_products.release_year                     ,dtb_products.release_month                     ,dtb_products.release_day                     ,dtb_products.release_area                     ,dtb_products.playback_time                     ,dtb_products.good                     ,dtb_products.sell_start_date                     ,dtb_products.sell_end_date                     ,dtb_products.comment1                     ,dtb_products.comment2                     ,dtb_products.comment3                     ,dtb_products.comment4                     ,dtb_products.comment5                     ,dtb_products.comment6                     ,dtb_products.note                     ,dtb_products.main_list_comment                     ,dtb_products.main_list_image                     ,dtb_products.main_comment                     ,dtb_products.main_image                     ,dtb_products.main_large_image                     ,dtb_products.sub_title1                     ,dtb_products.sub_comment1                     ,dtb_products.sub_image1                     ,dtb_products.sub_large_image1                     ,dtb_products.sub_title2                     ,dtb_products.sub_comment2                     ,dtb_products.sub_image2                     ,dtb_products.sub_large_image2                     ,dtb_products.sub_title3                     ,dtb_products.sub_comment3                     ,dtb_products.sub_image3                     ,dtb_products.sub_large_image3                     ,dtb_products.sub_title4                     ,dtb_products.sub_comment4                     ,dtb_products.sub_image4                     ,dtb_products.sub_large_image4                     ,dtb_products.sub_title5                     ,dtb_products.sub_comment5                     ,dtb_products.sub_image5                     ,dtb_products.sub_large_image5                     ,dtb_products.sub_title6                     ,dtb_products.sub_comment6                     ,dtb_products.sub_image6                     ,dtb_products.sub_large_image6                     ,dtb_products.sub_title7                     ,dtb_products.sub_comment7                     ,dtb_products.sub_image7                     ,dtb_products.sub_large_image7                     ,dtb_products.sub_title8                     ,dtb_products.sub_comment8                     ,dtb_products.sub_image8                     ,dtb_products.sub_large_image8                     ,dtb_products.sub_title9                     ,dtb_products.sub_comment9                     ,dtb_products.sub_image9                     ,dtb_products.sub_large_image9                     ,dtb_products.sub_title10                     ,dtb_products.sub_comment10                     ,dtb_products.sub_image10                     ,dtb_products.sub_large_image10                     ,dtb_products.sub_title11                     ,dtb_products.sub_comment11                     ,dtb_products.sub_image11                     ,dtb_products.sub_large_image11                     ,dtb_products.sub_title12                     ,dtb_products.sub_comment12                     ,dtb_products.sub_image12                     ,dtb_products.sub_large_image12                     ,dtb_products.del_flg                     ,dtb_products.creator_id                     ,dtb_products.create_date                     ,dtb_products.update_date                     ,dtb_products.deliv_date_id                     ,T4.product_code_min                     ,T4.product_code_max                     ,T4.price01_min                     ,T4.price01_max                     ,T4.price02_min                     ,T4.price02_max                     ,T4.supplier_price_min                     ,T4.supplier_price_max                     ,T4.stock_min                     ,T4.stock_max                     ,T4.stock_unlimited_min                     ,T4.stock_unlimited_max                     ,T4.sample_movie_flv                     ,T4.sample_movie_webm                     ,T4.sample_movie_mp4                     ,T4.point_rate                     ,T4.deliv_fee                     ,T4.sel_flg                     ,T4.class_count                     ,dtb_maker.name AS maker_name                     ,dtb_maker.kana AS maker_kana                     ,dtb_label.name AS label_name                     ,dtb_label.kana AS label_kana                 FROM dtb_products                     JOIN (                         SELECT product_id,                             MIN(product_code) AS product_code_min,                             MAX(product_code) AS product_code_max,                             MIN(price01) AS price01_min,                             MAX(price01) AS price01_max,                             MIN(price02) AS price02_min,                             MAX(price02) AS price02_max,                             MIN(supplier_price) AS supplier_price_min,                             MAX(supplier_price) AS supplier_price_max,                             MIN(stock) AS stock_min,                             MAX(stock) AS stock_max,                             MIN(stock_unlimited) AS stock_unlimited_min,                             MAX(stock_unlimited) AS stock_unlimited_max,                             MAX(sample_movie_flv) AS sample_movie_flv,                             MAX(sample_movie_webm) AS sample_movie_webm,                             MAX(sample_movie_mp4) AS sample_movie_mp4,                             MAX(point_rate) AS point_rate,                             MAX(deliv_fee) AS deliv_fee,                             MAX(sel_flg) AS sel_flg,                             COUNT(*) as class_count                         FROM dtb_products_class                         WHERE del_flg = 0                          GROUP BY product_id                     ) AS T4                         ON dtb_products.product_id = T4.product_id                     LEFT JOIN dtb_maker                         ON dtb_products.maker_id = dtb_maker.maker_id                     LEFT JOIN dtb_label                         ON dtb_products.label_id = dtb_label.label_id             ) AS alldtl LEFT JOIN dtb_products_class AS pc ON alldtl.product_id = pc.product_id WHERE alldtl.del_flg = 0 AND alldtl.status = 1 AND alldtl.comp_id = ?  AND (alldtl.sell_end_date > ? OR alldtl.sell_end_date is null) AND EXISTS(SELECT * FROM dtb_products_class WHERE product_id = alldtl.product_id AND alldtl.del_flg = 0 AND (stock >= 1 OR stock_unlimited = 1))   ']
[Native code: 1054]
[Native message: Unknown column 'alldtl.comp_id' in 'where clause']
 on [/home/stagpass/gaydvdsdata/class/SC_Query.php(1008)]
/home/stagpass/www/gaydvdshtml/products/list.php(34): LC_Page_Products_List_Ex->process
/home/stagpass/gaydvdsdata/class_extends/page_extends/products/LC_Page_Products_List_Ex.php(56): LC_Page_Products_List->process
/home/stagpass/gaydvdsdata/class/pages/products/LC_Page_Products_List.php(89): LC_Page_Products_List->action
/home/stagpass/gaydvdsdata/class/pages/products/LC_Page_Products_List.php(131): LC_Page_Products_List->lfGetProductAllNum
/home/stagpass/gaydvdsdata/class/pages/products/LC_Page_Products_List.php(437): SC_Product->findProductCount
/home/stagpass/gaydvdsdata/class/SC_Product.php(119): SC_Query->count
/home/stagpass/gaydvdsdata/class/SC_Query.php(137): SC_Query->get
/home/stagpass/gaydvdsdata/class/SC_Query.php(632): SC_Query->getOne
/home/stagpass/gaydvdsdata/class/SC_Query.php(647): SC_Query->prepare
/home/stagpass/gaydvdsdata/class/SC_Query.php(949): SC_Query->error
/home/stagpass/gaydvdsdata/class/SC_Query.php(1008): trigger_error
▲▲▲ デバッグ情報ここまで ▲▲▲
/ システムエラー

システムエラーが発生しました。
大変お手数ですが、サイト管理者までご連絡ください。

  • 戻る