Comments (14)
Never seen an error like that, not even sure what this means.
What happens if you try again?
from spotweb.
exactly the same so i've turned off report retrieval for now
fromhdr is in table reportsxover
On Fri, May 15, 2015 at 10:50 AM, Sweepr [email protected] wrote:
Never seen an error like that, not even sure what this means.
What happens if you try again?
โ
Reply to this email directly or view it on GitHub
#66 (comment).
from spotweb.
I'll monitor the retrieval of reports here and see if i see something similar
from spotweb.
So far i have not seen this error during retrieval.
Could you find out some more info?
from spotweb.
i already pasted the complete error message
i can try to run retrieve with debug
On Fri, May 15, 2015 at 11:41 AM, Sweepr [email protected] wrote:
Sofar i have not seens this error during retrieval.
Could you find out some more info?
โ
Reply to this email directly or view it on GitHub
#66 (comment).
from spotweb.
wally@debian:/var/www/spotweb$ php retrieve.php --debug
Last retrieve at Fri 15 May 2015 11:43:02 AM CEST
Retrieving new Spots from server reader.easyusenet.nl...
SpotWeb v0.68.29.32 on PHP v5.6.7-1 crashed
Fatal error occured retrieving reports:
22001: 1406: Data too long for column 'message' at row 1 (SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'message' at row 1)
#0 /var/www/spotweb/lib/dbeng/dbeng_pdo.php(74): dbeng_pdo->exec('INSERT INTO deb...', Array)
#1 /var/www/spotweb/lib/dao/Base/Dao_Base_DebugLog.php(25): dbeng_pdo->modify('INSERT INTO deb...', Array)
#2 /var/www/spotweb/lib/SpotDebug.php(28): Dao_Base_DebugLog->add(10, 1431683064.3145, 'searchMessageId...')
#3 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(126): SpotDebug::msg(10, 'searchMessageId...')
#4 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(308): Services_Retriever_Base->searchMessageId('7559697', 'p048uwN2oAUkb5V...', Array)
#5 /var/www/spotweb/retrieve.php(155): Services_Retriever_Base->perform()
#6 {main}
that is with debug on
from spotweb.
Try php upgrade-db.php to check the table's
Otherwise, perform a repair on the entire DB, something probably messed up the table field length's
from spotweb.
In the Database certain field length's are limited to 128 character, If the data you are trying to enter into that field length exceeds the set field/length you get:
22001: 1406: Data too long for column
Basically means that the data does not fit into the column space.
from spotweb.
i found the issue i have
somehow the db is turned into having different storage engines on tables (some are still myisam and some are innodb)
since i don't succeed to alter the tables i will setup db a new during the weekend (but for now i keep running without report retrieval on)
from spotweb.
I am seeing this same issue...
Last retrieve at Tue Jun 2 04:50:19 2015
Retrieving new reports from server ssl.astraweb.com...
Appr. Message count: 125712
First message number: 148
Last message number: 125860
Current article number: 120171
Retrieving 120171 till 125172, found 5001 reports in 1.63 seconds
SpotWeb v0.68.29.32 on PHP v5.5.12-2ubuntu4.4 crashed
Fatal error occured retrieving reports:
22001: 1406: Data too long for column 'fromhdr' at row 7
#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, '120171', 125172, 1433238620.1096)
#3 /var/www/spotweb/lib/services/Retriever/Services_Retriever_Base.php(319): Services_Retriever_Base->loopTillEnd('120171', '5000')
#4 /var/www/spotweb/retrieve.php(214): Services_Retriever_Base->perform()
#5 {main}
Spotweb running on fresh MySQL 5.6.24
from spotweb.
This fixed things for me.
ALTER TABLE spotweb
.reportsxover
CHANGE COLUMN fromhdr
fromhdr
VARCHAR(256) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NOT NULL DEFAULT '' ;
from spotweb.
thx cliv that sql (without the dbname before tablename ) worked fine for me afaik with mariadb 10.0.19
from spotweb.
Had the same issue. @cliv's solution worked:
ALTER TABLE reportsxover
CHANGE COLUMN fromhdr fromhdr VARCHAR(256) CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NOT NULL DEFAULT '' ;
from spotweb.
@LeonB ๐ I need to port this back into my Docker container for Spotweb now
from spotweb.
Related Issues (20)
- PHP8.2 Deprecated Functions HOT 2
- [New issue] HOT 24
- can get sonarr to work with nzbserver spotweb HOT 1
- Question about Spotweb usenet connections HOT 3
- Update from Debian 11 to Debian 12 (seeing index.php content) (solved) HOT 1
- NZB button makes file with name download with error message after update dsm Version: 7.1.1-42962 Update 5 HOT 3
- Spots aren't being retrieved HOT 6
- [New issue] Spotweb search โLaw & Orderโ gives error HOT 3
- (502) Authentication rejected [response: "Too many connections"] [response: ""] HOT 2
- [New issue] HOT 1
- Undefined array key "enc"Undefined array key "port" HOT 3
- Default blacklist/whitelist URLs are offline HOT 6
- unable to run retrieve.php HOT 9
- Where do I issue command to reset database? HOT 1
- [New issue] Black- and whitelists are not working anymore, seem to be garbled? HOT 22
- Local Blacklist HOT 2
- SpotWeb webui not loading in Organizr HOT 2
- add support for docker secrets as env-variabls HOT 1
- Latest SC Synology package wonโt run after install. HOT 4
- problem sending to sabnzbd when using reverse proxy HOT 11
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ๐๐๐
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google โค๏ธ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from spotweb.