Ticket #2502 (new バグ指摘)

Opened 7 years ago

Last modified 6 years ago

商品登録時に7つ以上のサブ情報の登録を行おうとするとエラーになる

Reported by: m_uehara Owned by: somebody
Priority: Milestone: バックログ
Component: 管理画面 Version: 2.13.1
Keywords: Cc:
修正済み: no

Description

1.管理画面>パラメータ画面にて「PRODUCTSUB_MAX」を「7」に設定する
2.管理画面>商品登録にて商品の登録を行う
3.システムエラーとなります

Fatal error(E_USER_ERROR): DB処理でエラーが発生しました。
SQL: [UPDATE dtb_products SET name= ?, status= ?, main_list_comment= ?, 
main_comment= ?, comment1= ?, comment2= ?, comment3= ?, comment4= ?, comment5= ?, 
comment6= ?, deliv_date_id= ?,maker_id= ?, note= ?, update_date= CURRENT_TIMESTAMP, 
creator_id= ?, main_list_image= ?,main_image= ?, main_large_image= ?, sub_image1= ?,
sub_large_image1= ?, sub_image2= ?,sub_large_image2= ?, sub_image3= ?,
sub_large_image3= ?,sub_image4= ?, sub_large_image4= ?,sub_image5= ?,
sub_large_image5= ?, sub_image6= ?,sub_large_image6= ?, sub_image7= ?,
sub_large_image7= ?, sub_title1= ?, sub_comment1= ?,sub_title2= ?, sub_comment2= ?,
sub_title3= ?, sub_comment3= ?, sub_title4= ?, sub_comment4= ?, sub_title5= ?,
sub_comment5= ?, sub_title6= ?, sub_comment6= ?,sub_title7= ?, 
sub_comment7= ? WHERE product_id = ?]
MDB2 Error: no such field
prepare: [Error message: Unable to create prepared statement handle]
[Last executed query: DEALLOCATE PREPARE 
mdb2_statement_pgsql_95ca448e49ec78c8c796128ebd86cfb08b661c773]
[Native message: ERROR: column "sub_image7" of relation "dtb_products" does not exist
行 1: ...ge5= $27, sub_image6= $28, sub_large_image6= $29, sub_image7...
^]
on [/mnt/NetBeansProjects/cube_dev_213/data/class/SC_Query.php(1087)] 

Change History

comment:1 Changed 6 years ago by h_yoshimoto

  • Milestone changed from EC-CUBE2.13.2 to EC-CUBE2.13.3

comment:2 Changed 6 years ago by kim

  • Milestone changed from EC-CUBE2.13.3 to バックログ

DB変更を伴うことが想定されるためバックログとします。

Note: See TracTickets for help on using tickets.