Just upgraded to the latest 1.4.0 with a git pull After I wanted to run the upgrade-db.php however I get the following error.

PS C:\> php "C:\inetpub\wwwroot\spotweb\bin\upgrade-db.php"
Updating schema..(pdo_mysql)
        Validating spots(messageid)
        Validating spots(poster)
        Validating spots(title)
        Validating spots(tag)
        Validating spots(category)
        Validating spots(subcata)
        Validating spots(subcatb)
        Validating spots(subcatc)
        Validating spots(subcatd)
        Validating spots(subcatz)
        Validating spots(stamp)
        Validating spots(reversestamp)
        Validating spots(filesize)
        Validating spots(moderated)
        Validating spots(commentcount)
        Validating spots(spotrating)
        Validating spots(reportcount)
        Validating spots(spotterid)
        Validating spots(editstamp)
        Validating spots(editor)
        Validating spotsfull(messageid)
        Validating spotsfull(verified)
        Validating spotsfull(usersignature)
        Validating spotsfull(userkey)
        Validating spotsfull(xmlsignature)
        Validating spotsfull(fullxml)
        Validating usenetstate(infotype)
        Validating usenetstate(curarticlenr)
        Validating usenetstate(curmessageid)
        Validating usenetstate(lastretrieved)
        Validating usenetstate(nowrunning)
        Validating commentsxover(messageid)
        Validating commentsxover(nntpref)
        Validating commentsxover(spotrating)
        Validating commentsxover(moderated)
        Validating commentsxover(stamp)
        Validating reportsxover(messageid)
        Validating reportsxover(fromhdr)
        Validating reportsxover(keyword)
        Validating reportsxover(nntpref)
        Validating spotstatelist(messageid)
        Validating spotstatelist(ouruserid)
        Validating spotstatelist(download)
        Validating spotstatelist(watch)
        Validating spotstatelist(seen)
        Validating commentsfull(messageid)
        Validating commentsfull(fromhdr)
        Validating commentsfull(stamp)
        Validating commentsfull(usersignature)
        Validating commentsfull(userkey)
        Validating commentsfull(spotterid)
        Validating commentsfull(hashcash)
        Validating commentsfull(body)
        Validating commentsfull(verified)
        Validating commentsfull(avatar)
        Validating settings(name)
        Validating settings(value)
        Validating settings(serialized)
        Validating commentsposted(ouruserid)
        Validating commentsposted(messageid)
        Validating commentsposted(inreplyto)
        Validating commentsposted(randompart)
        Validating commentsposted(rating)
        Validating commentsposted(body)
        Validating commentsposted(stamp)
        Validating spotsposted(messageid)
        Validating spotsposted(ouruserid)
        Validating spotsposted(stamp)
        Validating spotsposted(title)
        Validating spotsposted(tag)
        Validating spotsposted(category)
        Validating spotsposted(subcats)
        Validating spotsposted(filesize)
        Validating spotsposted(fullxml)
        Validating reportsposted(ouruserid)
        Validating reportsposted(messageid)
        Validating reportsposted(inreplyto)
        Validating reportsposted(randompart)
        Validating reportsposted(body)
        Validating reportsposted(stamp)
        Validating usersettings(userid)
        Validating usersettings(privatekey)
        Validating usersettings(publickey)
        Validating usersettings(avatar)
        Validating usersettings(otherprefs)
        Validating users(username)
        Validating users(firstname)
        Validating users(passhash)
        Validating users(lastname)
        Validating users(mail)
        Validating users(apikey)
        Validating users(lastlogin)
        Validating users(lastvisit)
        Validating users(lastread)
        Validating users(lastapiusage)
        Validating users(deleted)
        Validating sessions(sessionid)
        Validating sessions(userid)
        Validating sessions(hitcount)
        Validating sessions(lasthit)
        Validating sessions(ipaddr)
        Validating sessions(devicetype)
        Validating securitygroups(name)
        Validating grouppermissions(groupid)
        Validating grouppermissions(permissionid)
        Validating grouppermissions(objectid)
        Validating grouppermissions(deny)
        Validating usergroups(userid)
        Validating usergroups(groupid)
        Validating usergroups(prio)
        Validating notifications(userid)
        Validating notifications(stamp)
        Validating notifications(objectid)
        Validating notifications(type)
        Validating notifications(title)
        Validating notifications(body)
        Validating notifications(sent)
        Validating filters(userid)
        Validating filters(filtertype)
        Validating filters(title)
        Validating filters(icon)
        Validating filters(torder)
        Validating filters(tparent)
        Validating filters(tree)
        Validating filters(valuelist)
        Validating filters(sorton)
        Validating filters(sortorder)
        Validating filters(enablenotify)
        Validating filtercounts(userid)
        Validating filtercounts(filterhash)
        Validating filtercounts(currentspotcount)
        Validating filtercounts(lastvisitspotcount)
        Validating filtercounts(lastupdate)
        Validating spotteridblacklist(spotterid)
        Validating spotteridblacklist(ouruserid)
        Validating spotteridblacklist(idtype)
        Validating spotteridblacklist(origin)
        Validating spotteridblacklist(doubled)
        Validating cache(resourceid)
        Validating cache(cachetype)
        Validating cache(stamp)
        Validating cache(metadata)
        Validating cache(ttl)
        Validating moderatedringbuffer(messageid)
        Validating permaudit(stamp)
        Validating permaudit(userid)
        Validating permaudit(permissionid)
        Validating permaudit(objectid)
        Validating permaudit(result)
        Validating permaudit(ipaddr)
        Validating index idx_spots_1
                Dropping index idx_spots_1
                Adding index idx_spots_1
        Validating index idx_spots_2
                Dropping index idx_spots_2
                Adding index idx_spots_2
        Validating index idx_spots_3
                Dropping index idx_spots_3
                Adding index idx_spots_3
        Validating index idx_spots_4
                Dropping index idx_spots_4
                Adding index idx_spots_4
        Validating index idx_spots_5
                Dropping index idx_spots_5
                Adding index idx_spots_5
        Validating FTS idx_fts_spots
                Adding FTS idx_fts_spots
        Validating index idx_usenetstate_1
                Dropping index idx_usenetstate_1
                Adding index idx_usenetstate_1
        Validating index idx_spotsfull_1
                Dropping index idx_spotsfull_1
                Adding index idx_spotsfull_1
        Validating index idx_commentsfull_1
                Dropping index idx_commentsfull_1


SpotWeb crashed

Database schema or settings upgrade failed:
   HY000: 1553: Cannot drop index 'idx_commentsfull_1': needed in a foreign key constraint


#0 C:\inetpub\wwwroot\spotweb\lib\dbstruct\SpotStruct_mysql.php(162): dbeng_pdo->rawExec('DROP INDEX idx_...')
#1 C:\inetpub\wwwroot\spotweb\lib\dbstruct\SpotStruct_abs.php(125): SpotStruct_mysql->dropIndex('idx_commentsful...', 'commentsfull')
#2 C:\inetpub\wwwroot\spotweb\lib\dbstruct\SpotStruct_abs.php(711): SpotStruct_abs->validateIndex('idx_commentsful...', 'UNIQUE', 'commentsfull', Array)
#3 C:\inetpub\wwwroot\spotweb\lib\services\Upgrade\Services_Upgrade_Base.php(42): SpotStruct_abs->updateSchema()
#4 C:\inetpub\wwwroot\spotweb\bin\upgrade-db.php(34): Services_Upgrade_Base->database()
#5 {main}

Running Spotweb for a long time on Synology. After upgrading to the latest version last week with Git Pull i got a few Popup's with error's and can't find a solution for it. Spotweb is also slower then before the upgrade and pictures in the index page are also taking long time to load. Some pictures are quick and other are taking long time before i see them. Cache folder have 0777 rights.

Spotweb is working fine even with the error's but hoping for some solution or tips.

When opening Spotweb and see the index i get at random moment:

Warning: Invalid argument supplied for foreach() in /volume1/web/spotweb/lib/services/NzbHandler/Services_NzbHandler_abs.php on line 233 {"result":"success","data":[],"info":[],"warnings":[],"errors":[]}

I can't figure out why my spotweb index overview is so slow to load while this used to be really fast. Somehow after a new install of Spotweb with a fresh DB it is slow.

Specs:
Windows 2012R2
IIS 8.5
PHP 5.6.16
MySQL 5.6.28

Spotweb Master: ef965705cb21e520c67cc04270b698ced0ab350a

Total Spotweb Database size is 3 GB

Running on:

OS Name Microsoft Windows Server 2012 R2 Standard
Version 6.3.9600 Build 9600
System Model    Virtual Machine
System Type x64-based PC
Processor   Intel(R) Xeon(R) CPU E5-2660 v3 @ 2.60GHz, 2600 Mhz, 4 Core(s), 4 Logical Processor(s)
Installed Physical Memory (RAM) 16,0 GB
Total Physical Memory   16,0 GB

Because it is virtual, additional memory or CPU's are no problem if more are needed.

It appears the big hangup is the slow select statement which takes around 30 seconds.

# Time: 151229 13:38:58
# User@Host: root[root] @ localhost [::1]  Id:    38
# Query_time: 32.684651  Lock_time: 0.000000 Rows_sent: 26  Rows_examined: 6463381
SET timestamp=1451392738;
SELECT s.id AS id,
                                                s.messageid AS messageid,
                                                s.category AS category,
                                                s.poster AS poster,
                                                l.download as downloadstamp, 
                                                l.watch as watchstamp,
                                                l.seen AS seenstamp,
                                                s.subcata AS subcata,
                                                s.subcatb AS subcatb,
                                                s.subcatc AS subcatc,
                                                s.subcatd AS subcatd,
                                                s.subcatz AS subcatz,
                                                s.title AS title,
                                                s.tag AS tag,
                                                s.stamp AS stamp,
                                                s.moderated AS moderated,
                                                s.filesize AS filesize,
                                                s.spotrating AS rating,
                                                s.commentcount AS commentcount,
                                                s.reportcount AS reportcount,
                                                s.spotterid AS spotterid,
                                                s.editstamp AS editstamp,
                                                s.editor AS editor,
                                                f.verified AS verified,
                                                COALESCE(bl.idtype, wl.idtype, gwl.idtype) AS idtype

                                     FROM spots AS s  LEFT JOIN spotstatelist AS l on ((s.messageid = l.messageid) AND (l.ouruserid = 3)) 
                                     LEFT JOIN spotsfull AS f ON (s.messageid = f.messageid) 
                                     LEFT JOIN spotteridblacklist as bl ON ((bl.spotterid = s.spotterid) AND ((bl.ouruserid = 3) OR (bl.ouruserid = -1)) AND (bl.idtype = 1))
                                     LEFT JOIN spotteridblacklist as wl on ((wl.spotterid = s.spotterid) AND ((wl.ouruserid = 3) AND (wl.idtype = 2)))
                                     LEFT JOIN spotteridblacklist as gwl on ((gwl.spotterid = s.spotterid) AND ((gwl.ouruserid = -1) AND (gwl.idtype = 2)))  WHERE (bl.spotterid IS NULL)  AND (NOT ((s.Category = 0) AND (s.subcatz = 'z3|')))
                                     ORDER BY s.reversestamp ASC LIMIT 26 OFFSET 25;

Stack Trace.xlsx

With the update of sabnzbdplus to 0.8.0 on my ubuntu server, i cannot send a nzb to the sabnzbdplus download queue.

In the apache error log i see

[Mon Sep 28 22:47:39.841971 2015] [:error] [pid 3645] [client 192.168.1.110:38441] sabnzbd push failed: http returncode: 200 / , referer: http://192.168.1.100/spotweb/?page=index&search[tree]=cat0_z0_a4,cat0_z0_a6,cat0_z0_a7,cat0_z0_a8,cat0_z0_a9&search[value][]=

Anyone have any idea what to look for? Any help is welcome. Config has not changed.

Describe the bug/issue

• A clear and concise description of what the bug is.

Failed loading XML: 
Non-fatal: Updating black/whitelist failed, most likely unreachable!

Have you searched the internet or Github for an answer?

• Please search google if similar issue has been reported and fixed before.

To Reproduce Steps to reproduce the behavior:

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

php retrieve.php

Expected behavior

• A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

• OS: [e.g. iOS]
• Browser [e.g. chrome, safari]
• Spotweb Version [e.g. 1.4.8]
• Which branch (Master/Develop)
• PHP version
• Device information (ReadyNAS/Synology/FreeNAS)

Debian11

Latest commit (develop)

php 8.1.9

Smartphone if applicable (please complete the following information):

• Device: [e.g. iPhone6]
• OS: [e.g. iOS8.1]
• Browser [e.g. stock browser, safari]
• Spotweb Version [e.g. 1.4.8]
• Which branch (Master/Develop)
• PHP version
• Device information (ReadyNAS/Synology/FreeNAS)

Additional context Provide any other information about the bug or issue that can further help debugging here.

For a few months now I encountered this odd issue with Spotweb where it crashes during article retrieval on every run more or less. It only happens when I enable both Full Comments and Full post retrieval including all options there.

I can still browse all posts just fine in the web browser and it retrieves it on the fly but of course a bit slower to load, it used to work just fine in the beginning of this year and here's a couple of things I tried:

• Fresh Spotweb install (DB / clean pull from main branch) and let it retrieve for a few days, same error pops up.
• Changed newsserver from Giganews to Eweka
• Changed newsserver from Giganews EU to Giganews US
• First step of install to check if dep / config issue, reports all OK status.

The server is running Ubuntu 14.04LTS with PHP v5.5.24-1+deb.sury.org~trusty+1 and Percona 5.5, nothing much has changed on the server since it worked before other than the regular PHP/Percona updates.

At first I suspected a few fault spots which were an issue in the past where the retrieve process would hang, normally this could be fixed by de-selecting full spot/comment retrieval and letting that run a few times and restoring full spot/comment retrieval afterwards. The fatal error seems to be "Failed to read from socket" however no connections are dropped on the server as I can keep a stable connection to usenet servers on other applications.

Any insight into this would be much appreciated :)

Retrieving new Spots from server <server>.eweka.nl...
Appr. Message count:    2439698
First message number:   2
Last message number:    2439700
Current article number: 2439694

Retrieving 2439694 till 2439701
getHeader(): Failed to retrieve article: <[email protected]>

getBody(): Failed to retrieve article: <[email protected]>

getHeader(): Failed to retrieve article: <[email protected]>

getHeader(): Failed to retrieve article: <[email protected]>

getHeader(): Failed to retrieve article: <[email protected]>
SpotWeb v0.68.29.32 on PHP v5.5.24-1+deb.sury.org~trusty+1 crashed

Fatal error occured while connecting to the newsserver:
  (-1) Failed to read from socket...! [response: ""]


#0 /var/www/spotweb/NNTP/Protocol/Client.php(296): Net_NNTP_Protocol_Client->throwError('Failed to read ...')
#1 /var/www/spotweb/NNTP/Protocol/Client.php(279): Net_NNTP_Protocol_Client->_getStatusResponse()
#2 /var/www/spotweb/NNTP/Protocol/Client.php(1140): Net_NNTP_Protocol_Client->_sendCommand('HEAD <csRff2uwJ...')
#3 /var/www/spotweb/NNTP/Client.php(515): Net_NNTP_Protocol_Client->cmdHead('<csRff2uwJPQsJZ...')
#4 /var/www/spotweb/lib/services/Nntp/Services_Nntp_Engine.php(282): Net_NNTP_Client->getHeader('<csRff2uwJPQsJZ...')
#5 /var/www/spotweb/lib/services/Nntp/Services_Nntp_SpotReading.php(160): Services_Nntp_Engine->getHeader('<csRff2uwJPQsJZ...')
#6 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Spots.php(398): Services_Nntp_SpotReading->readFullSpot('csRff2uwJPQsJZT...')
#7 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(227): Services_Retriever_Spots->process(Array, '2439694', 2439701, 1431541450.4223)
#8 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(319): Services_Retriever_Base->loopTillEnd('2439694', '1000')
#9 /var/www/spotweb/retrieve.php(155): Services_Retriever_Base->perform()
#10 {main}

Since Synology DSM 5.2 we can no longer retrieve spots using SSL. There are multiple forum topics that blame DSM 5.2 for this:

https://translate.google.nl/translate?sl=nl&tl=en&js=y&prev=_t&hl=nl&ie=UTF-8&u=http%3A%2F%2Fwww.synology-forum.nl%2Fspotweb%2Fspotweb-werkt-niet-meer-na-upgrade-dsm-5-2%2F&edit-text=&act=url

http://www.synology-forum.nl/spotweb/spotweb-i-c-m-taakplanner/55/?wap2

http://gathering.tweakers.net/forum/list_messages/1538893/32

The error I and everyone else gets is this one:

SpotWeb v0.67.28.31 on PHP v5.5.24 crashed

Fatal error occured while connecting to the newsserver: (-1) Failed to read from socket...! [response: ""]

Probably Synology has updated PHP in their latest DSM, which also updates the SSL library. Is there anything we can do to make spotweb work with the new SSL, rather than just turning it off?

Thanks for any reply :)

Cheers

I haven't been able to retrieve / update my spotweb database since 29-03-2015.

Receiving the following error when manualy starting the retrieve job:

spotweb@webserver:~/domains/spotweburl/private_html/spotweb$ php retrieve.php Removing Spot information which is beyond retention period,, done Last retrieve at Sun 29 Mar 2015 03:30:29 PM CEST Retrieving new Spots from server news.cheapnews.eu...

Warning: stream_socket_client(): unable to connect to tcp://news.cheapnews.eu:119 (Connection timed out) in /home/spotweb/domains/spotweburl/private_html/spotweb/NNTP/Protocol/Client.php on line 693 SpotWeb v0.68.29.32 on PHP v5.5.23 crashed

Fatal error occured while connecting to the newsserver: (-1) Error while connecting to server (server did not respond) [response: ""] [response: ""] #0 /home/spotweb/domains/spotweburl/private_html/spotweb/lib/services/Nntp/Services_Nntp_Engine.php(120): Services_Nntp_Engine->connect() #1 /home/spotweb/domains/spotweburl/private_html/spotweb/lib/services/Retriever/Services_Retriever_Base.php(112): Services_Nntp_Engine->selectGroup('free.pt') #2 /home/spotweb/domains/spotweburl/private_html/spotweb/lib/services/Retriever/Services_Retriever_Base.php(280): Services_Retriever_Base->connect(Array) #3 /home/spotweb/domains/spotweburl/private_html/spotweb/retrieve.php(155): Services_Retriever_Base->perform() #4 {main}

Hi,

I installed the media-branch of Spotweb (clean install), everything went fine, but when I try to retrieve the spots for the first time, I get the following errors:

Warning: PDO::quote() expects parameter 1 to be string, array given in C:\XAMPP
htdocs\spotweb-media\lib\dbeng\dbeng_pdo.php on line 175

SpotWeb v0.68.29.32 on PHP v5.5.11 crashed

Fatal error occured retrieving reports: 42000: 1064: You have an error in your SQL syntax; check the manual that corre sponds to your MySQL server version for the right syntax to use near ',,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,' at line 1 (SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,' at line 1) #0 C:\XAMPP\htdocs\spotweb-media\lib\dbeng\dbeng_pdo.php(146): dbeng_pdo->exec('

SELECT messagei...', Array) #1 C:\XAMPP\htdocs\spotweb-media\lib\dao\Base\Dao_Base_Spot.php(606): dbeng_pdo-

arrayQuery('SELECT messagei...')

2 C:\XAMPP\htdocs\spotweb-media\lib\services\Retriever\Services_Retriever_Spots

.php(216): Dao_Base_Spot->matchSpotMessageIds(Array)

3 C:\XAMPP\htdocs\spotweb-media\lib\services\Retriever\Services_Retriever_Base.

php(227): Services_Retriever_Spots->process(Array, '2051487', 2056488, 142908960 1.5511)

4 C:\XAMPP\htdocs\spotweb-media\lib\services\Retriever\Services_Retriever_Base.

php(319): Services_Retriever_Base->loopTillEnd('0', '5000')

5 C:\XAMPP\htdocs\spotweb-media\retrieve.php(155): Services_Retriever_Base->per

form()

6 {main}

Everything is working fine except when request with the api. /api?t=c returns successfully. however when I am requesting something else, it is returning this. This page contains the following errors error on line 2 at column 1: Extra content at the end of the document. Below is a rendering of the page up to the first error.

I am not sure what is causing this.

As title,i can't see anymore spots then the last update,before when i scrolled dowwn a get a new page with older posts but nog go aftger fresh instalation on syno dsm 6.1.4 It works nonetheless and retrieves spots by ssh.