bugGNU Health - Bugs: bug #62002, update to version 4.0 fails in...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #62002: update to version 4.0 fails in 'before.sql'

Submitter:  Axel Braun <coogor>
Submitted:  Mon 07 Feb 2022 03:08:28 PM UTC
   
 
Category:  Database Severity:  4 - Important
Item Group:  None Status:  Works For Me
Privacy:  Public Assigned to:  meanmicio
Open/Closed:  Closed Release:  3.9.0
Module:  Update Component:  None

Wed 09 Feb 2022 04:19:45 PM UTC, comment #1: 

Hi, Axel!

Those errors mean that it did not find the tables / fields to delete, because the related packages (sepa, project .. ) are not installed.

You can ignore them.

Bests
Luis

Luis Falcon <meanmicio>
Group administrator
Mon 07 Feb 2022 03:08:28 PM UTC, original submission:  

I tried to upgrade a 3.8 demo database:
postgres@localhost:/usr/share/doc/packages/gnuhealth/upgrade/4.0> psql ghdemo40 < before.sql
UPDATE 1
UPDATE 1
DELETE 4051
ALTER TABLE
ALTER TABLE
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 0
DELETE 1
ERROR:  relation "account_payment_sepa_message" does not exist
ERROR:  relation "project_work" does not exist
LINE 1: UPDATE project_work SET status = db_id FROM ir_model_data WH...
               ^
ERROR:  relation "project_work" does not exist
LINE 1: UPDATE project_work SET status = db_id FROM ir_model_data WH...
               ^
ERROR:  relation "sale_amendment_line" does not exist
UPDATE 20
UPDATE 2
UPDATE 0
ALTER TABLE


as a consequence, the following trytond-admin failed as well, see log attached

Axel Braun <coogor>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attached Files
file #52819:  log.txt added by coogor (25KiB - text/plain)

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by meanmicio (Posted a comment)
  • -email is unavailable- added by coogor (Submitted the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

     

    Follow 4 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2022-03-05 meanmicio Open/ClosedOpen Closed
    2022-02-09 meanmicio StatusNone Works For Me
        ReleaseNone 3.9.0
    2022-02-07 coogor Attached File- Added log.txt, #52819

    Back to the top

    Powered by Savane 3.13-caa5.
    Corresponding source code