Author Topic: DB Errors in Lower Right Corner of first tmux window  (Read 4111 times)

Offline wkremser

  • Newbie
  • *
  • Posts: 3
  • Helpful: +0/-0
DB Errors in Lower Right Corner of first tmux window
« on: 2014-10-22, 06:25:48 am »
Hi Ho.

I get the following errors in my lower right tmux box .. sorry dont seem to be able to recognize which script is executed here.

[22/Oct/2014 14:38] [NOTICE] [1.37,2.15,2.28] [00H:00M:03S] [MEM:~~~4MB] [PID:13343] [\nzedb\db\DB.queryExec] [SQLSTATE[42S22]: Column not found: 1054 Unknown column 'collectionid' in 'where clause']
[22/Oct/2014 14:38] [SQL]    [1.37,2.15,2.28] [00H:00M:04S] [MEM:~~~4MB] [PID:13343] [\nzedb\db\DB.queryExec] [DELETE c FROM collections_4 c INNER JOIN releases r ON r.id = c.releaseid WHERE r.nzbstatus = 1 AND c.filecheck = 4]
[22/Oct/2014 14:38] [NOTICE] [1.37,2.15,2.28] [00H:00M:00S] [MEM:~~~4MB] [PID:13566] [\nzedb\db\DB.queryExec] [SQLSTATE[42S22]: Column not found: 1054 Unknown column 'collectionid' in 'where clause']
[22/Oct/2014 14:38] [SQL]    [1.37,2.15,2.28] [00H:00M:00S] [MEM:~~~4MB] [PID:13566] [\nzedb\db\DB.queryExec] [DELETE FROM collections_41 WHERE id = 20300]
[22/Oct/2014 14:38] [NOTICE] [1.37,2.15,2.28] [00H:00M:00S] [MEM:~~~4MB] [PID:13566] [\nzedb\db\DB.queryExec] [SQLSTATE[42S22]: Column not found: 1054 Unknown column 'collectionid' in 'where clause']
[22/Oct/2014 14:38] [SQL]    [1.37,2.15,2.28] [00H:00M:00S] [MEM:~~~4MB] [PID:13566] [\nzedb\db\DB.queryExec] [DELETE FROM collections_41 WHERE id = 20301]
[22/Oct/2014 14:38] [NOTICE] [1.37,2.15,2.28] [00H:00M:00S] [MEM:~~~4MB] [PID:13566] [\nzedb\db\DB.queryExec] [SQLSTATE[42S22]: Column not found: 1054 Unknown column 'collectionid' in 'where clause']
[22/Oct/2014 14:38] [SQL]    [1.37,2.15,2.28] [00H:00M:00S] [MEM:~~~4MB] [PID:13566] [\nzedb\db\DB.queryExec] [DELETE FROM collections_41 WHERE id = 20302]
[22/Oct/2014 14:38] [NOTICE] [1.37,2.15,2.28] [00H:00M:00S] [MEM:~~~4MB] [PID:13566] [\nzedb\db\DB.queryExec] [SQLSTATE[42S22]: Column not found: 1054 Unknown column 'collectionid' in 'where clause']
[22/Oct/2014 14:38] [SQL]    [1.37,2.15,2.28] [00H:00M:00S] [MEM:~~~4MB] [PID:13566] [\nzedb\db\DB.queryExec] [DELETE FROM collections_41 WHERE id = 20303]
[22/Oct/2014 14:38] [NOTICE] [1.37,2.15,2.28] [00H:00M:00S] [MEM:~~~4MB] [PID:13566] [\nzedb\db\DB.queryExec] [SQLSTATE[42S22]: Column not found: 1054 Unknown column 'collectionid' in 'where clause']
[22/Oct/2014 14:38] [SQL]    [1.37,2.15,2.28] [00H:00M:00S] [MEM:~~~4MB] [PID:13566] [\nzedb\db\DB.queryExec] [DELETE FROM collections_41 WHERE id = 20304]
[22/Oct/2014 14:38] [NOTICE] [1.37,2.15,2.28] [00H:00M:00S] [MEM:~~~4MB] [PID:13571] [\nzedb\db\DB.queryExec] [SQLSTATE[42S22]: Column not found: 1054 Unknown column 'collectionid' in 'where clause']
[22/Oct/2014 14:38] [SQL]    [1.37,2.15,2.28] [00H:00M:00S] [MEM:~~~4MB] [PID:13571] [\nzedb\db\DB.queryExec] [DELETE FROM collections_52 WHERE collectionhash = '7743b520ef9ff73ad5f3d6f2c7241e822898cd99']


i am running ubuntu 14.04 and mysql 5 and i  split my parts and co tables to one per group. it seems as if this is the problem here but i dont know how to fix it.

thx in advance
Wolfgang

Offline Darius

  • Enforcer
  • *****
  • Posts: 121
  • Helpful: +8/-1
Re: DB Errors in Lower Right Corner of first tmux window
« Reply #1 on: 2014-10-24, 03:23:11 am »
Have you updated lately? There is a specific patch for users running tpg.

Offline wkremser

  • Newbie
  • *
  • Posts: 3
  • Helpful: +0/-0
Re: DB Errors in Lower Right Corner of first tmux window
« Reply #2 on: 2014-10-24, 04:18:32 am »
i update every week or so.

which patch do you mean?

Offline wkremser

  • Newbie
  • *
  • Posts: 3
  • Helpful: +0/-0
Re: DB Errors in Lower Right Corner of first tmux window
« Reply #3 on: 2014-10-24, 12:35:06 pm »
found it in nzedb/build/_runonce.
i executed the scripts and now it is working again. it was the delete trigger on the tables that made troubles.