Errors with adding models to collections

[pxlnic]

This may have to do with my setup but I have caddy as my reverse proxy and this sits behind it. I was able to create a collection and add items to it from the model library but when I go to open it it says there are no models. I am getting node_module errors in my docker logs:

Error: no such column: size
    at e.handleError (/app/node_modules/sql.js/dist/sql-wasm.js:90:192)
    at e.tb (/app/node_modules/sql.js/dist/sql-wasm.js:88:454)
    at all (/app/server/database.js:368:19)
    at get (/app/server/database.js:379:19)
    at /app/server/index.js:1458:21
    at Layer.handle [as handle_request] (/app/node_modules/express/lib/router/layer.js:95:5)
    at next (/app/node_modules/express/lib/router/route.js:149:13)
    at authenticate (/app/server/middleware/auth.js:69:5)
    at Layer.handle [as handle_request] (/app/node_modules/express/lib/router/layer.js:95:5)
    at next (/app/node_modules/express/lib/router/route.js:149:13)

I was testing it not behind my proxy and then updated it to be behind it with no difference. I don't think that's the issue but not sure. I couldn't find anything in other issues or in the docs, but I may have missed it. Appreciate any guidance on this.

[aciulpan]

The issue is in https://github.com/TeeCodeDev/GyroidVault/blob/main/server/index.js#L1459, there is no column size because it's called file_size

you can add

command:
  - sh
  - -c
  - sed -i 's/SUM(size)/SUM(file_size)/' /app/server/index.js && exec node server/index.js

to your container and then restart the container while this will be fixed upstream.

[TeeCodeDev]

Thanks for reporting and sharing the log trace! It had nothing to do with your Caddy reverse proxy setup — there was a typo in the collection stats query (SUM(size) instead of SUM(file_size)).

Just pushed a fix to main. If you pull the latest image/code, collections will load properly.