teleport icon indicating copy to clipboard operation
teleport copied to clipboard

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

Open Jako opened this issue 8 years ago • 1 comments

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

Jako avatar Apr 28 '16 11:04 Jako

I'm getting the same error with develop.tpl promote and complete work fine.

muzzwood avatar Sep 25 '16 14:09 muzzwood