My favorites | Sign in
Project Home Downloads Wiki Issues Source
Search
for
Update  
Updating an existing database
Phase-Design
Updated Jan 6, 2012 by udo.spallek@gmail.com

Introduction

In case of changes in the framework or the modules, database update is required.

For updating the database, start trytond with the following command line:

# trytond -d <DATABASE_NAME> -u all

Options:

  • -d
    <database_name>
    : the database name to update.
  • -u all: update all modules. It's possible to update only some modules like: -u account,company,ir,product

The update process may take some times depending on the number of modules installed and the quantity of data in the database.

After the update, the server will stop. Then you can start it normally.

Server messages explained

E.g. Field password of 1@res.user not updated (id: user_admin), because it has changed since the last update

The update process tries to take care about the users modifications.

This is made thanks to the table (ir.model.data) which keep the association with all the records defined in the modules xml-files and the corresponding records in the db.

This means that it is possible to edit the records created by the module installation and update it without being afraid of losing the handmade changes.

E.g. INFO Field groups on res.user : integrity not tested.

Is a informational message about the field groups in object res.user.

Tryton can not test the integrity of the entries in groups, because groups create records on a specific table which handle the many2many relation, and there is no id in the xml corresponding to records in this table.

So its impossible for the update mechanism to check the integrity of of the values in the field groups.

Finally "integrity not tested" means that the module update will overwrite the field even if there was a modification, because it's not possible to find out if there was a modification for this record.

Conclusion: The update of this record was successful, but there is a possible risk of lost user modifications.


Sign in to add a comment
Powered by Google Project Hosting