Dashboard
Error in query number 1
We are sorry, but an error occurred while generating this page. You should contact the site's administrator.
In "index.sql": The following error occurred while executing an SQL statement:
error returned from database: relation "accounts" does not exist
The SQL statement sent by SQLPage was:
WITH inflows AS (SELECT a.id AS account_id, COALESCE(SUM(t.amount), 0) AS total_in FROM accounts AS a LEFT JOIN transactions AS t ON a.id = t.to_account_id GROUP BY a.id), outflows AS (SELECT a.id AS account_id, COALESCE(SUM(t.amount), 0) AS total_out FROM accounts AS a LEFT JOIN transactions AS t ON a.id = t.from_account_id GROUP BY a.id) SELECT 'card' AS component, 4 AS width FROM accounts;
⬆️
index.sql: lines 31 to 49 Note: You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.