Odoo Server (MOVED TO GITHUB)

Openerp upgrade 6.1.1

Asked by dana ilinca

Hi,

After server update i got this error when a new db is created using the application :

column "auto_install" of relation "ir_module_module" does not exist
LINE 1: ...sc, description, category_id, auto_insta...
                                                             ^
, in query INSERT INTO ir_module_module (author, website, name, shortdesc, description, category_id, auto_install, state, certificate, web, license, complexity, application, icon, sequence) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s) RETURNING id

On the server we had a version from april and it was update to a version from last week., the server is ubuntu and is used postrgess 9.1.
For the updates it was used the following command:
./openerp-server --config=/etc/openerp-server.conf -d db_name --update=all

To stop the server was used :
 kill -9 id_process
The server was restarted with this command :
./openerp-server --config=/etc/openerp-server.conf &

This is the server config file :

[options]
; This is the password that allows database operations:
; admin_passwd = admin

; Database settings
db_host =XXXXXXXXX
db_port = 5432
db_user = openerp
db_password = postgres

; Networking Settings
xmlrpc = True
xmlrpc_interface =
xmlrpc_port = 8069

netrpc = True
netrpc_interface =
netrpc_port = 8070

; Uncomment these for xml-rpc over SSL
;xmlrpcs = True
;xmlrpcs_interface =
;xmlrpcs_port = 8071
;secure_pkey_file = /etc/ssl/openerp/server.key
;secure_cert_file = /etc/ssl/openerp/server.crt

; Log settings
logfile = /var/log/openerp/openerp-server.log
syslog = False
logrotate = True
log_level = info

; False prevents the client displaying the list of databases
list_db = True
; addons_path = /home/openerp-6.1dev/openerp/addons, /home/openerp-web-6.1-dev/addons
addons_path = /opt/openerp-6.1dev/openerp/addons
demo = {}
soap = False
reportgz = False
translate_modules = ['all']

; Static http parameters
static_http_enable = False
static_http_document_root = /var/www/html
static_http_url_prefix = /

; Outbound email configuration
;smtp_user = <email address hidden>
;email_from = "OpenERP Support" <email address hidden>
;smtp_port = 25
;smtp_password = ********
;smtp_ssl = True
;smtp_server = mail.example.com

I need directions regarding this problem.

Thanks.
Dana

Question information

Language:
English Edit question
Status:
Solved
For:
Odoo Server (MOVED TO GITHUB) Edit question
Assignee:
No assignee Edit question
Solved by:
dana ilinca
Solved:
Last query:
Last reply:
Revision history for this message
dana ilinca (dilinca) said : 		#1

I made several test and i notice that this column is missing in the old databases, on another machine , where is the same version of the openerp the databases are correct. But the versions before the update wasn't the same.

Revision history for this message
Chandrapal Zala(SerpentCS) (c-zala-serpentcs) said : 		#2

hi,
I have some solution of your problem.

Simply update your base module,if it cannot update from gui then simply update base module from the terminal.

Revision history for this message
Serpent Consulting Services (serpent-consulting-services) said : 		#3

Dana,

This kind of warnings appear when the database does not satisfy some points.

As Chandrapal said you should update the base module from terminal via -u base -d <db_name> command.

Note that the upgrade from 6.0 to 6.1 is not painfree as its a major version change!

Thanks.

Revision history for this message
dana ilinca (dilinca) said : 		#4

Hi,

Thanks for you answer, but the problem is not solved.

Regards,
Dana

Revision history for this message
Serpent Consulting Services (serpent-consulting-services) said : 		#5

Dana,

Did you try -u base -d <db_name> ?

Revision history for this message
dana ilinca (dilinca) said : 		#6

Hi,

I did.

Revision history for this message
Niels Huylebroeck (red15) said : 		#7

Am I correct that you are trying to upgrade a 5.0 or 6.0 to 6.1 database
using the process described by previous posters ?

If so this is not meant to work, you should have OpenERP SA migrate your
database from (5/6).0 to 6.1 using the migration service found here :
http://migration.openerp.com/

There are some alternatives but I cannot provide more info on them because
I have no experience with using them.

2012/9/20 dana ilinca <email address hidden>

> Question #208357 on OpenERP Server changed:
> https://answers.launchpad.net/openobject-server/+question/208357
>
> dana ilinca posted a new comment:
> Hi,
>
> I did.
>
> --
> You received this question notification because you are a member of
> OpenERP Committers, which is an answer contact for OpenERP Server.
>

--
Niels Huylebroeck
Bubbles-IT
Tel. : +32 (0)9 328 33 88
Web : http://www.bubbles-it.be

Revision history for this message
Stefan Rijnhart (Opener) (stefan-opener) said : 		#8

Hi,

I am a maintainer of the OpenUpgrade project, which aims at providing an open source upgrade path for OpenERP. It occurred to me that the 'auto_install' field on the module model is indeed new in OpenERP 6.1, but like many changes in the OpenERP datamodel it needs no special treatment: when the 'base' module is updated, the database layout adopts the new field during the loading of the model. So there must be something else going on.

Having that said and as Niels already indicated, without the paid migration service of OpenERP SA or using an alternative path such as OpenUpgrade (see http://readthedocs.org/docs/openupgrade-server) or rolling your own SQL statements you cannot expectto be able to continue using the same database on a newer major release of OpenERP.

Cheers,
Stefan.

Revision history for this message
dana ilinca (dilinca) said : 		#9

Hi,

Thanks for your answers, the problem is solved now. We replaced the sources with an older version.

Dana