Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

No data shown and Unable to connect to the database: ConnectionError #45

Open
dawnarius opened this issue Feb 20, 2020 · 0 comments
Open

Comments

@dawnarius
Copy link

InstaPy Dashboard don't show any data and I have an error in cli output as below
Instapy is working without any issue
The path to instapy folder seems correct and accepted in .env file
instapy.db file exists
I am using windows 10

npm start

> [email protected] start E:\Dev\InstaPy\instapy-dashboard
> concurrently --kill-others-on-fail "react-scripts start" "npm run server"

[1]
[1] > [email protected] server E:\Dev\InstaPy\instapy-dashboard
[1] > node ./src/services/server.js
[1]
[1] RESTful API running on port: 3001
[1] Unable to connect to the database: ConnectionError [SequelizeConnectionError]: SQLITE_CANTOPEN: unable to open database file
[1]     at Database.<anonymous> (E:\Dev\InstaPy\instapy-dashboard\node_modules\sequelize\lib\dialects\sqlite\connection-manager.js:61:34) {
[1]   name: 'SequelizeConnectionError',
[1]   parent: [Error: SQLITE_CANTOPEN: unable to open database file] {
[1]     errno: 14,
[1]     code: 'SQLITE_CANTOPEN'
[1]   },
[1]   original: [Error: SQLITE_CANTOPEN: unable to open database file] {
[1]     errno: 14,
[1]     code: 'SQLITE_CANTOPEN'
[1]   }
[1] }
[0] i 「wds」: Project is running at http://192.168.1.2/
[0] i 「wds」: webpack output is served from
[0] i 「wds」: Content not from webpack is served from E:\Dev\InstaPy\instapy-dashboard\public
[0] i 「wds」: 404s will fallback to /
[0] Starting the development server...
[0]
[0] Compiled successfully!
[0]
[0] You can now view instapy-dashboard in the browser.
[0]
[0]   Local:            http://localhost:3000
[0]   On Your Network:  http://192.168.1.2:3000
[0]
[0] Note that the development build is not optimized.
[0] To create a production build, use npm run build.
[0]
[1] Executing (default): SELECT recActivity.rowid,
[1]                prof.id as profile_id,
[1]                prof.name,
[1]                sum(recActivity.likes) as likes,
[1]                sum(recActivity.comments) as comments,
[1]                sum(recActivity.follows) as follows,
[1]                sum(recActivity.unfollows) as unfollows,
[1]                sum(recActivity.server_calls) as server_calls,
[1]                strftime('%Y-%m-%d', recActivity.created) as day_filter
[1]       FROM recordActivity as recActivity
[1]       LEFT JOIN profiles as prof ON recActivity.profile_id = prof.id
[1]       GROUP BY day_filter, profile_id
[1]       ORDER BY recActivity.created desc

Screenshot_2020-02-20 InstaPy Dashboard
`

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant