Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please!

On Friday 18 April 2008 8:27 pm, BLazeD wrote:
> 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!

Did the Postgres versions change from one host to another?

--
Adrian Klaver
aklaver(at)comcast(dot)net