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

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

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.