spotweb/spotweb — Issue #1388: Occasional crash when using PostgreSQL
Author: jvandertil
Created: 2012-01-23 01:37:55+00:00
State: open

After a long idle time on the webpage, and running a spot import in the background. Ocassionally this error will occur:

SpotWeb v0.54.18.27 on PHP v5.3.9 crashed object(SqlErrorException)#10 (8) { ["message":protected]=> string(158) "42703: ERROR: column "f" of relation "filtercounts" does not exist LINE 2: SET f.lastvisitspotcount = f.currentspotcount, ^" ["string":"CustomException":private]=> NULL ["code":protected]=> int(-1) ["file":protected]=> string(44) "C:\iis_sites\spotweb\lib\dbeng\dbeng_pdo.php" ["line":protected]=> int(93) ["string":"Exception":private]=> string(0) "" ["trace":"Exception":private]=> array(5) { [0]=> array(6) { ["file"]=> string(44) "C:\iis_sites\spotweb\lib\dbeng\dbeng_pdo.php" ["line"]=> int(108) ["function"]=> string(4) "exec" ["class"]=> string(9) "dbeng_pdo" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(283) "UPDATE filtercounts f SET f.lastvisitspotcount = f.currentspotcount, f.currentspotcount = t.currentspotcount FROM filtercounts t WHERE (f.filterhash = t.filterhash) AND (t.userid = -1) AND (f.userid = %d)" [1]=> array(1) { [0]=> int(2) } } } [1]=> array(6) { ["file"]=> string(35) "C:\iis_sites\spotweb\lib\SpotDb.php" ["line"]=> int(2104) ["function"]=> string(6) "modify" ["class"]=> string(9) "dbeng_pdo" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(283) "UPDATE filtercounts f SET f.lastvisitspotcount = f.currentspotcount, f.currentspotcount = t.currentspotcount FROM filtercounts t WHERE (f.filterhash = t.filterhash) AND (t.userid = -1) AND (f.userid = %d)" [1]=> array(1) { [0]=> int(2) } } } [2]=> array(6) { ["file"]=> string(43) "C:\iis_sites\spotweb\lib\SpotUserSystem.php" ["line"]=> int(283) ["function"]=> string(23) "resetFilterCountForUser" ["class"]=> string(6) "SpotDb" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> int(2) } } [3]=> array(6) { ["file"]=> string(43) "C:\iis_sites\spotweb\lib\SpotUserSystem.php" ["line"]=> int(107) ["function"]=> string(12) "validSession" ["class"]=> string(14) "SpotUserSystem" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(61) "2ffb58nh3q8f4n04jscfqua7hul77i375p9btyyuzpcyw4asrgsxub7dc27.2" } } [4]=> array(6) { ["file"]=> string(30) "C:\iis_sites\spotweb\index.php" ["line"]=> int(75) ["function"]=> string(17) "useOrStartSession" ["class"]=> string(14) "SpotUserSystem" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> bool(false) } } } ["previous":"Exception":private]=> NULL } 42703: ERROR: column "f" of relation "filtercounts" does not exist LINE 2: SET f.lastvisitspotcount = f.currentspotcount, ^