Re: Changed Hosts, Lots of Errors in PostgreSQL - Help Please! - Mailing list pgsql-general

Hey there

Yup it went from 8.1.9 to 8.3



Adrian Klaver wrote:
>
> 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
> [email protected]
>
> --
> Sent via pgsql-general mailing list ([email protected])
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>

--
View this message in context:
http://www.nabble.com/Changed-Hosts%2C-Lots-of-Errors-in-PostgreSQL---Help-Please%21-tp16769300p16797840.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.