Page 1 of 1
Invalid input syntax for type double precision
Posted: Sat May 19, 2007 5:02 pm
by Chribu
Hi, i'm getting the following errors
and then
Posted: Mon May 21, 2007 4:21 pm
by marco
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
Posted: Mon May 21, 2007 5:41 pm
by Chribu
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
Posted: Sat May 26, 2007 1:04 pm
by marco
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