[trunk] ProgrammingError: column ir_act_server.website_path does not exist

[LisAndi - Andi Becker - http://lisandi.com]

1)
we updated OpenERP to Version 8.0dev-20140213-000102

2)
we were not able to install any modules or list them instead we got the following Error:
Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/http.py", line 348, in dispatch
    response["result"] = self._call_function(**self.params)
  File "/usr/lib/pymodules/python2.7/openerp/http.py", line 220, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/service/model.py", line 113, in wrapper
    return f(dbname, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/http.py", line 215, in checked_call
    return self.func(*a, **kw)
  File "/usr/lib/pymodules/python2.7/openerp/http.py", line 532, in __call__
    return self.method(*args, **kw)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1203, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1195, in _call_kw
    return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 1891, in fields_view_get
    resaction = ir_values_obj.get(cr, uid, 'action', 'client_action_multi', [(self._name, False)], False, context)
  File "/usr/lib/pymodules/python2.7/openerp/addons/calendar/calendar.py", line 601, in get
    meta, context, res_id_req, without_user, key2_req)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_values.py", line 477, in get
    return self._map_legacy_model_list(models, do_get, merge_results=True)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_values.py", line 434, in _map_legacy_model_list
    result = map_fn(model, res_id)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_values.py", line 476, in do_get
    return self.get_actions(cr, uid, action_slot=key2, model=model, res_id=res_id, context=context)
  File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_values.py", line 404, in get_actions
    action_def = self.pool[action_model].read(cr, uid, int(id), fields, context)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3240, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 3287, in _read_flat
    cr.execute(query, [tuple(sub_ids)] + rule_params)
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 153, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 218, in execute
    res = self._obj.execute(query, params)
ProgrammingError: column ir_act_server.website_path does not exist
LINE 1: ...nk_field_id",ir_act_server."use_relational_model",ir_act_ser...
                                                             ^
3)
we expected to see the moduls listed and being able to install and configure them.

4)
Debian 7, all Browsers same problem

5)
Version 8.0dev-20140213-000102

[Niels Huylebroeck (red15)]

Have you ran your server with arguments -d {your_db} -u all to update the modules ?

[Alejandro Esteve (jansalex)]

With arguments I get this :

Running as user 'root' is a security risk, aborting.

[Alejandro Esteve (jansalex)]

Ok, After doing arguments -d {your_db} -u all, the error dissapears.

[LisAndi - Andi Becker - http://lisandi.com (lisandi)]

Hi what is the full command

On debian install we have only a message after trying to start the server

Usage: openerp-server {start|stop|restart|force-reload}

when we enter this in /etc/init.d/openerp
DAEMON_OPTS="-c $CONFIGFILE --db-filter=lisandi-oerp"

and change the debain package default
    start-stop-daemon --start --quiet --pidfile /var/run/${NAME}.pid
--chuid ${USER} --background --make-pidfile --exec ${DAEMON} --
--config=${CONFIG} --logfile=${LOGFILE}

leads to
root@vm /usr/bin # service openerp start
Starting openerp-server: openerp-server.

and

     start-stop-daemon --start --quiet --pidfile /var/run/${NAME}.pid
--chuid ${USER} --background --make-pidfile --exec ${DAEMON}
--${DAEMON_OPTS} --config=${CONFIG} --logfile=${LOGFILE}

leeads to:
root@vm /usr/bin # service openerp start
Starting openerp-server: start-stop-daemon: unrecognized option '---c'
Try 'start-stop-daemon --help' for more information.

-----

What is the correct and complete syntax with the options you mentioned.

The default init.d script looks like this:

#!/bin/sh

### BEGIN INIT INFO
# Provides: openerp-server
# Required-Start: $remote_fs $syslog
# Required-Stop: $remote_fs $syslog
# Should-Start: $network
# Should-Stop: $network
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: Enterprise Resource Management software
# Description: Open ERP is a complete ERP and CRM software.
### END INIT INFO

PATH=/sbin:/bin:/usr/sbin:/usr/bin
DAEMON=/usr/bin/openerp-server
NAME=openerp-server
DESC=openerp-server
CONFIG=/etc/openerp/openerp-server.conf
LOGFILE=/var/log/openerp/openerp-server.log
USER=openerp

test -x ${DAEMON} || exit 0

set -e

do_start () {
    echo -n "Starting ${DESC}: "
    start-stop-daemon --start --quiet --pidfile /var/run/${NAME}.pid
--chuid ${USER} --background --make-pidfile --exec ${DAEMON} --
--config=${CONFIG} --logfile=${LOGFILE}
    echo "${NAME}."
}

do_stop () {
    echo -n "Stopping ${DESC}: "
    start-stop-daemon --stop --quiet --pidfile /var/run/${NAME}.pid --oknodo
    echo "${NAME}."
}

case "${1}" in
    start)
        do_start
        ;;

    stop)
        do_stop
        ;;

    restart|force-reload)
        echo -n "Restarting ${DESC}: "
        do_stop
        sleep 1
        do_start
        ;;

    *)
        N=/etc/init.d/${NAME}
        echo "Usage: ${NAME} {start|stop|restart|force-reload}" >&2
        exit 1
        ;;
esac

exit 0

Andi

Andreas Becker
CEO / Managing Director
__________________________
*LisAndi Co. Ltd.*, Phuket, Thailand (lisandi.com)
15/21 M.2 Viset Road, Rawai, Muang, Phuket, Thailand 83130
Mobile: [phone]
VoIP: [phone]
Fax: [phone]
Skype: lisandi
Facebook: andibecker
Google Talk: <email address hidden>
Facetime: <email address hidden>
__________________________

On Thu, Feb 13, 2014 at 7:20 PM, Alejandro Esteve <email address hidden>wrote:

> Ok, After doing arguments -d {your_db} -u all, the error dissapears.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1279650
>
> Title:
> [trunk] ProgrammingError: column ir_ac...

[Cedric Le Brouster(OpenFire) (cedric-lebrouster)]

You don't need to change your daemon, you can use this command in terminal:

su openerp
/usr/bin/openerp-server -d lisandi-oerp -u all --stop-after-init -c /etc/openerp/openerp-server.conf

It will update all of your modules and then stop the process

[LisAndi - Andi Becker - http://lisandi.com (lisandi)]

On Thu, Feb 13, 2014 at 9:15 PM, Cedric Le Brouster(OpenFire) <
<email address hidden>> wrote:

> /usr/bin/openerp-server -d lisandi-oerp -u all --stop-after-init -c
> /etc/openerp/openerp-server.conf
>

Thanks Cedric this worked just perfect!
So I have to abort with ctrl C after a while.

This is what I did:

root@vm /usr/bin # sudo su openerp
root@vm /usr/bin # su - openerp -s /bin/bash
No directory, logging in with HOME=/
openerp@vm:/$ /usr/bin/openerp-server -d lisandi-oerp -u all
--stop-after-init -c /etc/openerp/openerp-server.conf

waiting about 5 Minutes (not sure how long it will take if you have nearly
all default modules installed)

than the command Prompt will pop up again

openerp@vm:/$

CTRL-D and you are back on Root Prompt

openerp@vm:/$ logout
root@vm /usr/bin # service openerp start
Starting openerp-server: openerp-server.

----

The error which started this thread is gone.

Thanks the error which started this thread is gone - Problem SOLVED

Andi

Andreas Becker
CEO / Managing Director
__________________________
*LisAndi Co. Ltd.*, Phuket, Thailand (lisandi.com)
15/21 M.2 Viset Road, Rawai, Muang, Phuket, Thailand 83130
Mobile: [phone]
VoIP: [phone]
Fax: [phone]
Skype: lisandi
Facebook: andibecker
Google Talk: <email address hidden>
Facetime: <email address hidden>
__________________________

[Twinkle Christian(OpenERP) (tch-openerp)]

Hello Andi,

Would you please check this issue again with latest or with updated db ? As I am not facing any issue with this.

Waiting for your answer,
Thanks,

[LisAndi - Andi Becker - http://lisandi.com (lisandi)]

No more issues here too Christian in newest release it is working

[Twinkle Christian(OpenERP) (tch-openerp)]

Hello Andi,

Thanks for your answer ,,!!

As per your comment #9 , I am closing this issue.

Regards,