I create a local SQL lite database and works perfect. When I publish the site to production server the data is not displayed and get this error. The rest seems to work fine.
An error has occurred connecting to the database!
Invalid target configuration! Check your Web Server URL and the connectivity to it.
Any Idea??
Now I move forward a bit and get on the console.
{status: “500”,…}
message
:
“Knex: run\n$ npm install sqlite3 --save\nCannot find module ‘/var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-x64/node_sqlite3.node’\nRequire stack:\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/sqlite3/lib/sqlite3-binding.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/sqlite3/lib/sqlite3.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/dialects/sqlite3/index.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/dialects/index.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/knex-builder/internal/config-resolver.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/knex-builder/Knex.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/index.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/knex.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/core/db.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/core/app.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/core/middleware.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/setup/routes.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/server.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/index.js\n- /usr/share/passenger/helper-scripts/node-loader.js”
stack
:
“Error: Knex: run\n$ npm install sqlite3 --save\nCannot find module ‘/var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-x64/node_sqlite3.node’\nRequire stack:\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/sqlite3/lib/sqlite3-binding.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/sqlite3/lib/sqlite3.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/dialects/sqlite3/index.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/dialects/index.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/knex-builder/internal/config-resolver.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/knex-builder/Knex.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/index.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/knex.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/core/db.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/core/app.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/core/middleware.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/setup/routes.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/server.js\n- /var/www/vhosts/bydelamora.app/chapulinknode2.com/index.js\n- /usr/share/passenger/helper-scripts/node-loader.js\n at Client_SQLite3.initializeDriver (/var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/client.js:202:13)\n at new Client (/var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/client.js:83:12)\n at new Client_SQLite3 (/var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/dialects/sqlite3/index.js:22:5)\n at knex (/var/www/vhosts/bydelamora.app/chapulinknode2.com/node_modules/knex/lib/knex-builder/Knex.js:16:28)\n at App.setDbConnection (/var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/core/app.js:406:27)\n at App.getDbConnection (/var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/core/app.js:425:25)\n at App.select (/var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/modules/dbconnector.js:15:25)\n at App._exec (/var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/core/app.js:610:57)\n at App._exec (/var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/core/app.js:577:28)\n at async App.exec (/var/www/vhosts/bydelamora.app/chapulinknode2.com/lib/core/app.js:546:9)”
status
:
“500”
If I go to the ftp there is no this file
But if I run the list of NPM get this
SQL lite 3 is installed.
I get the error on the appconect
Any Idea I read some on the forum but not resolved.
Regards
SQLite is not really suitable for production deployment.
As SQLite is just a text file making a direct connection from Wappler is simply not going to work.
Also I suspect SQLite support is not present on your server? Can you access the server terminal and run
npm install sqlite3 --save
I run it and is on server.
I know that is not secure but can work for a very simply app without need to setup a complex database.
