Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update 12 to 13 : ERROR #16135

Closed
ajussak opened this issue Feb 1, 2021 · 0 comments
Closed

Update 12 to 13 : ERROR #16135

ajussak opened this issue Feb 1, 2021 · 0 comments
Labels
Bug This is a bug (something does not work as expected)

Comments

@ajussak
Copy link
Contributor

ajussak commented Feb 1, 2021

Bug

Migrating error with script : 12.0.0-13.0.0.sql

Erreur DB_ERROR_42883: UPDATE llx_projet_task_time SET tms = null WHERE tms = 0;ERROR:  42883: operator does not exist: timestamp without time zone = integer LINE 1: UPDATE llx_projet_task_time SET tms = null WHERE tms = 0;                                                              ^ HINT:  No operator matches the given name and argument types. You might need to add explicit type casts. LOCATION:  op_error, parse_oper.c:731
--
Erreur  DB_ERROR_SYNTAX: ALTER TABLE llx_projet_task_time MODIFY COLUMN tms  timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;ERROR:  42601: syntax error at or near "(" LINE 2: ..._time ALTER COLUMN tms TYPE timestamp without time zone()  ;                                                                   ^ LOCATION:  scanner_yyerror, scan.l:1149
Erreur  DB_ERROR_42830: ALTER TABLE llx_product ADD CONSTRAINT  fk_product_finished FOREIGN KEY (finished) REFERENCES  llx_c_product_nature (code);ERROR:  42830: there is no unique constraint matching given keys for referenced table "llx_c_product_nature" LOCATION:  transformFkeyCheckAttrs, tablecmds.c:9902

Environment

  • Version: [13.0]
  • OS: [Debian 10]
  • Web server: [Apache/2.4.46]
  • PHP: [PHP 7.3.26]
  • Database: [PostgreSQL 12.5 (Debian 12.5-1.pgdg100+1)]
  • URL(s): [/install]

Steps to reproduce the behavior

Launch migrating script 12.0 to 13.0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug This is a bug (something does not work as expected)
Projects
None yet
Development

No branches or pull requests

1 participant