Support for the templates I create.

 

Most templates are based on existing docker containers, I'm just adding the unraid sauce to them. Though I might be adding some of my own later.

 

GitHub Templates Repository: https://github.com/riffsphereha/Unraid-Templates

Edited May 17, 20233 yr by RiffSphereHA

Hi,

 

How does the database update itself? Everything is still empty now.

 

 

Thanks for your help.

 

Best regards

On 12/19/2023 at 10:34 AM, TallMan206 said:

Hi,

 

How does the database update itself? Everything is still empty now.

 

 

Thanks for your help.

 

Best regards

Sorry for the delay, been out for a long time.

You first have to login as admin, then go through the configuration, and it should start pulling automatically.

Howdy, what string would i use if i choose a postgrsql DB? I see in the template its set to mysql DB type and i just dont kmow how to find what to pu there.

Found an alternate way. You can trigger the standard installation wizard by deleting the database PHP file inside the appdata directory. Once you do this you then navigate to /install.php manually. It will then trigger the standard spotweb installation process. When you do this, you don't have to worry about what's hard coded into the template and can instead just use whatever. Alternatively, you can just use a standard SQL database if you happen to already be running a container for a different reason. If anyone does attempt this, remember, you can't turn off the container when you delete the file and you have to leave it running. It will then fail to rewrite that file, but that's okay because you can then just copy what the install script spits out at you and manually add that to that same file and you should be good to go. This is going to be useful to probably about five of us but I figured I'd post my solution anyway.

I have Spotweb working with MariaDB. What I do not understand, no matter the retention settings, it will not download older spots. The oldest one, after a fresh run, is 12 hours old. My retention is on 0. Eweka has 5746+ days retention, but Spotweb just does not download more.

 

Any suggestions?

On 5/15/2024 at 3:44 AM, TallMan206 said:

I have Spotweb working with MariaDB. What I do not understand, no matter the retention settings, it will not download older spots. The oldest one, after a fresh run, is 12 hours old. My retention is on 0. Eweka has 5746+ days retention, but Spotweb just does not download more.

 

Any suggestions?

Probably way too late for you, but maybe it will help the next guy.

 

I had the same issue. Use adminer to get into the database, then truncate the following tables:

 

cache

commentsfull

commentsposted

commentsxover

moderedringbuffer

reportsposted

reportsxover

spots

spotsfull

spotstatelist

usenetstate

 

Then in the settings table, select data and change retrieve_newer_than to 1257030000. On my newest installation this value isn't even showing, so perhaps alternatively you can just delete the entire line in the table. 

 

Credits for the solution goes to DrFrankenstein. 

Also don't forget to set in user preferences, the items per page, to a higher number. The arrows for the next and previous pages, are also low visible so easy to look over.

 

 

Any way to help me locate upgrade-db.php in the docker; i need to do a database reset and i read i need the command

php upgrade-db.php --reset-db

but i keep getting error dat upgrad-db.php is not found

thx

On 7/8/2025 at 11:09 AM, dusa said:

Any way to help me locate upgrade-db.php in the docker; i need to do a database reset and i read i need the command

php upgrade-db.php --reset-db

but i keep getting error dat upgrad-db.php is not found

thx

Its located in var/www/spotweb/bin

Edited August 26, 2025Aug 26 by Pepreal

EDIT Solved:

Issue :
version : 9.5.0

edition : MySQL Community Server - GPL

log_bin : 1 ← binary log ON

binlog_format: ROW

gtid_mode : ON ← GTID ON

enforce_gtid_consistency: ON

So your MySQL is strict GTID + binlog = ON, which does not like what Spotweb’s retrieve code is doing, and that’s why it keep getting:

Statement violates GTID consistency: Updates to non-transactional tables...

This MySQL config itself will keep breaking Spotweb.

I've created a file zz-spotweb-gtid.cnf chmod 644 with the following lines:
log_bin=0

skip_log_bin=1

gtid_mode=OFF

enforce_gtid_consistency=OFF

In UnRAID:

1. Go to Docker → click on mysql-spotweb → Edit.

2. Add a new Path mapping:

   • Host path:
     /mnt/user/appdata/mysql-spotweb/zz-spotweb-gtid.cnf

   • Container path:
     /etc/mysql/conf.d/zz-spotweb-gtid.cnf

   • Access mode: Read-only

and restart the mysql docker.

What is causing this crash?

SpotWeb v0.68.38.34 on PHP v8.3.27 crashed

Fatal error occured during retrieve:

HY000: 1785: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.

#0 /var/www/spotweb/lib/dbeng/dbeng_pdo.php(86): dbeng_pdo->exec()

#1 /var/www/spotweb/lib/dao/Mysql/Dao_Mysql_Spot.php(51): dbeng_pdo->modify()

#2 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Spots.php(656): Dao_Mysql_Spot->removeSpots()

#3 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(239): Services_Retriever_Spots->process()

#4 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(340): Services_Retriever_Base->loopTillEnd()

#5 /var/www/spotweb/retrieve.php(142): Services_Retriever_Base->perform()

#6 {main}

Finished retrieving spots.

Edited November 20, 2025Nov 20 by TallMan206

How come my Spotweb looks like this now?

On 11/19/2025 at 11:19 PM, TallMan206 said:

EDIT Solved:

Issue :
version : 9.5.0

edition : MySQL Community Server - GPL

log_bin : 1 ← binary log ON

binlog_format: ROW

gtid_mode : ON ← GTID ON

enforce_gtid_consistency: ON

So your MySQL is strict GTID + binlog = ON, which does not like what Spotweb’s retrieve code is doing, and that’s why it keep getting:

Statement violates GTID consistency: Updates to non-transactional tables...

This MySQL config itself will keep breaking Spotweb.

I've created a file zz-spotweb-gtid.cnf chmod 644 with the following lines:
log_bin=0

skip_log_bin=1

gtid_mode=OFF

enforce_gtid_consistency=OFF

In UnRAID:

1. Go to Docker → click on mysql-spotweb → Edit.

2. Add a new Path mapping:

   • Host path:
     /mnt/user/appdata/mysql-spotweb/zz-spotweb-gtid.cnf

   • Container path:
     /etc/mysql/conf.d/zz-spotweb-gtid.cnf

   • Access mode: Read-only

and restart the mysql docker.

What is causing this crash?

SpotWeb v0.68.38.34 on PHP v8.3.27 crashed

Fatal error occured during retrieve:

HY000: 1785: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.

#0 /var/www/spotweb/lib/dbeng/dbeng_pdo.php(86): dbeng_pdo->exec()

#1 /var/www/spotweb/lib/dao/Mysql/Dao_Mysql_Spot.php(51): dbeng_pdo->modify()

#2 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Spots.php(656): Dao_Mysql_Spot->removeSpots()

#3 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(239): Services_Retriever_Spots->process()

#4 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(340): Services_Retriever_Base->loopTillEnd()

#5 /var/www/spotweb/retrieve.php(142): Services_Retriever_Base->perform()

#6 {main}

Finished retrieving spots.

This worked perfectly for me in repairing my issues since the latest update, thanks! Small note that according to documentation newest supported mysql db is version 8.1

On 11/27/2025 at 3:13 AM, TallMan206 said:

How come my Spotweb looks like this now?

mine looks the same as well, not sure why

Edited January 4Jan 4 by ianb85

Hi,

I kind of managed to get this working with Mariadb as I get to the login page but cant get logged in via the admin user, it always says username password wrong. Any tips as I am going to try again as had one working on portainer before I moved to unraid. Thanks

After a reinstall I also get the following message if anybody can assist with this as well please

Spotweb contains updated global settings settings. Please run 'bin/upgrade-db.php' from a console window

Cheers

Edited January 15Jan 15 by Payneardo

2 hours ago, Payneardo said:

Hi,

I kind of managed to get this working with Mariadb as I get to the login page but cant get logged in via the admin user, it always says username password wrong. Any tips as I am going to try again as had one working on portainer before I moved to unraid. Thanks

After a reinstall I also get the following message if anybody can assist with this as well please

Spotweb contains updated global settings settings. Please run 'bin/upgrade-db.php' from a console window

Cheers

Managed to get in and got things setup but not sure if it is working as in the logs I have the following, giving a bit of time to see if it downloads anything....

PHP Warning: Undefined variable $retriever in /var/www/spotweb/retrieve.php on line 296

PHP Fatal error: Uncaught Error: Call to a member function quit() on null in /var/www/spotweb/retrieve.php:296

Stack trace:

#0 {main}

thrown in /var/www/spotweb/retrieve.php on line 296

Creating database configuration

Setting (PHP) time zone to Europe/London

* Starting periodic command scheduler cron

...done.

Module rewrite already enabled

Module expires already enabled

Considering dependency filter for deflate:

Module filter already enabled

Module deflate already enabled

* Restarting Apache httpd web server apache2

...done.

Creating database configuration

Setting (PHP) time zone to Europe/London

* Starting periodic command scheduler cron

...done.

Module rewrite already enabled

Module expires already enabled

Considering dependency filter for deflate:

Module filter already enabled

Module deflate already enabled

* Restarting Apache httpd web server apache2

...done.

retriever.php is already running, pass '--force' to ignore this warning.