Failed to import the collections

[jakubsuchy]

Is there a minimal Pocketbase version? I am on PocketBase v0.23.7

I got this:

Failed to import the collections configuration. Raw error:
failed to save collection "queue_locks": indexes: (0: Failed to create index idx_SKtU4DZ - SQL logic error: no such column: task (1).; 1: Failed to create index idx_GpAPmOu - SQL logic error: no such column: created (1)..).

[RalliPi]

Hi,
just checked the lib out today, because it's exactly what I currently need right now.
Seems like the import/export schema changed (I'm currently using pocketbase 0.24.4).

I quickly recreated the collections by hand. This should work for now:

[
{
"id": "pbc_1488669058",
"listRule": null,
"viewRule": null,
"createRule": null,
"updateRule": null,
"deleteRule": null,
"name": "queue_locks",
"type": "base",
"fields": [
{
"autogeneratePattern": "[a-z0-9]{15}",
"hidden": false,
"id": "text3208210256",
"max": 15,
"min": 15,
"name": "id",
"pattern": "^[a-z0-9]+$",
"presentable": false,
"primaryKey": true,
"required": true,
"system": true,
"type": "text"
},
{
"autogeneratePattern": "",
"hidden": false,
"id": "text1797306934",
"max": 0,
"min": 0,
"name": "worker_id",
"pattern": "",
"presentable": false,
"primaryKey": false,
"required": true,
"system": false,
"type": "text"
},
{
"cascadeDelete": false,
"collectionId": "pbc_4107420034",
"hidden": false,
"id": "relation1384045349",
"maxSelect": 1,
"minSelect": 0,
"name": "task",
"presentable": false,
"required": true,
"system": false,
"type": "relation"
},
{
"hidden": false,
"id": "autodate2990389176",
"name": "created",
"onCreate": true,
"onUpdate": false,
"presentable": false,
"system": false,
"type": "autodate"
},
{
"hidden": false,
"id": "autodate3332085495",
"name": "updated",
"onCreate": true,
"onUpdate": true,
"presentable": false,
"system": false,
"type": "autodate"
}
],
"indexes": [
"CREATE UNIQUE INDEX idx_HSFtKfUArr ON queue_locks (task)",
"CREATE INDEX idx_bn5iw0BzOm ON queue_locks (created)"
],
"system": false
},
{
"id": "pbc_4107420034",
"listRule": null,
"viewRule": null,
"createRule": null,
"updateRule": null,
"deleteRule": null,
"name": "queue_tasks",
"type": "base",
"fields": [
{
"autogeneratePattern": "[a-z0-9]{15}",
"hidden": false,
"id": "text3208210256",
"max": 15,
"min": 15,
"name": "id",
"pattern": "^[a-z0-9]+$",
"presentable": false,
"primaryKey": true,
"required": true,
"system": true,
"type": "text"
},
{
"autogeneratePattern": "",
"hidden": false,
"id": "text2147319651",
"max": 0,
"min": 0,
"name": "queue",
"pattern": "",
"presentable": false,
"primaryKey": false,
"required": true,
"system": false,
"type": "text"
},
{
"hidden": false,
"id": "json1384045349",
"maxSize": 2000000,
"name": "task",
"presentable": false,
"required": false,
"system": false,
"type": "json"
},
{
"hidden": false,
"id": "date2659951479",
"max": "",
"min": "",
"name": "failed",
"presentable": false,
"required": false,
"system": false,
"type": "date"
},
{
"autogeneratePattern": "",
"hidden": false,
"id": "text4016436606",
"max": 0,
"min": 0,
"name": "failed_reason",
"pattern": "",
"presentable": false,
"primaryKey": false,
"required": false,
"system": false,
"type": "text"
},
{
"hidden": false,
"id": "autodate2990389176",
"name": "created",
"onCreate": true,
"onUpdate": false,
"presentable": false,
"system": false,
"type": "autodate"
},
{
"hidden": false,
"id": "autodate3332085495",
"name": "updated",
"onCreate": true,
"onUpdate": true,
"presentable": false,
"system": false,
"type": "autodate"
}
],
"indexes": [
"CREATE INDEX idx_DjQFazUd5h ON queue_tasks (\n queue,\n failed,\n created\n)",
"CREATE INDEX idx_pUcaFfpCFF ON queue_tasks (\n failed,\n updated\n)"
],
"system": false
},
{
"id": "pbc_4199263681",
"listRule": null,
"viewRule": null,
"createRule": null,
"updateRule": null,
"deleteRule": null,
"name": "queue_stats",
"type": "view",
"fields": [
{
"autogeneratePattern": "",
"hidden": false,
"id": "text3208210256",
"max": 0,
"min": 0,
"name": "id",
"pattern": "^[a-z0-9]+$",
"presentable": false,
"primaryKey": true,
"required": true,
"system": true,
"type": "text"
},
{
"hidden": false,
"id": "json3486377887",
"maxSize": 1,
"name": "pending_tasks",
"presentable": false,
"required": false,
"system": false,
"type": "json"
},
{
"hidden": false,
"id": "json907408884",
"maxSize": 1,
"name": "failed_tasks",
"presentable": false,
"required": false,
"system": false,
"type": "json"
}
],
"indexes": [],
"system": false,
"viewQuery": "SELECT queue as id,\n SUM(CASE WHEN failed IS '' THEN 1 ELSE 0 END) as pending_tasks,\n SUM(CASE WHEN failed IS NOT '' THEN 1 ELSE 0 END) as failed_tasks\n FROM queue_tasks\n GROUP BY queue;"
}
]

I will provide a PR with pocketbase updated, if that is something the maintainer wants.

[joseferben]

I will provide a PR with pocketbase updated, if that is something the maintainer wants.

that would be much appreciated!