500 Errors when searching Courses content

Joy 2020-02-27 13:32:14 UTC #1

Keywords: Odoo - Google Cloud Platform - Technical issue - Other
bnsupport ID: 9f6ba59a-a5be-10ca-cae3-81d4b89b34b5
Description:
I have Odoo 13 20200215 deployed on Google Cloud. When I searched the in the course(eLearning: Documentation type) with any word, will get the 500 Internal Server Error.

vikram-bitnami 2020-02-28 07:40:42 UTC #2

Hi @Joy

Could you have a look at the Apache logs and see if you can identify the cause of the error? You can check those logs following the instructions at https://docs.bitnami.com/google/apps/odoo/troubleshooting/debug-errors-apache/.

Hope this helps,

Vikram

Joy 2020-02-28 19:16:58 UTC #3

Hi, Vikram

Thanks for your reply!

I'll look at the apache log later. For now, I can provide the direct real error log shows in the webpage:

500: Internal Server Error

Traceback

Traceback (most recent call last):
          File "/opt/odoo/apps/odoo/lib/odoo-13.0.post20200115-py3.7.egg/odoo/addons/base/models/ir_http.py", line 229, in _dispatch
            result = request.dispatch()
          File "/opt/odoo/apps/odoo/lib/odoo-13.0.post20200115-py3.7.egg/odoo/http.py", line 803, in dispatch
            r = self._call_function(**self.params)
          File "/opt/odoo/apps/odoo/lib/odoo-13.0.post20200115-py3.7.egg/odoo/http.py", line 345, in _call_function
            return checked_call(self.db, *args, **kwargs)
          File "/opt/odoo/apps/odoo/lib/odoo-13.0.post20200115-py3.7.egg/odoo/service/model.py", line 93, in wrapper
            return f(dbname, *args, **kwargs)
          File "/opt/odoo/apps/odoo/lib/odoo-13.0.post20200115-py3.7.egg/odoo/http.py", line 338, in checked_call
            result = self.endpoint(*a, **kw)
          File "/opt/odoo/apps/odoo/lib/odoo-13.0.post20200115-py3.7.egg/odoo/http.py", line 909, in __call__
            return self.method(*args, **kw)
          File "/opt/odoo/apps/odoo/lib/odoo-13.0.post20200115-py3.7.egg/odoo/http.py", line 510, in response_wrap
            response = f(*args, **kw)
          File "/opt/odoo/apps/odoo/lib/odoo-13.0.post20200115-py3.7.egg/odoo/addons/website_slides/controllers/main.py", line 380, in channel
            slide_count = request.env['slide.slide'].sudo().search_count(domain)
          File "/opt/odoo/apps/odoo/lib/odoo-13.0.post20200115-py3.7.egg/odoo/models.py", line 1578, in search_count
            res = self.search(args, count=True)
          File "/opt/odoo/apps/odoo/lib/odoo-13.0.post20200115-py3.7.egg/odoo/models.py", line 1601, in search
            res = self._search(args, offset=offset, limit=limit, order=order, count=count)
          File "/opt/odoo/apps/odoo/lib/odoo-13.0.post20200115-py3.7.egg/odoo/models.py", line 4348, in _search
            if expression.is_false(self, args):
          File "/opt/odoo/apps/odoo/lib/odoo-13.0.post20200115-py3.7.egg/odoo/osv/expression.py", line 216, in is_false
            for token in reversed(normalize_domain(domain)):
          File "/opt/odoo/apps/odoo/lib/odoo-13.0.post20200115-py3.7.egg/odoo/osv/expression.py", line 208, in normalize_domain
            assert expected == 0, 'This domain is syntactically not correct: %s' % (domain)
        AssertionError: This domain is syntactically not correct: ['&', '&', ('website_id', 'in', (False, 1)), '&', ('channel_id', '=', 2), ('is_category', '=', False), ('website_published', '=', True), '|', '|', '|', ('name', 'ilike', 'maya'), ('description', 'ilike', 'maya'), ('html_content', 'ilike', 'maya')]

davidg 2020-03-02 14:22:34 UTC #4

Hi @Joy,

That's right. This seems to be the real error (in /opt/bitnami/apps/odoo/log/production.log). Could you please let us know the exact steps you followed so we can try to reproduce the issue? Some screenshots may help.

Regards

Joy 2020-03-04 17:15:03 UTC #5

Hi, @davidg Thanks for your reply, I have made a screen recording for this, I just set up a new database with demo data, then can reproduce this issue. I have reproduced this on GCP, local installer, and virtual machines.

Screen Recording 2020-03-05 at 1.03.47 AM.mp4.zip (4.3 MB)

Regards!

darteaga 2020-03-06 10:25:07 UTC #6

Hi @Joy,
I was trying with an Odoo instance in GCP and could reproduce the issue, but it seems to be something related to the demo data and the eLearning module itself. It is trying to validate a domain that finally got an error. This could be because of a module misconfiguration or an error in the code of this module. I would suggest opening a case on the Odoo forum the might help more in that case. I've attached some screenshots of my researches, as you can see in the screenshots I also added a valid domain in the URL instead of using the IP, but the error is still there.

I found https://www.odoo.com/es_ES/forum/ayuda-1/question/error-with-search-content-in-elearning-platform-of-odoo-13-157340
Also, you can open a case here: https://www.odoo.com/forum/help-1

darteaga 2020-03-06 10:27:14 UTC #7

darteaga 2020-03-06 10:28:20 UTC #8

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!