Forums / General / transaction error while searching non-ASCII strings

transaction error while searching non-ASCII strings

Author Message

jozef bednarik

Wednesday 07 March 2007 7:51:45 pm

Hi,

im getting transaction error everytime i try to search string composed from more then ACSII chars. Im running Ez Publish 3.9.0(+ ezwebin extension) with MySQL 5.0, with utf 8 support.

In debug output it seems to have problem with adding data to search statistics table, complaining about column data are too long.

Everything else like adding or modifing content works well, also search composed from ASCII chars works.

Also tried new instalation without ezwebin extension, and still experiencing same problem with search. i have checked my config several times but have no clue what went wrong :(.

If someone experienced same problem and found way to solve it, please give me know. Many thanks.

Best regards

eZ debug

Timing: Jan 20 2025 00:23:52
Script start
Timing: Jan 20 2025 00:23:52
Module start 'content'
Timing: Jan 20 2025 00:23:52
Module end 'content'
Timing: Jan 20 2025 00:23:52
Script end

Main resources:

Total runtime0.1871 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.0079 589.0938180.8203
Module start 'content' 0.00790.0060 769.914189.6953
Module end 'content' 0.01390.1731 859.6094518.6250
Script end 0.1870  1,378.2344 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00412.1789200.0002
Check MTime0.00191.0094200.0001
Mysql Total
Database connection0.00120.648710.0012
Mysqli_queries0.141875.78481410.0010
Looping result0.00160.85911390.0000
Template Total0.172792.310.1727
Template load0.00100.532310.0010
Template processing0.171791.773310.1717
Override
Cache load0.00070.363910.0007
Sytem overhead
Fetch class attribute can translate value0.00080.412510.0008
XML
Image XML parsing0.00030.152210.0003
General
dbfile0.00140.7601200.0001
String conversion0.00000.004230.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