Comments (15)
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.
Related Issues (20)
- Why is US not in time-series-19-covid-combined.csv? HOT 1
- Files are getting dangerously close to the file size limit of 100MB set on GitHub HOT 1
- Update not working HOT 4
- Update not working HOT 1
- CSV is not being updated
- Recovered Cases Missing for Canada HOT 1
- Recovered Cases missing for USA HOT 1
- Update frequency? HOT 2
- Data for 10 December HOT 1
- Recovered Cases showing same as Confirmed Cases in El Salvador
- Recovered Cases for united states is showing 0 HOT 1
- Sudden decrease in recovered cases on data/worldwide-aggregate.csv on highlighted part in the image below.
- No data for 2021 HOT 3
- Recovered cases all zero? HOT 1
- Running process_worldwide.py always returns error on windows
- Portugal not updated anymore HOT 1
- Data has gone stale HOT 7
- Delayed data - last update 4 days ago HOT 17
- Delayed data updates HOT 1
- Data not updating HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from covid-19.