how to repair the ezurlalias table

Previous topic

Developer

Next topic

Author	Message
felix berlin	Friday 01 August 2008 8:05:11 am We used ez 3.9.4. Sometimes it seems to us, that table ezurlalias contains wrong url aliases. for example: 1190 content/view/full/976 berlin__2 1236 content/view/full/976 hannover__1 2317 content/view/full/1976 centrum 2911 content/view/full/1976 __1/centrum 2921 content/view/full/976 __1/hannover entry centrum is ok, for instance. the other enties are damaged. Entries with __1 are damaged. Now we upgraded to 3.10 and after than to 4.0.0. Hoping for better ezurlaliases... But there are no hope by ez software. After call the updateniceurls.php the content of table ezurlalias_ml is damaged with old content and some new content. the content of table ezurlalias is still always damaged. But the tree table contains the correct path of all nodes. There are nothing of __1 or berlin__2. How we can correct the entries of ezurlalias table by own? The script updateniceurls.php has a lot of bugs. We need an clean and correct table of ezurlalias. What we have to do?
kubus media	Monday 04 August 2008 1:16:51 am We've had that problem with ezurlalias_ml in eZP4. It was a known Bug. Updateniceurl.php doesn't work, if the table has content. We had to drop the table's content before running updateniceurl.php - after running the script than, we've had clean entries. BUT if you try, please make shure, you've made an backup of the table's content ;) Best regards and good luck

Author

Message

felix berlin

Friday 01 August 2008 8:05:11 am

We used ez 3.9.4. Sometimes it seems to us,
that table ezurlalias contains wrong url aliases.

for example:

1190 content/view/full/976 berlin__2
1236 content/view/full/976 hannover__1
2317 content/view/full/1976 centrum
2911 content/view/full/1976 __1/centrum
2921 content/view/full/976 __1/hannover

entry centrum is ok, for instance.
the other enties are damaged.
Entries with __1 are damaged.

Now we upgraded to 3.10 and after than to 4.0.0.
Hoping for better ezurlaliases...
But there are no hope by ez software.

After call the updateniceurls.php the content of table
ezurlalias_ml is damaged with old content and some new content.
the content of table ezurlalias is still always damaged.

But the tree table contains the correct path of all nodes.
There are nothing of __1 or berlin__2.

How we can correct the entries of ezurlalias table by own?

The script updateniceurls.php has a lot of bugs.

We need an clean and correct table of ezurlalias.
What we have to do?

kubus media

Monday 04 August 2008 1:16:51 am

We've had that problem with ezurlalias_ml in eZP4. It was a known Bug. Updateniceurl.php doesn't work, if the table has content. We had to drop the table's content before running updateniceurl.php - after running the script than, we've had clean entries.

BUT if you try, please make shure, you've made an backup of the table's content ;)

Best regards and good luck

eZ debug

Timing:	Jan 18 2025 16:13:29
Script start
Timing:	Jan 18 2025 16:13:29
Module start 'layout'
Timing:	Jan 18 2025 16:13:29
Module start 'content'
Timing:	Jan 18 2025 16:13:30
Module end 'content'
Timing:	Jan 18 2025 16:13:30
Script end

Main resources:

Total runtime	0.7176 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.0075	589.3516	152.6250
Module start 'layout'	0.0075	0.0045	741.9766	39.4609
Module start 'content'	0.0120	0.7043	781.4375	499.8125
Module end 'content'	0.7163	0.0012	1,281.2500	8.1563
Script end	0.7175		1,289.4063

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.4766	16	0.0002
Check MTime	0.0014	0.1918	16	0.0001
Mysql Total
Database connection	0.0012	0.1636	1	0.0012
Mysqli_queries	0.6703	93.4114	54	0.0124
Looping result	0.0005	0.0730	52	0.0000
Template Total	0.6793	94.7	2	0.3397
Template load	0.0019	0.2581	2	0.0009
Template processing	0.6775	94.4120	2	0.3387
Template load and register function	0.0001	0.0199	1	0.0001
states
state_id_array	0.0030	0.4146	1	0.0030
state_identifier_array	0.0010	0.1380	2	0.0005
Override
Cache load	0.0015	0.2151	31	0.0000
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0966	2	0.0003
Fetch class attribute name	0.0009	0.1314	3	0.0003
XML
Image XML parsing	0.0006	0.0789	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0012	3	0.0000
General
dbfile	0.0007	0.0999	16	0.0000
String conversion	0.0000	0.0018	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
7	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
8	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 20 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs