PROBLEM: editing keyword attribute!!!

Next topic

Author	Message
Valentina Ferrari	Wednesday 10 November 2004 2:43:33 am Hi all! I have this problem: I create a new object that contains a keyword attribute. I fill this attribute with a text that contains an apostrophe (for example: It's fine). I publish this object and all it's right. BUT, when I edit this object, the keyword attribute value is repeated n times separeted by a comma (for example: It's fine, It's fine, It's fine) Anybody knows the solution about this problem???? TIA Valentina
Wenyue Yu	Wednesday 10 November 2004 5:07:20 am Hi, This is caused by not changing ' to \' when select existing keyword. We will fix it in next release. You can fix it yourself by editing file kernel/classes/datatypes/ezkeyword/ezkeyword.php around line 161: Change $existingWords =& $db->arrayQuery( "SELECT * FROM ezkeyword WHERE keyword IN ( '$wordsString' ) AND class_id='$classID' " ); to $wordsString = $db->escapeString( $wordsString ); $existingWords =& $db->arrayQuery( "SELECT * FROM ezkeyword WHERE keyword IN ( '$wordsString' ) AND class_id='$classID' " ); Regards, wenyue

Author

Message

Wednesday 10 November 2004 2:43:33 am

Hi all!
I have this problem:

I create a new object that contains a keyword attribute.
I fill this attribute with a text that contains an apostrophe (for example: It's fine).
I publish this object and all it's right.

BUT, when I edit this object, the keyword attribute value is repeated n times separeted by a comma (for example: It's fine, It's fine, It's fine)

Anybody knows the solution about this problem????

TIA
Valentina

Wenyue Yu

Wednesday 10 November 2004 5:07:20 am

Hi,

This is caused by not changing ' to \' when select existing keyword. We will fix it in next release. You can fix it yourself by editing file kernel/classes/datatypes/ezkeyword/ezkeyword.php around line 161:

Change

$existingWords =& $db->arrayQuery( "SELECT * FROM ezkeyword WHERE keyword IN ( '$wordsString' ) AND class_id='$classID' " );

$wordsString = $db->escapeString( $wordsString );
$existingWords =& $db->arrayQuery( "SELECT * FROM ezkeyword WHERE keyword IN ( '$wordsString' ) AND class_id='$classID' " );

Regards,
wenyue

eZ debug

Timing:	Jan 19 2025 01:16:04
Script start
Timing:	Jan 19 2025 01:16:04
Module start 'layout'
Timing:	Jan 19 2025 01:16:04
Module start 'content'
Timing:	Jan 19 2025 01:16:05
Module end 'content'
Timing:	Jan 19 2025 01:16:05
Script end

Main resources:

Total runtime	1.0057 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0046	590.7500	152.6250
Module start 'layout'	0.0046	0.0033	743.3750	39.4609
Module start 'content'	0.0079	0.9963	782.8359	463.4766
Module end 'content'	1.0042	0.0015	1,246.3125	8.1563
Script end	1.0057		1,254.4688

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.3323	16	0.0002
Check MTime	0.0013	0.1260	16	0.0001
Mysql Total
Database connection	0.0006	0.0552	1	0.0006
Mysqli_queries	0.9619	95.6445	54	0.0178
Looping result	0.0006	0.0571	52	0.0000
Template Total	0.9760	97.0	2	0.4880
Template load	0.0018	0.1817	2	0.0009
Template processing	0.9741	96.8607	2	0.4871
Template load and register function	0.0001	0.0147	1	0.0001
states
state_id_array	0.0007	0.0656	1	0.0007
state_identifier_array	0.0009	0.0854	2	0.0004
Override
Cache load	0.0014	0.1437	21	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0008	0.0750	2	0.0004
Fetch class attribute name	0.0014	0.1381	2	0.0007
XML
Image XML parsing	0.0002	0.0240	2	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0006	2	0.0000
General
dbfile	0.0008	0.0831	10	0.0001
String conversion	0.0000	0.0009	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/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
6	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
2	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 16 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs