Thread: PostgreSQL query failed: ERROR: pg_atoi: zero-length string
If I try to delete a record from my table which is giving following error Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in /xxx/database.inc on line 73 What might be the problem. Regards, Sreedhar Bhaskararaju
On Tue, 2003-09-23 at 05:57, shreedhar wrote: > If I try to delete a record from my table which is giving following error > > > Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in > /xxx/database.inc on line 73 > > What might be the problem. What version are you running? Could you show us an example using psql? -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA The purpose of the military isn't to pay your college tuition or give you a little extra income; it's to "kill people and break things". Surprisingly, not everyone understands that.
On Tue, 23 Sep 2003, shreedhar wrote: > If I try to delete a record from my table which is giving following error > > > Warning: PostgreSQL query failed: ERROR: pg_atoi: zero-length string in > /xxx/database.inc on line 73 > > What might be the problem. 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. -- Nigel J. Andrews
>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