DB Errors in Lower Right Corner of first tmux window

[wkremser]

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

[Darius]

Have you updated lately? There is a specific patch for users running tpg.

[wkremser]

i update every week or so.

which patch do you mean?

[wkremser]

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.