Hi All
I recently changed hosts for my PHP/PostgreSQL site and have been seeing
alot of errors in the errors logs and also some on the site.
[quote]PHP Warning: pg_query(): Query failed: ERROR: operator does not
exist: timestamp without time zone > time without time zone at character
14\nHINT: No operator matches the given name and argument type(s). You
might need to add explicit type casts.\nQUERY: SELECT $1 > $2
\nCONTEXT: PL/pgSQL function "f_touch_user" line 29 at IF in
/..../include/database.php on line 40[/quote]
[quote]PHP Warning: pg_fetch_array() expects parameter 1 to be resource,
boolean given in /..../include/common.php on line 402[/quote]
[quote]PHP Warning: pg_query(): Query failed: ERROR: function
pg_catalog.btrim(bigint) does not exist at character 62\nHINT: No function
matches the given name and argument types. You might need to add explicit
type casts. in /..../include/database.php on line 40[/quote]
[quote]PHP Notice: Undefined index: HTTP_REFERER in
..../include/common.php on line 483[/quote]
Does anyone know what might be causing this? Here are the relevant lines
from the code:
[B]database.php on line 40[/B]
[quote]$l_hResult = pg_query($this->m_pHandle, $i_sQuery);[/quote]
[B]common.php on line 402[/B]
[quote]while ($l_asRow = pg_fetch_array($l_hResult)) {[/quote]
[B]common.php on line 483[/B]
[quote]$l_sReferer = isset($_POST['referer']) ? trim($_POST['referer'])
: base64_encode($_SERVER['HTTP_REFERER']);[/quote]
Thank you!
--
View this message in context:
http://www.nabble.com/Changed-Hosts%2C-Lots-of-Errors-in-PostgreSQL---Help-Please%21-tp16769300p16769300.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.