Skip to content

[develop.tpl] Not unique table/alias: 'Action' #32

Open
@Jako

Description

@Jako

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions