spotweb/spotweb — Issue #1145: upgrade_db.php crashed op missende messageid kolom
Author: r-win
Created: 2011-11-11 21:12:17+00:00
State: open

In commit c6e70e520f (Merge remote-tracking branch 'nightspirit81/master') is de column messageid in de tabel cache hernoemd naar resourceid.

In lib/dbstruct/SpotStruct_abs.php (regel 549) staat de volgende query:
$this->_dbcon->rawExec("DELETE FROM cache WHERE messageid IN (SELECT messageid FROM spots WHERE id > " . (int) $maxSpots . ")");

Wijzigen naar onderstaande regel lost het probleem op:
$this->_dbcon->rawExec("DELETE FROM cache WHERE resourceid IN (SELECT messageid FROM spots WHERE id > " . (int) $maxSpots . ")");