invalid literal for int() with base 10: 'None'

Nagaraj Raj <[email protected]> Tue, 7 Jan 2020 18:05:27 +0000 (UTC)
Newsgroups gmane.comp.db.postgresql.pgadmin,gmane.comp.db.postgresql.pgadmin.devel
Message-ID <[email protected]>
------=_Part_7962888_2137337677.1578420327020
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Throwing an error " invalid literal for int() with base 10: 'None'" while t=
rying to connect DB in latest version pgAdmin=C2=A0
 Version4.16

2020-01-07 10:00:29,870: ERROR flask.app: invalid literal for int() with ba=
se 10: 'None'
Traceback (most recent call last):

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/flask/app.py", line 1813, in full_dispatch_request

 rv =3D self.dispatch_request()

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/flask/app.py", line 1799, in dispatch_request

 return self.view_functions[rule.endpoint](**req.view_args)

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/flask/views.py", line 88, in view

 return self.dispatch_request(*args, **kwargs)

 File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/u=
tils.py", line 311, in dispatch_request

 return method(*args, **kwargs)

 File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/s=
erver_groups/servers/__init__.py", line 976, in connect_status

 recovery_state(conn, manager.version)

 File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/s=
erver_groups/servers/__init__.py", line 53, in recovery_state

 "connect/sql/#{0}#/check_recovery.sql".format(postgres_version))

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/flask/templating.py", line 134, in render_template

 return _render(ctx.app.jinja_env.get_or_select_template(template_name_or_l=
ist),

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/jinja2/environment.py", line 869, in get_or_select_template

 return self.get_template(template_name_or_list, parent, globals)

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/jinja2/environment.py", line 830, in get_template

 return self._load_template(name, self.make_globals(globals))

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/jinja2/environment.py", line 804, in _load_template

 template =3D self.loader.load(self, name, globals)

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/jinja2/loaders.py", line 113, in load

 source, filename, uptodate =3D self.get_source(environment, name)

 File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/utils/ver=
sioned_template_loader.py", line 15, in get_source

 specified_version_number, exists =3D parse_version(template)

 File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/utils/ver=
sioned_template_loader.py", line 49, in parse_version

 return int(version), True

ValueError: invalid literal for int() with base 10: 'None'

2020-01-07 10:00:29,960: ERROR flask.app: invalid literal for int() with ba=
se 10: 'None'

Traceback (most recent call last):

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/flask/app.py", line 1813, in full_dispatch_request

 rv =3D self.dispatch_request()

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/flask/app.py", line 1799, in dispatch_request

 return self.view_functions[rule.endpoint](**req.view_args)

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/flask/views.py", line 88, in view

 return self.dispatch_request(*args, **kwargs)

 File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/u=
tils.py", line 311, in dispatch_request

 return method(*args, **kwargs)

 File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/s=
erver_groups/servers/__init__.py", line 1160, in connect

 recovery_state(conn, manager.version)

 File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/browser/s=
erver_groups/servers/__init__.py", line 53, in recovery_state

 "connect/sql/#{0}#/check_recovery.sql".format(postgres_version))

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/flask/templating.py", line 134, in render_template

 return _render(ctx.app.jinja_env.get_or_select_template(template_name_or_l=
ist),

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/jinja2/environment.py", line 869, in get_or_select_template

 return self.get_template(template_name_or_list, parent, globals)

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/jinja2/environment.py", line 830, in get_template

 return self._load_template(name, self.make_globals(globals))

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/jinja2/environment.py", line 804, in _load_template

 template =3D self.loader.load(self, name, globals)

 File "/Applications/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/si=
te-packages/jinja2/loaders.py", line 113, in load

 source, filename, uptodate =3D self.get_source(environment, name)

 File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/utils/ver=
sioned_template_loader.py", line 15, in get_source

 specified_version_number, exists =3D parse_version(template)

 File "/Applications/pgAdmin 4.app/Contents/Resources/web/pgadmin/utils/ver=
sioned_template_loader.py", line 49, in parse_version

 return int(version), True

ValueError: invalid literal for int() with base 10: 'None'





------=_Part_7962888_2137337677.1578420327020
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div class=3D"yahoo-style-wrap" style=3D"font-fami=
ly:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div dir=
=3D"ltr" data-setdir=3D"false"><div>
<div style=3D"margin: 0px;" dir=3D"ltr" data-setdir=3D"false">Throwing an e=
rror <b>" <span>invalid literal for int() with base 10: 'None'</span>" </b>=
while trying to connect DB in latest version pgAdmin&nbsp;</div><div style=
=3D"margin: 0px;" dir=3D"ltr" data-setdir=3D"false"><br></div><div style=3D=
"margin: 0px;" dir=3D"ltr" data-setdir=3D"false"> <div><div class=3D"ydpdef=
7483ccol-sm-3" style=3D"max-width: 25%; position: relative; width: 162.5px;=
 padding-right: 7.5px; padding-left: 7.5px; color: rgb(34, 34, 34); font-fa=
mily: Roboto, &quot;Helvetica Neue&quot;, -apple-system, system-ui, &quot;S=
egoe UI&quot;, Arial, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Sego=
e UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;=
; font-size: 14px;"><span style=3D"font-weight: bolder;">Version</span></di=
v><div class=3D"ydpdef7483ccol-sm-9" style=3D"max-width: 75%; position: rel=
ative; width: 487.5px; padding-right: 7.5px; padding-left: 7.5px; color: rg=
b(34, 34, 34); font-family: Roboto, &quot;Helvetica Neue&quot;, -apple-syst=
em, system-ui, &quot;Segoe UI&quot;, Arial, sans-serif, &quot;Apple Color E=
moji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;=
Noto Color Emoji&quot;; font-size: 14px;">4.16</div></div><br></div><div st=
yle=3D"margin: 0px;"><br></div><div style=3D"margin: 0px;">2020-01-07 10:00=
:29,870: ERROR=09flask.app:=09invalid literal for int() with base 10: 'None=
'</div>
<p style=3D"margin: 0px;">Traceback (most recent call last):</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/flask/app.py", line 1813, in full_di=
spatch_request</p>
<p style=3D"margin: 0px;">    rv =3D self.dispatch_request()</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/flask/app.py", line 1799, in dispatc=
h_request</p>
<p style=3D"margin: 0px;">    return self.view_functions[rule.endpoint](**r=
eq.view_args)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/flask/views.py", line 88, in view</p=
>
<p style=3D"margin: 0px;">    return self.dispatch_request(*args, **kwargs)=
</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/web/pgadmin/browser/utils.py", line 311, in dispatch_request</p>
<p style=3D"margin: 0px;">    return method(*args, **kwargs)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/web/pgadmin/browser/server_groups/servers/__init__.py", line 976, in =
connect_status</p>
<p style=3D"margin: 0px;">    recovery_state(conn, manager.version)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/web/pgadmin/browser/server_groups/servers/__init__.py", line 53, in r=
ecovery_state</p>
<p style=3D"margin: 0px;">    "connect/sql/#{0}#/check_recovery.sql".format=
(postgres_version))</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/flask/templating.py", line 134, in r=
ender_template</p>
<p style=3D"margin: 0px;">    return _render(ctx.app.jinja_env.get_or_selec=
t_template(template_name_or_list),</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/jinja2/environment.py", line 869, in=
 get_or_select_template</p>
<p style=3D"margin: 0px;">    return self.get_template(template_name_or_lis=
t, parent, globals)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/jinja2/environment.py", line 830, in=
 get_template</p>
<p style=3D"margin: 0px;">    return self._load_template(name, self.make_gl=
obals(globals))</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/jinja2/environment.py", line 804, in=
 _load_template</p>
<p style=3D"margin: 0px;">    template =3D self.loader.load(self, name, glo=
bals)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/jinja2/loaders.py", line 113, in loa=
d</p>
<p style=3D"margin: 0px;">    source, filename, uptodate =3D self.get_sourc=
e(environment, name)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/web/pgadmin/utils/versioned_template_loader.py", line 15, in get_sour=
ce</p>
<p style=3D"margin: 0px;">    specified_version_number, exists =3D parse_ve=
rsion(template)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/web/pgadmin/utils/versioned_template_loader.py", line 49, in parse_ve=
rsion</p>
<p style=3D"margin: 0px;">    return int(version), True</p>
<p style=3D"margin: 0px;">ValueError: invalid literal for int() with base 1=
0: 'None'</p>
<p style=3D"margin: 0px;">2020-01-07 10:00:29,960: ERROR=09flask.app:=09inv=
alid literal for int() with base 10: 'None'</p>
<p style=3D"margin: 0px;">Traceback (most recent call last):</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/flask/app.py", line 1813, in full_di=
spatch_request</p>
<p style=3D"margin: 0px;">    rv =3D self.dispatch_request()</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/flask/app.py", line 1799, in dispatc=
h_request</p>
<p style=3D"margin: 0px;">    return self.view_functions[rule.endpoint](**r=
eq.view_args)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/flask/views.py", line 88, in view</p=
>
<p style=3D"margin: 0px;">    return self.dispatch_request(*args, **kwargs)=
</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/web/pgadmin/browser/utils.py", line 311, in dispatch_request</p>
<p style=3D"margin: 0px;">    return method(*args, **kwargs)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/web/pgadmin/browser/server_groups/servers/__init__.py", line 1160, in=
 connect</p>
<p style=3D"margin: 0px;">    recovery_state(conn, manager.version)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/web/pgadmin/browser/server_groups/servers/__init__.py", line 53, in r=
ecovery_state</p>
<p style=3D"margin: 0px;">    "connect/sql/#{0}#/check_recovery.sql".format=
(postgres_version))</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/flask/templating.py", line 134, in r=
ender_template</p>
<p style=3D"margin: 0px;">    return _render(ctx.app.jinja_env.get_or_selec=
t_template(template_name_or_list),</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/jinja2/environment.py", line 869, in=
 get_or_select_template</p>
<p style=3D"margin: 0px;">    return self.get_template(template_name_or_lis=
t, parent, globals)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/jinja2/environment.py", line 830, in=
 get_template</p>
<p style=3D"margin: 0px;">    return self._load_template(name, self.make_gl=
obals(globals))</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/jinja2/environment.py", line 804, in=
 _load_template</p>
<p style=3D"margin: 0px;">    template =3D self.loader.load(self, name, glo=
bals)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/venv/lib/python3.7/site-packages/jinja2/loaders.py", line 113, in loa=
d</p>
<p style=3D"margin: 0px;">    source, filename, uptodate =3D self.get_sourc=
e(environment, name)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/web/pgadmin/utils/versioned_template_loader.py", line 15, in get_sour=
ce</p>
<p style=3D"margin: 0px;">    specified_version_number, exists =3D parse_ve=
rsion(template)</p>
<p style=3D"margin: 0px;">  File "/Applications/pgAdmin 4.app/Contents/Reso=
urces/web/pgadmin/utils/versioned_template_loader.py", line 49, in parse_ve=
rsion</p>
<p style=3D"margin: 0px;">    return int(version), True</p>
<p style=3D"margin: 0px;">ValueError: invalid literal for int() with base 1=
0: 'None'</p>
<p style=3D"margin: 0px;"><br><!--EndFragment--></p></div><br></div></div><=
/body></html>
------=_Part_7962888_2137337677.1578420327020--