在ec-cube中解決1364號問題

Posted on 由
LINEで送る
[`evernote` not found]

安裝時會遇到:
>> DB Error: unknown error
[nativecode=1364 ** Field ‘create_date’ doesn’t have a default value]

後來GOOGLE一下
才在官網發現它在html\install\sql\insert_data.sql中
有幾行被偷工減料了^^”

原本:

insert into dtb_csv(csv_id,col,disp_name,rank,status)values(5,'category_id','カテゴリID',1,2);
insert into dtb_csv(csv_id,col,disp_name,rank,status)values(5,'category_name','カテゴリ名',2,2);
insert into dtb_csv(csv_id,col,disp_name,rank,status)values(5,'parent_category_id','親カテゴリID',3,2);
insert into dtb_csv(csv_id,col,disp_name,status)values(5,'level','階層',2);
insert into dtb_csv(csv_id,col,disp_name,status)values(5,'rank','表示ランク',2);

改成

insert into dtb_csv(csv_id,col,disp_name,rank,status, create_date, update_date)values(5,'category_id','カテゴリID',1,2, now(), now());
insert into dtb_csv(csv_id,col,disp_name,rank,status, create_date, update_date)values(5,'category_name','カテゴリ名',2,2, now(), now());
insert into dtb_csv(csv_id,col,disp_name,rank,status, create_date, update_date)values(5,'parent_category_id','親カテゴリID',3,2, now(), now());
insert into dtb_csv(csv_id,col,disp_name,status, create_date, update_date)values(5,'level','階層',2, now(), now());
insert into dtb_csv(csv_id,col,disp_name,status, create_date, update_date)values(5,'rank','表示ランク',2, now(), now());

OK!!!