Hello,
Let's me cut to the case, heres what happen. Well I would say accidentally, but to be honest this case was my stupid-curiosity-really-tired-troubleshoting-act deleting Inactive default users when cleaning up inactive users. There were default user, Public user & Template user. After that I couldn't access my web from page http://odoo.domain.tld frontend but the backend still working although the login page missed the image background and css style, but the login form still there and most modules still function like before.
**logs bellow
This what I've tried:
Upgrading module: Portal, Web & Website builder. After doing this, the default inactive users recreated. But I (think) saw it generate new ID for the public user, so it might be missing the ID flag to access the portal homepage.
Create new database: Fresh new database seems working without error, and http://odoo.domain.tld frontend also accessible
So did anyone happen to experince this situation, or do anyone have suggestion what gone wrong and would give me some solutions what should I do? By the way, I'm not Python developer or programmer. But please don't hesitate with the answers, any kind of clue would help.
Really appreciate for time and attention.
Cheers.
-AL-
Jun 13 17:34:51 wow Odoo Server 10.0-20170612:wow:ERROR:werkzeug:Error on request:#012Traceback (most recent call last):#012 File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 177, in run_wsgi#012 execute(self.server.app)#012 File "/usr/lib/python2.7/dist-packages/werkzeug/serving.py", line 165, in execute#012 application_iter = app(environ, start_response)#012 File "/usr/lib/python2.7/dist-packages/odoo/service/wsgi_server.py", line 182, in application#012 return werkzeug.contrib.fixers.ProxyFix(application_unproxied)(environ, start_response)#012 File "/usr/lib/python2.7/dist-packages/werkzeug/contrib/fixers.py", line 144, in __call__#012 return self.app(environ, start_response)#012 File "/usr/lib/python2.7/dist-packages/odoo/service/wsgi_server.py", line 170, in application_unproxied#012 result = handler(environ, start_response)#012 File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 1306, in __call__#012 return self.dispatch(environ, start_response)#012 File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 1280, in __call__#012 return self.app(environ, start_wrapped)#012 File "/usr/lib/python2.7/dist-packages/werkzeug/wsgi.py", line 588, in __call__#012 return self.app(environ, start_response)#012 File "/usr/lib/python2.7/dist-packages/odoo/http.py", line 1478, in dispatch#012 result = ir_http._dispatch()#012 File "/usr/lib/python2.7/dist-packages/odoo/addons/website/models/ir_http.py", line 175, in _dispatch#012 langs = [lg[0] for lg in request.website.get_languages()]#012 File "/usr/lib/python2.7/dist-packages/odoo/addons/website/models/website.py", line 349, in get_languages#012 return self._get_languages()#012 File "<string>", line 2, in _get_languages#012 #012 File "/usr/lib/python2.7/dist-packages/odoo/tools/cache.py", line 87, in lookup#012 value = d[key] = self.method(*args, **kwargs)#012 File "/usr/lib/python2.7/dist-packages/odoo/addons/website/models/website.py", line 353, in _get_languages#012 return [(lg.code, lg.name) for lg in self.language_ids]#012 File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 870, in __get__#012 self.determine_value(record)#012 File "/usr/lib/python2.7/dist-packages/odoo/fields.py", line 972, in determine_value#012 record._prefetch_field(self)#012 File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 3070, in _prefetch_field#012 result = records.read([f.name for f in fs], load='_classic_write')#012 File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 2991, in read#012 self.check_access_rights('read')#012 File "/usr/lib/python2.7/dist-packages/odoo/models.py", line 3289, in check_access_rights#012 return self.env['ir.model.access'].check(self._name, operation, raise_exception)#012 File "<string>", line 2, in check#012 #012 File "/usr/lib/python2.7/dist-packages/odoo/tools/cache.py", line 87, in lookup#012 value = d[key] = self.method(*args, **kwargs)#012 File "/usr/lib/python2.7/dist-packages/odoo/addons/base/ir/ir_model.py", line 909, in check#012 (model_name, self._uid,))#012 File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 141, in wrapper#012 return f(self, *args, **kwargs)#012 File "/usr/lib/python2.7/dist-packages/odoo/sql_db.py", line 218, in execute#012 res = self._obj.execute(query, params)#012ProgrammingError: operator does not exist: integer = boolean#012LINE 6: AND gu.uid = false#012 ^#012HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Hi, I am not sure with this, just upgrade the base module and check whether the things are ok
Please use proper line breaks when posting code. The easiest way is to first copy the code and apply the Code formatting afterwards (IIRC).
@Niyas upgrading Base module not helping, webpage still Internal Server Error
@Ermin thank for the tip, will do it properly next time