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.