Author Topic: [Fixed] When running Predb it suddenly stops  (Read 147 times)

Offline theblade954

  • Junior Indexer
  • **
  • Posts: 8
  • Helpful: +0/-0
[Fixed] When running Predb it suddenly stops
« 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!

« Last Edit: 2018-12-27, 01:52:03 AM by Wally73 »

Offline theblade954

  • Junior Indexer
  • **
  • Posts: 8
  • Helpful: +0/-0
Re: When running Predb it suddenly stops
« Reply #1 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


Offline theblade954

  • Junior Indexer
  • **
  • Posts: 8
  • Helpful: +0/-0
Re: When running Predb it suddenly stops
« Reply #2 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.