Recent Posts

Pages: 1 2 [3] 4 5 ... 10
21
Support / File renaming and processing with Tmux
« Last post by theblade954 on 2018-12-26, 02:09:03 PM »
Hello, i am kind of new with nzedb and i googled quite some time on this issue but i am experiancing some issues with the tools that are in nZEDb.
Because nZEDb when php start.php is beeing runned in folder /var/www/nZEDb/misc/update/nix/tmux/

I see that there are headers beeing downloaded into the database and published on the site but the file renaming and nfo adding are not beeing added to the site.
IRCscraper works well ( it downloads correctly everything from irc right into the predb ).

When i use /var/www/nZEDb/misc/update/nix/screen/sequential & ./simple.sh i see the following output...
Code: [Select]
Updating: 5 group(s) - Using compression? Yes [nzedb\Binaries::updateAllGroups]

Starting group 1 of 5 [nzedb\Binaries::updateAllGroups]

Processing alt.binaries.boneless

Part repair enabled. Checking for missing parts.

Group alt.binaries.boneless has 20,396 new articles. Leaving 10,198 for next pass.
Server oldest: 19,767,027 Server newest: 27,334,917,995 Local newest: 27,334,897,599


Getting 10,198 articles (27,334,897,600 to 27,334,907,797) from alt.binaries.boneless - (0 articles in queue).
Received 473KB from group (alt.binaries.boneless).
Received 10198 articles of 10,198 requested, 0 blacklisted, 147 not yEnc.
Debug: Sending 778.43 KB of MGR parts to MySQL
0.56s to download articles, 0.45s to process collections, 0.65s to insert binaries/parts, 0.00s for part repair, 1.66s total.

Group alt.binaries.boneless processed in 1.72 seconds.
...
Updating completed in 8.27 seconds. [nzedb\Binaries::updateAllGroups]

No work to do!
Process Releases -> Attempting to find complete collections.
0 collections were found to be complete. Time: 1 second(s)

Process Releases -> Calculating collection sizes (in bytes).
0 collections set to filecheck = 3(size calculated)
0 second(s)

Process Releases -> Delete collections smaller/larger than minimum size/file count from group/site setting.
Deleted 0 collections:
0 smaller than, 0 bigger than, 0 with less files than site/group settings in: 0 second(s)

Process Releases -> Create releases from complete collections.
0 Collections ready to be converted to releases.

0 Releases added and 0 duplicate collections deleted in 0 second(s)

Process Releases -> Create the NZB, delete collections/binaries/parts.
0 NZBs created/Collections deleted in 0 seconds.
Total time: 0 second(s)


Process Releases -> Delete finished collections.

Deleting collections/binaries/parts older than 72 hours.
Finished deleting 0 old collections/binaries/parts in 0 seconds.

Deleting collections that were missed after NZB creation.
Finished deleting 0 collections missed after NZB creation in 0 seconds.
Removed 0 parts/binaries/collection rows in 0 second(s)

Process Releases -> Delete releases smaller/larger than minimum size/file count from group/site setting.
Deleted 0 releases:
0 smaller than, 0 bigger than, 0 with less files than site/groups setting in: 0 second(s)

Process Releases -> Delete old releases and passworded releases.
Removed releases: 0 past retention, 0 passworded, 0 crossposted, 0 from disabled categories, 0 smaller than category settings, 0 from disabled music genres, 0 from misc->other0 from misc->hashed, 1 under 95% completion.
Removed 1 releases in 0 second(s)
Process Releases -> Request ID local lookup -- limit 0
No RequestID's to process.
0 releases updated in 0 second(s)

Process Releases -> Request ID web lookup -- limit 0
No RequestID's to process.
0 releases updated in 0 second(s)

Process Releases -> Categorize releases.
0 second(s)

Multi-processing for releases finished in 1.1662201881409 seconds at Wed, 26 Dec 2018 23:01:15 +0100.

No music releases to process.
No console releases to process.
No games releases to process.
No xxx releases to process.
No book releases to process for category id 7010

Decrypt Hashes (full) Started at 11:01:17
Matching predb hashes to hash(releases.name or releases.searchname)

2 releases to process.

Renamed 0 releases in 2 second(s).

Match PreFiles (150) Started at 11:01:19
Matching predb filename to cleaned release_files.name.


75 releases to process.

Renamed 0 releases in 0 second(s).
waiting 60 seconds...
U

The releases to process number will get every instance higher and not lower.

And no files will be renamed and also no mediainfo will be added. :-(

Is there someone who can help me with this issue..
i am kind of N00B around here ;-) sorry
22
Support / Re: When running Predb it suddenly stops
« Last post by theblade954 on 2018-12-26, 01:46:46 PM »
this thread can be closed .. problem solved.
The predb was corrupted. and wrong value in the cell.
23
just do git stash and then run ./zed update all again
24
Support / zed update all reporting changed files/untracked working tree files
« Last post by lukeren on 2018-12-23, 02:04:24 PM »
I'm trying to update nzedb with ./zed update all, but I'm getting these errors.
I haven't changed any files.

Code: [Select]
From https://github.com/nZEDb/nZEDb
 * branch                0.x        -> FETCH_HEAD
error: Your local changes to the following files would be overwritten by merge:
        resources/db/schema/data/10-categories.tsv
        resources/db/schema/mysql-ddl.sql
        www/admin/ajax.php
        www/admin/predb.php
        www/install/install.php
        www/smarty.php
        www/themes/Omicron/templates/viewnzb.tpl
        www/themes/Omicron/templates/viewserieslist.tpl
        www/themes/shared/templates/paginate.tpl
Please commit your changes or stash them before you merge.
error: The following untracked working tree files would be overwritten by merge:
        app/controllers/CountriesController.php
        app/controllers/GroupsController.php
        app/controllers/MultigroupPostersController.php
        app/controllers/PredbController.php
        app/controllers/VideosController.php
        app/extensions/action/Controller.php
        app/models/Countries.php
        app/models/Films.php
        app/models/Groups.php
        app/models/Tables.php
        app/models/Videos.php
        app/tests/cases/controllers/CountriesControllerTest.php
        app/tests/cases/controllers/MultigroupPostersControllerTest.php
        app/tests/cases/controllers/VideosControllerTest.php
        app/tests/cases/extensions/util/YencTest.php
        app/tests/cases/extensions/util/yenc/yenc-test.txt
        app/tests/cases/extensions/util/yenc/yenc-test.ync
        app/tests/cases/extensions/util/yenc/yenc1.zip
        app/tests/cases/extensions/util/yenc/yenc2.zip
        app/tests/cases/models/CountriesTest.php
        app/tests/cases/models/MultigroupPostersTest.php
        app/tests/cases/models/VideosTest.php
        resources/db/patches/mysql/0484~collections.sql
        resources/db/patches/mysql/0485~countries.sql
        resources/db/patches/mysql/0486~categories.sql
Please move or remove them before you merge.
Aborting

Should I just do 'git stash' and then delete the untracked files it's complaining about?

I'm not sure which version I'm on, where do I see this?
25
Support / Re: When running Predb it suddenly stops
« Last post by theblade954 on 2018-12-23, 10:01:48 AM »
Screen dump
 
Skipping dump 1427377992, as your minimum unix time argument is 1427550800
Skipping dump 1427464396, as your minimum unix time argument is 1427550800
Skipping dump 1427550799, as your minimum unix time argument is 1427550800
Downloading: https://raw.githubusercontent.com/nZEDb/nZEDbPre_Dumps/master/dumps/1404152742/1427637204_predb_dump.csv.gz
Dump 2015-03-29 downloaded
Info: Clearing import table
LOAD DATA LOCAL INFILE :path
  IGNORE INTO TABLE predb_imports
  FIELDS TERMINATED BY '\t\t'  OPTIONALLY ENCLOSED BY "'"
  LINES TERMINATED BY '\r\n'
  (title, nfo, size, files, filename, nuked, nukereason, category, created, source, requestid, groupname);
Info: Deleting any records where title <=8 from Temporary Table
Info: Inserting records from temporary table into predb table
 
 
CLI log
 
[23-Dec-2018 18:53:31 Europe/Berlin] PHP Fatal error:  Uncaught PDOException: SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '2015-03-29 02:44:19' for column 'created' at row 970 in /var/www/nZEDb/nzedb/db/PreDb.php:122
Stack trace:
#0 /var/www/nZEDb/nzedb/db/PreDb.php(122): PDOStatement->execute()
#1 /var/www/nZEDb/cli/data/predb_import_daily_batch.php(208): nzedb\db\PreDb->executeInsert()
#2 {main}  thrown in /var/www/nZEDb/nzedb/db/PreDb.php on line 122

26
Support / [Fixed] When running Predb it suddenly stops
« Last post by theblade954 on 2018-12-23, 03:50:44 AM »
When i am running php data/predb_import_daily_batch.php 0 local true for importing the PreDB it always stops at the following lines:

Successfully imported PreDB dump 1427464396 (2015-03-27), 1370 dumps remaining
Downloading: https://raw.githubusercontent.com/nZEDb/nZEDbPre_Dumps/master/dumps/1404152742/1427550799_predb_dump.csv.gz                                                                                                                                                     
Info: Clearing import table
Info: Deleting any records where title <=8 from Temporary Table
Info: Inserting records from temporary table into predb table
Successfully imported PreDB dump 1427550799 (2015-03-28), 1369 dumps remaining
Downloading: https://raw.githubusercontent.com/nZEDb/nZEDbPre_Dumps/master/dumps/1404152742/1427637204_predb_dump.csv.gz                                                                                                                                                       
Info: Clearing import table
Info: Deleting any records where title <=8 from Temporary Table
Info: Inserting records from temporary table into predb table
marc@usenetindx:/var/www/nZEDb/cli$ php /var/www/nZEDb/misc/testing/DB/show_table_sizes.php                                                                                                                                                       
Error:
This script will show table data, index and free space used. The argument needed is numeric.                                                                                                                                                             

php /var/www/nZEDb/misc/testing/DB/show_table_sizes.php 1      ...: To show all tables with data + index space used greater than 1MB or free space greater than 1MB.                                                                                                                                                                                                                                                                                                               
php /var/www/nZEDb/misc/testing/DB/show_table_sizes.php .01    ...: To show all                                                                                                                                                              tables with data + index space used greater than .01MB or free space greater tha                                                                                                                                                             n .01MB.


What can be wrong?

I have also runned the command php data/predb_import_daily_batch.php 1 local true
 But still the same!

27
Announcements / Release 0.8.13.0 2018-12-03
« Last post by Wally73 on 2018-12-03, 11:33:40 PM »
0.8.13.0 2018-12-03
Fixed:
   * Improved accuracy of PreDb matching. Closes issue 2568.
   * Add pagination links in Browse Groups for Alpha, Charisma, Gamma, Gentele, and Omicron Themes.
   * Corrected categories table data for Book entries. This caused books (Comics, etc.) to be
    listed in the wrong subcategory.
   * New groups not respecting number of days/posts to initialise with and then starting from
    the first header on the server.


0.8.12.0 2018-11-05
Added:
   * New anime title regex in PPA to capture more titles correctly.
   * Support for mediaInfo's new format in v17.12+

Changed:
   * Renamed 'Complete Sequential' to 'Custom Sequential' in tmux settings, to avoid confusion of
    people thinking it is more complete than Simple.

Fixed:
   * Make sure newly activated groups have TPG tables, if TPG mode is enabled and MGR mode is not.
   * Fix anime last updated check to correctly return if an update was attempted 'recently'.
   * Correct generic music regex to actually match the example.
   * Corrected counter on predb import daily script, so it no longer reports -1 remaining.


0.8.11.0 2018-10-02
Fixed:
   * Updated scripts in .../misc/testing/DB to use modern require_once syntax (instead of nesting
    multiple dirname() calls. Also added a new require_once to two scripts that need
    .../configuration/settings.php to run. Note they will cause an error if the file does not
    exist, but it should be obvious to the user what the problem is.
     If any other scripts are complaining about missing nZEDb_* or other constants let Niel know
    and he'll update them as well.
28
Guides / Re: Announcing simply-nzedb (Defunct)
« Last post by noobg on 2018-11-18, 08:31:45 PM »
I've been tinkering on an update to this apparently "defunct" docker container.  It is working for me, all bells and whistles right up to the latest dev branch (although the container itself is currently set to 0.8.12.0.  If someone wants to give it a shot, please let me know what isn't working out of the box and I'll tweak it.  You do need to follow the directions and i've likely forgotten a couple necessary ones so some beta testers would be appreciated.
I've sent a pull request to the original repository, but if they aren't interested in merging it you can find my fork at https://github.com/pl77/simply-nzedb
29
Support / Re: Need to run update_binaries Otherwise the group is dead error
« Last post by noobg on 2018-11-16, 12:47:32 PM »
The easiest way to resolve this that I've found is to open the admin panel, under site settings choose groups and then view the group that's causing an issue.  I found that this occurred when the "First Record ID" (or maybe it's called Oldest Record in previous versions) was too low, which caused the program to assume there were no more releases earlier than that. 

The solution is to make the "First Record" a later number.  If you haven't backfilled too much yet, set it to the "Last Record ID".  Hopefully it'll work then. Also, when you choose a new group don't immediately select backfill.  Wait for it to cycle for a bit as it updates the latest binaries and then choose backfill once it has established a first/last ID. 
30
Support / Need to run update_binaries Otherwise the group is dead error
« Last post by pdupreez on 2018-09-29, 09:32:23 AM »
I have been getting an error "Error: You need to run update_binaries on a.b.ebook. Otherwise the group is dead, you must disable it."

I have (previously) already run the update_binaries against the newsgroup, but get nothing
Code: [Select]
bash-4.4# php update_binaries.php alt.binaries.ebook
Updating group: alt.binaries.ebook
Processing alt.binaries.ebook

Searching for an approximate article number for group alt.binaries.ebook 1 days back.
----------------------+-++
Found article #32265952 which has a date of Fri, 28 Sep 2018 11:52:25 -0500, vs wanted date of Fri, 28 Sep 2018 11:29:05 -0500. Difference from goal is -0 days.
No new articles for alt.binaries.ebook (first 32,265,952, last 32,265,952, grouplast 0, total 0)
Server oldest: 319 Server newest: 32,265,956 Local newest: 0

I have reset the group, and purged it, but it doesn't show up as being read in my group settings


Pages: 1 2 [3] 4 5 ... 10