Wat heeft Duto te maken met spotweb/spotnet? Hoe kan ik Duto als eindgebruiker gebruiken? Vind er niks over terug...

Creating collections starting from 0, PHP Fatal error: Maximum execution time of 120 seconds exceeded in /var/www/html/spotweb/lib/dao/Base/Dao_Base_Collections.php on line 143 Segmentation fault (core dumped)

I set my user account to English language but NMA notifications arrive in Dutch, like this:

1 nieuwe spots beschikbaar in filter "Walking Dead"

Walking Dead heeft 1 spots beschikbaar

This is with the current 96a688f revision.

Anyone using the statistics page? Should we remove it entirely? Because it seems like clutter to me but idk.

Option to enable/disable the image preview.

Hello!

I'm experiencing a problem with my new setup of Spotweb on a OpenSuse 13.2 system.

I clone the project from Git and then browse to [server]/spotweb/install.php but nothing happens. I get a blank screen. In the apache error_log file I get the following:

[php5:error] [pid 9487] [client ::1:49948] PHP Notice: Undefined offset: 20 in /srv/www/htdocs/spotweb/vendor/phpseclib/Math/BigInteger.php on line 3491

I can't seem to get it working. I've done this setup a couple of times already on other systems but now it doesn't seem to work anymore.

Can you help me?

Hello all,

I want to use the mobile template. i can select the mobile template. however when i try to send a nzb to sabnzbd it is not working. The loading icon keeps circling arround and arround.

Does anyone have a sollution for this?

Thanx in advance.

I tried to use the mobile template for Phone and Tablet but failed with an error.
Changed some Spotweb settings as mentioned here:
https://github.com/Spotweb/Spotweb/wiki/Frequently-asked-questions#how-to-configure-a-new-kind-of-template--theme

The template works fine, but when saving the NZB the page keeps loading and an error was logged:
FastCGI: server "/php-fpm-handler" stderr: PHP message: PHP Fatal error: require(): Failed opening required 'lib/page/SpotPage_getnzbmobile.php' (include_path='.') in /volume1/web/spotweb/lib/SpotClassAutoload.php on line 20,

The file 'lib/page/SpotPage_getnzbmobile.php' does not exists in this repository but does in the repository of h4rdc0m (4 years old, no longer active):
https://github.com/h4rdc0m/spotweb/blob/master/lib/page/SpotPage_getnzbmobile.php

| pulled that file but now get this error:
FastCGI: server "/php-fpm-handler" stderr: PHP message: PHP Catchable fatal error: Argument 1 passed to SpotPage_getnzbmobile::__construct() must be an instance of SpotDb, instance of Dao_Mysql_Factory given, called in /volume1/web/spotweb/index.php on line 143 and defined in /volume1/web/spotweb/lib/page/SpotPage_getnzbmobile.php on line 6

Is it possible to use the mobile template with working NZB?
What am I doing wrong?

my iis throws an error when I try to open a spot with (a lot) bbcodes in the description.
Is there a way to remove the bbcodes (or prevent them from being parsed)?

With the last update the preview on the overview page is not available anymore.

Please advise how to solve this issue.

I just dit a git pull. And when I did a upgrade of the database this is what I see:

Database schema or settings upgrade failed:
23000: 1062: Duplicate entry '3-31-pushover' for key 'idx_grouppermissions_1'

How to fix it?

Thanks.

[Fri Mar 20 23:20:02 2015] [error] [client 192.168.2.254] SpotWeb Exception occured: Server refused connection [response: "Too many connections."] [response: ""], referer: https://spotweb.server.nl/?search[tree]=&search[unfiltered]=true

I'm getting a lot of these in my log when I log in to my spotweb server.
Page loads normally but the mouse over doesn't work on a lot of the spots.
Pictures are shown without problem if I click on a spot.
If I go back to the index it still doesn't show the picture on mouse over.

To make it even weirder.. after a few minutes most pictures do show on mouse over :)

I'm not downloading at the moment so I've got all my threads to Pure usenet available.
I've even switched to textnews.kpn.nl for a while (because of the recent 6hr delay on Pure) but that didn't solve the problem.

Strange thing is that I don't get this error when running retrieve.php.

Maybe related... I'm also getting this error a few times a day:
[Fri Mar 20 23:07:13 2015] [error] [client 192.168.2.254] SpotWeb Exception occured: Cache is corrupt, could not find on-disk resource for: 3927 ./cache//web/c63/642/8b5/355/0e4/100/471/bbc/624/59c/9d0/bec/f989.http -> ./cache//web/3/3927.http, referer: https://spotweb.server.nl/

But like I said, All pictures show when I click on a spot.

Spotweb is a clean install (arouynd 2 weeks old) on Debian Wheezy.

Dear,

As there continues to be some confusion about versions, upgrades and likewise, let us try to discuss the issue once and for all in this particular issue.

My experience is this:

1. The "mediainfo" branch is as far as I can tell the most recent version of Spotweb available. It is stable, and should be used by anyone.
2. The "mediainfo"-part is optional (it contains both 'collections' and TMDB integration of some sorts), and should only be enabled on well equipped hardware.
3. You can safely upgrade from your current installation to the mediainfo branch.
4. You can never downgrade an Spotweb installation succesfully.

With regards to the database itself:

1. Databases don't go stale, they don't start to smell bad and they do not grow mouldy green hairs. There is no need to "start fresh" or anything like that. The only reason for that would be to severely reduce the size of the database. You never hear of your local bank starting fresh with their database so why would Spotweb need to?
2. Starting from scratch with an empty database is very seldom a valid troubleshooting tactic. Please stop advising it unless the user has messed around in the database entries yourselve of you have tried a downgrade.
3. Do not downgrade your Spotweb version.
4. Do not manually modify the Spotweb database.
5. You can safely run upgrade-db as many times that you like.

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}

Add a "remove" spot button on spot overview to delete spot without having to go to the edit dialog.?

Seems some Wiki pages are now empty, was using them before as an reference for new users (keyboard shortcuts etc..) so would be great if they can make a comeback 👍
Few examples of cleared pages:

https://github.com/spotweb/spotweb/wiki/Performance-tips
https://github.com/spotweb/spotweb/wiki/Sneltoetsen

and most links that refer to the wiki on the site below:

http://www.spot-net.nl/spotweb/handleiding/

My usenet provider (extremeusenet) switched to a new platform. Hence I had to make a full, initial retrieve. This is taking very, very long on the media branch. I have decreased the number of spots parameter to 1000 and notice that there looks to be a 1:1 relation between the number of full posts and the time it takes to process them:

...
Retrieving 2309309 till 2310310 (parsed: 1001, in DB: 0, signed: 1, invalid: 1000, rtntn.skip: 0, mod: 0, full: 1, total: 1001) in 0.5 seconds
Retrieving 2310310 till 2311311 (parsed: 1001, in DB: 0, signed: 6, invalid: 995, rtntn.skip: 0, mod: 0, full: 6, total: 1001) in 2.64 seconds
Retrieving 2311311 till 2312312 (parsed: 1001, in DB: 0, signed: 113, invalid: 870, rtntn.skip: 0, mod: 18, full: 113, total: 1001) in 15.06 seconds
Retrieving 2312312 till 2313313 (parsed: 1001, in DB: 0, signed: 936, invalid: 3, rtntn.skip: 0, mod: 62, full: 936, total: 1001) in 114.84 seconds
...

My server (intel i3, Ubuntu with 12G memory) is already processing for more than a day, whereas it used to take only a couple of hours on the same system. What has happened?

The line 432 in lib/services/Format/Services_Format_Parsing.php
$spot['verified'] = (substr($userSignedHash, 0, 3) == '0000');

must read
$spot['verified'] = (substr($userSignedHash, 0, 4) === '0000');

( notes:
php > var_dump( '0' == '000');
bool(true)
php > var_dump( '0' === '000');
bool(false)
var_dump('0e10' == '0000');
bool(true)

smells like a php bug, because it's only when the string starts with 0e....
)

Hello,

after the latest changes I have issues with a slow non responsive GUI. In my settings I have set to show 250 posts per page. When I scroll down and the GUI has to prepare the next 250 posts the GUI hangs. Results show after 30 seconds but before I can scroll again more then a minute is passed.
I have tested this in IE 11, Chrome and Firefox and they all react the same. Normally I never had any issues with this.
When I switch back to show 50 posts per page it is doable. Any thoughts what the issue can be?
Thanks in advance for the support.
Cheers
Burner1977

latest pull gives this in error_log.

[20-Jan-2015 13:07:30 Europe/Amsterdam] PHP Parse error: syntax error, unexpected '{' in /var/www/spotweb/lib/dbeng/dbeng_abs.php on line 122

Did a an update today and now I get the following error message trying to do 'php retrieve.php':

DiskStation> php retrieve.php                                                                                                                                                  
Removing Spot information which is beyond retention period,, done                                                                                                              
PHP Fatal error:  Cannot redeclare Services_Retriever_Spots::__construct() in /volume1/web/spotweb/lib/services/Retriever/Services_Retriever_Spots.php on line 95       

Hello, I keep getting a message about my IP address changing after downloading a few nzb's. This error prevents me from downloading anymore nab's from spotweb for maybe 10 or 20 mins. It seems to think my ip address changes from the ISP where spotweb is being hosted on and the remote ISP where I am accessing it. Is there a way to disable this security feature?

Hi there,

I am getting below errors. What could i be doing wrong?

OS: Linux/Ubuntu

Notice: Undefined index: userid in /var/www/spotweb/lib/SpotSecurity.php on line 140

Notice: Undefined index: prefs in /var/www/spotweb/lib/services/User/Services_User_Authentication.php on line 138

Notice: Undefined index: userid in /var/www/spotweb/lib/services/User/Services_User_Authentication.php on line 70

Notice: Undefined index: prefs in /var/www/spotweb/index.php on line 63

Notice: Undefined index: prefs in /var/www/spotweb/index.php on line 64

Notice: Undefined index: userid in /var/www/spotweb/index.php on line 73

Notice: Undefined index: userid in /var/www/spotweb/index.php on line 371

Warning: require(templates//SpotTemplateHelper_.php): failed to open stream: No such file or directory in /var/www/spotweb/lib/SpotClassAutoload.php on line 54

Fatal error: require(): Failed opening required 'templates//SpotTemplateHelper_.php' (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/spotweb/lib/SpotClassAutoload.php on line 54

A thanks in advance!

Marc

@Blauwbek can you reattach your PR?

According to GitHub issue 1569 (Add support for NGINX proxy forward) enabling php env var $_SERVER['HTTP_X_FORWARDED_SSL'] would enable https opportunities using SpotWeb.

In case of the Master branch, HTTPS does not work using NGINX as a reverse proxy. Issue 1569 involves also a change in the file ` lib/page/SpotPage_statics.php ´. This change is currently not included in the Master branch, which maybe the cause of the above issue.

I just switched from main to media. When executing php upgrade-db.php, I consistently get the following error:

...
    Validating index idx_users_4
    Validating index idx_sessions_1
    Validating index idx_sessions_2
    Validating index idx_sessions_3
    Validating index idx_sessionsrel_1
    Validating index idx_spotstatelist_1
    Validating index idx_spotstatelistrel_1
    Validating index idx_securitygroups_1
    Validating index idx_grouppermissions_1
    Validating index idx_usergroups_1
    Validating index idx_usergroupsrel_1
    Validating index idx_notifications_1
    Validating index idx_notifications_2
    Validating index idx_filters_1
    Validating index idx_filtercounts_1
    Validating index idx_spotteridblacklist_1
    Validating index idx_spotteridblacklist_2
    Validating index idx_cache_1
    Validating index idx_cache_2
    Validating index idx_moderatedringbuffer_1
    Validating index idx_mastercollections_1
    Validating index idx_collections_1
    Validating index idx_tmdbinfo_1
    Validating index idx_tmdbtrailers_1
    Validating index idx_tmdbcredits_1
    Validating index idx_tmdbcast_1
    Validating index idx_tmdbcrew_1
    Validating index idx_tmdbimages_1
Schema update done
Updating settings
Settings update done


SpotWeb crashed

Database schema or settings upgrade failed:
   23000: 1062: Duplicate entry '3-31-pushover' for key 'idx_grouppermissions_1'


#0 /var/www/spotweb/lib/services/Upgrade/Services_Upgrade_Users.php(468): dbeng_pdo->rawExec('INSERT INTO gro...')
#1 /var/www/spotweb/lib/services/Upgrade/Services_Upgrade_Users.php(19): Services_Upgrade_Users->updateSecurityGroups(false)
#2 /var/www/spotweb/lib/services/Upgrade/Services_Upgrade_Base.php(35): Services_Upgrade_Users->update()
#3 /var/www/spotweb/upgrade-db.php(50): Services_Upgrade_Base->users(Object(Services_Settings_Container))
#4 {main}

This error also occurs when starting from scratch, so git pull the source and also build the database from scratch

With the latest commits with the preview pictures (which is a nice addition) you can no longer use the "back" button on your browser. You can still click on the back button in the website which will work but no longer outside of that. I normally use my mouse back button to go back but that fails now.

This was more of a request or question, i know in the very past there was an external blacklist. Are they still around? Or how can i add one if i find an external blacklist?

Yesterday evening I switched to the Media branch of Spotweb. After switching I was required to run upgrade-db.sh. This took quite some time, but ended in a crash. Now I cannot run spotweb anymore, but also the upgrade-db routine keeps crashing with the message below. Anyone got a suggestion on how to fix this? I preferably don't want to start from scratch with my database.

<>
Validating index idx_tmdbimages_1
Schema update done
Updating settings
Settings update done

SpotWeb crashed

Database schema or settings upgrade failed:
23000: 1062: Duplicate entry '3-31-pushover' for key 'idx_grouppermissions_1'
#0 /volume1/web/spotweb/lib/services/Upgrade/Services_Upgrade_Users.php(468): dbeng_pdo->rawExec('INSERT INTO gro...')
#1 /volume1/web/spotweb/lib/services/Upgrade/Services_Upgrade_Users.php(19): Services_Upgrade_Users->updateSecurityGroups(false)
#2 /volume1/web/spotweb/lib/services/Upgrade/Services_Upgrade_Base.php(35): Services_Upgrade_Users->update()
#3 /volume1/web/spotweb/upgrade-db.php(50): Services_Upgrade_Base->users(Object(Services_Settings_Container))
#4 {main}DiskStation>

during retrieve reports

Retrieving 41941 till 43942, found 1987 reports in 0.22 seconds
Retrieving 43942 till 45943, found 2001 reports in 0.3 seconds
Retrieving 45943 till 46306, found 363 reports in 0.07 seconds


   SpotWeb v0.68.29.32 on PHP v5.6.7-1 crashed

Fatal error occured retrieving reports: 
 22001: 1406: Data too long for column 'fromhdr' at row 1



#0 /var/www/spotweb/lib/dao/Base/Dao_Base_SpotReport.php(69): dbeng_pdo-     >batchInsert(Array, 'INSERT INTO rep...', Array, Array)
#1 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Reports.php(124): Dao_Base_SpotReport->addReportRefs(Array)
#2 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(227): Services_Retriever_Reports->process(Array, 45943, 46306, 1431679277.447)
#3 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(319): Services_Retriever_Base->loopTillEnd(27934, '2000')
#4 /var/www/spotweb/retrieve.php(214): Services_Retriever_Base->perform()
#5 {main}

PHP 5.6.7-1 (cli) (built: Mar 24 2015 12:30:15)
Copyright (c) 1997-2015 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2015 Zend Technologies

mysql: 10.0.19-MariaDB-1~sid mariadb.org binary distribution

on Debian Jessie

Non-fatal: Updating black/whitelist failed, most likely unreachable!Expiring debuglog entries, if any, done.

http://jij.haatmij.nl/spotnet/blacklist.txt
http://jij.haatmij.nl/spotnet/whitelist.txt
these sites automatically redirect to duckduckgo.com

Are there new url for the white/blacklist or should i just ignore this issue?

Hi There,

In the root folder is no cache folder making NZB and images not load properly.

Please add a empty directory named "cache".

Thanks a lot.

In the past under the original Spotweb i fixed an issue where after pressing the Add button the text would be cleared from the "Add spot", Currently after pressing "Add spot " it looks like nothing happens, but the spot get's posted like normal.

Apparently this was never commited into the newer branches and since the original tree has been deleted the issue remains, sadly i forgot half about what the fix was.. all i know that there is a $ missing infront of a "article" variable somewhere, "article" ,must be "$article", but i don't remember where.

I have been searching for a few hours compairing files one by one using my old install (v0.67.28.31) over the new install (v0.68.29.32) but for now and untill now i am unable to locate the bugged file, some help would be appreciated.

Does anyone have a clue or maybe you could digg through your archive and see if you can find this fix?

Can anybody explain what below error message is?

And how i can fix it?

I heard spotweb is working on H265 category but I still can't find it. Is it a bug on my side or is the category not yet released to the public?

I'm using a reverse proxy and when I access spotweb I get an error in Chrome (Mac) about mixed content.

Mixed Content: The page at '/spotweb/' was loaded over HTTPS, but requested an insecure stylesheet '/spotweb/?page=statics&type=css&mod=1421318161'. This request has been blocked; the content must be served over HTTPS.
web.pjsyno.be/:56 The page at /spotweb/' was loaded over HTTPS, but is submitting data to an insecure location at '/spotweb/?': this content should also be submitted over HTTPS.

web.pjsyno.be/:1 Mixed Content: The page at 'https://web.pjsyno.be/spotweb/' was loaded over HTTPS, but requested an insecure script '/spotweb/?page=statics&type=js&lang=en_US&mod=1421318161'. This request has been blocked; the content must be served over HTTPS.
web.pjsyno.be/:304 Uncaught ReferenceError: initSpotwebJs is not defined
spotweb/ Failed to load resource: net::ERR_CACHE_MISS

I looked for a solution and this can be solved by using protocol independent URL's like they have done here: https://github.com/PeterDaveHello/snabbt.js/commit/7e3e5f17bcf073c044c7c843fad7c6177ce32b2d

Can I exclude thos from my list? same as I can exclude porn from the list? If yes can anyone tell me how or if no maybe it would be nice in a future version ;-)

Thanks anyway

a696fd4

• I do not think this is correct. You basically supress an error caused by incorrect input, but it should never be incorrect. eg, you are fixing the wrong bug.

b57f5e6

• Same story, i do not think this is correct as the calle should always be explicit about its intent, and we should not mangle the input in the database layer.

When spotweb tries to find an NZB belonging to a certain a spot, it sometimes can't find the NZB anymore. This usually occurs with older spots (> 1200 days?).

If I download the NZB manually I receive the following error:
getBody(): Failed to retrieve article: {"result":"failure","data":[],"info":[],"warnings":[],"errors":["No such article found [response: \"no such article\"]"]}
Sending the NZB to sabnzbd is stuck with the download button haning on the "loading, sending nzb to sab" icon.

Is there a way to do a check and remove this spots automatically? This is really annoying because sickrage thinks it snatched an episode, but sabnzbd do not received anything and sickrage is therefore stuck a status snatched

It would be nice to be able to register users via the API. Limited to certain user groups (admins for ex.).

That way I can create Spotweb accounts from my own website.

From https://github.com/spotweb/spotweb/wiki/Handy-SQL-Query%27s
I got:

To delete spots with more than 5 spam reports:

DELETE FROM spots WHERE messageid IN (SELECT nntpref FROM reportsxover)
GROUP BY nntpref
HAVING ( COUNT(nntpref) > 5 );

But.. it's not working, i get an error saying:
#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 'GROUP BY nntpref HAVING ( COUNT(nntpref) > 5 )' at line 2

Can anyone using SQL tell me what the correct query must be?

Whenever I change the username 'nzbget' to something else and save, after reloading the settings/nzb handling page it's set back to 'nzbget'.

When I select the nzbget option in the user settings I get when logging in webiterface error below.

Fatal error: Call to undefined function curl_init () in /var/www/html/Spotweb/lib/services/Providers/Services_Providers_Http.php on line 190

When I then remove this setting via the admin account, I can log in again.

NZBget the option does not work anymore.

This is since I have one new installation done today with a new pull from the git.

#55

In addition to the above i found a problem with the double / in my error_log aswell:

[26-Mar-2015 19:40:17 Europe/Amsterdam] Unable to write to cache directory (./cache//web/221/851/0/2218510.http)

[26-Mar-2015 19:41:54 Europe/Amsterdam] PHP Warning: fileperms(): stat failed for ./cache//image/221/904/7 in /home/public_html/spotweblib/dao/Base/Dao_Base_Cache.php on line 307
[26-Mar-2015 19:41:54 Europe/Amsterdam] PHP Warning: fileowner(): stat failed for ./cache//image/221/904/7 in /home/public_html/spotweb/lib/dao/Base/Dao_Base_Cache.php on line 308
[26-Mar-2015 19:41:54 Europe/Amsterdam] PHP Warning: filegroup(): stat failed for ./cache//image/221/904/7 in /home/public_html/spotweb/lib/dao/Base/Dao_Base_Cache.php on line 309

In the settings i found this table:

42 cache_path ./cache/ and changed ./cache/ -> ./cache

Now the error seems to have been solved and files are now populating correctly.
This could be what @Longshot has been experiencing, meaning files are not being correctly cached.

I'll create a commit for this now.

Bug: notice extra forward slash in settings: ./cache//web/ ... this should be /cache/web/

Can anyone explain me how and whatfor these table's are?

they are and stay empty,

There are these scripts: precacheTmdbInfo.php and queryTmdb.php

-> php precacheTmdbInfo.php
Done precaching tmdb information collections (that's it, table's stay empty)

-> php queryTmdb.php
queryTmdb.php - query tmdb distribution script

You have to give the filename as a parameter which you received first

??

tmdb_cast Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~0 InnoDB ascii_general_ci 48 KiB -
tmdb_credits Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~0 InnoDB ascii_general_ci 32 KiB -
tmdb_crew Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~0 InnoDB ascii_general_ci 48 KiB -
tmdb_images Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~0 InnoDB ascii_general_ci 32 KiB -
tmdb_info Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~0 InnoDB ascii_general_ci 32 KiB -
tmdb_trailers Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop ~0 InnoDB ascii_general_ci 32 KiB

Hello,

I want to move user's and their settings from the mysql database to a new server

From: spotweb v0.67.28.31
To: spotweb v0.68.29.32

Is this possible? and if so, what the best way to do so?

I have already tried to export the table's users and usersetting and importing them in the new server but i cannot login using a test user, nor are their details shown:

Username
Firstname
Lastname
E-mail Address
Member of group seems also to be empty for the copied users.

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}

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}

Ik dacht even slim te zijn door mijn commentsxover table te verwijderen met als doel om deze op te ruimen (3gb groot!) en opnieuw aan te laten maken met php upgrade-db. Helaas lukt dit niet en krijg ik onderstaande error. iemand een idee wat er mis gaat?

user@webserver:~/domains/mijndomein.nl/private_html/spotweb$ php upgrade-db.php
Updating schema..(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 spots(collectionid)
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)

Database schema or settings upgrade failed:
HY000: 1005: Can't create table 'spotweb.commentsxover' (errno: 150)50)
#0 /home/user/domains/mijndomein.nl/private_html/spotweb/lib/dbstruct/SpotStruct_mysql.php(254): dbeng_pdo->rawExec('CREATE TABLE co...')
#1 /home/user/domains/mijndomein.nl/private_html/spotweb/lib/dbstruct/SpotStruct_abs.php(387): SpotStruct_mysql->createTable('commentsxover', 'ascii')
#2 /home/user/domains/mijndomein.nl/private_html/spotweb/lib/services/Upgrade/Services_Upgrade_Base.php(42): SpotStruct_abs->updateSchema()
#3 /home/user/domains/mijndomein.nl/private_html/spotweb/upgrade-db.php(44): Services_Upgrade_Base->database()
#4 {main}user@webserver:~/domains/mijndomein.nl/private_html/spotweb$