Looks like line 73 of your /xxx/database.inc PHP script is submitting a query
formated with a zero length string instead of a number. Look for the variable
being formated into the query string being undefined thereby leading to the
somethat that looks like:

delete from aaa where id =

instead of a more normal:

delete from aaa where id = 44

You wouldn't believe the number of times I've explained that error message to a
PHP developer.



Older versions of PostgreSQL would allow a '' to be inserted as an integer base value which is illegal. Newer
versions do not allow a '' to be inserted into a integer base value. Thus if you have a query that may return
'' as an integer base value, you should run it through a condition to make the '' == NULL which is valid.


Sincerely,

Joshua Drake








---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to