Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-2013

Pixel Processing: pixels mishandle apostrophe refcd

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: unspecified
    • Fix Version/s: None
    • Component/s: xOther
    • Labels:
      None
    • Environment:

      Operating System: Linux
      Platform: PC

    • Bugzilla Id:
      3638

      Description

      Pixel processing seems to want to escape the ' in the refcd but then not revert
      before sticking data in the database. Final result: two sources, unknown conversion

      mysql> select * from sources where altkey like 'go0001008s_http%'\G

                                                          • 1. row ***************************
                                                            id: 663959916
                                                            altKey: go0001008s_http_www_sam's_club
                                                            accountID: 690
                                                            siteID: 0
                                                            searchEngineAccountID: 40918
                                                            keywordID: 0
                                                            distributionID: 3
                                                            searchEngineIdentifier: 11461059992
                                                            searchEngineGroupIdentifier: 1416204902
                                                            searchEngineMatchType: broad
                                                            searchEngineGroupID: 5376
                                                            isBiddable: true
                                                            campaignID: 0
                                                            description: Keyword: [http www sam's club] broad
                                                            type: 1
                                                            keyword: http www sam's club
                                                            sourceURL:
                                                            cost: 3.5
                                                            maxCost: 3.5
                                                            waypointID: NULL
                                                            landingURL:
                                                            http://thesearchagency.net/tsaredir.php?siteid=699&wayid=3815&refcd=GO0001008S_http_www_sam's_club&tsacr=GO {creative}

                                                            &dest=http%3A%2F%2Fwww.samsclub.com
                                                            passParams:
                                                            trackPerformance: true
                                                            searchEngineStatus: ok
                                                            searchEngineStatusText: Active
                                                            lastChecked: 0000-00-00 00:00:00

                                                          • 2. row ***************************
                                                            id: 666267576
                                                            altKey: go0001008s_http_www_sam\'s_club
                                                            accountID: 690
                                                            siteID: 699
                                                            searchEngineAccountID: 0
                                                            keywordID: 0
                                                            distributionID: 3
                                                            searchEngineIdentifier: NULL
                                                            searchEngineGroupIdentifier:
                                                            searchEngineMatchType: unknown
                                                            searchEngineGroupID: 0
                                                            isBiddable: false
                                                            campaignID: 13
                                                            description: Keyword "http www sam\'s club"
                                                            type: 1
                                                            keyword: http www sam\'s club
                                                            sourceURL:
                                                            cost: NULL
                                                            maxCost: 0
                                                            waypointID: NULL
                                                            landingURL:
                                                            passParams:
                                                            trackPerformance: true
                                                            searchEngineStatus: unknown
                                                            searchEngineStatusText:
                                                            lastChecked: 0000-00-00 00:00:00
                                                            2 rows in set (0.02 sec)

        Attachments

          Activity

            People

            • Assignee:
              squadrim Mike Squadrito (Inactive)
              Reporter:
              bduffy Bill Duffy (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: