Unknown column 'response' in 'field list'(No Description) sql: INSERT INTO externalrequestlog (`type`, `wherefrom`, `url`, `parameters`, `successful`, `response`, `timetaken`, `appinstance`, `apprequesturi`, `created`) SELECT 'ebay', 'function searchProducts()', 'https://svcs.ebay.com/services/search/FindingService/v1?OPERATION-NAME=findItemsByKeywords&SERVICE-VERSION=1.0.0&GLOBAL-ID=EBAY-GB&SECURITY-APPNAME=Jonathan-AzonVide-PRD-1bddb6120-227faf21&RESPONSE-DATA-FORMAT=XML&REST-PAYLOAD&keywords=dj+light+Scanners&paginationInput.pageNumber=1&paginationInput.entriesPerPage=10&itemFilter(0).name=HideDuplicateItems&itemFilter(0).value=true&affiliate.trackingId=5337917157&affiliate.networkId=9', 'a:10:{s:9:\"ebayappid\";s:40:\"Jonathan-AzonVide-PRD-1bddb6120-227faf21\";s:9:\"authtoken\";s:872:\"AgAAAA**AQAAAA**aAAAAA**F7ykXg**nY+sHZ2PrBmdj6wVnY+sEZ2PrA2dj6MEkIenDJmLoQudj6x9nY+seQ**2sIFAA**AAMAAA**iFj4nQxiGVfPyuuI1MllllfX1Y/0MQU47mf6wIA/JyVZzdpOZTfjbLchhxyP0NLWT2jGVA5F+aGTlh8lW6CIAemGyJ2ch82jjPBvuH/8NNjpVAgu3LjwSj0e4r6ow16TAr+/om44yA/Nb2jP2yON7P5AM3O0X8LcW+VVAEFP3/Oy5Uxsj0hWVv21XSvDKsInJT2swH8ih4phPoHyufpSWN8t/l5/sv6mRSHozB7HRrXeiL2s1WWc7WCtwVTOD55vgR1VqFr5/ShuXIEQp8GYNRUBnIIxUGE5JkkoNVwlZCwd7+0U3zX9ceXL2ThgUQKf0uIFJ6UbAXzr/8ubfAfbgeWDSltCE+KeQa6Wyb0bFBvd1D3YS/Ip6Abn1McFCivf1SWWndRP85zlwSXFvKDctyrOcvm7NNzUqPHoeSHdCdQV535jaf9H1Ia8bnlUncHYmgqXSC+X+ZfSG2dtIjK4FSnDWzi9A4EXRQ39TLkxv8H54U//DFuxUTUIQzB4KL0gIHZOIKMqwaa9tqyT+WCo8F+o/jeBf/P+ztP0oB1pi1FIg77oAeGw+qYffPmqQqZ47C5UmZweaR5JyfWQHOJFOJA3h+Ukx8t6+klP5Y5fppQ98JSrNaMZZr7wO7YpIoPsSIOPzEThb3NfwhjZgabrRQKs90ONzYPNccNoPJwnMt4rsoKn9bKww17YUEshgXK4dSplhn5xHTyOOzb7MlAbecmCKhpZcdNbV35kP4+EoyC0QtrqGB5wuUgMwEOy1j1J\";s:13:\"ebaynetworkid\";s:1:\"9\";s:14:\"ebaytrackingid\";s:10:\"5337917157\";s:19:\"googlerecaptchatype\";s:1:\"0\";s:15:\"googlesecretkey\";s:40:\"6Lc4bFsUAAAAAL465x4Oo_CI5UV9BxW-PIoZt2z6\";s:13:\"googlesitekey\";s:40:\"6Lc4bFsUAAAAAG2bH7wS5nkM_iVN97qDAJRVMphz\";s:12:\"ebayglobalid\";s:7:\"EBAY-GB\";s:10:\"ebaysiteid\";s:1:\"3\";s:8:\"currency\";s:3:\"GBP\";}', '1', '{\"ack\":\"Success\",\"version\":\"1.13.0\",\"timestamp\":\"2021-07-31T09:23:25.526Z\",\"searchResult\":{\"@attributes\":{\"count\":\"10\"},\"item\":[{\"itemId\":\"383972534420\",\"title\":\"2x Beamz LED RGBW Wildflower GOBO Effect DJ Scanner Lights Lighting TTB4626\",\"globalId\":\"EBAY-GB\",\"primaryCategory\":{\"categoryId\":\"12921\",\"categoryName\":\"Stage Lighting Systems & Kits\"},\"secondaryCategory\":{\"categoryId\":\"177022\",\"categoryName\":\"Stage Lighting Single Units\"},\"galleryURL\":\"https:\\/\\/thumbs1.ebaystatic.com\\/m\\/mFB9Q4W26NDJHywbSVkqecQ\\/140.jpg\",\"viewItemURL\":\"https:\\/\\/rover.ebay.com\\/rover\\/1\\/710-53481-19255-0\\/1?ff3=2&toolid=10041&campid=5337917157&customid=&lgeo=1&vectorid=229508&item=383972534420\",\"autoPay\":\"false\",\"postalCode\":\"RM203XD\",\"location\":\"Grays,United Kingdom\",\"country\":\"GB\",\"shippingInfo\":{\"shippingServiceCost\":\"0.0\",\"shippingType\":\"Free\",\"shipToLocations\":\"Worldwide\"},\"sellingStatus\":{\"currentPrice\":\"135.0\",\"convertedCurrentPrice\":\"135.0\",\"sellingState\":\"Active\",\"timeLeft\":\"P22DT5H56M12S\"},\"listingInfo\":{\"bestOfferEnabled\":\"true\",\"buyItNowAvailable\":\"false\",\"startTime\":\"2021-02-22T15:19:37.000Z\",\"endTime\":\"2021-08-22T15:19:37.000Z\",\"listingType\":\"FixedPrice\",\"gift\":\"false\",\"watchCount\":\"9\"},\"condition\":{\"conditionId\":\"1000\",\"conditionDisplayName\":\"New\"},\"isMultiVariationListing\":\"false\",\"discountPriceInfo\":{\"originalRetailPrice\":\"179.99\",\"pricingTreatment\":\"STP\",\"soldOnEbay\":\"false\",\"soldOffEbay\":\"false\"},\"topRatedListing\":\"true\"},{\"itemId\":\"124826405174\",\"title\":\" NJD PREDATOR HX PROFESSIONAL DJ DISCO LIGHTING DMX LIGHT CLUB FX\",\"globalId\":\"EBAY-GB\",\"primaryCategory\":{\"categoryId\":\"177023\",\"categoryName\":\"DJ Lighting Single Units\"},\"galleryURL\":\"https:\\/\\/thumbs3.ebaystatic.com\\/m\\/mjtTqQOKvNhmL2t5V5zpk7w\\/140.jpg\",\"viewItemURL\":\"https:\\/\\/rover.ebay.com\\/rover\\/1\\/710-53481-19255-0\\/1?ff3=2&toolid=10041&campid=5337917157&customid=&lgeo=1&vectorid=229508&item=124826405174\",\"autoPay\":\"false\",\"postalCode\":\"WR118QD\",\"location\":\"Evesham,United Kingdom\",\"country\":\"GB\",\"shippingInfo\":{\"shippingServiceCost\":\"7.9\",\"shippingType\":\"Flat\",\"shipToLocations\":\"Worldwide\"},\"sellingStatus\":{\"currentPrice\":\"60.0\",\"convertedCurrentPrice\":\"60.0\",\"bidCount\":\"0\",\"sellingState\":\"Active\",\"timeLeft\":\"P5DT4H55M10S\"},\"listingInfo\":{\"bestOfferEnabled\":\"false\",\"buyItNowAvailable\":\"false\",\"startTime\":\"2021-07-26T14:18:35.000Z\",\"endTime\":\"2021-08-05T14:18:35.000Z\",\"listingType\":\"Auction\",\"gift\":\"false\",\"watchCount\":\"1\"},\"condition\":{\"conditionId\":\"3000\",\"conditionDisplayName\":\"Used\"},\"isMultiVariationListing\":\"false\",\"topRatedListing\":\"false\"},{\"itemId\":\"184692232880\",\"title\":\"LED GOBO Mirror Scanner Light Colour Mixing Mobile DJ Disco Beamz Wildflower\",\"globalId\":\"EBAY-GB\",\"primaryCategory\":{\"categoryId\":\"177022\",\"categoryName\":\"Stage Lighting Single Units\"},\"galleryURL\":\"https:\\/\\/thumbs1.ebaystatic.com\\/m\\/mIfbw_Co1aa9hm4tZHXI9tw\\/140.jpg\",\"viewItemURL\":\"https:\\/\\/rover.ebay.com\\/rover\\/1\\/710-53481-19255-0\\/1?ff3=2&toolid=10041&campid=5337917157&customid=&lgeo=1&vectorid=229508&item=184692232880\",\"autoPay\":\"false\",\"postalCode\":\"RM203XD\",\"location\":\"Grays,United Kingdom\",\"country\":\"GB\",\"shippingInfo\":{\"shippingServiceCost\":\"0.0\",\"shippingType\":\"Free\",\"shipToLocations\":\"Worldwide\"},\"sellingStatus\":{\"currentPrice\":\"77.99\",\"convertedCurrentPrice\":\"77.99\",\"sellingState\":\"Active\",\"timeLeft\":\"P2DT17H56M35S\"},\"listingInfo\":{\"bestOfferEnabled\":\"true\",\"buyItNowAvailable\":\"false\",\"startTime\":\"2021-03-03T03:20:00.000Z\",\"endTime\":\"2021-08-03T03:20:00.000Z\",\"listingType\":\"FixedPrice\",\"gift\":\"false\",\"watchCount\":\"5\"},\"condition\":{\"conditionId\":\"1000\",\"conditionDisplayName\":\"New\"},\"isMultiVariationListing\":\"false\",\"discountPriceInfo\":{\"originalRetailPrice\":\"109.99\",\"pricingTreatment\":\"STP\",\"soldOnEbay\":\"false\",\"soldOffEbay\":\"false\"},\"topRatedListing\":\"true\"},{\"itemId\":\"174732197721\",\"title\":\"Chauvet Intimidator Scan 110 10W LED Mirror Scanner Effect Light DJ Disco *B*\",\"globalId\":\"EBAY-GB\",\"primaryCategory\":{\"categoryId\":\"177022\",\"categoryName\":\"Stage Lighting Single Units\"},\"galleryURL\":\"https:\\/\\/thumbs2.ebaystatic.com\\/m\\/mBFJt6m3YHLAbZLDWXYqt5A\\/140.jpg\",\"viewItemURL\":\"https:\\/\\/rover.ebay.com\\/rover\\/1\\/710-53481-19255-0\\/1?ff3=2&toolid=10041&campid=5337917157&customid=&lgeo=1&vectorid=229508&item=174732197721\",\"autoPay\":\"false\",\"postalCode\":\"IP224EU\",\"location\":\"Diss,United Kingdom\",\"country\":\"GB\",\"shippingInfo\":{\"shippingServiceCost\":\"0.0\",\"shippingType\":\"Free\",\"shipToLocations\":\"Worldwide\"},\"sellingStatus\":{\"currentPrice\":\"99.0\",\"convertedCurrentPrice\":\"99.0\",\"sellingState\":\"Active\",\"timeLeft\":\"P14DT6H29M32S\"},\"listingInfo\":{\"bestOfferEnabled\":\"false\",\"buyItNowAvailable\":\"false\",\"startTime\":\"2021-04-14T15:52:57.000Z\",\"endTime\":\"2021-08-14T15:52:57.000Z\",\"listingType\":\"StoreInventory\",\"gift\":\"false\",\"watchCount\":\"6\"},\"condition\":{\"conditionId\":\"2500\",\"conditionDisplayName\":\"Seller refurbished\"},\"isMultiVariationListing\":\"false\",\"topRatedListing\":\"false\"},{\"itemId\":\"124773020340\",\"title\":\"CHAUVET DJ GOBOZAP LED BARREL SCANNER EFFECT LIGHT WITH 14 GOBOS\",\"globalId\":\"EBAY-GB\",\"primaryCategory\":{\"categoryId\":\"177022\",\"categoryName\":\"Stage Lighting Single Units\"},\"galleryURL\":\"https:\\/\\/thumbs1.ebaystatic.com\\/m\\/m8eREheLvTet7Lb4p5H0whQ\\/140.jpg\",\"viewItemURL\":\"https:\\/\\/rover.ebay.com\\/rover\\/1\\/710-53481-19255-0\\/1?ff3=2&toolid=10041&campid=5337917157&customid=&lgeo=1&vectorid=229508&item=124773020340\",\"autoPay\":\"false\",\"postalCode\":\"LU61SA\",\"location\":\"Dunstable,United Kingdom\",\"country\":\"GB\",\"shippingInfo\":{\"shippingServiceCost\":\"0.0\",\"shippingType\":\"Free\",\"shipToLocations\":\"Worldwide\"},\"sellingStatus\":{\"currentPrice\":\"299.0\",\"convertedCurrentPrice\":\"299.0\",\"sellingState\":\"Active\",\"timeLeft\":\"P15DT4H26M43S\"},\"listingInfo\":{\"bestOfferEnabled\":\"false\",\"buyItNowAvailable\":\"false\",\"startTime\":\"2021-06-15T13:50:08.000Z\",\"endTime\":\"2021-08-15T13:50:08.000Z\",\"listingType\":\"FixedPrice\",\"gift\":\"false\",\"watchCount\":\"1\"},\"condition\":{\"conditionId\":\"1000\",\"conditionDisplayName\":\"New\"},\"isMultiVariationListing\":\"false\",\"topRatedListing\":\"true\"},{\"itemId\":\"164736865491\",\"title\":\"3x Beamz RGBW LED Mobile DJ Disco Party Scanner Lights Club GOBO Lighting\",\"globalId\":\"EBAY-GB\",\"primaryCategory\":{\"categoryId\":\"12921\",\"categoryName\":\"Stage Lighting Systems & Kits\"},\"secondaryCategory\":{\"categoryId\":\"177022\",\"categoryName\":\"Stage Lighting Single Units\"},\"galleryURL\":\"https:\\/\\/thumbs4.ebaystatic.com\\/m\\/m2AGayN4pLfZv01eCPqCAvg\\/140.jpg\",\"viewItemURL\":\"https:\\/\\/rover.ebay.com\\/rover\\/1\\/710-53481-19255-0\\/1?ff3=2&toolid=10041&campid=5337917157&customid=&lgeo=1&vectorid=229508&item=164736865491\",\"autoPay\":\"false\",\"postalCode\":\"RM203XD\",\"location\":\"Grays,United Kingdom\",\"country\":\"GB\",\"shippingInfo\":{\"shippingServiceCost\":\"0.0\",\"shippingType\":\"Free\",\"shipToLocations\":\"Worldwide\"},\"sellingStatus\":{\"currentPrice\":\"195.0\",\"convertedCurrentPrice\":\"195.0\",\"sellingState\":\"Active\",\"timeLeft\":\"P2DT17H56M2S\"},\"listingInfo\":{\"bestOfferEnabled\":\"true\",\"buyItNowAvailable\":\"false\",\"startTime\":\"2021-03-03T03:19:27.000Z\",\"endTime\":\"2021-08-03T03:19:27.000Z\",\"listingType\":\"FixedPrice\",\"gift\":\"false\",\"watchCount\":\"7\"},\"condition\":{\"conditionId\":\"1000\",\"conditionDisplayName\":\"New\"},\"isMultiVariationListing\":\"false\",\"discountPriceInfo\":{\"originalRetailPrice\":\"259.99\",\"pricingTreatment\":\"STP\",\"soldOnEbay\":\"false\",\"soldOffEbay\":\"false\"},\"topRatedListing\":\"true\"},{\"itemId\":\"162348370168\",\"title\":\"*BRAND NEW* MARTIN PROFESSIONAL MX-1 SCANNER LIGHTING EFFECT DJ CLUB LIGHT FX\",\"globalId\":\"EBAY-GB\",\"primaryCategory\":{\"categoryId\":\"177022\",\"categoryName\":\"Stage Lighting Single Units\"},\"galleryURL\":\"https:\\/\\/thumbs1.ebaystatic.com\\/m\\/mHo9ZxaS1xhgW6UPYZN_CaA\\/140.jpg\",\"viewItemURL\":\"https:\\/\\/rover.ebay.com\\/rover\\/1\\/710-53481-19255-0\\/1?ff3=2&toolid=10041&campid=5337917157&customid=&lgeo=1&vectorid=229508&item=162348370168\",\"paymentMethod\":\"PayPal\",\"autoPay\":\"false\",\"postalCode\":\"B56**\",\"location\":\"Birmingham,United Kingdom\",\"country\":\"GB\",\"shippingInfo\":{\"shippingServiceCost\":\"0.0\",\"shippingType\":\"Free\",\"shipToLocations\":\"Worldwide\"},\"sellingStatus\":{\"currentPrice\":\"109.0\",\"convertedCurrentPrice\":\"109.0\",\"sellingState\":\"Active\",\"timeLeft\":\"P6DT5H31M22S\"},\"listingInfo\":{\"bestOfferEnabled\":\"true\",\"buyItNowAvailable\":\"false\",\"startTime\":\"2017-01-06T14:54:47.000Z\",\"endTime\":\"2021-08-06T14:54:47.000Z\",\"listingType\":\"FixedPrice\",\"gift\":\"false\",\"watchCount\":\"9\"},\"condition\":{\"conditionId\":\"1000\",\"conditionDisplayName\":\"New\"},\"isMultiVariationListing\":\"false\",\"topRatedListing\":\"false\"},{\"itemId\":\"194230115302\",\"title\":\"2X BEAMZ LED RGBW WILDFLOWER GOBO EFFECT DJ DISCO PARTY SCANNER LIGHTS\",\"globalId\":\"EBAY-GB\",\"primaryCategory\":{\"categoryId\":\"12921\",\"categoryName\":\"Stage Lighting Systems & Kits\"},\"galleryURL\":\"https:\\/\\/thumbs3.ebaystatic.com\\/m\\/mUOF2yeBlpKv5zjmB0JVr7Q\\/140.jpg\",\"viewItemURL\":\"https:\\/\\/rover.ebay.com\\/rover\\/1\\/710-53481-19255-0\\/1?ff3=2&toolid=10041&campid=5337917157&customid=&lgeo=1&vectorid=229508&item=194230115302\",\"autoPay\":\"true\",\"postalCode\":\"L35**\",\"location\":\"Liverpool,United Kingdom\",\"country\":\"GB\",\"shippingInfo\":{\"shippingServiceCost\":\"0.0\",\"shippingType\":\"Free\",\"shipToLocations\":\"Worldwide\"},\"sellingStatus\":{\"currentPrice\":\"82.99\",\"convertedCurrentPrice\":\"82.99\",\"sellingState\":\"Active\",\"timeLeft\":\"P6DT1H13M32S\"},\"listingInfo\":{\"bestOfferEnabled\":\"false\",\"buyItNowAvailable\":\"false\",\"startTime\":\"2021-07-06T10:36:57.000Z\",\"endTime\":\"2021-08-06T10:36:57.000Z\",\"listingType\":\"FixedPrice\",\"gift\":\"false\",\"watchCount\":\"3\"},\"condition\":{\"conditionId\":\"3000\",\"conditionDisplayName\":\"Used\"},\"isMultiVariationListing\":\"false\",\"topRatedListing\":\"true\"},{\"itemId\":\"114057243131\",\"title\":\"Martin Lighting Package - 4 x MX1 Scanner + 1 x Acrobat Barrel + Controller DJ \",\"globalId\":\"EBAY-GB\",\"primaryCategory\":{\"categoryId\":\"177022\",\"categoryName\":\"Stage Lighting Single Units\"},\"galleryURL\":\"https:\\/\\/thumbs4.ebaystatic.com\\/m\\/mUMQB_RD1axLGpvTk1E5X1Q\\/140.jpg\",\"viewItemURL\":\"https:\\/\\/rover.ebay.com\\/rover\\/1\\/710-53481-19255-0\\/1?ff3=2&toolid=10041&campid=5337917157&customid=&lgeo=1&vectorid=229508&item=114057243131\",\"autoPay\":\"true\",\"postalCode\":\"WR102LF\",\"location\":\"Pershore,United Kingdom\",\"country\":\"GB\",\"shippingInfo\":{\"shippingServiceCost\":\"30.0\",\"shippingType\":\"Flat\",\"shipToLocations\":\"Worldwide\"},\"sellingStatus\":{\"currentPrice\":\"679.0\",\"convertedCurrentPrice\":\"679.0\",\"sellingState\":\"Active\",\"timeLeft\":\"P8DT7H26M16S\"},\"listingInfo\":{\"bestOfferEnabled\":\"true\",\"buyItNowAvailable\":\"false\",\"startTime\":\"2020-01-08T16:49:41.000Z\",\"endTime\":\"2021-08-08T16:49:41.000Z\",\"listingType\":\"FixedPrice\",\"gift\":\"false\",\"watchCount\":\"10\"},\"condition\":{\"conditionId\":\"3000\",\"conditionDisplayName\":\"Used\"},\"isMultiVariationListing\":\"false\",\"topRatedListing\":\"false\"},{\"itemId\":\"233906349924\",\"title\":\"Beamz 10w wildflower 153.732 LED DJ Disco RGBW Gobo Scanner light\",\"globalId\":\"EBAY-GB\",\"primaryCategory\":{\"categoryId\":\"177022\",\"categoryName\":\"Stage Lighting Single Units\"},\"galleryURL\":\"https:\\/\\/thumbs1.ebaystatic.com\\/m\\/mMQ-5or0hO5gMKoP9rvPEDg\\/140.jpg\",\"viewItemURL\":\"https:\\/\\/rover.ebay.com\\/rover\\/1\\/710-53481-19255-0\\/1?ff3=2&toolid=10041&campid=5337917157&customid=&lgeo=1&vectorid=229508&item=233906349924\",\"autoPay\":\"false\",\"postalCode\":\"RM203XD\",\"location\":\"Grays,United Kingdom\",\"country\":\"GB\",\"shippingInfo\":{\"shippingServiceCost\":\"0.0\",\"shippingType\":\"Free\",\"shipToLocations\":\"Worldwide\"},\"sellingStatus\":{\"currentPrice\":\"77.99\",\"convertedCurrentPrice\":\"77.99\",\"sellingState\":\"Active\",\"timeLeft\":\"P22DT10H6M28S\"},\"listingInfo\":{\"bestOfferEnabled\":\"true\",\"buyItNowAvailable\":\"false\",\"startTime\":\"2021-02-22T19:29:53.000Z\",\"endTime\":\"2021-08-22T19:29:53.000Z\",\"listingType\":\"FixedPrice\",\"gift\":\"false\",\"watchCount\":\"2\"},\"condition\":{\"conditionId\":\"1000\",\"conditionDisplayName\":\"New\"},\"isMultiVariationListing\":\"false\",\"discountPriceInfo\":{\"originalRetailPrice\":\"109.99\",\"pricingTreatment\":\"STP\",\"soldOnEbay\":\"false\",\"soldOffEbay\":\"false\"},\"topRatedListing\":\"true\"}]},\"paginationOutput\":{\"pageNumber\":\"1\",\"entriesPerPage\":\"10\",\"totalPages\":\"6\",\"totalEntries\":\"59\"},\"itemSearchURL\":\"https:\\/\\/rover.ebay.com\\/rover\\/1\\/710-53481-19255-0\\/1?ff3=4&toolid=10041&campid=5337917157&customid=&lgeo=1&mpre=http%3A%2F%2Fwww.ebay.co.uk%2Fsch%2Fi.html%3F_nkw%3Ddj%2Blight%2BScanners%26_ipg%3D10%26_pgn%3D1\"}', '0.53113102912903', '9368f5fa8f715842687a0d9e7bc79052', 'http://hi-mr-dj.co.uk/scanners/', '2021-07-31 09:23:25' DJ Scanners | HiMrDj For All Your DJ Needs