FlamongOle

@martspret and @Squid I have replicated the problem, and I am working on it. Just not entirely sure why it behaves as it does yet.

Could you run this for me, and post it: sqlite3 /boot/config/plugins/disklocation/disklocation.sqlite -cmd "PRAGMA user_version" ".schema disks" ".quit" This will tell me which version of the database it went through, and also the layout of the disks table. I don't see any link between the PHP fatal error and the missing smart_nvme_units_read as it's two different tables.

Would not delete the entire disklocation contents, but only the disklocation.sqlite database in that case. Backup has been made of earlier version, and once I figure this out, it would work after database upgrade.

When did you get that? What did you do before getting that error? That column does not exist anymore, so wonder what happened there.

Update 2024.02.11 Commit #269 - Set SMART "command timeout" to disabled by default. Because of Seagate drives it makes more sense to disable this monitoring by default, like Unraid does. If you already installed Update 2024.02.09 or 2024.02.10 you might need to disable it manually (if you need/want to). Commit #268 - Make a bit more space for more info. Moved the sort buttons below the text to save some space on short columns. Minor convenience update for the larger Overhaul '24 update (yes, I know I'm one day ahead, but that's how I roll):

N/A would be the temperature of the drive, you might need to run "Force scan all" to get it back, if it has a sensor. The SMART warning message should be visible under the "Devices" tab. Disable "Command Timeout" if you have Seagate, not going to make an exception for a manufacturer, or a series of devices. It's disabled by default in Unraid, and I might change that myself as default behaviour.

Is it recognized as an unassigned device? If so, you might need to check if it has a custom color, then change that. Eventually you might need to reset the colors, but do so after a Force scan all, in case something needs to be updated in the database. Custom colors cannot have the same colors as the common colors.

I don't understand what you mean. But USB drives are not supported.

Yes, it's in the group settings. You define the sizes of each "drive" there.

Overhaul '24 By far the biggest update in Disk Locations time! Take a look and read the nice Change Log, and then read the extra info at the bottom. AND THEN! RTFM (press HELP) in Unraid after update! Update 2024.02.12 Commit #271 - BUG: Due to a bug in the database upgrade, I have now checked multiple scenarios why it happened. It should be solved. Also made it possible to access limited functions during database errors for restoring older databases. Version 2 and below is not supported anymore (very old databases: 2019-06-19 and earlier). They will be deleted (but not from the backup) and a new fresh database will be created. Update 2024.02.11 Commit #269 - Set SMART "command timeout" to disabled by default. Because of Seagate drives it makes more sense to disable this monitoring by default, like Unraid does. If you already installed Update 2024.02.09 or 2024.02.10 you might need to disable it manually (if you need/want to). Commit #268 - Make a bit more space for more info. Moved the sort buttons below the text to save some space on short columns. Update 2024.02.10 Commit #262 - IMPROVEMENT: Use manufacture dates from Unraid if they exists instead of just own values. Values written in Unraid will be prioritized and overwrite dates in the plugins database if they exists (also read Commit #249). Commit #261 - BUG: Unassigned devices missing LED for disk OP has been fixed (introduced in 2024.02.09 if you were quick on getting the Overhaul '24 first release). Commit #256 - FEATURE: Added critical SMART warnings, configurable with RAW data (for SATA devices). NVMe uses spare threshold. Also added data units read and written for both SATA (LBAs) and NVMe. Commit #147 - (includes #256) Commit #255 - FEATURE: Added the ability to re-arrange groups. You can now swap between two groups, but only the last one can still be deleted. Commit #254 - FEATURE: Added the ability to create a list to be downloaded (TSV), following the Information selection and sort. Commit #253 - FEATURE: Added possibility to use colors in "comments", see Help under "Tray Allocations" Commit #252 - FEATURE: Database management and cleanup of System. Creating, restoring and deleting backups, moving the database to another location possible. Old backups are converted to the new system. Commit #251 - IMPROVEMENT: Inconsistent action when filling dates occurred in the ISO date format (and probably some others). Limited the max year to 9999. Commit #250 - FEATURE: Sort information by fields has been implemented (in combination with #245). Commit #249 - FEATURE: Database field for 'Date of Manufacture' has been implemented. Might need to enable it manually. Commit #248 - MINOR ISSUE: Lagging Documentation: 'Force Scan All' button is now on System tab. Went through and updated the text on multiple pages and updated the Help sections. Commit #247 - FEATURE: Include legend for color coding on pages where it's used has been added to Info, Tray Allocations and Drives tabs. Commit #246 - FEATURE: Algorithmic abbreviate serial numbers as 'friendly name' has been implemented. Trimming of serial numbers available. Commit #245 - FEATURE: Turn off / rearrange columns has been implemented. (in combination with #250). Commit #242 - IMPROVEMENT: "hover" on the tray number has been moved to the LED, also attached all info to one LED. The worst warning will be shown on the LED, but info from all stages visible. Extra info: New default colors has been made for the array, but they won't change automatically in case you like the original ones. But there's a new button under "Configuration" to reset common colors. Please read the Help text for more information about the new features, there's a lot of new stuff added as you see on the changelog. Click the "Help" icon on the Unraid status bar. "Drives" tab has been merged into "Tray Allocations" as it wasn't really necessary to have an own page for it.

Update 2024.01.18b - HUGE update, really. IMPROVEMENT: Rewrote-ish the cronjob script, works in the plugin GUI as before. Also added back the possibility to run it via CLI again, for manual control: php -f /usr/local/emhttp/plugins/disklocation/pages/cron_disklocation.php cronjob|force [silent] BUG: Yes, to both - probably (fixed old ones and created new ones). IMPROVEMENT: Some minor design tweaks to fit larger systems and not using too much space on the screen/page. IMPROVEMENT: Added a "hover" over the tray number on the dashboard to show the temperature. BUG: Fixed a glitch in the cronjob script. (version b)

Update 2024.01.15 Commit #240 - BUG: Fixed SMART update so it won't disable itself every reboot. It will use the value stored in the DB. Minor update this time, I'll have a look into the other stuff some other day I have time.

Just came to think of it, there's also a debugging file saved at: /boot/config/plugins/disklocation/debugging.html But only after doing the post above!

Almost, there's a manual way of getting the debug info: open unraid terminal and edit this file: /usr/local/emhttp/plugins/disklocation/pages/system.php set the variable $debugging_active to 1: $debugging_active = 1; save the file, run "Force Scan All", copy the text from the output and paste it into a text file (within 60 seconds, yes, auto-refresh still active). Then send me the file privately if you don't wanna share the data publicly (serial numbers etc.), but please leave the log as it is as I need to know what might cause the issue. Then disable the variable again, 0: $debugging_active = 0; GL;HF

Update 2023.09.20 Commit #237 - IMPROVEMENT: Add slightly more info on the "Force Scan All" button. Delayed auto-refresh and added a "Done" button. @arthfink If you still have problems, update the plugin to this version and run "Force Scan All" and give me the output. I need to check how things works as I don't own a raid controller myself.

Update 2923.09.14 Commit #227 - FEATURE: Added "percentage used" and other NVME SMART data to the plugin. Should cover TBW.. ish. Commit #232 - FEATURE: Include global SMART controller and autorenew cron script. Visible Frontpage Information is slightly rearranged, LUN info broken and removed. "Force Scan All" under System tab is advised to run after the update.

I have no idea, however, new update rolling out soon which accepts the global unraid setting. And some other thing..

Update 2023.09.13 Commit #230 FEATURE: SMART controllers should now be supported. Currently only supporting controllers defined by "per device", and not global in Unraid (probably). "Force Scan all" button is moved under "System" tab with more information. Automatic SMART scanning during installation and updates is now disabled entirely, use Force Scan All. No, this was not a small fix. @arthfink you might be interested.

Have you tried to go to "Tray Allocations" and check if the colors has been added as "Custom color"? They override the common config. Also, you can try to "Reset All Colors" with the button at the bottom. If I remember correctly, this should only reset custom colors.

I have not looked into that and how they do it, don't count on it any time soon as I am quite busy with my real life at the moment

"Package server down" Just try again later/tomorrow or something, looks like a GitHub issue. These packages are auto-generated and nothing I make myself.

Update 2023.08.21 Commit #228 - MINOR ISSUE: Fixed temperatures not showing on the LED hover and info page.

Did you try a web browser instead? 😛 Mainly joking as it is Chromium based, but you never know...

Did you "force scan all"? if you have a lot of drives, all of them will likely spin up and take some time per device to complete the scan.

Sadly no. Might be something to add in the future, but no ETA or really any time atm.