folders objects unaccessible - duplicate key violates unique constraints ezurlalias1051_key (postgres)

Previous topic

General

Next topic

Author	Message
Baur Aibek	Sunday 28 March 2004 9:17:50 pm hi people i have multiple sites single installation of EZpublish 3.3-3 (Postgres, FreeBSD) some times when i create folder or another objects they are not accesses via alias for example i have several folder in root folder. some of them work fine but some of them are not accessed site/index.php/site_admin/node_56 - error module not found site/index.php/site_admin/content/view/full/56 - works i can edit the folder but can't view it. i cudn't find any regularity, pattern or rule of the error occurence. only possible solution for now is to remove the folder and create it again, but this also works only in some cases. i've found out that there the error is also shown in postgres log : duplicate key violates unique constraints ezurlalias1051_key. seems to me the problem is with table ezurlalias cud u please say what to do? or at least please explain how this alias allocation works, which php script inesrts into ezurlalias table and what logic is base of alias and url objects or any other tips. may be it'll help to find solution.
Baur Aibek	Saturday 03 April 2004 1:37:49 am <b>sequence.sql.template</b> - solved the problem. run sequence.sql.template, but: take into account that first select is just an example and the second is generating list of select expressions. remove both.

Author

Message

Baur Aibek

Sunday 28 March 2004 9:17:50 pm

hi people

i have multiple sites single installation of EZpublish 3.3-3 (Postgres, FreeBSD)

some times when i create folder or another objects they are not accesses via alias

for example i have several folder in root folder.
some of them work fine but some of them are not accessed

site/index.php/site_admin/node_56 - error module not found
site/index.php/site_admin/content/view/full/56 - works

i can edit the folder but can't view it.
i cudn't find any regularity, pattern or rule of the error occurence.
only possible solution for now is to remove the folder and create it again, but this also works only in some cases.

i've found out that there the error is also shown in postgres log : duplicate key violates unique constraints ezurlalias1051_key.

seems to me the problem is with table ezurlalias

cud u please say what to do?

or at least please explain how this alias allocation works, which php script inesrts into ezurlalias table and what logic is base of alias and url objects or any other tips. may be it'll help to find solution.

Baur Aibek

Saturday 03 April 2004 1:37:49 am

<b>sequence.sql.template</b> - solved the problem.

run sequence.sql.template, but:
take into account that first select is just an example
and the second is generating list of select expressions.
remove both.

eZ debug

Timing:	Jan 31 2025 06:15:00
Script start
Timing:	Jan 31 2025 06:15:00
Module start 'layout'
Timing:	Jan 31 2025 06:15:00
Module start 'content'
Timing:	Jan 31 2025 06:15:00
Module end 'content'
Timing:	Jan 31 2025 06:15:00
Script end

Main resources:

Total runtime	0.0151 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0052	588.6328	151.2734
Module start 'layout'	0.0052	0.0038	739.9063	36.8203
Module start 'content'	0.0090	0.0046	776.7266	90.1406
Module end 'content'	0.0136	0.0015	866.8672	29.9922
Script end	0.0151		896.8594

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0023	15.2011	14	0.0002
Check MTime	0.0010	6.9288	14	0.0001
Mysql Total
Database connection	0.0014	9.1370	1	0.0014
Mysqli_queries	0.0029	19.4616	3	0.0010
Looping result	0.0000	0.1780	1	0.0000
Template Total	0.0011	7.2	1	0.0011
Template load	0.0008	5.4765	1	0.0008
Template processing	0.0003	1.7105	1	0.0003
Override
Cache load	0.0006	3.8983	1	0.0006
General
dbfile	0.0003	1.6696	8	0.0000
String conversion	0.0000	0.0614	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	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs