Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

客戶關係
e-Commerce
會計
庫存
PoS
專案管理
MRP

All apps

所有帖文人獎章

標籤（查看所有）

odoo accounting v14 pos v15

關於此討論區

支援

ODOO12 not creating db column?

postgresql odoo12 ORM

4 回覆

3494 瀏覽次數

Some ODOO newbie developer

Hello people.

I am having a problem with ODOO 12, I am declaring a text field and it is simply not being created by ODOO, I have already enabled --log-level debug_sql, and at creation time it just skips the field without giving me any errors...

My code:

class Processo(models.Model):

_name = 'processo'
_description = 'Processo'

name = fields.Char(string=u'Número do processo', readonly=True)

status = fields.Selection(selection=[
                ('tec','Análise Técnica'),
                ('tecsup','Análise Técnica Superior'),
                ('pendencia','Pendência'),
                ('indeferido','Indeferido'),
                ('concluido','Concluído')],
                string=u'Estados',
                default='tec')

is_tecsup = fields.Boolean( string='É análise superior?')

requerente_id = fields.Many2one( string='Requerente', comodel_name='res.partner', readonly=True)

requerente_user_id = fields.Many2one( string='Requerente', comodel_name='res.users', readonly=True)

documentos_ids = fields.One2many(string='Documentos', comodel_name='documentos.protocolos', inverse_name='processo_id')

protocolo_ids = fields.One2many( comodel_name='protocolo', inverse_name='processo_id', string='Protocolos')

protocolo_id = fields.Many2one( comodel_name='protocolo', string=u'Protocolo')

data_aprovacao = fields.Date(string="Data do alvará")

historico = fields.Text( string="Histórico")

pendencia_processo = fields.Text( string="Pendência")

pendencia = fields.Text(string="Pendencia") # <= field problem

This is the log at creation time:

2019-11-27 13:28:32,156 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "name" VARCHAR
2019-11-27 13:28:32,182 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."name" IS 'Número do processo'
2019-11-27 13:28:32,182 24061 DEBUG teste_all odoo.sql_db: query: SELECT 1 FROM "processo" LIMIT 1
2019-11-27 13:28:32,183 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_name_index"
2019-11-27 13:28:32,183 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "status" VARCHAR
2019-11-27 13:28:32,184 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."status" IS 'Estados'
2019-11-27 13:28:32,184 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_status_index"
2019-11-27 13:28:32,184 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "is_tecsup" bool
2019-11-27 13:28:32,185 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."is_tecsup" IS 'É análise superior?'
2019-11-27 13:28:32,185 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_is_tecsup_index"
2019-11-27 13:28:32,186 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "requerente_id" int4
2019-11-27 13:28:32,186 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."requerente_id" IS 'Requerente'
2019-11-27 13:28:32,187 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_requerente_id_index"
2019-11-27 13:28:32,187 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "requerente_user_id" int4
2019-11-27 13:28:32,187 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."requerente_user_id" IS 'Requerente'
2019-11-27 13:28:32,188 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_requerente_user_id_index"
2019-11-27 13:28:32,188 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "protocolo_id" int4
2019-11-27 13:28:32,189 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."protocolo_id" IS 'Protocolo'
2019-11-27 13:28:32,189 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_protocolo_id_index"
2019-11-27 13:28:32,191 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "data_aprovacao" date
2019-11-27 13:28:32,191 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."data_aprovacao" IS 'Data do alvará'
2019-11-27 13:28:32,191 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_data_aprovacao_index"
2019-11-27 13:28:32,191 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "historico" text
2019-11-27 13:28:32,192 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."historico" IS 'Histórico'
2019-11-27 13:28:32,192 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_historico_index"
2019-11-27 13:28:32,192 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "pendencia_processo" text
2019-11-27 13:28:32,192 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."pendencia_processo" IS 'Pendência'
2019-11-27 13:28:32,193 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_pendencia_processo_index"
2019-11-27 13:28:32,193 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "autorizador_id" int4
2019-11-27 13:28:32,193 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."autorizador_id" IS 'Autorizador'
2019-11-27 13:28:32,193 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_autorizador_id_index"
2019-11-27 13:28:32,194 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "create_uid" int4
2019-11-27 13:28:32,194 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."create_uid" IS 'Created by'
2019-11-27 13:28:32,194 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_create_uid_index"
2019-11-27 13:28:32,194 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "create_date" timestamp
2019-11-27 13:28:32,194 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."create_date" IS 'Created on'
2019-11-27 13:28:32,195 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_create_date_index"
2019-11-27 13:28:32,195 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "write_uid" int4
2019-11-27 13:28:32,195 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."write_uid" IS 'Last Updated by'
2019-11-27 13:28:32,195 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_write_uid_index"
2019-11-27 13:28:32,196 24061 DEBUG teste_all odoo.sql_db: query: ALTER TABLE "processo" ADD COLUMN "write_date" timestamp
2019-11-27 13:28:32,196 24061 DEBUG teste_all odoo.sql_db: query: COMMENT ON COLUMN "processo"."write_date" IS 'Last Updated on'
2019-11-27 13:28:32,196 24061 DEBUG teste_all odoo.sql_db: query: DROP INDEX IF EXISTS "processo_write_date_index"118/5000

Simply skips field "pendencia" creation without giving me any errors ... Does anyone know why? This is already giving me a headaches....

rehan

you need to declare it in xml views first i think :/

Some ODOO newbie developer

作者

I did this, with or without declaration on xml views. If I declare the field on a views odoo just give me " field does not exist"...

What I did to "solve" was just declaring another text field and it worked as expected... I have no idea what is happening

Muhammad Anees

pendencia_processo = fields.Text( string="Pendência")
pendencia = fields.Text(string="Pendencia")

string looks same. Try to give different.

Some ODOO newbie developer

作者

The string could be the problem?

Some ODOO newbie developer

作者

I changed the string, nothing happens.

喜歡這則討論？不要只閱讀，加入發表意見吧！

今天就建立帳戶，享受獨家功能，與我們精彩的社群互動！

註冊

相關帖文	回覆	瀏覽次數
How to connect Odoo with Postgresql? 已解決 postgresql odoo12	2 9月 25	53321
Odoo closes connection to DB on GCP Cloud SQL for longpolling requests and Causing 404 Error 已解決 postgresql odoo12	2 7月 20	8048
How to connect Odoo with Postgresql postgresql odoo12	0 3月 19	5
PostgreSQL_for_Odoo can't run postgresql odoo12 windows10	1 11月 24	7136
Postgresql not connecting. 已解決 postgresql beginner odoo12	1 2月 19	9017

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！