unable to open database file about covid-19 HOT 15 CLOSED

Any update on this?

from covid-19.

I also encountered the same:
Traceback (most recent call last):
File "process.py", line 39, in
'aggregate': 'first'
File "C:\ProgramData\Anaconda3\lib\site-packages\dataflows\processors\join.py", line 363, in join
return join_aux(source_name, source_key, source_delete, target_name, target_key, fields, full, mode)
File "C:\ProgramData\Anaconda3\lib\site-packages\dataflows\processors\join.py", line 172, in join_aux
db_keys_usage = KVFile()
File "C:\ProgramData\Anaconda3\lib\site-packages\kvfile\kvfile.py", line 19, in init
self.db = DB_ENGINE.connect(self.tmpfile.name)
sqlite3.OperationalError: unable to open database file

from covid-19.

@zelima it would appear multiple people have this same exact problem? Is there a solution for it?

from covid-19.

@karthikkunala are you also using windows?

I have no idea, but after googling a bit it might be related to insufficient permission for sqlite. See gunthercox/ChatterBot#1044 (comment) also https://serverfault.com/a/57597

Usually sqlite db file will created in current directory. Due to lack of permission sqlite unable to create db.sqlite3 file on your current directory.

from covid-19.

@karthikkunala can you give more detail of how you are trying to use this so we can help debug?

from covid-19.

Hi,
I just opened up the project, and after I run the code 'process.py' I received the same error.
Here is my traceback:
Traceback (most recent call last):
File "C:\Users\user\Desktop\covid-19\process.py", line 44, in
'aggregate': 'first'
File "C:\Users\user\AppData\Local\Programs\Python\Python36\lib\site-packages\dataflows\processors\join.py", line 363, in join
return join_aux(source_name, source_key, source_delete, target_name, target_key, fields, full, mode)
File "C:\Users\user\AppData\Local\Programs\Python\Python36\lib\site-packages\dataflows\processors\join.py", line 172, in join_aux
db_keys_usage = KVFile()
File "C:\Users\user\AppData\Local\Programs\Python\Python36\lib\site-packages\kvfile\kvfile.py", line 19, in init
self.db = DB_ENGINE.connect(self.tmpfile.name)
sqlite3.OperationalError: unable to open database file

from covid-19.

It's made the program crash every time I tried to run it.

from covid-19.

@odev954 why are you trying to run it? That's the data collection script.

from covid-19.

from covid-19.

@karthikkunala @SavoX2 @eemberda @odev954 hi all, can you try to follow updated instructions - https://github.com/datasets/covid-19#preparation ? Also, make sure you're using python v3.6 or newer.

from covid-19.

I followed the updated preparation instructions but I still got the same error as before after I run the 'process.py' script. I am currently running it in python v3.6.8 on Windows 10.
Here is the traceback I received:
Traceback (most recent call last): File "process.py", line 44, in <module> 'aggregate': 'first' File "C:\Users\user\AppData\Local\Programs\Python\Python36\lib\site-packages\dataflows\processors\join.py", line 363, in join return join_aux(source_name, source_key, source_delete, target_name, target_key, fields, full, mode) File "C:\Users\user\AppData\Local\Programs\Python\Python36\lib\site-packages\dataflows\processors\join.py", line 172, in join_aux db_keys_usage = KVFile() File "C:\Users\user\AppData\Local\Programs\Python\Python36\lib\site-packages\kvfile\kvfile.py", line 19, in __init__ self.db = DB_ENGINE.connect(self.tmpfile.name) sqlite3.OperationalError: unable to open database file

from covid-19.

after I run the project on my VM (OS: Ubunto) the project is working and the process.py is running successfully, maybe it's because the 'dataflows' package is not so supported currently in Windows or has some issues.

from covid-19.

I'm also getting the same error. I have followed the instructions and using python version greater 3.6 on windows machine.

Traceback (most recent call last):
  File ".\scripts\process.py", line 90, in <module>
    join(
  File "C:\Users\midhu\Documents\midhun\covid 19 projects\envs\covid19_1_env\lib\site-packages\dataflows\processors\join.py", line 363, in join
    return join_aux(source_name, source_key, source_delete, target_name, target_key, fields, full, mode)
  File "C:\Users\midhu\Documents\midhun\covid 19 projects\envs\covid19_1_env\lib\site-packages\dataflows\processors\join.py", line 172, in join_aux
    db_keys_usage = KVFile()
  File "C:\Users\midhu\Documents\midhun\covid 19 projects\envs\covid19_1_env\lib\site-packages\kvfile\kvfile.py", line 19, in __init__
    self.db = DB_ENGINE.connect(self.tmpfile.name)
sqlite3.OperationalError: unable to open database file

from covid-19.

I can confirm that this is windows specific issue. Here is the tracker - datahq/dataflows#57

from covid-19.

Closing this as WONTFIX

from covid-19.