Author Topic: Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'noise' in 'field  (Read 4019 times)

Offline moloquin

  • Junior Indexer
  • **
  • Posts: 31
  • Helpful: +1/-0
Hello,

Just updated Dev, patched the db and seeing this error in both tmux and screen scripts when trying to run update.  Anyone else seeing this?

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'noise' in 'field list'

Thanks.

Offline moloquin

  • Junior Indexer
  • **
  • Posts: 31
  • Helpful: +1/-0
FYI, May have fixed it.  All of the sub collection tables (collections_1000161, etc) did not get the noise column created in the table.  Added it to the existing tables and things appear to be churning along again...

Still catching up with a pile of jobs in the queue, but looks like it's inserting the parts into the DB.

Offline Wally73

  • Overlord
  • ******
  • Posts: 269
  • Helpful: +31/-1
  • i'm nuts
i assume you run tpg so you had to run something else too as stated in changelog

https://github.com/nZEDb/nZEDb/blob/dev/Changelog#L13

ALWAYS read the changelog when updating!!!

Offline moloquin

  • Junior Indexer
  • **
  • Posts: 31
  • Helpful: +1/-0
Crap.  Missed that in the changelog.

Thanks.

Offline Bart39

  • Overlord
  • ******
  • Posts: 172
  • Helpful: +19/-0
Crap.  Missed that in the changelog.

Thanks.

i put it in caps and everything  :'(