Hello there,
When I start openerp-server, I get this log. All seems right :
2014-10-23 22:31:37,217 4503 INFO la_page_pt openerp.service.server: Initiating shutdown
2014-10-23 22:31:37,217 4503 INFO la_page_pt openerp.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2014-10-23 22:31:39,126 5436 INFO ? openerp: OpenERP version 8.0-8a9027e
2014-10-23 22:31:39,126 5436 INFO ? openerp: addons paths: ['/var/lib/odoo/addons/8.0', u'/usr/lib/python2.7/dist-packages/openerp/addons']
2014-10-23 22:31:39,126 5436 INFO ? openerp: database hostname: localhost
2014-10-23 22:31:39,126 5436 INFO ? openerp: database port: 5432
2014-10-23 22:31:39,127 5436 INFO ? openerp: database user: odoo
2014-10-23 22:31:39,289 5436 INFO ? openerp.service.server: HTTP service (werkzeug) running on 0.0.0.0:8069
2014-10-23 22:31:39,295 5436 INFO la_page_pt openerp.modules.loading: loading 1 modules...
2014-10-23 22:31:39,426 5436 INFO la_page_pt openerp.modules.loading: 1 modules loaded in 0.13s, 0 queries
2014-10-23 22:31:39,451 5436 INFO la_page_pt openerp.modules.loading: loading 83 modules...
2014-10-23 22:31:39,455 5436 INFO la_page_pt passlib.registry: registered crypt handler 'pbkdf2_sha512': <class 'passlib.handlers.pbkdf2.pbkdf2_sha512'>
2014-10-23 22:31:39,455 5436 INFO la_page_pt passlib.registry: registered crypt handler 'md5_crypt': <class 'passlib.handlers.md5_crypt.md5_crypt'>
2014-10-23 22:31:39,518 5436 INFO ? openerp.addons.bus.bus: Bus.loop listen imbus on db postgres
2014-10-23 22:31:39,529 5436 INFO la_page_pt openerp.addons.report.models.report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf
2014-10-23 22:31:41,646 5436 INFO la_page_pt openerp.modules.loading: 83 modules loaded in 2.20s, 0 queries
2014-10-23 22:31:41,719 5436 INFO la_page_pt openerp.modules.loading: Modules loaded.
After this, I go in my browser to localhos:8069. I get an « internal server error ». Here is the error in the log. Unable to solve it. Many hours on this.
2014-10-23 22:38:46,822 5713 INFO ? openerp.http: HTTP Configuring static files
2014-10-23 22:38:46,827 5713 INFO None openerp.http: Generating nondb routing
2014-10-23 22:38:46,840 5713 INFO None werkzeug: 192.168.1.1 - - [23/Oct/2014 22:38:46] "GET /web/database/manager HTTP/1.1" 200 -
2014-10-23 22:38:47,039 5713 INFO None werkzeug: 192.168.1.1 - - [23/Oct/2014 22:38:47] "POST /web/session/get_session_info HTTP/1.1" 200 -
2014-10-23 22:38:47,058 5713 INFO None werkzeug: 192.168.1.1 - - [23/Oct/2014 22:38:47] "POST /web/webclient/bootstrap_translations HTTP/1.1" 200 -
2014-10-23 22:38:47,087 5713 INFO None werkzeug: 192.168.1.1 - - [23/Oct/2014 22:38:47] "POST /web/proxy/load HTTP/1.1" 200 -
2014-10-23 22:38:47,126 5713 INFO None werkzeug: 192.168.1.1 - - [23/Oct/2014 22:38:47] "POST /web/session/get_lang_list HTTP/1.1" 200 -
2014-10-23 22:38:47,128 5713 INFO None werkzeug: 192.168.1.1 - - [23/Oct/2014 22:38:47] "POST /web/database/get_list HTTP/1.1" 200 -
2014-10-23 22:39:11,570 5713 INFO None werkzeug: 192.168.1.1 - - [23/Oct/2014 22:39:11] "GET /web HTTP/1.1" 303 -
2014-10-23 22:39:11,634 5713 INFO None werkzeug: 192.168.1.1 - - [23/Oct/2014 22:39:11] "GET /web/database/selector HTTP/1.1" 200 -
2014-10-23 22:39:13,739 5713 INFO None werkzeug: 192.168.1.1 - - [23/Oct/2014 22:39:13] "GET /web?db=la_page_pt HTTP/1.1" 302 -
2014-10-23 22:39:13,741 5713 INFO la_page_pt openerp.addons.base.ir.ir_http: Generating routing map
2014-10-23 22:39:13,800 5713 INFO la_page_pt werkzeug: 192.168.1.1 - - [23/Oct/2014 22:39:13] "GET /web?db=la_page_pt HTTP/1.1" 200 -
2014-10-23 22:39:13,848 5713 ERROR la_page_pt openerp.sql_db: Programming error: operator does not exist: integer = boolean
LINE 1: ...roup_id) WHERE m.model = 'website' AND gu.uid = false ...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
, in query SELECT MAX(CASE WHEN perm_read THEN 1 ELSE 0 END) FROM ir_model_access a JOIN ir_model m ON (m.id = a.model_id) JOIN res_groups_users_rel gu ON (gu.gid = a.group_id) WHERE m.model = %s AND gu.uid = %s AND a.active IS True
2014-10-23 22:39:13,911 5713 INFO la_page_pt werkzeug: 192.168.1.1 - - [23/Oct/2014 22:39:13] "GET /web/login?redirect=http%3A%2F%2F24.226.196.31%3A8069%2Fweb%3Fdb%3Dla_page_pt HTTP/1.1" 500 -
2014-10-23 22:39:13,924 5713 ERROR la_page_pt werkzeug: Error on request:
Traceback (most recent call last):
File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 177, in run_wsgi
execute(self.server.app)
File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 165, in execute
application_iter = app(environ, start_response)
File "/usr/lib/python2.7/dist-packages/openerp/service/server.py", line 280, in app
return self.app(e, s)
File "/usr/lib/python2.7/dist-packages/openerp/service/wsgi_server.py", line 216, in application
return application_unproxied(environ, start_response)
File "/usr/lib/python2.7/dist-packages/openerp/service/wsgi_server.py", line 202, in application_unproxied
result = handler(environ, start_response)
File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1215, in __call__
return self.dispatch(environ, start_response)
File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1189, in __call__
return self.app(environ, start_wrapped)
File "/usr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 579, in __call__
return self.app(environ, start_response)
File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 1356, in dispatch
result = ir_http._dispatch()
File "/usr/lib/python2.7/dist-packages/openerp/addons/website/models/ir_http.py", line 91, in _dispatch
langs = [lg[0] for lg in request.website.get_languages()]
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 235, in wrapper
return new_api(self, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 552, in new_api
result = method(self._model, cr, uid, self.ids, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/addons/website/models/website.py", line 235, in get_languages
return self._get_languages(cr, uid, ids[0], context=context)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
return old_api(self, *args, **kwargs)
File "<string>", line 2, in _get_languages
File "/usr/lib/python2.7/dist-packages/openerp/tools/cache.py", line 75, in lookup
return self.method(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/addons/website/models/website.py", line 232, in _get_languages
return [(lg.code, lg.name) for lg in website.language_ids]
File "/usr/lib/python2.7/dist-packages/openerp/fields.py", line 754, in __get__
self.determine_value(record)
File "/usr/lib/python2.7/dist-packages/openerp/fields.py", line 849, in determine_value
record._prefetch_field(self)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 235, in wrapper
return new_api(self, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3154, in _prefetch_field
result = records.read(list(fnames), load='_classic_write')
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 235, in wrapper
return new_api(self, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3087, in read
self.check_access_rights('read')
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 235, in wrapper
return new_api(self, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 442, in new_api
result = method(self._model, cr, uid, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3401, in check_access_rights
return self.pool.get('ir.model.access').check(cr, uid, self._name, operation, raise_exception)
File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 237, in wrapper
return old_api(self, *args, **kwargs)
File "<string>", line 2, in check
File "/usr/lib/python2.7/dist-packages/openerp/tools/cache.py", line 71, in lookup
value = d[key] = self.method(*args, **kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/addons/base/ir/ir_model.py", line 750, in check
, (model_name, uid,)
File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 158, in wrapper
return f(self, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 234, in execute
res = self._obj.execute(query, params)
ProgrammingError: operator does not exist: integer = boolean
LINE 1: ...roup_id) WHERE m.model = 'website' AND gu.uid = false ...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Would you have idea?
Thanks everybody