Unable to create products on a database migrated to 6.8 with supply on sale activated
The supply on sale method migration introduced by 72b2fb3ab32e does not work.
- There is a typo on the method name (so the migration is never executed) which causes the following error message:
Traceback (most recent call last):
File "/home/pokoli/projectes/tryton/migration/migrate.py", line 505, in <module>
main(args.database, args.source, args.config_file)
File "/home/pokoli/projectes/tryton/migration/migrate.py", line 478, in main
load_products(source, categories)
File "/home/pokoli/projectes/tryton/migration/migrate.py", line 463, in load_products
Template.save(records)
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/proteus/__init__.py", line 104, in newfunc
return self.func(owner, *args, **kwargs)
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/proteus/__init__.py", line 855, in save
ids = proxy.create(values, context)
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/proteus/config.py", line 209, in __call__
result = rpc.result(meth(*c_args, **c_kwargs))
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/trytond/modules/product/product.py", line 273, in create
templates = super(Template, cls).create(vlist)
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/trytond/model/modelsql.py", line 234, in wrapper
return func(cls, *args, **kwargs)
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/trytond/model/modelsql.py", line 930, in create
cls._validate(sub_records)
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/trytond/transaction.py", line 50, in wrapper
return func(*args, **kwargs)
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/trytond/model/modelstorage.py", line 1502, in _validate
raise SelectionValidationError(gettext(
trytond.model.modelstorage.SelectionValidationError: El valor "False" del camp "Subministra a la venda" del registre "Tonillo M5x16 "de "Plantilla de producte" no és un dels seus valors permesos. -
- In case the
_history
is activated on the product, the history table is never updated thus causing an error when inserting history:
Traceback (most recent call last):
File "/home/pokoli/projectes/tryton/migration/migrate.py", line 505, in <module>
main(args.database, args.source, args.config_file)
File "/home/pokoli/projectes/tryton/migration/migrate.py", line 478, in main
load_products(source, categories)
File "/home/pokoli/projectes/tryton/migration/migrate.py", line 463, in load_products
Template.save(records)
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/proteus/__init__.py", line 104, in newfunc
return self.func(owner, *args, **kwargs)
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/proteus/__init__.py", line 855, in save
ids = proxy.create(values, context)
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/proteus/config.py", line 209, in __call__
result = rpc.result(meth(*c_args, **c_kwargs))
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/trytond/modules/product/product.py", line 273, in create
templates = super(Template, cls).create(vlist)
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/trytond/model/modelsql.py", line 234, in wrapper
return func(cls, *args, **kwargs)
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/trytond/model/modelsql.py", line 924, in create
cls._insert_history(new_ids)
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/trytond/model/modelsql.py", line 626, in _insert_history
cursor.execute(*history.insert(hcolumns,
File "/home/pokoli/.virtualenvs/tryton/lib/python3.10/site-packages/trytond/backend/postgresql/database.py", line 68, in execute
cursor.execute(self, sql, args)
psycopg2.errors.DatatypeMismatch: column "supply_on_sale" is of type boolean but expression is of type character varying
LINE 1: ...a"."purchase_uom", "a"."salable", "a"."sale_uom", "a"."suppl...
``