Invalid input syntax for type double precision

Chribu · Post by **Chribu** » Sat May 19, 2007 5:02 pm

Hi, i'm getting the following errors

and then

Post by **marco** » Mon May 21, 2007 4:21 pm

Hello,
this bug only affects postgresql database, here is the file you have to replace in php-residence 0.6.4 directory to solve it:

http://www.digitaldruid.net/download/creaprezzi.zip

Marco

Chribu · Post by **Chribu** » Mon May 21, 2007 5:41 pm

I think this is connected

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: invalid input syntax for type double precision: "" in /home/chribu/websites/php-residence/includes/funzioni_postgresql.php on line 55

ERROR in: select metodo_pagamento,saldo_prenota,data_inserimento from soldi2007 where saldo_prenota != '' and motivazione LIKE '%;2' order by data_inserimento

Warning: pg_numrows(): supplied argument is not a valid PostgreSQL result resource in /home/chribu/websites/php-residence/includes/funzioni_postgresql.php on line 75

Post by **marco** » Sat May 26, 2007 1:04 pm

I will try to correct all these errors in the next php-residence version, meanwhile you can use a previous version of postgresql or mysql.

Marco