Getting (code: 11) malformed database schema (5)

[castlekaybee]

My SQLITE database is on a network drive. I can connect and edit the data through sqlPage. sqlpage.exe and the associated .sql files are also on that network drive.

LOG:
[2024-10-22T08:09:29.799Z INFO sqlpage::webserver::database::connect] Connecting to database: sqlite://../safety.db?mode=rwc [2024-10-22T08:09:29.809Z INFO sqlpage::webserver::database::migrations] No migration found in ./sqlpage\migrations. You can specify database operations to apply when the server first starts by creating files in migrations/<VERSION>_<DESCRIPTION>.sql where <VERSION> is a number and <DESCRIPTION> is a short string. [2024-10-22T08:09:30.020Z INFO sqlpage::webserver::http] SQLPage v0.28.0 started successfully. Now listening on 0.0.0.0:8080: accessible from the network, and locally on http://localhost:8080 You can write your website's code in .sql files in #network location [2024-10-22T08:09:32.890Z INFO actix_web::middleware::logger] 127.0.0.1 "GET / HTTP/1.1" 200 6410 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36" 0.015733 [2024-10-22T08:09:37.782Z INFO actix_web::middleware::logger] 127.0.0.1 "GET /UI/MaschinenKomponenten/MK_PageList.sql?m_id_from_url=5&agg_id_from_url=all HTTP/1.1" 200 270176 "http://localhost:8080/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36" 0.072359 [2024-10-22T08:09:39.348Z INFO actix_web::middleware::logger] 127.0.0.1 "GET /UI/MaschinenKomponenten/MK_PageList.sql?m_id_from_url=5&agg_id_from_url=3 HTTP/1.1" 200 10102 "http://localhost:8080/UI/MaschinenKomponenten/MK_PageList.sql?m_id_from_url=5&agg_id_from_url=all" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36" 0.018570

Connecting from a different PC I get this error:
[2024-10-22T08:10:08.090Z INFO sqlpage::webserver::database::connect] Connecting to database: sqlite://../safety.db?mode=rwc [2024-10-22T08:10:08.148Z INFO sqlpage::webserver::database::migrations] No migration found in ./sqlpage\migrations. You can specify database operations to apply when the server first starts by creating files in migrations/<VERSION>_<DESCRIPTION>.sql where <VERSION> is a number and <DESCRIPTION> is a short string. [2024-10-22T08:10:08.602Z INFO sqlpage::webserver::http] SQLPage v0.28.0 started successfully. Now listening on 0.0.0.0:8080: accessible from the network, and locally on http://localhost:8080 You can write your website's code in .sql files in #network location [2024-10-22T08:10:10.709Z ERROR sqlpage::render] SQL error: error returned from database: (code: 11) malformed database schema (5) Caused by: (code: 11) malformed database schema (5) [2024-10-22T08:10:10.714Z INFO actix_web::middleware::logger] 127.0.0.1 "GET / HTTP/1.1" 200 5367 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36" 0.050127

There seems to be a different port in the GET but why would there be and can you help me troubleshoot this?

[castlekaybee]

It seems there is an access conflict when starting sqlpage on two pcs. I should propably install it as a proper server...

[lovasoa]

Yes, sqlpage is a local database, and making the file available on a network drive will not make it a network database : 😁