Forums / Install & configuration / ERROR: invalid input syntax for integer: ""

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

ERROR: invalid input syntax for integer: ""

Previous topic

Install & configuration

Next topic

Author	Message
Timothy Stone	Friday 16 September 2005 10:18:52 am Configuration: Exponential 3.7rc2 postgresql 8.0.3 Mac OS X (Tiger 10.4.2) PHP 4.4.0 Apache 2 (+FastCGI) The Setup Wizard finally gets where to the end, and following submission for registration of Exponential, the PostgreSQL log "comes alive" with ALTER statements, then the index.php displays: ------- <b>Fatal error:</b> Exponential did not finish its request The execution of Exponential was abruptly ended, the debug output is present below. ------- No "debug output" is actually presented but the PostgreSQL log notes the following: ------- ... ... NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "ezworkflow_event_pkey" for table "ezworkflow_event" NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "ezworkflow_group_pkey" for table "ezworkflow_group" NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "ezworkflow_group_link_pkey" for table "ezworkflow_group_link" NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "ezworkflow_process_pkey" for table "ezworkflow_process" ERROR: invalid input syntax for integer: "" ERROR: invalid input syntax for integer: "" Based on other information found on other sites, it appears that this is a problem with the script <b>assuming</b> "" (empty string) is equivalent to "0" (zero). PostgreSQL does not permit this (v. MySQL which apparently, and incorrectly I might add, does permit "" == "0") So, since no one has posted a solution to this, lets talk. Where might this error be coming from? What script? I would rather fix the script than hack PostgreSQL into accepting a bad practice. Thanks, Tim

Author

Message

Timothy Stone

Friday 16 September 2005 10:18:52 am

Configuration:

Exponential 3.7rc2
postgresql 8.0.3
Mac OS X (Tiger 10.4.2)
PHP 4.4.0
Apache 2 (+FastCGI)

The Setup Wizard finally gets where to the end, and following submission for registration of Exponential, the PostgreSQL log "comes alive" with ALTER statements, then the index.php displays:

-------
<b>Fatal error:</b> Exponential did not finish its request

The execution of Exponential was abruptly ended, the debug output is present below.
-------

No "debug output" is actually presented but the PostgreSQL log notes the following:

-------

...
...
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "ezworkflow_event_pkey" for table "ezworkflow_event"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "ezworkflow_group_pkey" for table "ezworkflow_group"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "ezworkflow_group_link_pkey" for table "ezworkflow_group_link"
NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index "ezworkflow_process_pkey" for table "ezworkflow_process"
ERROR:  invalid input syntax for integer: ""
ERROR:  invalid input syntax for integer: ""

Based on other information found on other sites, it appears that this is a problem with the script <b>assuming</b> "" (empty string) is equivalent to "0" (zero). PostgreSQL does not permit this (v. MySQL which apparently, and incorrectly I might add, does permit "" == "0")

So, since no one has posted a solution to this, lets talk. Where might this error be coming from? What script? I would rather fix the script than hack PostgreSQL into accepting a bad practice.

Thanks,
Tim