Changes between Initial Version and Version 1 of Ticket #1044


Ignore:
Timestamp:
2011/02/22 17:22:34 (15 years ago)
Author:
kotani
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #1044

    • Property Summary changed from [管理画面]顧客管理：MySQLの場合、顧客CSVダウンロードで構文エラー to [管理画面]顧客管理/受注管理：MySQLの場合、CSVダウンロードでSQL構文エラー

  • Ticket #1044 – Description

    initial v1  
     1管理画面＞顧客管理＞CSVダウンロード[[BR]] 
    12 
    23{{{ 
    … …  
    1112 
    1213}}} 
     14 
     15管理画面＞受注管理＞CSVダウンロード[[BR]] 
     16 
     17 
     18{{{ 
     19SQL: SELECT order_id, customer_id, message, order_name01, order_name02, order_kana01, order_kana02, order_email, order_tel01, order_tel02, order_tel03, order_fax01, order_fax02, order_fax03, order_zip01, order_zip02, (SELECT name FROM mtb_pref WHERE CAST(mtb_pref.id AS smallint) = dtb_order.order_pref), order_addr01, order_addr02, order_sex, order_birth, order_job, subtotal, discount, deliv_fee, charge, use_point, add_point, tax, total, payment_total, deliv_id, payment_method, note, status, create_date, create_date, commit_date, device_type_id, (SELECT COUNT(shipping_id) as shipping_target_num FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id), (SELECT GROUP_CONCAT(shipping_id SEPARATOR ',') FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id) as shipping_ids FROM dtb_order WHERE del_flg = 0 ORDER BY update_date DESC 
     20 
     21MDB2 Error: syntax error 
     22 
     23_doQuery: [Error message: Could not execute statement] 
     24[Last executed query: PREPARE mdb2_statement_mysql_47efbbdb8784f26f78ddac09385fe759f5247a139 FROM 'SELECT order_id, customer_id, message, order_name01, order_name02, order_kana01, order_kana02, order_email, order_tel01, order_tel02, order_tel03, order_fax01, order_fax02, order_fax03, order_zip01, order_zip02, (SELECT name FROM mtb_pref WHERE CAST(mtb_pref.id AS smallint) = dtb_order.order_pref), order_addr01, order_addr02, order_sex, order_birth, order_job, subtotal, discount, deliv_fee, charge, use_point, add_point, tax, total, payment_total, deliv_id, payment_method, note, status, create_date, create_date, commit_date, device_type_id, (SELECT COUNT(shipping_id) as shipping_target_num FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id), (SELECT GROUP_CONCAT(shipping_id SEPARATOR \',\') FROM dtb_shipping WHERE dtb_shipping.order_id = dtb_order.order_id) as shipping_ids FROM dtb_order WHERE del_flg = 0 ORDER BY update_date DESC'] 
     25[Native code: 1064] 
     26[Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'smallint) = dtb_order.order_pref), order_addr01, order_addr02, order_sex, order_' at line 1] 
     27}}}