Thread: ValueError: unsupported format character 'D'
Hello
I went through the installation description of pgAdmin on
Installation was done on Centos8.
After connecting to pgAdmin web site I got "server error" in browser and following messages in the error_log of Apache
Are you able to advise what can be done?
[Fri Nov 20 16:26:44.074222 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] mod_wsgi (pid=38774): Exception occurred processing WSGI script '/usr/lib/python3.6/site-packages/pgadmin4-web/pgAdmin4.wsgi'.
[Fri Nov 20 16:26:44.077629 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] Traceback (most recent call last):
[Fri Nov 20 16:26:44.077673 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 2309, in __call__
[Fri Nov 20 16:26:44.077677 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] return self.wsgi_app(environ, start_response)
[Fri Nov 20 16:26:44.077682 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/pgAdmin4.py", line 72, in __call__
[Fri Nov 20 16:26:44.077684 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] return self.app(environ, start_response)
[Fri Nov 20 16:26:44.077687 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/werkzeug/middleware/proxy_fix.py", line 228, in __call__
[Fri Nov 20 16:26:44.077690 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] return self.app(environ, start_response)
[Fri Nov 20 16:26:44.077693 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 2295, in wsgi_app
[Fri Nov 20 16:26:44.077695 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] response = self.handle_exception(e)
[Fri Nov 20 16:26:44.077698 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 1741, in handle_exception
[Fri Nov 20 16:26:44.077700 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] reraise(exc_type, exc_value, tb)
[Fri Nov 20 16:26:44.077703 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/_compat.py", line 35, in reraise
[Fri Nov 20 16:26:44.077706 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] raise value
[Fri Nov 20 16:26:44.077709 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 2292, in wsgi_app
[Fri Nov 20 16:26:44.077711 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] response = self.full_dispatch_request()
[Fri Nov 20 16:26:44.077714 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 1808, in full_dispatch_request
[Fri Nov 20 16:26:44.077716 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] self.try_trigger_before_first_request_functions()
[Fri Nov 20 16:26:44.077719 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 1855, in try_trigger_before_first_request_functions
[Fri Nov 20 16:26:44.077721 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] func()
[Fri Nov 20 16:26:44.077724 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/utils/__init__.py", line 48, in create_module_preference
[Fri Nov 20 16:26:44.077727 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] self.register_preferences()
[Fri Nov 20 16:26:44.077730 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/__init__.py", line 272, in register_preferences
[Fri Nov 20 16:26:44.077732 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] register_browser_preferences(self)
[Fri Nov 20 16:26:44.077735 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/register_browser_preferences.py", line 461, in register_browser_preferences
[Fri Nov 20 16:26:44.077741 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] 'Supported placeholders are %DATABASE%, %USERNAME%, and %SERVER%. '
[Fri Nov 20 16:26:44.077745 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask_babelex/__init__.py", line 623, in gettext
[Fri Nov 20 16:26:44.077747 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] return get_domain().gettext(*args, **kwargs)
[Fri Nov 20 16:26:44.077750 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask_babelex/__init__.py", line 534, in gettext
[Fri Nov 20 16:26:44.077753 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] return t.ugettext(string) % variables
[Fri Nov 20 16:26:44.077765 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] ValueError: unsupported format character 'D' (0x44) at index 28
Regards
Rafal
Hello , I also encountered this issue while I staring the pgAdmin4 on
CentOS7.
Fixed it by changing "%" to "%%" in file
/pgadmin/browser/register_browser_preferences.py".
It's python usage for processing a variable which has pre- and post- "%",
such as "%%DATABASE%%".
you can try.
/[Fri Nov 20 16:26:44.077735 2020] [wsgi:error] [pid 38774:tid
139824286275328] [remote ::1:55110] File
"/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/register_browser_preferences.py",
line 461, in register_browser_preferences
[Fri Nov 20 16:26:44.077741 2020] [wsgi:error] [pid 38774:tid
139824286275328] [remote ::1:55110] 'Supported placeholders are
%DATABASE%, %USERNAME%, and %SERVER%. '
/
====-----------------------
457 gettext("Query tool tab title"),
458 'text', '%DATABASE%/%USERNAME%@%SERVER%',
459 category_label=PREF_LABEL_DISPLAY,
460 help_str=gettext(
461 'Supported placeholders are %%DATABASE%%, %%USERNAME%%, and
%%SERVER%%. '
462 'Users can provide any string with or without placeholders
of'
463 ' their choice. The blank title will be revert back to the'
464 ' default title with placeholders.'
465 )
466 )
467
468 self.ve_edt_tab_title = self.preference.register(
469 'tab settings', 'vw_edt_tab_title_placeholder',
470 gettext("View/Edit data tab title"),
471 'text',
'%%SCHEMA%%.%%TABLE%%/%%DATABASE%%/%%USERNAME%%@%%SERVER%%',
472 category_label=PREF_LABEL_DISPLAY,
473 help_str=gettext(
474 'Supported placeholders are %%SCHEMA%%, %%TABLE%%,
%%DATABASE%%, '
475 '%%USERNAME%%, and %%SERVER%%. Users can provide any string
with or '
476 'without placeholders of their choice. The blank title will
be '
477 'revert back to the default title with placeholders.'
478 )
479 )
480
481 self.debugger_tab_title = self.preference.register(
482 'tab settings', 'debugger_tab_title_placeholder',
483 gettext("Debugger tab title"),
484 'text', '%%FUNCTION%%(%%ARGS%%)',
485 category_label=PREF_LABEL_DISPLAY,
486 help_str=gettext(
487 'Supported placeholders are %%FUNCTION%%, %%ARGS%%,
%%SCHEMA%% and'
488 ' %%DATABASE%%. Users can provide any string with or '
489 'without placeholders of their choice. The blank title will
be'
490 ' revert back to the default title with placeholders.'
491 )
492 )
493
494 self.open_in_new_tab = self.preference.register(
495 'tab settings', 'new_browser_tab_open',
496 gettext("Open in new browser tab"), 'select2', None,
497 category_label=PREF_LABEL_OPTIONS,
498 options=[{'label': gettext('Query Tool'), 'value': 'qt'},
499 {'label': gettext('Debugger'), 'value': 'debugger'},
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html
Hi
On Fri, Nov 20, 2020 at 4:16 PM Sekretarka Rafala <sekretarka.rafala@gmail.com> wrote:
HelloI went through the installation description of pgAdmin onInstallation was done on Centos8.After connecting to pgAdmin web site I got "server error" in browser and following messages in the error_log of ApacheAre you able to advise what can be done?
I would strongly recommend using the packages the pgAdmin team produce, as they are quite different from the ones installed if you follow that web page. See https://www.pgadmin.org/download/pgadmin-4-rpm/
[Fri Nov 20 16:26:44.074222 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] mod_wsgi (pid=38774): Exception occurred processing WSGI script '/usr/lib/python3.6/site-packages/pgadmin4-web/pgAdmin4.wsgi'.[Fri Nov 20 16:26:44.077629 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] Traceback (most recent call last):[Fri Nov 20 16:26:44.077673 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 2309, in __call__[Fri Nov 20 16:26:44.077677 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] return self.wsgi_app(environ, start_response)[Fri Nov 20 16:26:44.077682 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/pgAdmin4.py", line 72, in __call__[Fri Nov 20 16:26:44.077684 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] return self.app(environ, start_response)[Fri Nov 20 16:26:44.077687 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/werkzeug/middleware/proxy_fix.py", line 228, in __call__[Fri Nov 20 16:26:44.077690 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] return self.app(environ, start_response)[Fri Nov 20 16:26:44.077693 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 2295, in wsgi_app[Fri Nov 20 16:26:44.077695 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] response = self.handle_exception(e)[Fri Nov 20 16:26:44.077698 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 1741, in handle_exception[Fri Nov 20 16:26:44.077700 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] reraise(exc_type, exc_value, tb)[Fri Nov 20 16:26:44.077703 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/_compat.py", line 35, in reraise[Fri Nov 20 16:26:44.077706 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] raise value[Fri Nov 20 16:26:44.077709 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 2292, in wsgi_app[Fri Nov 20 16:26:44.077711 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] response = self.full_dispatch_request()[Fri Nov 20 16:26:44.077714 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 1808, in full_dispatch_request[Fri Nov 20 16:26:44.077716 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] self.try_trigger_before_first_request_functions()[Fri Nov 20 16:26:44.077719 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask/app.py", line 1855, in try_trigger_before_first_request_functions[Fri Nov 20 16:26:44.077721 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] func()[Fri Nov 20 16:26:44.077724 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/utils/__init__.py", line 48, in create_module_preference[Fri Nov 20 16:26:44.077727 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] self.register_preferences()[Fri Nov 20 16:26:44.077730 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/__init__.py", line 272, in register_preferences[Fri Nov 20 16:26:44.077732 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] register_browser_preferences(self)[Fri Nov 20 16:26:44.077735 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/pgadmin/browser/register_browser_preferences.py", line 461, in register_browser_preferences[Fri Nov 20 16:26:44.077741 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] 'Supported placeholders are %DATABASE%, %USERNAME%, and %SERVER%. '[Fri Nov 20 16:26:44.077745 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask_babelex/__init__.py", line 623, in gettext[Fri Nov 20 16:26:44.077747 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] return get_domain().gettext(*args, **kwargs)[Fri Nov 20 16:26:44.077750 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] File "/usr/lib/python3.6/site-packages/pgadmin4-web/flask_babelex/__init__.py", line 534, in gettext[Fri Nov 20 16:26:44.077753 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] return t.ugettext(string) % variables[Fri Nov 20 16:26:44.077765 2020] [wsgi:error] [pid 38774:tid 139824286275328] [remote ::1:55110] ValueError: unsupported format character 'D' (0x44) at index 28RegardsRafal