search

henrywhitaker3 / Speedtest-Tracker

Continuously track your internet speed
GNU General Public License v3.0
1.52k stars 121 forks source link

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

Open Tom7320 opened 1 year ago

Tom7320 commented 1 year ago

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

image

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

Additional context (none)

wavemop commented 1 year ago

Same on Raspi + Docker St-T Version 1.12.2

te5s3rakt commented 9 months ago

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 commented 9 months ago

Same Issue here, any idea how to fix that?

te5s3rakt commented 9 months ago

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 commented 9 months ago

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!