@usafa43tsolo @FrederikBaerentsen I figured it out.
The unraid CommunityApplications template for BrickTracker sets the default sorting environment variables (in the 'show more settings')…
so your concatenate those two columns into a virtual column or something? I'll see if I can get compose working. unraid and compose is always a pain lol
@FrederikBaerentsen your schema doesn't appear to have any "set_number" column, so I'm struggling to understand how the application would even be looking for it
@bitkraken yes. It was a mistake. Apologies!
@FrederikBaerentsen can you advise which columns should be present in each of the tables? I'm not well versed in SQL to be able to look at the…
@bitkraken - do you have any input here? Still getting this issue. Not sure if its exclusive to unraid?
I just realized that the Parts, Problems, and Minifigures pages also throw database errors for versions greater than 1.0.0 -
Parts: no such column: inventory.name Problems: no such column:…
Its happening because of the origin definition.. if it doesn't match how you're actually accessing the instance, it won't pull.
I would love to see the option to automatically grab instruction pdf's from rebrickable or bricklink - perhaps not by default because some users wouldn't want them. Otherwise this is an awesome…