Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

Version 1 Current »

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, on same Categories table to get access to some parent category field values. In this case we get a problem to avoid 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

  • No labels