[BUG] Can't configure table layout (duplicate columns)

[Tom7320]

Describe the bug I can't add/configure/delete columns:

To Reproduce Steps to reproduce the behavior: Try to add/remove columns under Settings -> Tables.

Expected behavior No duplicates. Adding and removing columns without errors.

Context

• OS: Docker on Synology NAS
• Speedtest-Tracker Version: 1.12.0

Additional context (none)

[wavemop]

Same on Raspi + Docker St-T Version 1.12.2

[te5s3rakt]

same on Unraid docker.

I did a quick dig around the source code. I couldn't spot where these are saved in the config files, otherwise I would've just changed manually.

[PROJECTS4com]

Same Issue here, any idea how to fix that?

[te5s3rakt]

Same Issue here, any idea how to fix that?

I worked out that the settings are stored in the local db. Have a look in the settings table. There's values for visible_columns and hidden_columns.

These are all the available fields. Make sure all of them are listed in one of the above.

id,created_at,download,upload,ping,server_id,server_name,server_host,scheduled,url,server_id,server_name,server_host,url,scheduled

I'm not sure of your setup or expertise, but simplest method to edit the db is power down the container, and in the appdata folder copy speed.db to your local machine. There you can edit it with a tool such as sqlite browser. There's versions for MacOS, Windows, whatever. It's simple enough to use. Just edit visible_columns and hidden_columns to your desire, save the db, copy back to appdata, and restart the container.

[PROJECTS4com]

THANK YOU VERY MUCH @te5s3rakt

Although I'm not a programming professional, I was able to solve the issue with your advice.

The speed test tracker of @henrywhitaker3 is a perfect tool and now the table with the speed test results is clear again and without double entries. I´m happy and thankful for your help!