transaction error while searching non-ASCII strings

Next topic

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

Author

Message

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 03:25:50
Script start
Timing:	Jan 20 2025 03:25:50
Module start 'layout'
Timing:	Jan 20 2025 03:25:50
Module start 'content'
Timing:	Jan 20 2025 03:25:51
Module end 'content'
Timing:	Jan 20 2025 03:25:51
Script end

Main resources:

Total runtime	1.1216 sec
Peak memory usage	4,096.0000 KB
Database Queries	46

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0107	590.5547	152.6406
Module start 'layout'	0.0107	0.0045	743.1953	39.4922
Module start 'content'	0.0152	1.1051	782.6875	399.2109
Module end 'content'	1.1204	0.0012	1,181.8984	8.1250
Script end	1.1215		1,190.0234

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	0.3237	16	0.0002
Check MTime	0.0014	0.1260	16	0.0001
Mysql Total
Database connection	0.0020	0.1748	1	0.0020
Mysqli_queries	1.0785	96.1582	46	0.0234
Looping result	0.0008	0.0736	44	0.0000
Template Total	1.0805	96.3	2	0.5403
Template load	0.0019	0.1655	2	0.0009
Template processing	1.0787	96.1735	2	0.5393
Template load and register function	0.0002	0.0198	1	0.0002
states
state_id_array	0.0012	0.1102	1	0.0012
state_identifier_array	0.0013	0.1146	2	0.0006
Override
Cache load	0.0015	0.1380	10	0.0002
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0624	1	0.0007
Fetch class attribute name	0.0010	0.0918	1	0.0010
XML
Image XML parsing	0.0001	0.0101	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0004	1	0.0000
General
dbfile	0.0009	0.0833	10	0.0001
String conversion	0.0000	0.0011	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
1	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
1	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 4 Number of unique templates used: 4

Time used to render debug report: 0.0001 secs