Thread: Export Error

On Mar 27, 2020, at 12:15 AM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi,

On Fri, Mar 27, 2020 at 2:07 AM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

In pgadmin 4.16 I get the following error when I try to export a file: "expected str, bytes or os.PathLike object, not NoneType". Any thoughts? Thanks.

Please enable logging and send the pgAdmin log file. Please refer: https://www.pgadmin.org/faq/#8

Thanks,

Khushboo 

On Mar 29, 2020, at 11:27 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

On Sat, Mar 28, 2020 at 2:04 AM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

There is no folder “web/“ (Mac) and about 10 different “config.py” files. 

on MacOS, path would be /Applications/pgAdmin 4.app/Contents/Resources/web .

On Mar 27, 2020, at 12:15 AM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi,

On Fri, Mar 27, 2020 at 2:07 AM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

In pgadmin 4.16 I get the following error when I try to export a file: "expected str, bytes or os.PathLike object, not NoneType". Any thoughts? Thanks.

Please enable logging and send the pgAdmin log file. Please refer: https://www.pgadmin.org/faq/#8

Thanks,

Khushboo 

On Apr 7, 2020, at 3:49 AM, Dave Page <dpage@pgadmin.org> wrote:

On Mon, Apr 6, 2020 at 5:57 PM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

There is no folder /web

Then one has to wonder what you're running. Probably 95% of the code for pgAdmin is in the web/ directory in the macOS build. Are you running a container or the Python package?

 

On Mar 29, 2020, at 11:27 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

On Sat, Mar 28, 2020 at 2:04 AM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

There is no folder “web/“ (Mac) and about 10 different “config.py” files. 

on MacOS, path would be /Applications/pgAdmin 4.app/Contents/Resources/web .

On Mar 27, 2020, at 12:15 AM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi,

On Fri, Mar 27, 2020 at 2:07 AM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

In pgadmin 4.16 I get the following error when I try to export a file: "expected str, bytes or os.PathLike object, not NoneType". Any thoughts? Thanks.

Please enable logging and send the pgAdmin log file. Please refer: https://www.pgadmin.org/faq/#8

Thanks,

Khushboo 

-- 

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Apr 8, 2020, at 12:44 PM, Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

2020-04-07 15:08:44,503: ERROR flask.app: expected str, bytes or os.PathLike object, not NoneType

Traceback (most recent call last):

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/web/pgadmin/tools/import_export/__init__.py", line 323, in create_import_export_job

p.start()

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/web/pgadmin/misc/bgprocess/processes.py", line 406, in start

preexec_fn=preexec_function, env=env

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/subprocess.py", line 775, in __init__

restore_signals, start_new_session)

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/subprocess.py", line 1433, in _execute_child

env_list.append(k + b'=' + os.fsencode(v))

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/os.py", line 809, in fsencode

filename = fspath(filename) # Does type-checking of `filename`.

TypeError: expected str, bytes or os.PathLike object, not NoneType

Note: I uninstalled and reinstalled everything and found the web folder. 

On Apr 7, 2020, at 3:49 AM, Dave Page <dpage@pgadmin.org> wrote:

On Mon, Apr 6, 2020 at 5:57 PM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

There is no folder /web

Then one has to wonder what you're running. Probably 95% of the code for pgAdmin is in the web/ directory in the macOS build. Are you running a container or the Python package?

 

On Mar 29, 2020, at 11:27 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

On Sat, Mar 28, 2020 at 2:04 AM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

There is no folder “web/“ (Mac) and about 10 different “config.py” files. 

on MacOS, path would be /Applications/pgAdmin 4.app/Contents/Resources/web .

On Mar 27, 2020, at 12:15 AM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi,

On Fri, Mar 27, 2020 at 2:07 AM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

In pgadmin 4.16 I get the following error when I try to export a file: "expected str, bytes or os.PathLike object, not NoneType". Any thoughts? Thanks.

Please enable logging and send the pgAdmin log file. Please refer: https://www.pgadmin.org/faq/#8

Thanks,

Khushboo 

-- 

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Apr 14, 2020, at 11:46 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi,

On Tue, Apr 14, 2020 at 10:39 PM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

Haven’t heard back on this yet.

2020-04-07 15:08:44,503: ERROR flask.app: expected str, bytes or os.PathLike object, not NoneType

Traceback (most recent call last):

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/web/pgadmin/tools/import_export/__init__.py", line 323, in create_import_export_job

p.start()

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/web/pgadmin/misc/bgprocess/processes.py", line 406, in start

preexec_fn=preexec_function, env=env

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/subprocess.py", line 775, in __init__

restore_signals, start_new_session)

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/subprocess.py", line 1433, in _execute_child

env_list.append(k + b'=' + os.fsencode(v))

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/os.py", line 809, in fsencode

filename = fspath(filename) # Does type-checking of `filename`.

TypeError: expected str, bytes or os.PathLike object, not NoneType

Looks like, some problem with the file path.

Please provide the steps which you have followed to export the file, if possible provide screen-shots.

Thanks,

Khushboo

Note: I uninstalled and reinstalled everything and found the web folder.

Thanks

On Apr 8, 2020, at 12:44 PM, Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

2020-04-07 15:08:44,503: ERROR flask.app: expected str, bytes or os.PathLike object, not NoneType

Traceback (most recent call last):

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/web/pgadmin/tools/import_export/__init__.py", line 323, in create_import_export_job

p.start()

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/web/pgadmin/misc/bgprocess/processes.py", line 406, in start

preexec_fn=preexec_function, env=env

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/subprocess.py", line 775, in __init__

restore_signals, start_new_session)

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/subprocess.py", line 1433, in _execute_child

env_list.append(k + b'=' + os.fsencode(v))

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/os.py", line 809, in fsencode

filename = fspath(filename) # Does type-checking of `filename`.

TypeError: expected str, bytes or os.PathLike object, not NoneType

Note: I uninstalled and reinstalled everything and found the web folder. 

On Apr 7, 2020, at 3:49 AM, Dave Page <dpage@pgadmin.org> wrote:

On Mon, Apr 6, 2020 at 5:57 PM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

There is no folder /web

Then one has to wonder what you're running. Probably 95% of the code for pgAdmin is in the web/ directory in the macOS build. Are you running a container or the Python package?

 

On Mar 29, 2020, at 11:27 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

On Sat, Mar 28, 2020 at 2:04 AM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

There is no folder “web/“ (Mac) and about 10 different “config.py” files. 

on MacOS, path would be /Applications/pgAdmin 4.app/Contents/Resources/web .

On Mar 27, 2020, at 12:15 AM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi,

On Fri, Mar 27, 2020 at 2:07 AM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

In pgadmin 4.16 I get the following error when I try to export a file: "expected str, bytes or os.PathLike object, not NoneType". Any thoughts? Thanks.

Please enable logging and send the pgAdmin log file. Please refer: https://www.pgadmin.org/faq/#8

Thanks,

Khushboo 

-- 

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On Apr 16, 2020, at 12:43 AM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi Michael,

On Thu, Apr 16, 2020 at 1:35 AM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

<Screen Shot 2020-04-15 at 4.04.10 PM.png><Screen Shot 2020-04-15 at 4.02.31 PM.png><Screen Shot 2020-04-15 at 3.55.36 PM.png>

Thanks for sharing the details. We need to investigate this issue further as I am not able to reproduce this issue at my end.

Please log this issue @ https://redmine.postgresql.org/projects/pgadmin4 with all the details. 

Thanks,

Khushboo

On Apr 14, 2020, at 11:46 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi,

On Tue, Apr 14, 2020 at 10:39 PM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

Haven’t heard back on this yet.

2020-04-07 15:08:44,503: ERROR flask.app: expected str, bytes or os.PathLike object, not NoneType

Traceback (most recent call last):

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/web/pgadmin/tools/import_export/__init__.py", line 323, in create_import_export_job

p.start()

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/web/pgadmin/misc/bgprocess/processes.py", line 406, in start

preexec_fn=preexec_function, env=env

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/subprocess.py", line 775, in __init__

restore_signals, start_new_session)

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/subprocess.py", line 1433, in _execute_child

env_list.append(k + b'=' + os.fsencode(v))

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/os.py", line 809, in fsencode

filename = fspath(filename) # Does type-checking of `filename`.

TypeError: expected str, bytes or os.PathLike object, not NoneType

Looks like, some problem with the file path.

Please provide the steps which you have followed to export the file, if possible provide screen-shots.

Thanks,

Khushboo

Note: I uninstalled and reinstalled everything and found the web folder.

Thanks

On Apr 8, 2020, at 12:44 PM, Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

2020-04-07 15:08:44,503: ERROR flask.app: expected str, bytes or os.PathLike object, not NoneType

Traceback (most recent call last):

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/web/pgadmin/tools/import_export/__init__.py", line 323, in create_import_export_job

p.start()

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/web/pgadmin/misc/bgprocess/processes.py", line 406, in start

preexec_fn=preexec_function, env=env

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/subprocess.py", line 775, in __init__

restore_signals, start_new_session)

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/subprocess.py", line 1433, in _execute_child

env_list.append(k + b'=' + os.fsencode(v))

File "/Library/PostgreSQL/12/pgAdmin 4.app/Contents/Resources/venv/lib/python3.7/os.py", line 809, in fsencode

filename = fspath(filename) # Does type-checking of `filename`.

TypeError: expected str, bytes or os.PathLike object, not NoneType

Note: I uninstalled and reinstalled everything and found the web folder. 

On Apr 7, 2020, at 3:49 AM, Dave Page <dpage@pgadmin.org> wrote:

On Mon, Apr 6, 2020 at 5:57 PM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

There is no folder /web

Then one has to wonder what you're running. Probably 95% of the code for pgAdmin is in the web/ directory in the macOS build. Are you running a container or the Python package?

 

On Mar 29, 2020, at 11:27 PM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

On Sat, Mar 28, 2020 at 2:04 AM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

There is no folder “web/“ (Mac) and about 10 different “config.py” files. 

on MacOS, path would be /Applications/pgAdmin 4.app/Contents/Resources/web .

On Mar 27, 2020, at 12:15 AM, Khushboo Vashi <khushboo.vashi@enterprisedb.com> wrote:

Hi,

On Fri, Mar 27, 2020 at 2:07 AM Michael Benjamin <michaelbenjamin@advancedneuralbio.com> wrote:

In pgadmin 4.16 I get the following error when I try to export a file: "expected str, bytes or os.PathLike object, not NoneType". Any thoughts? Thanks.

Please enable logging and send the pgAdmin log file. Please refer: https://www.pgadmin.org/faq/#8

Thanks,

Khushboo 

-- 

Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company