Hi everyone,
I'm encountering a database error while trying to set up my application, and I could use some help.
What I Did So Far
Thanks to some previous advice, I was able to proceed past an earlier issue and reach the password input step. However, now I'm facing a new error:
Browser Console Error:
JSON.parse: unexpected end of data at line 1 column 1 of the JSON data
Additionally, the console logs show:
`Page running with server errors. dedalo_last_error: Server errors occurred. Check the server log for details.
DBB installed:
Object { result: true, msg: "OK. Request done", action: "install", dedalo_last_error: "Server errors occurred. Check the server log for details" }
Request options:
Object { body: {…} }
body: Object { action: "install", dd_api: "dd_utils_api", options: {…} }
action: "install"
dd_api: "dd_utils_api"
options: Object { action: "set_root_pw", password: "MYVERYSECRETPASSWORD" }
!!!!! [data_manager.request] SERVER ERROR. Received data is not JSON valid. See your server log for details.`
PHP Log Errors:
AH01071: Got error 'PHP message: ERROR [dd_error::captureError]: Array
[type] => 2
[message] => pg_query(): Query failed: ERROR: relation "jer_dd" does not exist
LINE 1: ...FROM "jer_dd" WHERE "terminoID"='dd133'
^
[file] => /var/www/vhosts/myfantasticdomain.com/httpdocs/dedalo/core/db/class.RecordDataBoundObject.php
[line] => 213
This indicates that the SQL query is trying to access the table "jer_dd", but the table does not exist in the database.
Possible Causes
- The database might not have been properly initialized.
- The required schema might not have been imported correctly.
- Some permissions issues might be preventing access to the database.
- I previously had trouble importing the database and added:
- CREATE EXTENSION IF NOT EXISTS pg_trgm;
- CREATE EXTENSION IF NOT EXISTS unaccent;
- I'm running AlmaLinux with Plesk, and I've had multiple issues with permissions, especially with .pgpass.
Questions
- Could this be due to a missing schema or an incomplete database import?
- Would dropping and re-importing the database be a good idea?
- Are there specific Plesk/PostgreSQL settings that might be causing permission issues?
Any insights would be greatly appreciated! Thanks in advance.
