Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: Bing-Integration
-
Fix Version/s: Bing-Integration
-
Component/s: AdMax
-
Labels:None
-
Environment:
hosts file matches yell-ec-xml2
Description
Command: nohup ./seupdate.sh -d4 --distribution 147 -U 5987 --listings 2> /tmp/yell_bing_integration_testing/seupdate_listings_U5987.log &
(this was run after --accounts and after --groups)
throws exception:
2012-04-17 10:27:12.191 (1) [P1T1]: Exception [syncing accounts]:java.lang.Exception: Missing `searchEngineGroupID` in temp table
at com.thesearchagency.searchengines.ISearchEngine$IListingChunk$FieldMap.put(ISearchEngine.java:193)
at com.thesearchagency.searchengines.bing.BingAPISearchEngine$ListingChunk.getListings(BingAPISearchEngine.java:1702)
at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.syncListings(SearchEngineUpdater.java:1646)
at com.thesearchagency.searchengines.SearchEngineUpdater$SearchEngineAccountWorker.run(SearchEngineUpdater.java:1572)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:651)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:676)
at java.lang.Thread.run(Thread.java:595)
in above lines of log, you can see the temp table isn't created with the searchEngineGroupID field, which is a bug - the temp table should match the actual table
2012-04-17 10:27:11.907 (4) [P1T2]: [1] creating temporary "searchEngineListings" table with fields [searchEngineStatus, searchEngineAccountID, type, title, hash, description2, searchEngineIdentifier, description1, altKey, url, iconSearchEngineImageID, searchEngineStatusText, searchEngineGroupIdentifier, searchEngineImageID, displayURL, calcHash]
2012-04-17 10:27:11.907 (4) [P1T2]: spike: SQL->[create temporary table `st-tracker`.`tmp3` (tempKey varchar(168),primary key (tempKey(168))) engine=myisam character set latin1 collate latin1_swedish_ci select `searchEngineStatus`,`searchEngineAccountID`,`type`,`title`,`hash`,`description2`,`searchEngineIdentifier`,`description1`,`altKey`,`url`,`iconSearchEngineImageID`,`searchEngineStatusText`,`searchEngineGroupIdentifier`,`searchEngineImageID`,`displayURL`,`calcHash` from searchEngineListings where (0)]
