バージョン選択
フォーラム
メニュー
オンライン状況
|
 |
127 人のユーザが現在オンラインです。 (122 人のユーザが フォーラム を参照しています。) |
|
|
| 質問 > 管理機能 > 商品マスタ CSVダウンロードのシステムエラー |
|
管理機能
| 投稿者 |
スレッド |
| illfrog300 |
投稿日時: 2009/9/14 14:24
対応状況: −−−
|
一人前   登録日: 2009/5/4 居住地: 投稿: 106 |
商品マスタ CSVダウンロードのシステムエラー いつもお世話になっております。 先日、商品登録の項目を新規追加し、それに合わせてCSVでダウンロード出来るようにdtb_csvに追加カラムで カラム名「cartkill」を追加しました。 設定は csv_id： 1 col： cartkill disp_name: ポイント機能ON:OFF rank: 59 status: 1 としました。 この段階で商品マスタのCSVダウンロードをクリックしますと 下記のエラーが出力されます。 引用：
SELECT product_id, product_class_id, classcategory_id1, classcategory_id2, name, status, product_flag, product_code, price01, price02, stock, deliv_fee, point_rate, sale_limit, comment1, comment3, note, main_list_comment, main_list_image, main_comment, main_image, main_large_image, file1, file2, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, deliv_date_id, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_product_id1, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_comment1, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_product_id2, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_comment2, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_product_id3, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_comment3, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id4, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment4, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_product_id5, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_comment5, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_product_id6, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_comment6, cartkill FROM vw_product_class AS prdcls WHERE del_flg = 0 ORDER BY update_date DESC, product_id DESC
DB Error: no such field
SELECT product_id, product_class_id, classcategory_id1, classcategory_id2, name, status, product_flag, product_code, price01, price02, stock, deliv_fee, point_rate, sale_limit, comment1, comment3, note, main_list_comment, main_list_image, main_comment, main_image, main_large_image, file1, file2, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, deliv_date_id, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_product_id1, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_comment1, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_product_id2, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_comment2, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_product_id3, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_comment3, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id4, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment4, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_product_id5, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_comment5, (SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_product_id6, (SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_comment6, cartkill FROM vw_product_class AS prdcls WHERE del_flg = 0 ORDER BY update_date DESC, product_id DESC [nativecode=ERROR: column "cartkill" does not exist]
/var/www/html/admin/products/index.php 34:LC_Page_Admin_Products_Ex->process
/var/www/html/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_Ex.php 56:LC_Page_Admin_Products->process
/var/www/html/data/class/pages/admin/products/LC_Page_Admin_Products.php 263:SC_Helper_CSV->lfGetProductsCSV
/var/www/html/data/class/helper/SC_Helper_CSV.php 112:SC_Query->select
/var/www/html/data/class/SC_Query.php 95:SC_DbConn->getAll
/var/www/html/data/class/SC_DbConn.php 162:DB_common->getAll
/var/www/html/data/module/DB/common.php 1613:DB_common->query
/var/www/html/data/module/DB/common.php 1167:DB_pgsql->simpleQuery
/var/www/html/data/module/DB/pgsql.php 338:DB_pgsql->pgsqlRaiseError
/var/www/html/data/module/DB/pgsql.php 786:DB_common->raiseError
/var/www/html/data/module/DB/common.php 1853:PEAR->raiseError
/var/www/html/data/module/PEAR.php 557:DB_Error->DB_Error
/var/www/html/data/module/DB.php 893:PEAR_Error->PEAR_Error
どうも、cartkillのカラムを正常に参照出来ていない為に 発生しているかと思うのですが、どのファイルのどの部分を どのように修正しなければならないのか検討がつかず 3日ほど悩みあげています。 どなたかお詳しい方がいらっしゃいましたらお知恵をお貸しください＞＜； 過去スレでかなり酷似したスレを発見致しましたが 解決には結びつきませんでした。。 http://xoops.ec-cube.net/modules/newbb/viewtopic.php?viewmode=thread&topic_id=3121&forum=9&post_id=12034#forumpost12034 |
|
|
|
統計情報
総メンバー数は90,251名です
総投稿数は110,349件です
|
どうか教えて下さい！
商品マスタ CSVダウンロードのシステムエラー
