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

CRM
e-Commerce
Contabilità
Magazzino
PoS
Progetti
MRP

All apps

Tutti gli articoli Persone Badge

Etichette (Mostra tutto)

odoo accounting v14 pos v15

Sul forum

Assistenza

ODOO12 not creating db column?

postgresql odoo12 ORM

4 Risposte

3572 Visualizzazioni

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

Autore

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

Autore

The string could be the problem?

Some ODOO newbie developer

Autore

I changed the string, nothing happens.

Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!

Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!

Registrati

Post correlati	Risposte	Visualizzazioni
How to connect Odoo with Postgresql? Risolto postgresql odoo12	2 set 25	53576
Odoo closes connection to DB on GCP Cloud SQL for longpolling requests and Causing 404 Error Risolto postgresql odoo12	2 lug 20	8141
How to connect Odoo with Postgresql postgresql odoo12	0 mar 19	5
PostgreSQL_for_Odoo can't run postgresql odoo12 windows10	1 nov 24	7296
Postgresql not connecting. Risolto postgresql beginner odoo12	1 feb 19	9108

La domanda è stata contrassegnata

Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!