stockbase.profession

Add record

No data

Error in query number 7

We are sorry, but an error occurred while generating this page. You should contact the site's administrator.

In "dwui/table/stockbase.profession.sql": The following error occurred while executing an SQL statement:
error returned from database: ODBC emitted an error calling 'SQLExecDirect':
State: 42501, Native error: 1, Message: ERROR: permission denied for table command;
Error while executing the query

The SQL statement sent by SQLPage was:
SELECT '**[' || (coalesce(title::TEXT, '')) || ']( ' || '../form/stockbase.profession' || dwui.jsonb_urlencode(CAST(? AS TEXT), ('{"id": ' || to_json(uuid::TEXT) || '}')::JSONB) || ')**' AS profession, title AS title, description AS description, '[' || (SELECT count(*) FROM stockbase.skill __ctable WHERE __ctable.profession_uuid = stockbase.profession.uuid)::TEXT || ' ' || 'skill' || '](stockbase.skill?filter=' || urlencode(jsonb_build_object('profession_uuid', uuid::TEXT)::TEXT) || ')' AS skill, '[' || (SELECT count(*) FROM stockbase.command __ctable WHERE __ctable.profession_uuid = stockbase.profession.uuid)::TEXT || ' ' || 'command' || '](stockbase.command?filter=' || urlencode(jsonb_build_object('profession_uuid', uuid::TEXT)::TEXT) || ')' AS command, '[' || (SELECT count(*) FROM stockbase.function __ctable WHERE __ctable.profession_uuid = stockbase.profession.uuid)::TEXT || ' ' || 'function' || '](stockbase.function?filter=' || urlencode(jsonb_build_object('profession_uuid', uuid::TEXT)::TEXT) || ')' AS function FROM stockbase.profession WHERE (CAST(? AS TEXT) IS NULL OR (((CAST(? AS TEXT)::JSONB) ->> 'uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'uuid')::UUID = uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'title' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'title')::"varchar" = title) AND ((CAST(? AS TEXT)::JSONB) ->> 'description' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'description')::"varchar" = description))) LIMIT CAST(CAST(? AS TEXT) AS INTEGER) OFFSET (CAST(CAST(? AS TEXT) AS INTEGER) - 1) * CAST(CAST(? AS TEXT) AS INTEGER);
dwui/table/stockbase.profession.sql: lines 64 to 78

Note: You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.