teleport
teleport copied to clipboard
[develop.tpl] Not unique table/alias: 'Action'
I get this error in modFormCustomizationSet using develop.tpl during an extract.
SQL code:
SELECT modFormCustomizationSet
.id
AS modFormCustomizationSet_id
, modFormCustomizationSet
.profile
AS modFormCustomizationSet_profile
, modFormCustomizationSet
.action
AS modFormCustomizationSet_action
, modFormCustomizationSet
.description
AS modFormCustomizationSet_description
, modFormCustomizationSet
.active
AS modFormCustomizationSet_active
, modFormCustomizationSet
.template
AS modFormCustomizationSet_template
, modFormCustomizationSet
.constraint
AS modFormCustomizationSet_constraint
, modFormCustomizationSet
.constraint_field
AS modFormCustomizationSet_constraint_field
, modFormCustomizationSet
.constraint_class
AS modFormCustomizationSet_constraint_class
, Action
.id
AS Action_id
, Action
.namespace
AS Action_namespace
, Action
.controller
AS Action_controller
, Action
.haslayout
AS Action_haslayout
, Action
.lang_topics
AS Action_lang_topics
, Action
.assets
AS Action_assets
, Action
.help_url
AS Action_help_url
, Template
.id
AS Template_id
, Template
.source
AS Template_source
, Template
.property_preprocess
AS Template_property_preprocess
, Template
.templatename
AS Template_templatename
, Template
.description
AS Template_description
, Template
.editor_type
AS Template_editor_type
, Template
.category
AS Template_category
, Template
.icon
AS Template_icon
, Template
.template_type
AS Template_template_type
, Template
.content
AS Template_content
, Template
.locked
AS Template_locked
, Template
.properties
AS Template_properties
, Template
.static
AS Template_static
, Template
.static_file
AS Template_static_file
, Rules
.id
AS Rules_id
, Rules
.set
AS Rules_set
, Rules
.action
AS Rules_action
, Rules
.name
AS Rules_name
, Rules
.description
AS Rules_description
, Rules
.xtype
AS Rules_xtype
, Rules
.container
AS Rules_container
, Rules
.rule
AS Rules_rule
, Rules
.value
AS Rules_value
, Rules
.constraint
AS Rules_constraint
, Rules
.constraint_field
AS Rules_constraint_field
, Rules
.constraint_class
AS Rules_constraint_class
, Rules
.active
AS Rules_active
, Rules
.for_parent
AS Rules_for_parent
, Rules
.rank
AS Rules_rank
, Action
.id
AS Action_id
, Action
.namespace
AS Action_namespace
, Action
.controller
AS Action_controller
, Action
.haslayout
AS Action_haslayout
, Action
.lang_topics
AS Action_lang_topics
, Action
.assets
AS Action_assets
, Action
.help_url
AS Action_help_url
FROM modx_fc_sets
AS modFormCustomizationSet
LEFT JOIN modx_actions
Action
ON modFormCustomizationSet
.action
= Action
.id
LEFT JOIN modx_site_templates
Template
ON modFormCustomizationSet
.template
= Template
.id
LEFT JOIN modx_actiondom
Rules
ON modFormCustomizationSet
.id
= Rules
.set
LEFT JOIN modx_actions
Action
ON Rules
.action
= Action
.id
WHERE modFormCustomizationSet
.profile
= ? ORDER BY modFormCustomizationSet
.id
ASC
I'm getting the same error with develop.tpl promote and complete work fine.