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)
- 1. row ***************************
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-