Forums / Install & configuration / Invalid UFT-8 byte sequence detected

Invalid UFT-8 byte sequence detected

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 20 2025 12:47:48
Script start
Timing: Jan 20 2025 12:47:48
Module start 'content'
Timing: Jan 20 2025 12:47:48
Module end 'content'
Timing: Jan 20 2025 12:47:48
Script end

Main resources:

Total runtime0.1281 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0059 592.6953180.8203
Module start 'content' 0.00590.0049 773.515693.9297
Module end 'content' 0.01080.1172 867.4453523.0781
Script end 0.1280  1,390.5234 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00332.6126200.0002
Check MTime0.00141.1111200.0001
Mysql Total
Database connection0.00100.777610.0010
Mysqli_queries0.086267.29061410.0006
Looping result0.00110.84611390.0000
Template Total0.116991.310.1169
Template load0.00080.644110.0008
Template processing0.116190.608910.1161
Override
Cache load0.00060.438810.0006
Sytem overhead
Fetch class attribute can translate value0.00110.858910.0011
XML
Image XML parsing0.00030.209210.0003
General
dbfile0.00544.2428200.0003
String conversion0.00000.004730.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs