我在我的 models.py 中添加:
commercial_group = fields.Many2one("simcard.simcard")
在我的 views.xml 中:
<field name="commercial_group" widget="selection"/>
然后我试图在我的模型中创建一个新记录,如下所示:
record.sudo().create({
"icc": icc.text,
"imsi": imsi.text,
"msisdn": msisdn.text,
"lte_status": lte_status.text,
"life_cycle_status": life_cycle_status.text,
"sim_model": simmodel.text,
"gprs_status": gprsStatus.text,
"consumption_monthly_data_limit": consumption_monthly_data_limit.text,
"consumption_monthly_data_value": consumption_monthly_data_value.text,
"consumption_monthly_data_thrReached": consumption_monthly_data_thrReached.text,
"commercial_group": commercial_group.text,
"country": country.text,
"operator": operator.text
})
http.request.env.cr.commit()
我在日志中收到此错误:
INFO test odoo.sql_db: bad query: INSERT INTO "simcard_simcard" ("id", "consumption_monthly_data_limit", "consumption_monthly_data_thrReached", "msisdn", "country", "lte_status", "consumption_monthly_data_value", "life_cycle_status", "icc", "gprs_status", "sim_model", "operator", "commercial_group", "imsi", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('simcard_simcard_id_seq'), '0', '0', '34590169', 'CH', 'false', '0', 'ACTIVE', '89293165951', '2', 'M2M Plug-in', 're', '1GB_dynPool_Plus_LTE', '29782', 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id
^
错误在于在 Commercial_group 字段中插入值,因为当我从 record.sudo().create() 语句中删除此字段时,我没有收到任何错误。
我在这里错过了什么吗??
相关分类