joshmans
  • Joined on 2025-01-08
joshmans commented on issue FrederikBaerentsen/BrickTracker#72 2025-03-28 23:46:38 +01:00
Database error if version is greater than 1.0.0

@usafa43tsolo @FrederikBaerentsen I figured it out.

The unraid CommunityApplications template for BrickTracker sets the default sorting environment variables (in the 'show more settings')…

joshmans commented on issue FrederikBaerentsen/BrickTracker#72 2025-03-28 23:18:49 +01:00
Database error if version is greater than 1.0.0

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

joshmans commented on issue FrederikBaerentsen/BrickTracker#72 2025-03-28 23:10:32 +01:00
Database error if version is greater than 1.0.0

@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

joshmans commented on issue FrederikBaerentsen/BrickTracker#72 2025-03-28 22:39:23 +01:00
Database error if version is greater than 1.0.0

@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…

joshmans commented on issue FrederikBaerentsen/BrickTracker#72 2025-03-28 22:12:16 +01:00
Database error if version is greater than 1.0.0

@bitkraken - do you have any input here? Still getting this issue. Not sure if its exclusive to unraid?

joshmans commented on issue FrederikBaerentsen/BrickTracker#72 2025-03-22 21:30:05 +01:00
Database error if version is greater than 1.0.0

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:…

joshmans opened issue FrederikBaerentsen/BrickTracker#72 2025-03-22 03:21:55 +01:00
Database error if version is greater than 1.0.0
joshmans commented on issue FrederikBaerentsen/BrickTracker#33 2025-01-08 03:49:31 +01:00
can't add sets on create page

Its happening because of the origin definition.. if it doesn't match how you're actually accessing the instance, it won't pull.

joshmans commented on issue FrederikBaerentsen/BrickTracker#25 2025-01-08 03:43:08 +01:00
Improvements

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…