質問 > その他 > 助けて下さい |
その他
フラット表示 | 前のトピック | 次のトピック |
投稿者 | スレッド |
---|---|
dodozou3 |
投稿日時: 2013/7/8 21:13
対応状況: −−−
|
新米 登録日: 2013/7/8 居住地: 投稿: 2 |
助けて下さい 急に下記のエラーが出てしまって困っています。
いろいろやって見てるのですが、初心者なもので 解決出来ません。 どうかご助言お願いします。 Fatal error(E_USER_ERROR): DB処理でエラーが発生しました。 SQL: [SELECT product_id ,product_code_min ,product_code_max ,name ,comment1 ,comment2 ,comment3 ,main_list_comment ,main_image ,main_list_image ,price01_min ,price01_max ,price02_min ,price02_max ,stock_min ,stock_max ,stock_unlimited_min ,stock_unlimited_max ,deliv_date_id ,status ,del_flg ,update_date FROM ( SELECT dtb_products.product_id ,dtb_products.name ,dtb_products.maker_id ,dtb_products.status ,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.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.stock_min ,T4.stock_max ,T4.stock_unlimited_min ,T4.stock_unlimited_max ,T4.point_rate ,T4.deliv_fee ,T4.class_count ,dtb_maker.name AS maker_name 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(stock) AS stock_min, MAX(stock) AS stock_max, MIN(stock_unlimited) AS stock_unlimited_min, MAX(stock_unlimited) AS stock_unlimited_max, MAX(point_rate) AS point_rate, MAX(deliv_fee) AS deliv_fee, 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 ) AS alldtl WHERE alldtl.product_id IN (?,?,?,?) AND alldtl.del_flg = 0 ] MDB2 Error: no such field prepare: [Error message: Unable to create prepared statement handle] [Last executed query: DEALLOCATE PREPARE mdb2_statement_pgsql_1206e431e97c9b2ab72ef4612d033d9561392895fd] [Native message: ERROR: column dtb_products.sub_title7 does not exist LINE 63: ... ,dtb_products.sub_large_image6,dtb_produc... ^] on [/data/class/SC_Query.php(1007)] from 111.87.41.73 customer_id = /doc_root/index.php(33): LC_Page_Index_Ex->process /data/class_extends/page_extends/LC_Page_Index_Ex.php(56): LC_Page_Index->process /data/class/pages/LC_Page_Index.php(56): LC_Page->sendResponse /data/class/pages/LC_Page.php(144): SC_Display->prepare /data/class/SC_Display.php(77): SC_View->getResponse /data/class/SC_View.php(100): Smarty->fetch /data/module/Smarty/libs/Smarty.class.php(1263): include /data/Smarty/templates_c/06/%%F1^F15^F158E3F4%%site_frame.tpl.php(114): Smarty->_smarty_include /data/module/Smarty/libs/Smarty.class.php(1869): include /data/Smarty/templates_c/06/%%58^587^5876E692%%site_main.tpl.php(149): smarty_core_smarty_include_php /data/module/Smarty/libs/internals/core.smarty_include_php.php(40): Smarty->_include /data/module/Smarty/libs/Smarty.class.php(1923): include /doc_root/frontparts/bloc/recommend.php(35): LC_Page_FrontParts_Bloc_Recommend_Ex->process /data/class_extends/page_extends/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend_Ex.php(56): LC_Page_FrontParts_Bloc_Recommend->process /data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php(54): LC_Page_FrontParts_Bloc_Recommend->action /data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php(70): LC_Page_FrontParts_Bloc_Recommend->lfGetRanking /data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php(111): SC_Product->getListByProductIds /data/class/SC_Product.php(180): SC_Product->lists /data/class/SC_Product.php(155): SC_Query->select /data/class/SC_Query.php(167): SC_Query->getAll /data/class/SC_Query.php(279): SC_Query->prepare /data/class/SC_Query.php(948): SC_Query->error /data/class/SC_Query.php(1007): trigger_error |
フラット表示 | 前のトピック | 次のトピック |
題名 | 投稿者 | 日時 |
---|---|---|
» 助けて下さい | dodozou3 | 2013/7/8 21:13 |
Re: 助けて下さい | red | 2013/7/8 22:11 |
Re: 助けて下さい | bratech | 2013/7/8 22:14 |
Re: 助けて下さい | dodozou3 | 2013/7/10 7:50 |