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: eZpublish 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 ezpublish, the PostgreSQL log "comes alive" with ALTER statements, then the index.php displays: ------- <b>Fatal error:</b> eZ publish did not finish its request The execution of eZ publish 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:

eZpublish 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 ezpublish, the PostgreSQL log "comes alive" with ALTER statements, then the index.php displays:

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

The execution of eZ publish 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

eZ debug

Timing:	Jan 19 2025 01:21:37
Script start
Timing:	Jan 19 2025 01:21:37
Module start 'layout'
Timing:	Jan 19 2025 01:21:37
Module start 'content'
Timing:	Jan 19 2025 01:21:37
Module end 'content'
Timing:	Jan 19 2025 01:21:37
Script end

Main resources:

Total runtime	0.0204 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0047	590.4141	152.6406
Module start 'layout'	0.0047	0.0030	743.0547	39.4922
Module start 'content'	0.0077	0.0105	782.5469	89.4141
Module end 'content'	0.0183	0.0021	871.9609	30.3047
Script end	0.0203		902.2656

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	12.1299	14	0.0002
Check MTime	0.0011	5.1820	14	0.0001
Mysql Total
Database connection	0.0007	3.2076	1	0.0007
Mysqli_queries	0.0025	12.3138	3	0.0008
Looping result	0.0000	0.0691	1	0.0000
Template Total	0.0016	7.8	1	0.0016
Template load	0.0009	4.3271	1	0.0009
Template processing	0.0007	3.4184	1	0.0007
Override
Cache load	0.0006	3.0600	1	0.0006
General
dbfile	0.0002	0.9837	8	0.0000
String conversion	0.0000	0.0445	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs