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.

eZ debug

Timing: Jan 18 2025 19:21:26
Script start
Timing: Jan 18 2025 19:21:26
Module start 'content'
Timing: Jan 18 2025 19:21:27
Module end 'content'
Timing: Jan 18 2025 19:21:27
Script end

Main resources:

Total runtime0.6077 sec
Peak memory usage4,096.0000 KB
Database Queries189

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0054 589.4375180.7734
Module start 'content' 0.00540.4720 770.2109434.4453
Module end 'content' 0.47750.1302 1,204.6563333.7109
Script end 0.6076  1,538.3672 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00410.6815210.0002
Check MTime0.00190.3048210.0001
Mysql Total
Database connection0.00080.132610.0008
Mysqli_queries0.545989.82471890.0029
Looping result0.00170.28591870.0000
Template Total0.585596.320.2927
Template load0.00220.364820.0011
Template processing0.583395.982020.2916
Template load and register function0.00010.023710.0001
states
state_id_array0.00100.165710.0010
state_identifier_array0.00060.104520.0003
Override
Cache load0.00190.3082230.0001
Sytem overhead
Fetch class attribute can translate value0.00120.200920.0006
Fetch class attribute name0.00100.165120.0005
XML
Image XML parsing0.00100.161820.0005
class_abstraction
Instantiating content class attribute0.00000.000920.0000
General
dbfile0.00220.3621210.0001
String conversion0.00000.000930.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
6content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
4content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 14
 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs