Invalid UFT-8 byte sequence detected

Previous topic

Install & configuration

Next topic

Author	Message
Oliver Pawellek	Sunday 08 January 2006 6:11:46 pm Greetings: I have just attempted to deploy eZ Publish 3.7.2 with the latest Postgres 8.1 atabase (UTF-8 encoded); most of the initial eZ publish setup went somewhat smooth until near the end of installation I receive a database application crash after table for "ezworkflow_process": Excerpt from postgresql log (last three lines): 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 UTF-8 byte sequence detected near byte 0xf8 I have been informed that Postgres 8.1 is less forgiving about UTF-8 encodings. Has anyone crossed similar problems with eZ Publish 3.7.2 deployment and the latest Postgres 8.1. Might this be a bug or problem with the php scripts of eZ publish 3.7.2? and perhaps has been corrected in the latest SVN stable release.. Oliver Pawellek Saisung Corporation Ltd www.saisung.com
Oliver Pawellek	Monday 09 January 2006 2:04:32 am Please ignore my above recent post. I have just bumped into the eZ Publish documentation detailing the modification of files site.ini, i18n.ini and template.ini with "Charset=utf-8" within eZ Publish, and it appears to have cured the utf-8 database encoding dilemma. Oliver Pawellek Saisung Corporation Ltd www.saisung.com

Author

Message

Oliver Pawellek

Sunday 08 January 2006 6:11:46 pm

Greetings:

I have just attempted to deploy eZ Publish 3.7.2 with the latest Postgres 8.1 atabase (UTF-8 encoded); most of the initial eZ publish setup went somewhat smooth until near the end of installation I receive a database application crash after table for "ezworkflow_process":

Excerpt from postgresql log (last three lines):
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 UTF-8 byte sequence detected near byte 0xf8

I have been informed that Postgres 8.1 is less forgiving about UTF-8 encodings. Has anyone crossed similar problems with eZ Publish 3.7.2 deployment and the latest Postgres 8.1. Might this be a bug or problem with the php scripts of eZ publish 3.7.2? and perhaps has been corrected in the latest SVN stable release..

Oliver Pawellek

Saisung Corporation Ltd
www.saisung.com

Oliver Pawellek

Monday 09 January 2006 2:04:32 am

Please ignore my above recent post. I have just bumped into the eZ Publish documentation detailing the modification of files site.ini, i18n.ini and template.ini with "Charset=utf-8" within eZ Publish, and it appears to have cured the utf-8 database encoding dilemma.

Oliver Pawellek

Saisung Corporation Ltd
www.saisung.com

eZ debug

Timing:	Jan 19 2025 04:37:49
Script start
Timing:	Jan 19 2025 04:37:49
Module start 'layout'
Timing:	Jan 19 2025 04:37:49
Module start 'content'
Timing:	Jan 19 2025 04:37:49
Module end 'content'
Timing:	Jan 19 2025 04:37:49
Script end

Main resources:

Total runtime	0.8359 sec
Peak memory usage	4,096.0000 KB
Database Queries	52

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0100	589.2813	152.6406
Module start 'layout'	0.0100	0.0032	741.9219	39.4766
Module start 'content'	0.0132	0.8212	781.3984	486.1094
Module end 'content'	0.8344	0.0014	1,267.5078	8.1406
Script end	0.8359		1,275.6484

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	0.4208	16	0.0002
Check MTime	0.0015	0.1760	16	0.0001
Mysql Total
Database connection	0.0023	0.2790	1	0.0023
Mysqli_queries	0.7825	93.6140	52	0.0150
Looping result	0.0008	0.0963	50	0.0000
Template Total	0.7973	95.4	2	0.3987
Template load	0.0018	0.2200	2	0.0009
Template processing	0.7955	95.1589	2	0.3977
Template load and register function	0.0003	0.0322	1	0.0003
states
state_id_array	0.0009	0.1032	1	0.0009
state_identifier_array	0.0014	0.1662	2	0.0007
Override
Cache load	0.0015	0.1803	14	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0018	0.2205	1	0.0018
Fetch class attribute name	0.0015	0.1817	3	0.0005
XML
Image XML parsing	0.0033	0.4003	1	0.0033
class_abstraction
Instantiating content class attribute	0.0000	0.0016	4	0.0000
General
dbfile	0.0035	0.4165	16	0.0002
String conversion	0.0000	0.0012	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 10 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs