DoliCloud/SellYourSaas

SQL script bug for PostgreSQL databases when upgrading to version 15.0.1 from 14.0.5

BaMzee-Coded opened this issue · 1 comments

Describe the bug
Migration script 14.0.0-15.0.0.sql bug for PostgreSQL databases during upgrade task from 14.0.5 to 15.0.1. The error seems to be caused by an incorrect PostgreSQL syntax.

Erroneous Syntax:

ALTER TABLE dae_product_fournisseur_price MODIFY COLUMN packaging real DEFAULT null;
ALTER TABLE dae_ticket MODIFY COLUMN progress integer;

Expected Syntax (or similar):

ALTER TABLE dae_product_fournisseur_price ALTER COLUMN packaging SET DEFAULT null;
ALTER TABLE dae_ticket ALTER COLUMN progress SET DATA TYPE integer USING progress::integer;

To Reproduce
Steps to reproduce the behavior:

  1. Start the upgrade process from 14.0.5 to 15.0.1

Dolibarr_Install_01

  1. Click on 'Start' command button
  2. Error is displayed on the next page as per screen shots below

Dolibarr_bug_ScreenShot_01

Dolibarr_bug_ScreenShot_02

Desktop (please complete the following information):

  • OS: Debian Bullseye and Ubuntu 22.04 LTS
  • Browser: Brave Private Window 1.38.115
  • Version: Dolibarr 14.0.5 upgrade to 15.0.1 issue
eldy commented

I think this is fixed in Dolibarr 15.0.2.