Uploaded image for project: 'In-Portal CMS'
  1. In-Portal CMS
  2. INP-1765

Use table alias, when creating calculated fields for catalog items

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.2.2-B3
    • Component/s: Database
    • Labels:
      None
    • Change Log Group:
      Fixed
    • Change Log Message:
      Fixed SQL error, when searching in "Show All" mode in Admin Console's Catalog.
    • Story Points:
      1
    • Copy Issue Key:
    • Patch Instructions:

      Patches must be submitted through Phabricator.

      Description

      In the "\kCatDBEventHandler::prepareObject" method change this code:

      $object->addCalculatedField('CachedNavbar', 'l' . $this->Application->GetVar('m_lang') . '_CachedNavbar');

      into

      $object->addCalculatedField('CachedNavbar', TABLE_PREFIX . 'Categories.l'.$this->Application->GetVar('m_lang') . '_CachedNavbar');

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex Alex
                Reporter:
                alex Alex
                Developer:
                Alex
                Reviewer:
                Erik Snarski [Intechnic]
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1.5h
                  1.5h