spotweb/spotweb — Issue #1386: SqlErrorException met PostgreSQL
Author: jvandertil
Created: 2012-01-22 21:19:26+00:00
State: open

Hallo,

Ik heb de volgende config:

PHP 5.3.9 met IIS 7.0 op Windows Server 2008R2
PostgreSQL 8.4
(Dit is een schone installatie, nog geen spots oid in de database)

en krijg de volgende error als ik index.php open:

SpotWeb v0.54.18.27 on PHP v5.3.9 crashed object(SqlErrorException)#10 (8) { ["message":protected]=> string(119) "42601: ERROR: syntax error at or near "," LINE 1: UPDATE filtercounts f, filtercounts t ^" ["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(303) "UPDATE filtercounts f, filtercounts t SET f.lastvisitspotcount = t.currentspotcount, f.currentspotcount = t.currentspotcount, f.lastupdate = t.lastupdate WHERE (f.filterhash = t.filterhash) AND (t.userid = -1) AND (f.userid = %d)" [1]=> array(1) { [0]=> int(1) } } } [1]=> array(6) { ["file"]=> string(35) "C:\iis_sites\spotweb\lib\SpotDb.php" ["line"]=> int(2245) ["function"]=> string(6) "modify" ["class"]=> string(9) "dbeng_pdo" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(303) "UPDATE filtercounts f, filtercounts t SET f.lastvisitspotcount = t.currentspotcount, f.currentspotcount = t.currentspotcount, f.lastupdate = t.lastupdate WHERE (f.filterhash = t.filterhash) AND (t.userid = -1) AND (f.userid = %d)" [1]=> array(1) { [0]=> int(1) } } } [2]=> array(6) { ["file"]=> string(43) "C:\iis_sites\spotweb\lib\SpotUserSystem.php" ["line"]=> int(43) ["function"]=> string(21) "markFilterCountAsSeen" ["class"]=> string(6) "SpotDb" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> int(1) } } [3]=> array(6) { ["file"]=> string(43) "C:\iis_sites\spotweb\lib\SpotUserSystem.php" ["line"]=> int(118) ["function"]=> string(16) "createNewSession" ["class"]=> string(14) "SpotUserSystem" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> int(1) } } [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 } 42601: ERROR: syntax error at or near "," LINE 1: UPDATE filtercounts f, filtercounts t ^