The GC2 framework helps you build a spatial data infrastructure quickly and easily. Powered using open source components for a scalable solution focused on freedom rather than fees.
{"success":false,"message":"Unsupported operand types: int - string","code":500}
The cause of this is an empty value in the fieldconf of a featuretype. if the value of "sort_id" is "" (empty string) PHP will fail.
I've used this to find the relevant information in settings.geometry_columns_join:
SELECT
_key_,
key AS json_key,
value->>'sort_id' AS sort_id
FROM settings.geometry_columns_view, jsonb_each(fieldconf::jsonb)
WHERE value->>'sort_id' IS NULL OR value->>'sort_id' = ''
if your table is very old, fieldconf might not be valid json and the statement will throw errors.
i suggest a check for null/empty values and default to 0 when getting the information.
Failures observed:
Each of the services til return an error like:
The cause of this is an empty value in the fieldconf of a featuretype. if the value of "sort_id" is "" (empty string) PHP will fail.
I've used this to find the relevant information in
settings.geometry_columns_join:if your table is very old,
fieldconfmight not be valid json and the statement will throw errors.i suggest a check for null/empty values and default to 0 when getting the information.