converge / instapy-dashboard

(discontinued) InstaPy Dashboard developed using React.js and Node.js
GNU Affero General Public License v3.0
218 stars 44 forks source link

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

Open dawnarius opened 4 years ago

dawnarius commented 4 years ago

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

> instapy-dashboard@0.3.0 start E:\Dev\InstaPy\instapy-dashboard
> concurrently --kill-others-on-fail "react-scripts start" "npm run server"

[1]
[1] > instapy-dashboard@0.3.0 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 `