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

SQL Fatal when using Double-quotes in Text Filters in Grids

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.0.2-B1
    • Fix Version/s: 5.0.2-B1
    • Component/s: Admin Interfaces
    • Labels:
      None

      Description

      SQL Fatal when using Double-quotes in Text Filters in Grids.

      Example - filter"

      1. Applies to all text filters including main search one
      2. single-quote (') works fine.

      SQL Fatal

      SELECT Category.* ,(REPLACE(ParentPath, CONCAT('|', Category.CategoryId, '|'), '')) AS `CurrentSort`,(img.SameImages) AS `SameImages`,(img.LocalThumb) AS `LocalThumb`,(img.ThumbPath) AS `ThumbPath`,(img.ThumbUrl) AS `ThumbUrl`,(img.LocalImage) AS `LocalImage`,(img.LocalPath) AS `LocalPath`,(img.Url) AS `FullUrl`,(IF(ThemeId != 0, 1, 0)) AS `CreatedBySystem`,(cust.l1_cust_7) AS `cust_l_ItemTemplate`,(cust.l1_cust_8) AS `cust_RssExpireInterval`,(cust.l1_cust_9) AS `cust_RssUpdateInterval`,(cust.l1_cust_10) AS `cust_RssLastUpdated`,(cust.l1_cust_11) AS `cust_RssDeleteExpired`,(cust.l1_cust_13) AS `cust_RssUpdateIntervalType`,(cust.l1_cust_14) AS `cust_RssSource`,(cust.l1_cust_15) AS `cust_RssExpireIntervalType`,(cust.l1_cust_16) AS `cust_RssDefaultExpiration`,(cust.l1_cust_17) AS `cust_RssDefaultExpirationType`,(cust.l1_cust_18) AS `cust_RssLastExpired`,(cust.l1_cust_20) AS `cust_n_ItemTemplate`,(cust.l1_cust_21) AS `cust_bb_ItemTemplate`,(cust.l1_cust_24) AS `cust_p_ItemTemplate`,(Category.CreatedOn) AS `CreatedOn_date`,(Category.CreatedOn) AS `CreatedOn_time`,(Category.Modified) AS `Modified_date`,(Category.Modified) AS `Modified_time`,( IF(Category.NewItem = 2, IF(Category.CreatedOn >= (UNIX_TIMESTAMP() - 8*3600*24), 1, 0), Category.NewItem )) AS `IsNew`
      FROM Category
      LEFT JOIN Images img ON img.ResourceId = Category.ResourceId AND img.DefaultImg = 1
      LEFT JOIN PermCache ON PermCache.CategoryId = Category.CategoryId
      LEFT JOIN CategoryCustomData cust ON Category.ResourceId = cust.ResourceId
      WHERE ((Category.Status <> 4) AND (Category.ThemeId = 4 OR Category.ThemeId = 0) AND (ParentId = 1) AND (PermId = 1)) AND (((`Category`.`l1_Name` LIKE "%tret
      "%")))
      ORDER BY `Category`.`Priority` desc,`Category`.`l1_Name` asc
      LIMIT 0,21

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex Alex
                Reporter:
                dmitry Dmitry Andrejev [Intechnic]
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: