Author Topic: IRCScraper inserts only very few releases into DB  (Read 1508 times)

Offline hanshansen

  • Decent Indexer
  • ***
  • Posts: 57
  • Helpful: +1/-0
IRCScraper inserts only very few releases into DB
« on: 2017-07-28, 02:16:41 pm »
Hi all,

I don't know for how long I already have this problem, but scrape.php seems to insert only a tiny fraction of releases from the IRC channel into the database. The IRCScraper tab in tmux shows only very few releases. The znc log shows much much more. When I run
Code: [Select]
scrape.php true false true I see the same releases as in the znc log, but they are still not inserted into the database.

What am I doing wrong or is this normal?

Offline hanshansen

  • Decent Indexer
  • ***
  • Posts: 57
  • Helpful: +1/-0

Offline Wally73

  • Overlord
  • ******
  • Posts: 269
  • Helpful: +31/-1
  • i'm nuts
Re: IRCScraper inserts only very few releases into DB
« Reply #2 on: 2017-08-02, 01:58:01 pm »
Fixed by adding

Code: [Select]
sql_mode = "ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
under [mysqld] in /etc/mysql/my.cnf

fix found by Slug ;)