Ticket #1095 (closed バグ指摘: 修正済)

Opened 10 years ago

Last modified 10 years ago

[管理画面]商品管理(商品登録CSV):「在庫無制限」を空のまま登録するとDBエラー

Reported by: kotani Owned by: t_yuo
Priority: Milestone: EC-CUBE2.11.0
Component: 管理画面 Version: 2.11.0 β2
Keywords: Cc:
修正済み:

Description (last modified by kotani) (diff)

▼▼▼ デバッグ情報ここから ▼▼▼

http://eccube.local/admin/products/upload_csv.php??

SERVER_ADDR: 192.168.56.103
REMOTE_ADDR: 192.168.56.1
USER_AGENT: Mozilla/5.0 (Windows; U; Windows NT 6.1; ja; rv:1.9.2.14) Gecko/20110218 Firefox/3.6.14 FirePHP/0.5

/mnt/working_copy/eccube211/html/admin/products/upload_csv.php 34:LC_Page_Admin_Products_UploadCSV_Ex->process
/mnt/working_copy/eccube211/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_UploadCSV_Ex.php 56:LC_Page_Admin_Products_UploadCSV->process
/mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php 90:LC_Page_Admin_Products_UploadCSV->action
/mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php 129:LC_Page_Admin_Products_UploadCSV->doUploadCsv
/mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php 235:LC_Page_Admin_Products_UploadCSV->lfRegistProduct
/mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php 404:LC_Page_Admin_Products_UploadCSV->lfRegistProductClass
/mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php 440:SC_Query->update
/mnt/working_copy/eccube211/data/class/SC_Query.php 537:SC_Query->query
/mnt/working_copy/eccube211/data/class/SC_Query.php 735:SC_Query->execute
/mnt/working_copy/eccube211/data/class/SC_Query.php 904:trigger_error
▼▼▼ エラーメッセージ ▼▼▼
https://eccube.local/admin/products/upload_csv.php?

SERVER_ADDR: 192.168.56.103
REMOTE_ADDR: 192.168.56.1
USER_AGENT: Mozilla/5.0 (Windows; U; Windows NT 6.1; ja; rv:1.9.2.14) Gecko/20110218 Firefox/3.6.14 FirePHP/0.5

SQL: UPDATE dtb_products_class SET product_class_id= $1, product_id= $2, class_combination_id= $3, product_type_id= $4, product_code= $5, stock= $6, stock_unlimited= $7, sale_limit= $8, price01= $9, price02= $10, deliv_fee= $11, point_rate= $12, update_date= $13, down_filename= $14, down_realfilename= $15, del_flg= $16, creator_id= $17 WHERE product_class_id = $18

MDB2 Error: null value violates not-null constraint

_doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_pgsql_14afb9036ed2dad8613f6854f345252cdc277c62b3 ('10', '2', NULL, '1', 'nabe-01', NULL, NULL, '5', '1700', '1650', NULL, '100', '2011-03-04 17:49:20.000002', NULL, NULL, '0', '2', '10')]
[Native message: ERROR:  null value in column "stock_unlimited" violates not-null constraint]


/mnt/working_copy/eccube211/html/admin/products/upload_csv.php 34:LC_Page_Admin_Products_UploadCSV_Ex->process
/mnt/working_copy/eccube211/data/class_extends/page_extends/admin/products/LC_Page_Admin_Products_UploadCSV_Ex.php 56:LC_Page_Admin_Products_UploadCSV->process
/mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php 90:LC_Page_Admin_Products_UploadCSV->action
/mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php 129:LC_Page_Admin_Products_UploadCSV->doUploadCsv
/mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php 235:LC_Page_Admin_Products_UploadCSV->lfRegistProduct
/mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php 404:LC_Page_Admin_Products_UploadCSV->lfRegistProductClass
/mnt/working_copy/eccube211/data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php 440:SC_Query->update
/mnt/working_copy/eccube211/data/class/SC_Query.php 537:SC_Query->query
/mnt/working_copy/eccube211/data/class/SC_Query.php 735:SC_Query->execute
/mnt/working_copy/eccube211/data/class/SC_Query.php 888:MDB2_Statement_Common->execute
/mnt/working_copy/eccube211/data/module/MDB2.php 4152:MDB2_Statement_pgsql->_execute
/mnt/working_copy/eccube211/data/module/MDB2/Driver/pgsql.php 1474:MDB2_Driver_pgsql->_doQuery
/mnt/working_copy/eccube211/data/module/MDB2/Driver/pgsql.php 673:MDB2_Driver_Common->raiseError
/mnt/working_copy/eccube211/data/module/MDB2.php 1497:PEAR->raiseError
/mnt/working_copy/eccube211/data/module/PEAR.php 557:MDB2_Error->MDB2_Error
/mnt/working_copy/eccube211/data/module/MDB2.php 1009:PEAR_Error->PEAR_Error
▲▲▲ エラーメッセージ ▲▲▲


▲▲▲ デバッグ情報ここまで ▲▲▲
>> /install/index.php は、インストール完了後にファイルを削除してください。
EC-CUBE
システムエラーが発生しました。
大変お手数ですが、サイト管理者までご連絡ください。

    * ログインページに戻る


Change History

comment:1 Changed 10 years ago by kotani

  • Owner changed from somebody to t_yuo
  • Description modified (diff)

comment:2 Changed 10 years ago by t_yuo

  • Status changed from new to assigned

comment:3 Changed 10 years ago by t_yuo

  • Status changed from assigned to closed
  • Resolution set to 修正済

r20613 修正しました。

Note: See TracTickets for help on using tickets.