patapata様


テストで一件詳細サブコメント(1)を空欄にし
（htmlソースが入力されていました）アップロードしましたら
以下のエラー文が表示されました

/////////////////////////////////////////////////////////

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



http://www.hogehoge.com/admin/products/upload_csv.php

SERVER_ADDR:***.**.**.**
REMOTE_ADDR:***.**.**.**
USER_AGENT:Mozilla/5.0 (Windows; U; Windows NT 5.1; ja; rv:1.9.2.14) Gecko/20110218 Firefox/3.6.14 GTB7.1 ( .NET CLR 3.5.30729)

UPDATE dtb_products SET product_id= ?,name= ?,status= ?,product_flag= ?,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= ?,update_date= ?,creator_id= ?,sale_unlimited= ? WHERE product_id = ?
DB Error: unknown error

UPDATE dtb_products SET product_id= '14',name= '?i??A(?',status= '2',product_flag= '0',deliv_fee= NULL,point_rate= '1',sale_limit= NULL,comment1= NULL,comment3= '?[h?uh',note= NULL,main_list_comment= 'lp??B',main_list_image= '01281006_4d4216880fb72.jpg',main_comment= '<p>CgEFCgR``nO(dグzbvTbNn?WPbgB p^[?v?Ad1/2?B????dオ?B pTCY: LARGE</p>',main_image= '01281006_4d421688112e7.jpg',main_large_image= '01281006_4d4216881743b.jpg',file1= NULL,file2= NULL,sub_title1= NULL,sub_comment1= NULL,sub_image1= '01281307_4d42411f1e4e7.jpg',sub_large_image1= '01281307_4d42411f07d83.jpg',sub_title2= NULL,sub_comment2= NULL,sub_image2= '01281308_4d42412ae1db9.jpg',sub_large_image2= '01281308_4d42412aca28d.jpg',sub_title3= NULL,sub_comment3= NULL,sub_image3= '01281308_4d424135c5bfe.jpg',sub_large_image3= '01281308_4d424135af8c2.jpg',sub_title4= NULL,sub_comment4= NULL,sub_image4= NULL,sub_large_image4= NULL,sub_title5= NULL,sub_comment5= NULL,sub_image5= NULL,sub_large_image5= NULL,deliv_date_id= '3',update_date= '2011-03-03 11:33:35.000002',creator_id= '2',sale_unlimited= '1' WHERE product_id = '14' [nativecode=ERROR: invalid byte sequence for encoding "UTF8": 0xf5838f81
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".]

/var/www/vhosts/hogehoge.com/httpdocs/admin/products/upload_csv.php 33:LC_Page_Admin_Products_UploadCSV_Ex->process
/var/www/vhosts/hogehoge.com/httpdocs/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_UploadCSV_Ex.php 56:LC_Page_Admin_Products_UploadCSV->process
/var/www/vhosts/hogehoge.com/httpdocs/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php 172:LC_Page_Admin_Products_UploadCSV->lfRegistProduct
/var/www/vhosts/hogehoge.com/httpdocs/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php 362:SC_Query->update
/var/www/vhosts/hogehoge.com/httpdocs/data/class/SC_Query.php 366:SC_DbConn->query
/var/www/vhosts/hogehoge.com/httpdocs/data/class/SC_DbConn.php 82:DB_common->query
/var/www/vhosts/hogehoge.com/httpdocs/data/module/DB/common.php 1162:DB_common->execute
/var/www/vhosts/hogehoge.com/httpdocs/data/module/DB/common.php 959:DB_pgsql->simpleQuery
/var/www/vhosts/hogehoge.com/httpdocs/data/module/DB/pgsql.php 338:DB_pgsql->pgsqlRaiseError
/var/www/vhosts/hogehoge.com/httpdocs/data/module/DB/pgsql.php 786:DB_common->raiseError
/var/www/vhosts/hogehoge.com/httpdocs/data/module/DB/common.php 1853:PEAR->raiseError
/var/www/vhosts/hogehoge.com/httpdocs/data/module/PEAR.php 557:DB_Error->DB_Error
/var/www/vhosts/hogehoge.com/httpdocs/data/module/DB.php 893:PEAR_Error->PEAR_Error

/////////////////////////////////////////////////////////

ドメインとIPは伏せさせていただきます。