Change all email addresses on a site(in the database) - is the field "original_url_md5" important?

Next topic

Author	Message
K259	Wednesday 30 March 2005 7:20:47 am We're going to change all our email-addresses on our ez-site. We want to replace all @x.x.de addresses with @x.de. I'm thinking of doing a replace in the mysql prompt in the ezurl table..where I replace all istances of @x.x.de with @x.de in the url field. BUT, I see that there is a field in the ezurl table called original_url_md5 which is a hashed value. In which way is this field beeing used? Do I have to update this as well? Best regards.
K259	Thursday 31 March 2005 4:47:36 am I now see that the original_url_md5 is a hashed value of $url-field, but don't find any documentation on where this is beeing used, or which function this field has. Does anyone know some more about this?

Author

Message

Wednesday 30 March 2005 7:20:47 am

We're going to change all our email-addresses on our ez-site.
We want to replace all @x.x.de addresses with @x.de.

I'm thinking of doing a replace in the mysql prompt in the ezurl table..where I replace all istances of @x.x.de with @x.de in the url field.

BUT, I see that there is a field in the ezurl table called original_url_md5 which is a hashed value. In which way is this field beeing used? Do I have to update this as well?

Best regards.

K259

Thursday 31 March 2005 4:47:36 am

I now see that the original_url_md5 is a hashed value of $url-field, but don't find any documentation on where this is beeing used, or which function this field has.

Does anyone know some more about this?

eZ debug

Timing:	Jan 20 2025 04:08:45
Script start
Timing:	Jan 20 2025 04:08:45
Module start 'layout'
Timing:	Jan 20 2025 04:08:45
Module start 'content'
Timing:	Jan 20 2025 04:08:46
Module end 'content'
Timing:	Jan 20 2025 04:08:46
Script end

Main resources:

Total runtime	1.2020 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.0051	589.6641	152.6875
Module start 'layout'	0.0051	0.0027	742.3516	39.6172
Module start 'content'	0.0077	1.1930	781.9688	423.1172
Module end 'content'	1.2007	0.0013	1,205.0859	8.0156
Script end	1.2020		1,213.1016

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0038	0.3186	16	0.0002
Check MTime	0.0017	0.1450	16	0.0001
Mysql Total
Database connection	0.0010	0.0799	1	0.0010
Mysqli_queries	1.1621	96.6848	52	0.0223
Looping result	0.0004	0.0358	50	0.0000
Template Total	1.1651	96.9	2	0.5825
Template load	0.0025	0.2094	2	0.0013
Template processing	1.1625	96.7172	2	0.5813
Template load and register function	0.0002	0.0163	1	0.0002
states
state_id_array	0.0073	0.6050	1	0.0073
state_identifier_array	0.0010	0.0864	2	0.0005
Override
Cache load	0.0021	0.1736	11	0.0002
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0483	1	0.0006
Fetch class attribute name	0.0008	0.0706	2	0.0004
XML
Image XML parsing	0.0001	0.0119	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0005	2	0.0000
General
dbfile	0.0006	0.0470	10	0.0001
String conversion	0.0000	0.0007	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
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
2	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: 7 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs