/
"ParentPath" field usage in SQL without table alias [5.2.1]

"ParentPath" field usage in SQL without table alias [5.2.1]

Owned by Erik S.
Last updated: Oct 28, 2014 by Alex

In the categories_config.php calculated field "CurrentSort" is used without table alias. This may be a problem if customization requires additional join. For example, join on same Categories table to get access to some parent category field values. In this case we get following SQL error "1052: Column 'ParentPath' in field list is ambiguous".

categories_config.php
'CalculatedFields' => Array (
    '' => Array (
        'CurrentSort' => "REPLACE(ParentPath, CONCAT('|', ".'%1$s'.".CategoryId, '|'), '')",

I suggest use before ParentPath same prefix '%1$s' as before CategoryId field.

Related Tasks