FrederikBaerentsen/BrickTracker
8
20
Fork 12
Code Issues 11 Pull Requests Actions Packages Projects 1 Releases 9 Wiki Activity

Database error! An error has occured: near "name": syntax error. #135

New Issue
Closed
opened 2026-01-25 18:20:31 +01:00 by m_fife · 7 comments
m_fife commented 2026-01-25 18:20:31 +01:00
Copy Link
Copy Source

I'm trying to get BrickTracker setup on my Unraid Server. Currently I'm able to add sets, however, when I add them, none of the pictures show up - just question marks. Additionally, when I attempt to open a set, I receive "Database error!
An error has occured: near "name": syntax error." when I click on it. Any help would be greatly appreciated! Thanks.

I'm trying to get BrickTracker setup on my Unraid Server. Currently I'm able to add sets, however, when I add them, none of the pictures show up - just question marks. Additionally, when I attempt to open a set, I receive "Database error! An error has occured: near "name": syntax error." when I click on it. Any help would be greatly appreciated! Thanks.
FrederikBaerentsen added the Unraid label 2026-01-25 19:03:30 +01:00
FrederikBaerentsen commented 2026-01-25 19:05:17 +01:00
Owner
Copy Link
Copy Source

I unfortunately don't use Unraid and I have no idea how its Docker implementation is. I would suggest you look at some of the older issues regarding Unraid (https://gitea.baerentsen.space/FrederikBaerentsen/BrickTracker/issues?type=all&state=all&labels=68).

Unraid is not officially supported.

I unfortunately don't use Unraid and I have no idea how its Docker implementation is. I would suggest you look at some of the older issues regarding Unraid (https://gitea.baerentsen.space/FrederikBaerentsen/BrickTracker/issues?type=all&state=all&labels=68). Unraid is not officially supported.
m_fife commented 2026-01-25 23:42:38 +01:00
Author
Copy Link
Copy Source

I’ll keep working on it, lots of repeat stuff in the logs like “ WARNING:bricktracker.views.error:Not found: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. (path: /static/minifigures/nil_mf.jpg)”

I’m not sure why it is looking there, all the paths dropped the static? Is there somewhere else to configure it?

I’ll keep working on it, lots of repeat stuff in the logs like “ WARNING:bricktracker.views.error:Not found: 404 Not Found: The requested URL was not found on the server. If you entered the URL manually please check your spelling and try again. (path: /static/minifigures/nil_mf.jpg)” I’m not sure why it is looking there, all the paths dropped the static? Is there somewhere else to configure it?
FrederikBaerentsen commented 2026-01-26 13:01:43 +01:00
Owner
Copy Link
Copy Source

How are you running it in Unraid? Are you using an existing template or setting up your own Docker container?

Please take a look at #132 (comment), as it might help.

How are you running it in Unraid? Are you using an existing template or setting up your own Docker container? Please take a look at https://gitea.baerentsen.space/FrederikBaerentsen/BrickTracker/issues/132#issuecomment-1223, as it might help.
m_fife commented 2026-01-29 01:57:55 +01:00
Author
Copy Link
Copy Source

Figured it out.. the parts sort SQL command had a typo in it! Awesome app, sorry for the trouble!

Figured it out.. the parts sort SQL command had a typo in it! Awesome app, sorry for the trouble!
FrederikBaerentsen commented 2026-01-29 17:18:29 +01:00
Owner
Copy Link
Copy Source

What did you change it to? Maybe i can fix it in the code.

What did you change it to? Maybe i can fix it in the code.
deadbattery commented 2026-02-09 17:10:46 +01:00
Copy Link
Copy Source

I have BK_PARTS_DEFAULT_ORDER currently set to "rebrickable_parts"."color_name" ASC, "rebrickable_parts"."name" ASC but I don't know what the default was before I changed it.

I have `BK_PARTS_DEFAULT_ORDER` currently set to `"rebrickable_parts"."color_name" ASC, "rebrickable_parts"."name" ASC` but I don't know what the default was before I changed it.
FrederikBaerentsen commented 2026-02-18 16:31:19 +01:00
Owner
Copy Link
Copy Source

Defaults are:

  • 1.3.1: Default: "rebrickable_parts"."name" ASC, "rebrickable_parts"."color_name" ASC, "bricktracker_parts"."spare" ASC
  • 1.4: Default: "rebrickable_parts"."name" ASC, "rebrickable_parts"."color_name" ASC, "combined"."spare" ASC

Closing this for now. Feel free to comment or reopen if they defaults doesn't work.

Defaults are: - 1.3.1: `Default: "rebrickable_parts"."name" ASC, "rebrickable_parts"."color_name" ASC, "bricktracker_parts"."spare" ASC` - 1.4: `Default: "rebrickable_parts"."name" ASC, "rebrickable_parts"."color_name" ASC, "combined"."spare" ASC` Closing this for now. Feel free to comment or reopen if they defaults doesn't work.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Compat/Breaking
Breaking change that won't be backward compatible
 Kind/Bug
Something is not working
 Kind/Documentation
Documentation changes
 Kind/Enhancement
Improve existing functionality
 Kind/Feature
New functionality
 Kind/Security
This is security issue
 Kind/Testing
Issue or pull request related to testing
 Out of Scope
Request is out of scope
Priority
Critical
The priority is critical
Priority
High
The priority is high
Priority
Low
The priority is low
Priority
Medium
The priority is medium
Reviewed
Confirmed
Issue has been confirmed
Reviewed
Duplicate
This issue or pull request already exists
Reviewed
Invalid
Invalid issue
Reviewed
Won't Fix
This issue won't be fixed
Status
Abandoned
Somebody has started to work on this but abandoned work
Status
Blocked
Something is blocking this issue or pull request
Status
Need More Info
Feedback is required to reproduce issue or to continue work
Unraid
Unsupported/Can't help
No Label Unraid
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
FrederikBaerentsen
No Assignees
3 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: FrederikBaerentsen/BrickTracker#135
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?