search

olehj / disklocation

Disk Location is a plugin for Unraid.
https://forums.unraid.net/topic/77302-plugin-disk-location
GNU General Public License v3.0
21 stars 3 forks source link

SQL error during installation #174

Closed P6g9YHK6 closed 1 year ago

P6g9YHK6 commented 2 years ago

I am getting the following during the installation:

Adding disks into database, please wait... this might take a while...

**Warning: SQLite3::exec(): no such table: settings in /usr/local/emhttp/plugins/disklocation/pages/sqlite_tables.php on line 465 no such table: settings Warning: SQLite3::exec(): cannot start a transaction within a transaction in /usr/local/emhttp/plugins/disklocation/pages/sqlite_tables.php on line 498 cannot start a transaction within a transaction Warning: SQLite3::query(): Unable to prepare statement: 1, no such table: disks in /usr/local/emhttp/plugins/disklocation/pages/sqlite_tables.php on line 506

Fatal error: Uncaught Error: Call to a member function fetchArray() on bool in /usr/local/emhttp/plugins/disklocation/pages/sqlite_tables.php:507 Stack trace:

0 /usr/local/emhttp/plugins/disklocation/pages/system.php(61): require_once()

1 {main}

thrown in /usr/local/emhttp/plugins/disklocation/pages/sqlite_tables.php on line 507**

Plugin installed successfully! plugin: disklocation-master.plg installed

Obviously nothing is installed.

olehj commented 2 years ago

Which Unraid version so you have? Did you try to delete database and reinstall the plugin?

I tried to install from plain state from Community Apps and everything worked as expected.

P6g9YHK6 commented 2 years ago

Version: 6.9.2

and the database in the plugins directory is correctly removed on uninstall so yes it's clean every time.

i have tired to reinstall it on multiple occasions and every time same results

olehj commented 2 years ago

The database is not removed on an uninstall. Is the USB stick/Unraid drive read-write? Can you create any file in /boot/config/plugins/ manually?

touch /boot/config/plugins/testfile

PintjesB commented 2 years ago

Can confirm removing the database fixed this issue for me!

P6g9YHK6 commented 2 years ago

Solved i tried to check "/usr/local/emhttp/plugins/disklocation/" rather than "/boot/config/plugins/" after deleting the database in /boot/config/plugins/ it worked like a charm. but there is an issue after all with the install process if i am not the only one that it happened to.

olehj commented 1 year ago

I'm interested in knowing if this is still a problem for someone? I haven't really done anything with it, but Unraid has changed the way plugins are installed in the later versions (6.11?).

olehj commented 1 year ago

Closing this issue, as I haven't heard anyone having this problem recently. Might be fixed by the new plugin system by Unraid.