Re: pgadmin4 error

Cool, it's working
Thank you!!!

    Levi


On 28/10/2020 12:45, Aditya Toshniwal wrote:
> Hi Levente,
> 
> Please try installing from pgAdmin team built installer - 
> https://www.pgadmin.org/download/pgadmin-4-rpm/ 
> <https://www.pgadmin.org/download/pgadmin-4-rpm/>
> 
> On Wed, Oct 28, 2020 at 4:10 PM Levente Birta <blevi.linux@gmail.com 
> <mailto:blevi.linux@gmail.com>> wrote:
> 
> 
>     Hello,
> 
>     I use pgadmin4 with server installation, on Centos7, installed from
>     official postgresql yum repo.
> 
>     I'm on 4.27 now, but since v4.24, IIRC, I got error when I try to
>     visualize the SQL for a table:
>     INTERNAL SERVER ERROR ... expected token 'end of statement block',
>     got  '.'
> 
>     For views, foreign tables or any other stuff is working ...
> 
>     Any ideas?
>     Thanks
>     Levi
> 
> 
>     The apache error log:
> 
>     [Thu Oct 08 10:29:05.260331 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105] 2020-10-08 10:29:05,259: ERROR\tflask.app:\texpected
>     token 'end of statement block', got '.'
>     [Thu Oct 08 10:29:05.260347 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105] Traceback (most recent call last):
>     [Thu Oct 08 10:29:05.260350 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line
>     1813,
>     in full_dispatch_request
>     [Thu Oct 08 10:29:05.260352 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     rv = self.dispatch_request()
>     [Thu Oct 08 10:29:05.260353 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line
>     1799,
>     in dispatch_request
>     [Thu Oct 08 10:29:05.260361 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     return
>     self.view_functions[rule.endpoint](**req.view_args)
>     [Thu Oct 08 10:29:05.260363 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/views.py", line
>     88,
>     in view
>     [Thu Oct 08 10:29:05.260365 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     return self.dispatch_request(*args, **kwargs)
>     [Thu Oct 08 10:29:05.260367 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/utils.py",
> 
>     line 313, in dispatch_request
>     [Thu Oct 08 10:29:05.260369 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     return method(*args, **kwargs)
>     [Thu Oct 08 10:29:05.260371 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>
"/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py",
> 
>     line 158, in wrap
>     [Thu Oct 08 10:29:05.260373 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     return f(*args, **kwargs)
>     [Thu Oct 08 10:29:05.260374 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>
"/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/__init__.py",
> 
>     line 1388, in sql
>     [Thu Oct 08 10:29:05.260376 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     self, did=did, scid=scid, tid=tid,
>     main_sql=main_sql, data=data)
>     [Thu Oct 08 10:29:05.260378 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>
"/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py",
> 
>     line 770, in get_reverse_engineered_sql
>     [Thu Oct 08 10:29:05.260380 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     self._get_resql_for_table(did, scid, tid, data,
>     json_resp, main_sql)
>     [Thu Oct 08 10:29:05.260382 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>
"/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py",
> 
>     line 495, in _get_resql_for_table
>     [Thu Oct 08 10:29:05.260383 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     data=data, conn=self.conn, is_sql=True)
>     [Thu Oct 08 10:29:05.260385 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/templating.py",
>     line 134, in render_template
>     [Thu Oct 08 10:29:05.260387 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     return
>     _render(ctx.app.jinja_env.get_or_select_template(template_name_or_list),
>     [Thu Oct 08 10:29:05.260388 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
>     line 851, in get_or_select_template
>     [Thu Oct 08 10:29:05.260390 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     return self.get_template(template_name_or_list,
>     parent, globals)
>     [Thu Oct 08 10:29:05.260392 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
>     line 812, in get_template
>     [Thu Oct 08 10:29:05.260393 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     return self._load_template(name,
>     self.make_globals(globals))
>     [Thu Oct 08 10:29:05.260395 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
>     line 786, in _load_template
>     [Thu Oct 08 10:29:05.260397 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     template = self.loader.load(self, name, globals)
>     [Thu Oct 08 10:29:05.260398 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/loaders.py", line
>     125, in load
>     [Thu Oct 08 10:29:05.260400 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     code = environment.compile(source, name,
>     filename)
>     [Thu Oct 08 10:29:05.260407 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
>     line 565, in compile
>     [Thu Oct 08 10:29:05.260409 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     self.handle_exception(exc_info,
>     source_hint=source_hint)
>     [Thu Oct 08 10:29:05.260411 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
>     line 754, in handle_exception
>     [Thu Oct 08 10:29:05.260412 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     reraise(exc_type, exc_value, tb)
>     [Thu Oct 08 10:29:05.260414 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/_compat.py", line
>     37, in reraise
>     [Thu Oct 08 10:29:05.260415 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     raise value.with_traceback(tb)
>     [Thu Oct 08 10:29:05.260417 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>
"/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/12_plus/create.sql",
> 
>     line 88, in template
>     [Thu Oct 08 10:29:05.260419 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     {% if data.fillfactor %}{% set ns.add_comma =
>     true%}
>     [Thu Oct 08 10:29:05.260421 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/environment.py",
>     line 470, in _parse
>     [Thu Oct 08 10:29:05.260422 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     return Parser(self, source, name,
>     encode_filename(filename)).parse()
>     [Thu Oct 08 10:29:05.260424 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
>     897, in parse
>     [Thu Oct 08 10:29:05.260426 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     result = nodes.Template(self.subparse(),
>     lineno=1)
>     [Thu Oct 08 10:29:05.260427 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
>     879, in subparse
>     [Thu Oct 08 10:29:05.260429 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     rv = self.parse_statement()
>     [Thu Oct 08 10:29:05.260430 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
>     121, in parse_statement
>     [Thu Oct 08 10:29:05.260432 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     return getattr(self, 'parse_' +
>     self.stream.current.value)()
>     [Thu Oct 08 10:29:05.260434 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
>     203, in parse_if
>     [Thu Oct 08 10:29:05.260435 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     'name:endif'))
>     [Thu Oct 08 10:29:05.260437 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
>     156, in parse_statements
>     [Thu Oct 08 10:29:05.260438 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     result = self.subparse(end_tokens)
>     [Thu Oct 08 10:29:05.260440 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
>     879, in subparse
>     [Thu Oct 08 10:29:05.260442 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     rv = self.parse_statement()
>     [Thu Oct 08 10:29:05.260443 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
>     121, in parse_statement
>     [Thu Oct 08 10:29:05.260445 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     return getattr(self, 'parse_' +
>     self.stream.current.value)()
>     [Thu Oct 08 10:29:05.260446 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
>     203, in parse_if
>     [Thu Oct 08 10:29:05.260450 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     'name:endif'))
>     [Thu Oct 08 10:29:05.260451 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
>     156, in parse_statements
>     [Thu Oct 08 10:29:05.260453 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     result = self.subparse(end_tokens)
>     [Thu Oct 08 10:29:05.260455 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
>     879, in subparse
>     [Thu Oct 08 10:29:05.260456 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     rv = self.parse_statement()
>     [Thu Oct 08 10:29:05.260458 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
>     121, in parse_statement
>     [Thu Oct 08 10:29:05.260459 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     return getattr(self, 'parse_' +
>     self.stream.current.value)()
>     [Thu Oct 08 10:29:05.260461 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
>     175, in parse_set
>     [Thu Oct 08 10:29:05.260463 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     drop_needle=True)
>     [Thu Oct 08 10:29:05.260464 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/parser.py", line
>     155, in parse_statements
>     [Thu Oct 08 10:29:05.260466 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]     self.stream.expect('block_end')
>     [Thu Oct 08 10:29:05.260467 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]   File
>     "/usr/lib/python3.6/site-packages/pgadmin4-web/jinja2/lexer.py", line
>     374, in expect
>     [Thu Oct 08 10:29:05.260469 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105] self.name <http://self.name>, self.filename)
>     [Thu Oct 08 10:29:05.260472 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105] jinja2.exceptions.TemplateSyntaxError: expected
>     token
>     'end of statement block', got '.'
>     [Thu Oct 08 10:29:05.260477 2020] [wsgi:error] [pid 1047] [remote
>     ip.ad.re.ss:53105]
> 
> 
> 
> 
> -- 
> Thanks,
> Aditya Toshniwal
> pgAdmin hacker | Sr. Software Engineer| *edbpostgres.com* 
> <http://edbpostgres.com>
> "Don't Complain about Heat, Plant a TREE"