Problem occurred when I tried to add new warehouse to the system

[sunzhoujian]

成功 报告 : 新建仓库成功
数据库错误 1364 : 为所有已存在物料插入新仓库记录时发生错误, 因为
Field 'bin' doesn't have a default value
数据库SQL败 : 用作插入新仓库记录的 SQL 是
INSERT INTO locstock ( loccode, stockid, quantity, reorderlevel) SELECT 'YL', stockmaster.stockid, 0, 0 FROM stockmaster

The Version is the latest version 4.11.1

[Exsonqu_Qu]

hi,
It's been solved in the SVN.

Please refer to this post for details: http://www.minghao.hk/bbs/read.php?tid=2522

Thanks best regards!

Exson

[phil]

Well I was a bit sceptical too at first, but actually for those businesses that can keep the same stock always in the same location as many smaller businesses can, it is useful. The packing slip now shows where the stock is for picking.

Probably makes sense to default it to an empty string as you say.

[Exsonqu_Qu]

hi, Tim and Phil,

Thank you for your comments. I've revised them to NOT NULL default '';

Best regards!

Exson