PostgreSQL query failed: ERROR: pg_atoi: zero-length string

Поиск
Список
Период
Сортировка
Искать

PostgreSQL query failed: ERROR: pg_atoi: zero-length string

От:
"shreedhar" <shreedhar@lucidindia.net>
Дата:
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

Re: [GENERAL] PostgreSQL query failed: ERROR: pg_atoi: zero-length

От:
"Nigel J. Andrews" <nandrews@investsystems.co.uk>
Дата:
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

Re: [GENERAL] PostgreSQL query failed: ERROR: pg_atoi: zero-length

От:
"Joshua D. Drake" <jd@commandprompt.com>
Дата:

>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







FAQ