Crash on import of data
Hi Duke
I have had issues with both 0.57 & 0.58 - again, both do not recognize the entry of my email address leaving the.json with "" but keeps the frontier code - but when I try to import the data - or it runs automatically I get an exception - the dump file, even compressed is massive - 750Mb uncompressed - but I have attached the exception log
Can you help?
Unfortunately, it will not allow me to upload the file - the add file option is not visible in Edge or Chrome - text inserted
Hi Duke
I have had issues with both 0.57 & 0.58 - again, both do not recognize the entry of my email address leaving the.json with "" but keeps the frontier code - but when I try to import the data - or it runs automatically I get an exception - the dump file, even compressed is massive - 750Mb uncompressed - but I have attached the exception log
Can you help?
Unfortunately, it will not allow me to upload the file - the add file option is not visible in Edge or Chrome - text inserted
26.10.2016 16:51:53 : 26.10.2016 15:51:53 : Error in EDDN-Sending-Thread (commodity)
--------------------------------------------------------------------------------
26.10.2016 15:51:53 : Object reference not set to an instance of an object.
26.10.2016 15:51:53 : at IBE.Condition.get_GameversionIsBeta() in E:\dev\RN\ED-IBE\ED-IBE\Condition.cs:line 239
at IBE.EDDN.EDDNCommunicator.SendCommodityData_i() in E:\dev\RN\ED-IBE\ED-IBE\EDDN\EDDNCommunicator.cs:line 1445
********************************************************************************
26.10.2016 16:51:53 : 26.10.2016 15:51:53 : Error in EDDN-Sending-Thread (outfitting)
--------------------------------------------------------------------------------
26.10.2016 15:51:53 : Object reference not set to an instance of an object.
26.10.2016 15:51:53 : at IBE.Condition.get_GameversionIsBeta() in E:\dev\RN\ED-IBE\ED-IBE\Condition.cs:line 239
at IBE.EDDN.EDDNCommunicator.SendOutfittingData_i() in E:\dev\RN\ED-IBE\ED-IBE\EDDN\EDDNCommunicator.cs:line 1349
********************************************************************************
26.10.2016 23:52:43 : 26.10.2016 22:52:43 : Error in cmdEventLanded_Click
--------------------------------------------------------------------------------
26.10.2016 22:52:43 : Object reference not set to an instance of an object.
26.10.2016 22:52:43 : at IBE.Condition.get_GameversionIsBeta() in E:\dev\RN\ED-IBE\ED-IBE\Condition.cs:line 239
at IBE.IBECompanion.CompanionData.RefreshAndImport(String systemName, String stationName) in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\CompanionData.cs:line 628
********************************************************************************
26.10.2016 23:53:33 : 26.10.2016 22:53:33 : Unhandled Exception
--------------------------------------------------------------------------------
26.10.2016 22:53:33 : InvalidArgument=Value of '0' is not valid for 'SelectedIndex'.
Parameter name: SelectedIndex
26.10.2016 22:53:33 : at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
at IBE.Form1.txtEventInfo_DropDownClosed(Object sender, EventArgs e) in E:\dev\RN\ED-IBE\ED-IBE\Form1.cs:line 3606
at System.Windows.Forms.ComboBox.OnDropDownClosed(EventArgs e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
********************************************************************************
26.10.2016 23:53:58 : 26.10.2016 22:53:58 : Unhandled Exception
--------------------------------------------------------------------------------
26.10.2016 22:53:58 : Access to the path 'C:\ED-IBE\ed-ibe-dump-v0_5_0_dmp' is denied.
26.10.2016 22:53:58 : at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode)
at IBE.Program.CreateMiniDump(String Filename) in E:\dev\RN\ED-IBE\ED-IBE\Program.cs:line 168
at IBE.Program.HandleException(Exception ex) in E:\dev\RN\ED-IBE\ED-IBE\Program.cs:line 130
at System.Windows.Forms.Application.ThreadContext.OnThreadException(Exception t)
at System.Windows.Forms.Control.WndProcException(Exception e)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
********************************************************************************
26.10.2016 23:58:31 : 26.10.2016 22:58:31 : Error in cmdEventLanded_Click
--------------------------------------------------------------------------------
26.10.2016 22:58:31 : Object reference not set to an instance of an object.
26.10.2016 22:58:31 : at IBE.Condition.get_GameversionIsBeta() in E:\dev\RN\ED-IBE\ED-IBE\Condition.cs:line 239
at IBE.IBECompanion.CompanionData.RefreshAndImport(String systemName, String stationName) in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\CompanionData.cs:line 628
********************************************************************************
28.10.2016 22:43:49 : 28.10.2016 21:43:49 : Error in cmdEventLanded_Click
--------------------------------------------------------------------------------
28.10.2016 21:43:49 : Error while collecting market data from external tool
28.10.2016 21:43:49 : at IBE.IBECompanion.DataEventBase.ImportMarketData() in H:\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 108
at IBE.IBECompanion.CompanionData.RefreshAndImport() in H:\RN\ED-IBE\ED-IBE\IBECompanion\CompanionData.cs:line 630
--------------------------------------------------------------------------------
28.10.2016 21:43:49 : Error while importing prices from companion interface
28.10.2016 21:43:49 : at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2942
at IBE.IBECompanion.DataEventBase.ImportMarketData() in H:\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 97
--------------------------------------------------------------------------------
28.10.2016 21:43:49 : Error while importing self collected price data
28.10.2016 21:43:49 : at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2878
at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2938
--------------------------------------------------------------------------------
28.10.2016 21:43:49 : Error while importing prices
28.10.2016 21:43:49 : at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2646
at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2860
--------------------------------------------------------------------------------
28.10.2016 21:43:49 : Error on 'ExecuteNonQuery', SQLString = <insert into tbCommodityData(id, station_id, commodity_id, Sell, Buy,Demand, DemandLevel, Supply, SupplyLevel, Sources_id, timestamp) (select if(SC1.cnt = 0, 0, SC1.id),298,1,196,212,1,null,34400,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 1) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,2,97,102,1,null,207959,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 2) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,277,884,0,47326,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 277) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,278,126,141,1,null,7428,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 278) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,3,165,0,88985,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 3) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,4,113,127,1,null,9910,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 4) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,118,290,306,1,null,52334,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 118) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,117,7580,0,3006,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 117) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,271,124,0,18468,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 271) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,5,476,0,88749,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 5) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,7,527,0,11108,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 7) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,116,138,149,1,null,4675,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 116) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-1,1335,0,8381,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -1) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,15,1312,0,3190,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 15) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,16,403,0,57294,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 16) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,17,141,0,10251,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 17) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,18,338,0,38140,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 18) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,19,207,0,137949,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 19) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,20,95,106,1,null,242275,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 20) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,21,1512,0,7941,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 21) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-2,3659,0,100164,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -2) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,115,380,0,65107,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 115) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,282,8494,0,48946,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 282) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,114,88198,0,19032,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 114) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,22,58,71,1,null,136716,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 22) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,23,721,748,1,null,18507,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 23) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,24,6606,6746,1,null,51072,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 24) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-3,499,0,20659,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -3) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,295,973,0,63856,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 295) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,28,106,120,1,null,163599,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 28) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,296,348,0,314019,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 296) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,289,389,0,230631,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 289) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,30,527,0,18343,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 30) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-7,2045,0,31553,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -7) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,31,300,0,11582,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 31) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,305,980,1016,1,null,8225,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 305) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,32,790,819,1,null,8974,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 32) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,33,209,227,1,null,34557,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 33) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,35,6196,6327,1,null,25578,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 35) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,36,6357,6491,1,null,2462,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 36) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,37,221,239,1,null,232909,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 37) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,38,8740,0,100381,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 38) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,112,2890,0,306491,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 112) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,39,867,0,1064088,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 39) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,40,346,366,1,null,81328,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 40) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,41,5028,0,56553,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 41) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,42,9777,0,25097,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 42) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,43,5743,0,74620,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 43) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,111,9604,0,219351,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 111) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,44,1894,0,766086,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 44) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,97,7580,0,269432,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 97) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,45,14009,0,160880,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 45) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,46,19297,0,12020,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 46) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,273,7129,0,142228,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 273) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,275,6305,0,157252,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 275) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,47,5539,0,343290,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 47) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,48,4188,0,276231,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 48) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,110,4379,0,427685,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 110) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,109,12333,0,178286,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 109) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,49,829,860,1,null,167004,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 49) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,50,2867,0,371048,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 50) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,51,252,0,455513,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 51) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,52,3040,0,142381,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 52) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,274,7078,0,142228,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 274) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,53,1796,0,110734,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 53) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,108,2727,0,540116,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 108) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,54,2423,0,737069,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 54) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,107,1191,0,173778,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 107) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,55,2706,0,157738,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 55) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,56,882,0,235577,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 56) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,280,5579,0,95654,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 280) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-4,57832,0,12271,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -4) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,281,599,0,375351,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 281) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-6,2293,0,113181,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -6) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,83,41218,0,3069,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 83) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,105,1934,0,1103516,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 105) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,57,551,0,3374372,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 57) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,58,1062,0,116590,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 58) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,61,2654,0,50043,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 61) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,62,179,194,1,null,123957,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 62) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,63,155,169,1,null,22996,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 63) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,64,3252,3322,1,null,9533,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 64) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,65,733,761,1,null,7288,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 65) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,66,764,0,235292,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 66) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-5,4941,0,19032,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -5) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,67,309,0,102168,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 67) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,306,2199,2247,1,null,26042,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 306) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,300,2821,2882,1,null,10655,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 300) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,69,5476,5592,1,null,192015,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 69) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,70,1470,1522,1,null,8411,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 70) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,104,1286,1332,1,null,16026,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 104) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,68,4353,4446,1,null,7852,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 68) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,303,619,0,263847,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 303) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,304,483,509,1,null,36559,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 304) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,74,94,107,1,null,95489,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 74) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,75,12,16,1,null,12778,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 75) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,76,126,0,22740,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 76) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,77,35,41,1,null,50711,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 77) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,78,1291,1336,1,null,41456,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 78) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,80,1734,1794,1,null,13254,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 80) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) on duplicate key update Sell = Values(Sell), Buy = Values(Buy), Demand = Values(Demand), DemandLevel = Values(DemandLevel), Supply = Values(Supply), SupplyLevel = Values(SupplyLevel), Sources_id = Values(Sources_id), timestamp = Values(timestamp)>(master)
28.10.2016 21:43:49 : at IBE.SQL.DBConnector.Execute(String CommandText) in H:\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 349
at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2607
--------------------------------------------------------------------------------
28.10.2016 21:43:49 : Deadlock found when trying to get lock; try restarting transaction
28.10.2016 21:43:49 : at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at IBE.SQL.DBConnector.Execute(String CommandText) in H:\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 340
********************************************************************************
28.10.2016 22:57:07 : 28.10.2016 21:57:07 : Error in cmdEventLanded_Click
--------------------------------------------------------------------------------
28.10.2016 21:57:07 : Error while collecting market data from external tool
28.10.2016 21:57:07 : at IBE.IBECompanion.DataEventBase.ImportMarketData() in H:\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 108
at IBE.IBECompanion.CompanionData.RefreshAndImport() in H:\RN\ED-IBE\ED-IBE\IBECompanion\CompanionData.cs:line 630
--------------------------------------------------------------------------------
28.10.2016 21:57:07 : Error while importing prices from companion interface
28.10.2016 21:57:07 : at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2942
at IBE.IBECompanion.DataEventBase.ImportMarketData() in H:\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 97
--------------------------------------------------------------------------------
28.10.2016 21:57:07 : Error while importing self collected price data
28.10.2016 21:57:07 : at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2878
at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2938
--------------------------------------------------------------------------------
28.10.2016 21:57:07 : Error while importing prices
28.10.2016 21:57:07 : at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2646
at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2860
--------------------------------------------------------------------------------
28.10.2016 21:57:07 : Error on 'ExecuteNonQuery', SQLString = <insert into tbCommodityData(id, station_id, commodity_id, Sell, Buy,Demand, DemandLevel, Supply, SupplyLevel, Sources_id, timestamp) (select if(SC1.cnt = 0, 0, SC1.id),571,2,91,95,1,null,525167,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 2) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,277,749,0,196468,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 277) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,278,341,0,539230,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 278) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,4,110,123,1,null,20885,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 4) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,117,6678,0,6333,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 117) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,271,112,0,59772,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 271) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,5,369,0,131792,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 5) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,6,5724,5845,1,null,57918,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 6) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,7,475,0,14392,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 7) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,116,144,156,1,null,9852,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 116) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,307,290,306,1,null,4159,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 307) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,13,97,0,85470,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 13) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-1,1158,0,19939,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -1) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,15,1158,0,4985,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 15) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,16,363,0,55706,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 16) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,17,30,39,1,null,614577,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 17) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,18,284,0,17986,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 18) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,19,187,0,120045,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 19) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,20,99,110,1,null,578286,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 20) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,21,1314,0,18089,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 21) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-2,3188,0,289081,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -2) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,115,312,0,1146803,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 115) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,282,7541,0,140767,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 282) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,114,77828,0,40110,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 114) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,22,179,0,862801,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 22) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,23,1079,0,1310810,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 23) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,24,6096,0,100487,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 24) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,25,255,275,1,null,52596,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 25) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,119,694,720,1,null,11434,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 119) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,26,1707,1767,1,null,37253,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 26) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,288,1071,0,51475,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 288) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,293,522,0,110749,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 293) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,103,1224,1267,1,null,389788,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 103) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-3,450,0,43546,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -3) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,295,826,0,134596,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 295) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,28,91,103,1,null,290718,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 28) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,296,284,0,661893,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 296) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,27,3465,3539,1,null,22701,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 27) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,29,309,326,1,null,177819,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 29) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,289,320,0,486127,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 289) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,30,387,409,1,null,319203,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 30) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-7,1764,0,66507,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -7) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,102,578,600,1,null,4506,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 102) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,101,134,145,1,null,38460,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 101) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,31,270,0,19527,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 31) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,305,1078,0,24333,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 305) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,32,737,764,1,null,18907,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 32) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,33,183,199,1,null,55031,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 33) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,35,5430,5544,1,null,72560,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 35) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,36,6045,0,5711,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 36) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,37,327,0,842833,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 37) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,38,7979,0,289443,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 38) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,112,2507,0,645820,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 112) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,39,813,0,2951687,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 39) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,40,488,0,693468,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 40) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,41,5022,0,417217,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 41) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,42,9078,0,276336,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 42) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,43,5565,0,474680,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 43) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,111,8543,0,462204,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 111) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,44,1753,0,2136707,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 44) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,97,6678,0,847360,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 97) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,45,12508,0,506816,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 45) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,46,17244,0,37802,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 46) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,273,6274,0,447305,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 273) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,275,5539,0,494557,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 275) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,47,4887,0,784023,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 47) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,48,3988,0,1155070,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 48) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,110,3826,0,901193,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 110) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,109,11003,0,375673,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 109) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,49,967,0,313008,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 49) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,50,2761,0,1567307,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 50) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,274,6254,0,299694,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 274) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,108,2364,0,1086918,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 108) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,54,2096,0,1493688,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 54) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,280,4892,0,109748,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 280) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-4,51755,0,31565,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -4) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-6,1982,0,238489,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -6) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,83,36620,0,7893,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 83) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,105,1666,0,2011326,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 105) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,57,460,0,6890343,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 57) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,8,267,0,254898,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 8) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,9,731,0,9027,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 9) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,11,4302,0,9873,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 11) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,12,356,0,238950,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 12) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,61,2252,2302,1,null,24813,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 61) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,62,172,187,1,null,261177,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 62) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,63,150,163,1,null,48453,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 63) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,64,3377,0,37217,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 64) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,65,685,711,1,null,15360,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 65) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,66,664,0,545899,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 66) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-5,4325,0,40110,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -5) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,67,325,0,424215,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 67) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,306,2067,2112,1,null,54870,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 306) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,300,2709,2768,1,null,30771,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 300) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,69,4884,4987,1,null,352174,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 69) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,70,1806,0,110362,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 70) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,104,1224,1267,1,null,33766,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 104) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,68,3971,4056,1,null,16544,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 68) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,303,604,0,1136100,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 303) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,72,283,0,745042,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 72) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,73,543,0,2799152,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 73) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,74,257,0,1103433,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 74) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,75,12,17,1,null,23819,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 75) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,77,28,33,1,null,147369,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 77) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,78,1224,1267,1,null,96459,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 78) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,80,1571,1626,1,null,29966,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 80) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) on duplicate key update Sell = Values(Sell), Buy = Values(Buy), Demand = Values(Demand), DemandLevel = Values(DemandLevel), Supply = Values(Supply), SupplyLevel = Values(SupplyLevel), Sources_id = Values(Sources_id), timestamp = Values(timestamp)>(master)
28.10.2016 21:57:07 : at IBE.SQL.DBConnector.Execute(String CommandText) in H:\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 349
at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2607
--------------------------------------------------------------------------------
28.10.2016 21:57:07 : Deadlock found when trying to get lock; try restarting transaction
28.10.2016 21:57:07 : at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at IBE.SQL.DBConnector.Execute(String CommandText) in H:\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 340
********************************************************************************
01.01.2017 23:18:31 : 01.01.2017 23:18:31 : ED-IBE v0.5.7.0
01.01.2017 23:18:31 : Error while filtering stations
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : Error while refreshing current data view
01.01.2017 23:18:31 : at IBE.MTPriceAnalysis.tabPriceAnalysis.refreshPriceView(Boolean TabWasChanged) in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\tabPriceAnalysis.cs:line 404
at IBE.MTPriceAnalysis.tabPriceAnalysis.ActivateFilterSettings() in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\tabPriceAnalysis.cs:line 326
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : Error while starting to create a new baseview
01.01.2017 23:18:31 : at IBE.MTPriceAnalysis.tabPriceAnalysis.createNewBaseView() in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\tabPriceAnalysis.cs:line 740
at IBE.MTPriceAnalysis.tabPriceAnalysis.refreshPriceView(Boolean TabWasChanged) in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\tabPriceAnalysis.cs:line 347
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : Error while creating the base view
01.01.2017 23:18:31 : at IBE.MTPriceAnalysis.PriceAnalysis.createFilteredTable(Point3Dbl baseCoordinates, Object Distance, Object DistanceToStar, Object minLandingPadSize, enVisitedFilter VisitedFilter, Object locationType) in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\PriceAnalysis.cs:line 445
at IBE.MTPriceAnalysis.tabPriceAnalysis.createNewBaseView() in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\tabPriceAnalysis.cs:line 644
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : Error on 'ExecuteNonQuery', SQLString = <truncate table tmFilteredStations;>(master)
01.01.2017 23:18:31 : at IBE.SQL.DBConnector.Execute(String CommandText) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 353
at IBE.MTPriceAnalysis.PriceAnalysis.createFilteredTable(Point3Dbl baseCoordinates, Object Distance, Object DistanceToStar, Object minLandingPadSize, enVisitedFilter VisitedFilter, Object locationType) in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\PriceAnalysis.cs:line 308
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : Fatal error encountered during command execution.
01.01.2017 23:18:31 : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at IBE.SQL.DBConnector.Execute(String CommandText) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 346
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : Unable to write data to the transport connection: An established connection was aborted by the software in your host machine.
01.01.2017 23:18:31 : at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
at MySql.Data.Common.MyNetworkStream.Write(Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.TimedStream.Write(Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet)
at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute)
at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket queryPacket)
at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p)
at MySql.Data.MySqlClient.Statement.ExecuteNext()
at MySql.Data.MySqlClient.PreparableStatement.Execute()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : An established connection was aborted by the software in your host machine
01.01.2017 23:18:31 : at System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
********************************************************************************
04.01.2017 23:33:03 : 04.01.2017 23:33:03 : ED-IBE v0.5.8.1
04.01.2017 23:33:03 : Error in cmdEventLanded_Click
--------------------------------------------------------------------------------
04.01.2017 23:33:03 : Error while collecting market data from external tool
04.01.2017 23:33:03 : at IBE.IBECompanion.DataEventBase.ImportMarketData() in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 108
at IBE.IBECompanion.CompanionData.RefreshAndImport() in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\CompanionData.cs:line 629
--------------------------------------------------------------------------------
04.01.2017 23:33:03 : Error while importing prices from companion interface
04.01.2017 23:33:03 : at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3234
at IBE.IBECompanion.DataEventBase.ImportMarketData() in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 97
--------------------------------------------------------------------------------
04.01.2017 23:33:03 : Error while importing self collected price data
04.01.2017 23:33:03 : at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3170
at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3230
--------------------------------------------------------------------------------
04.01.2017 23:33:03 : Error while importing prices
04.01.2017 23:33:03 : at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2939
at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3152
--------------------------------------------------------------------------------
04.01.2017 23:33:03 : Error on 'ExecuteNonQuery', SQLString = <insert into tbCommodityData(id, station_id, commodity_id, Sell, Buy,Demand, DemandLevel, Supply, SupplyLevel, Sources_id, timestamp) (select if(SC1.cnt = 0, 0, SC1.id),16089,2,131,137,1,null,7930,0,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 2) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,271,287,0,2092,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 271) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,5,515,0,11430,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 5) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,6,7363,0,1570,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 6) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,7,782,0,3413,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 7) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,14,1387,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 14) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,15,1387,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 15) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,16,627,0,882,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 16) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,17,141,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 17) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,18,515,0,2858,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 18) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,19,380,0,19068,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 19) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,20,436,0,5536,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 20) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,21,1894,0,1437,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 21) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,22,557,0,423065,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 22) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,23,1418,0,381424,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 23) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,24,7578,0,11571,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 24) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,25,627,0,4409,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 25) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,30,982,0,60438,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 30) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,31,741,0,106419,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 31) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,305,1531,0,3495,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 305) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,33,315,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 33) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,42,9164,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 42) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,97,7503,0,652,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 97) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,45,13100,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 45) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,46,18259,0,30,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 46) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,47,4705,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 47) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,-4,56756,0,131,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = -4) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,8,343,0,8243,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 8) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,9,902,0,980,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 9) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,12,436,0,6129,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 12) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,63,465,0,26642,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 63) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,68,5473,0,34087,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 68) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,74,688,0,295538,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 74) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,75,17,23,1,null,7,0,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 75) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,78,2129,0,200,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 78) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,80,2526,0,541,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 80) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) on duplicate key update Sell = Values(Sell), Buy = Values(Buy), Demand = Values(Demand), DemandLevel = Values(DemandLevel), Supply = Values(Supply), SupplyLevel = Values(SupplyLevel), Sources_id = Values(Sources_id), timestamp = Values(timestamp)>(master)
04.01.2017 23:33:03 : at IBE.SQL.DBConnector.Execute(String CommandText) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 353
at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2900
--------------------------------------------------------------------------------
04.01.2017 23:33:03 : Cannot add or update a child row: a foreign key constraint fails (`elite_db`.`tbcommoditydata`, CONSTRAINT `fk_tbStations_has_tbCommodities_tbCommodities1` FOREIGN KEY (`commodity_id`) REFERENCES `tbcommodity` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
04.01.2017 23:33:03 : at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at IBE.SQL.DBConnector.Execute(String CommandText) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 346
********************************************************************************
04.01.2017 23:34:17 : 04.01.2017 23:34:17 : ED-IBE v0.5.8.1
04.01.2017 23:34:17 : Error in cmdEventLanded_Click
--------------------------------------------------------------------------------
04.01.2017 23:34:17 : Error while collecting market data from external tool
04.01.2017 23:34:17 : at IBE.IBECompanion.DataEventBase.ImportMarketData() in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 108
at IBE.IBECompanion.CompanionData.RefreshAndImport() in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\CompanionData.cs:line 629
--------------------------------------------------------------------------------
04.01.2017 23:34:17 : Error while importing prices from companion interface
04.01.2017 23:34:17 : at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3234
at IBE.IBECompanion.DataEventBase.ImportMarketData() in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 97
--------------------------------------------------------------------------------
04.01.2017 23:34:17 : Error while importing self collected price data
04.01.2017 23:34:17 : at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3170
at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3230
--------------------------------------------------------------------------------
04.01.2017 23:34:17 : Error while importing prices
04.01.2017 23:34:17 : at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2939
at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3152
--------------------------------------------------------------------------------
04.01.2017 23:34:17 : Error on 'ExecuteNonQuery', SQLString = <insert into tbCommodityData(id, station_id, commodity_id, Sell, Buy,Demand, DemandLevel, Supply, SupplyLevel, Sources_id, timestamp) (select if(SC1.cnt = 0, 0, SC1.id),16089,2,131,137,1,null,7930,0,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 2) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,271,287,0,2092,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 271) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,5,515,0,11430,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 5) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,6,7363,0,1570,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 6) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,7,782,0,3413,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 7) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,14,1387,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 14) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,15,1387,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 15) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,16,627,0,882,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 16) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,17,141,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 17) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,18,515,0,2858,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 18) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,19,380,0,19068,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 19) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,20,436,0,5536,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 20) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,21,1894,0,1437,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 21) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,22,557,0,423065,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 22) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,23,1418,0,381424,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 23) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,24,7578,0,11571,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 24) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,25,627,0,4409,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 25) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,30,982,0,60438,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 30) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,31,741,0,106419,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 31) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,305,1531,0,3495,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 305) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,33,315,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 33) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,42,9164,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 42) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,97,7503,0,652,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 97) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,45,13100,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 45) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,46,18259,0,30,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 46) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,47,4705,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 47) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,-4,56756,0,131,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = -4) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,8,343,0,8243,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 8) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,9,902,0,980,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 9) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,12,436,0,6129,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 12) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,63,465,0,26642,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 63) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,68,5473,0,34087,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 68) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,74,688,0,295538,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 74) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,75,17,23,1,null,7,0,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 75) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,78,2129,0,200,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 78) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,80,2526,0,541,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 80) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) on duplicate key update Sell = Values(Sell), Buy = Values(Buy), Demand = Values(Demand), DemandLevel = Values(DemandLevel), Supply = Values(Supply), SupplyLevel = Values(SupplyLevel), Sources_id = Values(Sources_id), timestamp = Values(timestamp)>(master)
04.01.2017 23:34:17 : at IBE.SQL.DBConnector.Execute(String CommandText) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 353
at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2900
--------------------------------------------------------------------------------
04.01.2017 23:34:17 : Cannot add or update a child row: a foreign key constraint fails (`elite_db`.`tbcommoditydata`, CONSTRAINT `fk_tbStations_has_tbCommodities_tbCommodities1` FOREIGN KEY (`commodity_id`) REFERENCES `tbcommodity` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
04.01.2017 23:34:17 : at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at IBE.SQL.DBConnector.Execute(String CommandText) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 346
********************************************************************************
--------------------------------------------------------------------------------
26.10.2016 15:51:53 : Object reference not set to an instance of an object.
26.10.2016 15:51:53 : at IBE.Condition.get_GameversionIsBeta() in E:\dev\RN\ED-IBE\ED-IBE\Condition.cs:line 239
at IBE.EDDN.EDDNCommunicator.SendCommodityData_i() in E:\dev\RN\ED-IBE\ED-IBE\EDDN\EDDNCommunicator.cs:line 1445
********************************************************************************
26.10.2016 16:51:53 : 26.10.2016 15:51:53 : Error in EDDN-Sending-Thread (outfitting)
--------------------------------------------------------------------------------
26.10.2016 15:51:53 : Object reference not set to an instance of an object.
26.10.2016 15:51:53 : at IBE.Condition.get_GameversionIsBeta() in E:\dev\RN\ED-IBE\ED-IBE\Condition.cs:line 239
at IBE.EDDN.EDDNCommunicator.SendOutfittingData_i() in E:\dev\RN\ED-IBE\ED-IBE\EDDN\EDDNCommunicator.cs:line 1349
********************************************************************************
26.10.2016 23:52:43 : 26.10.2016 22:52:43 : Error in cmdEventLanded_Click
--------------------------------------------------------------------------------
26.10.2016 22:52:43 : Object reference not set to an instance of an object.
26.10.2016 22:52:43 : at IBE.Condition.get_GameversionIsBeta() in E:\dev\RN\ED-IBE\ED-IBE\Condition.cs:line 239
at IBE.IBECompanion.CompanionData.RefreshAndImport(String systemName, String stationName) in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\CompanionData.cs:line 628
********************************************************************************
26.10.2016 23:53:33 : 26.10.2016 22:53:33 : Unhandled Exception
--------------------------------------------------------------------------------
26.10.2016 22:53:33 : InvalidArgument=Value of '0' is not valid for 'SelectedIndex'.
Parameter name: SelectedIndex
26.10.2016 22:53:33 : at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
at IBE.Form1.txtEventInfo_DropDownClosed(Object sender, EventArgs e) in E:\dev\RN\ED-IBE\ED-IBE\Form1.cs:line 3606
at System.Windows.Forms.ComboBox.OnDropDownClosed(EventArgs e)
at System.Windows.Forms.ComboBox.WmReflectCommand(Message& m)
at System.Windows.Forms.ComboBox.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
********************************************************************************
26.10.2016 23:53:58 : 26.10.2016 22:53:58 : Unhandled Exception
--------------------------------------------------------------------------------
26.10.2016 22:53:58 : Access to the path 'C:\ED-IBE\ed-ibe-dump-v0_5_0_dmp' is denied.
26.10.2016 22:53:58 : at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode)
at IBE.Program.CreateMiniDump(String Filename) in E:\dev\RN\ED-IBE\ED-IBE\Program.cs:line 168
at IBE.Program.HandleException(Exception ex) in E:\dev\RN\ED-IBE\ED-IBE\Program.cs:line 130
at System.Windows.Forms.Application.ThreadContext.OnThreadException(Exception t)
at System.Windows.Forms.Control.WndProcException(Exception e)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
********************************************************************************
26.10.2016 23:58:31 : 26.10.2016 22:58:31 : Error in cmdEventLanded_Click
--------------------------------------------------------------------------------
26.10.2016 22:58:31 : Object reference not set to an instance of an object.
26.10.2016 22:58:31 : at IBE.Condition.get_GameversionIsBeta() in E:\dev\RN\ED-IBE\ED-IBE\Condition.cs:line 239
at IBE.IBECompanion.CompanionData.RefreshAndImport(String systemName, String stationName) in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\CompanionData.cs:line 628
********************************************************************************
28.10.2016 22:43:49 : 28.10.2016 21:43:49 : Error in cmdEventLanded_Click
--------------------------------------------------------------------------------
28.10.2016 21:43:49 : Error while collecting market data from external tool
28.10.2016 21:43:49 : at IBE.IBECompanion.DataEventBase.ImportMarketData() in H:\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 108
at IBE.IBECompanion.CompanionData.RefreshAndImport() in H:\RN\ED-IBE\ED-IBE\IBECompanion\CompanionData.cs:line 630
--------------------------------------------------------------------------------
28.10.2016 21:43:49 : Error while importing prices from companion interface
28.10.2016 21:43:49 : at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2942
at IBE.IBECompanion.DataEventBase.ImportMarketData() in H:\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 97
--------------------------------------------------------------------------------
28.10.2016 21:43:49 : Error while importing self collected price data
28.10.2016 21:43:49 : at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2878
at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2938
--------------------------------------------------------------------------------
28.10.2016 21:43:49 : Error while importing prices
28.10.2016 21:43:49 : at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2646
at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2860
--------------------------------------------------------------------------------
28.10.2016 21:43:49 : Error on 'ExecuteNonQuery', SQLString = <insert into tbCommodityData(id, station_id, commodity_id, Sell, Buy,Demand, DemandLevel, Supply, SupplyLevel, Sources_id, timestamp) (select if(SC1.cnt = 0, 0, SC1.id),298,1,196,212,1,null,34400,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 1) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,2,97,102,1,null,207959,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 2) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,277,884,0,47326,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 277) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,278,126,141,1,null,7428,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 278) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,3,165,0,88985,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 3) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,4,113,127,1,null,9910,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 4) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,118,290,306,1,null,52334,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 118) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,117,7580,0,3006,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 117) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,271,124,0,18468,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 271) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,5,476,0,88749,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 5) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,7,527,0,11108,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 7) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,116,138,149,1,null,4675,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 116) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-1,1335,0,8381,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -1) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,15,1312,0,3190,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 15) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,16,403,0,57294,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 16) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,17,141,0,10251,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 17) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,18,338,0,38140,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 18) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,19,207,0,137949,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 19) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,20,95,106,1,null,242275,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 20) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,21,1512,0,7941,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 21) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-2,3659,0,100164,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -2) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,115,380,0,65107,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 115) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,282,8494,0,48946,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 282) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,114,88198,0,19032,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 114) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,22,58,71,1,null,136716,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 22) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,23,721,748,1,null,18507,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 23) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,24,6606,6746,1,null,51072,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 24) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-3,499,0,20659,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -3) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,295,973,0,63856,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 295) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,28,106,120,1,null,163599,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 28) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,296,348,0,314019,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 296) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,289,389,0,230631,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 289) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,30,527,0,18343,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 30) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-7,2045,0,31553,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -7) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,31,300,0,11582,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 31) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,305,980,1016,1,null,8225,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 305) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,32,790,819,1,null,8974,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 32) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,33,209,227,1,null,34557,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 33) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,35,6196,6327,1,null,25578,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 35) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,36,6357,6491,1,null,2462,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 36) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,37,221,239,1,null,232909,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 37) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,38,8740,0,100381,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 38) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,112,2890,0,306491,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 112) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,39,867,0,1064088,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 39) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,40,346,366,1,null,81328,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 40) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,41,5028,0,56553,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 41) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,42,9777,0,25097,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 42) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,43,5743,0,74620,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 43) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,111,9604,0,219351,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 111) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,44,1894,0,766086,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 44) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,97,7580,0,269432,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 97) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,45,14009,0,160880,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 45) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,46,19297,0,12020,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 46) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,273,7129,0,142228,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 273) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,275,6305,0,157252,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 275) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,47,5539,0,343290,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 47) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,48,4188,0,276231,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 48) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,110,4379,0,427685,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 110) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,109,12333,0,178286,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 109) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,49,829,860,1,null,167004,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 49) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,50,2867,0,371048,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 50) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,51,252,0,455513,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 51) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,52,3040,0,142381,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 52) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,274,7078,0,142228,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 274) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,53,1796,0,110734,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 53) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,108,2727,0,540116,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 108) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,54,2423,0,737069,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 54) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,107,1191,0,173778,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 107) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,55,2706,0,157738,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 55) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,56,882,0,235577,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 56) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,280,5579,0,95654,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 280) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-4,57832,0,12271,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -4) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,281,599,0,375351,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 281) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-6,2293,0,113181,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -6) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,83,41218,0,3069,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 83) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,105,1934,0,1103516,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 105) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,57,551,0,3374372,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 57) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,58,1062,0,116590,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 58) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,61,2654,0,50043,0,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 61) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,62,179,194,1,null,123957,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 62) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,63,155,169,1,null,22996,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 63) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,64,3252,3322,1,null,9533,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 64) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,65,733,761,1,null,7288,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 65) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,66,764,0,235292,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 66) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,-5,4941,0,19032,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = -5) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,67,309,0,102168,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 67) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,306,2199,2247,1,null,26042,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 306) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,300,2821,2882,1,null,10655,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 300) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,69,5476,5592,1,null,192015,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 69) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,70,1470,1522,1,null,8411,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 70) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,104,1286,1332,1,null,16026,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 104) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,68,4353,4446,1,null,7852,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 68) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,303,619,0,263847,1,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 303) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,304,483,509,1,null,36559,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 304) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,74,94,107,1,null,95489,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 74) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,75,12,16,1,null,12778,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 75) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,76,126,0,22740,2,0,null,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 76) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,77,35,41,1,null,50711,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 77) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,78,1291,1336,1,null,41456,2,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 78) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),298,80,1734,1794,1,null,13254,1,1,{ts '2016-10-28 22:43:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 298 and commodity_id = 80) SC1 where (SC1.timestamp < {ts '2016-10-28 22:43:00'}) or (SC1.timestamp is null)) on duplicate key update Sell = Values(Sell), Buy = Values(Buy), Demand = Values(Demand), DemandLevel = Values(DemandLevel), Supply = Values(Supply), SupplyLevel = Values(SupplyLevel), Sources_id = Values(Sources_id), timestamp = Values(timestamp)>(master)
28.10.2016 21:43:49 : at IBE.SQL.DBConnector.Execute(String CommandText) in H:\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 349
at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2607
--------------------------------------------------------------------------------
28.10.2016 21:43:49 : Deadlock found when trying to get lock; try restarting transaction
28.10.2016 21:43:49 : at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at IBE.SQL.DBConnector.Execute(String CommandText) in H:\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 340
********************************************************************************
28.10.2016 22:57:07 : 28.10.2016 21:57:07 : Error in cmdEventLanded_Click
--------------------------------------------------------------------------------
28.10.2016 21:57:07 : Error while collecting market data from external tool
28.10.2016 21:57:07 : at IBE.IBECompanion.DataEventBase.ImportMarketData() in H:\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 108
at IBE.IBECompanion.CompanionData.RefreshAndImport() in H:\RN\ED-IBE\ED-IBE\IBECompanion\CompanionData.cs:line 630
--------------------------------------------------------------------------------
28.10.2016 21:57:07 : Error while importing prices from companion interface
28.10.2016 21:57:07 : at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2942
at IBE.IBECompanion.DataEventBase.ImportMarketData() in H:\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 97
--------------------------------------------------------------------------------
28.10.2016 21:57:07 : Error while importing self collected price data
28.10.2016 21:57:07 : at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2878
at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2938
--------------------------------------------------------------------------------
28.10.2016 21:57:07 : Error while importing prices
28.10.2016 21:57:07 : at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2646
at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2860
--------------------------------------------------------------------------------
28.10.2016 21:57:07 : Error on 'ExecuteNonQuery', SQLString = <insert into tbCommodityData(id, station_id, commodity_id, Sell, Buy,Demand, DemandLevel, Supply, SupplyLevel, Sources_id, timestamp) (select if(SC1.cnt = 0, 0, SC1.id),571,2,91,95,1,null,525167,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 2) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,277,749,0,196468,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 277) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,278,341,0,539230,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 278) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,4,110,123,1,null,20885,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 4) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,117,6678,0,6333,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 117) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,271,112,0,59772,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 271) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,5,369,0,131792,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 5) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,6,5724,5845,1,null,57918,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 6) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,7,475,0,14392,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 7) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,116,144,156,1,null,9852,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 116) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,307,290,306,1,null,4159,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 307) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,13,97,0,85470,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 13) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-1,1158,0,19939,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -1) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,15,1158,0,4985,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 15) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,16,363,0,55706,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 16) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,17,30,39,1,null,614577,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 17) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,18,284,0,17986,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 18) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,19,187,0,120045,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 19) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,20,99,110,1,null,578286,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 20) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,21,1314,0,18089,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 21) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-2,3188,0,289081,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -2) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,115,312,0,1146803,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 115) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,282,7541,0,140767,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 282) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,114,77828,0,40110,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 114) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,22,179,0,862801,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 22) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,23,1079,0,1310810,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 23) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,24,6096,0,100487,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 24) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,25,255,275,1,null,52596,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 25) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,119,694,720,1,null,11434,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 119) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,26,1707,1767,1,null,37253,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 26) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,288,1071,0,51475,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 288) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,293,522,0,110749,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 293) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,103,1224,1267,1,null,389788,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 103) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-3,450,0,43546,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -3) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,295,826,0,134596,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 295) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,28,91,103,1,null,290718,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 28) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,296,284,0,661893,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 296) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,27,3465,3539,1,null,22701,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 27) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,29,309,326,1,null,177819,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 29) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,289,320,0,486127,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 289) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,30,387,409,1,null,319203,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 30) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-7,1764,0,66507,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -7) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,102,578,600,1,null,4506,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 102) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,101,134,145,1,null,38460,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 101) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,31,270,0,19527,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 31) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,305,1078,0,24333,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 305) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,32,737,764,1,null,18907,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 32) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,33,183,199,1,null,55031,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 33) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,35,5430,5544,1,null,72560,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 35) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,36,6045,0,5711,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 36) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,37,327,0,842833,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 37) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,38,7979,0,289443,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 38) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,112,2507,0,645820,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 112) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,39,813,0,2951687,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 39) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,40,488,0,693468,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 40) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,41,5022,0,417217,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 41) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,42,9078,0,276336,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 42) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,43,5565,0,474680,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 43) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,111,8543,0,462204,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 111) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,44,1753,0,2136707,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 44) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,97,6678,0,847360,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 97) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,45,12508,0,506816,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 45) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,46,17244,0,37802,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 46) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,273,6274,0,447305,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 273) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,275,5539,0,494557,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 275) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,47,4887,0,784023,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 47) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,48,3988,0,1155070,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 48) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,110,3826,0,901193,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 110) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,109,11003,0,375673,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 109) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,49,967,0,313008,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 49) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,50,2761,0,1567307,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 50) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,274,6254,0,299694,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 274) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,108,2364,0,1086918,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 108) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,54,2096,0,1493688,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 54) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,280,4892,0,109748,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 280) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-4,51755,0,31565,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -4) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-6,1982,0,238489,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -6) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,83,36620,0,7893,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 83) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,105,1666,0,2011326,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 105) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,57,460,0,6890343,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 57) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,8,267,0,254898,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 8) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,9,731,0,9027,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 9) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,11,4302,0,9873,0,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 11) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,12,356,0,238950,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 12) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,61,2252,2302,1,null,24813,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 61) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,62,172,187,1,null,261177,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 62) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,63,150,163,1,null,48453,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 63) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,64,3377,0,37217,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 64) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,65,685,711,1,null,15360,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 65) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,66,664,0,545899,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 66) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,-5,4325,0,40110,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = -5) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,67,325,0,424215,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 67) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,306,2067,2112,1,null,54870,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 306) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,300,2709,2768,1,null,30771,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 300) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,69,4884,4987,1,null,352174,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 69) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,70,1806,0,110362,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 70) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,104,1224,1267,1,null,33766,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 104) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,68,3971,4056,1,null,16544,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 68) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,303,604,0,1136100,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 303) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,72,283,0,745042,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 72) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,73,543,0,2799152,2,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 73) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,74,257,0,1103433,1,0,null,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 74) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,75,12,17,1,null,23819,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 75) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,77,28,33,1,null,147369,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 77) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,78,1224,1267,1,null,96459,2,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 78) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),571,80,1571,1626,1,null,29966,1,1,{ts '2016-10-28 22:57:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 571 and commodity_id = 80) SC1 where (SC1.timestamp < {ts '2016-10-28 22:57:00'}) or (SC1.timestamp is null)) on duplicate key update Sell = Values(Sell), Buy = Values(Buy), Demand = Values(Demand), DemandLevel = Values(DemandLevel), Supply = Values(Supply), SupplyLevel = Values(SupplyLevel), Sources_id = Values(Sources_id), timestamp = Values(timestamp)>(master)
28.10.2016 21:57:07 : at IBE.SQL.DBConnector.Execute(String CommandText) in H:\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 349
at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in H:\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2607
--------------------------------------------------------------------------------
28.10.2016 21:57:07 : Deadlock found when trying to get lock; try restarting transaction
28.10.2016 21:57:07 : at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at IBE.SQL.DBConnector.Execute(String CommandText) in H:\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 340
********************************************************************************
01.01.2017 23:18:31 : 01.01.2017 23:18:31 : ED-IBE v0.5.7.0
01.01.2017 23:18:31 : Error while filtering stations
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : Error while refreshing current data view
01.01.2017 23:18:31 : at IBE.MTPriceAnalysis.tabPriceAnalysis.refreshPriceView(Boolean TabWasChanged) in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\tabPriceAnalysis.cs:line 404
at IBE.MTPriceAnalysis.tabPriceAnalysis.ActivateFilterSettings() in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\tabPriceAnalysis.cs:line 326
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : Error while starting to create a new baseview
01.01.2017 23:18:31 : at IBE.MTPriceAnalysis.tabPriceAnalysis.createNewBaseView() in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\tabPriceAnalysis.cs:line 740
at IBE.MTPriceAnalysis.tabPriceAnalysis.refreshPriceView(Boolean TabWasChanged) in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\tabPriceAnalysis.cs:line 347
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : Error while creating the base view
01.01.2017 23:18:31 : at IBE.MTPriceAnalysis.PriceAnalysis.createFilteredTable(Point3Dbl baseCoordinates, Object Distance, Object DistanceToStar, Object minLandingPadSize, enVisitedFilter VisitedFilter, Object locationType) in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\PriceAnalysis.cs:line 445
at IBE.MTPriceAnalysis.tabPriceAnalysis.createNewBaseView() in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\tabPriceAnalysis.cs:line 644
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : Error on 'ExecuteNonQuery', SQLString = <truncate table tmFilteredStations;>(master)
01.01.2017 23:18:31 : at IBE.SQL.DBConnector.Execute(String CommandText) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 353
at IBE.MTPriceAnalysis.PriceAnalysis.createFilteredTable(Point3Dbl baseCoordinates, Object Distance, Object DistanceToStar, Object minLandingPadSize, enVisitedFilter VisitedFilter, Object locationType) in E:\dev\RN\ED-IBE\ED-IBE\MainTabs\PriceAnalysis.cs:line 308
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : Fatal error encountered during command execution.
01.01.2017 23:18:31 : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at IBE.SQL.DBConnector.Execute(String CommandText) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 346
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : Unable to write data to the transport connection: An established connection was aborted by the software in your host machine.
01.01.2017 23:18:31 : at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
at MySql.Data.Common.MyNetworkStream.Write(Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.TimedStream.Write(Byte[] buffer, Int32 offset, Int32 count)
at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet)
at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute)
at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket queryPacket)
at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p)
at MySql.Data.MySqlClient.Statement.ExecuteNext()
at MySql.Data.MySqlClient.PreparableStatement.Execute()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
--------------------------------------------------------------------------------
01.01.2017 23:18:31 : An established connection was aborted by the software in your host machine
01.01.2017 23:18:31 : at System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
********************************************************************************
04.01.2017 23:33:03 : 04.01.2017 23:33:03 : ED-IBE v0.5.8.1
04.01.2017 23:33:03 : Error in cmdEventLanded_Click
--------------------------------------------------------------------------------
04.01.2017 23:33:03 : Error while collecting market data from external tool
04.01.2017 23:33:03 : at IBE.IBECompanion.DataEventBase.ImportMarketData() in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 108
at IBE.IBECompanion.CompanionData.RefreshAndImport() in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\CompanionData.cs:line 629
--------------------------------------------------------------------------------
04.01.2017 23:33:03 : Error while importing prices from companion interface
04.01.2017 23:33:03 : at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3234
at IBE.IBECompanion.DataEventBase.ImportMarketData() in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 97
--------------------------------------------------------------------------------
04.01.2017 23:33:03 : Error while importing self collected price data
04.01.2017 23:33:03 : at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3170
at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3230
--------------------------------------------------------------------------------
04.01.2017 23:33:03 : Error while importing prices
04.01.2017 23:33:03 : at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2939
at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3152
--------------------------------------------------------------------------------
04.01.2017 23:33:03 : Error on 'ExecuteNonQuery', SQLString = <insert into tbCommodityData(id, station_id, commodity_id, Sell, Buy,Demand, DemandLevel, Supply, SupplyLevel, Sources_id, timestamp) (select if(SC1.cnt = 0, 0, SC1.id),16089,2,131,137,1,null,7930,0,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 2) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,271,287,0,2092,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 271) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,5,515,0,11430,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 5) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,6,7363,0,1570,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 6) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,7,782,0,3413,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 7) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,14,1387,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 14) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,15,1387,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 15) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,16,627,0,882,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 16) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,17,141,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 17) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,18,515,0,2858,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 18) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,19,380,0,19068,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 19) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,20,436,0,5536,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 20) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,21,1894,0,1437,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 21) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,22,557,0,423065,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 22) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,23,1418,0,381424,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 23) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,24,7578,0,11571,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 24) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,25,627,0,4409,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 25) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,30,982,0,60438,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 30) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,31,741,0,106419,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 31) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,305,1531,0,3495,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 305) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,33,315,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 33) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,42,9164,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 42) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,97,7503,0,652,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 97) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,45,13100,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 45) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,46,18259,0,30,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 46) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,47,4705,0,0,0,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 47) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,-4,56756,0,131,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = -4) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,8,343,0,8243,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 8) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,9,902,0,980,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 9) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,12,436,0,6129,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 12) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,63,465,0,26642,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 63) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,68,5473,0,34087,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 68) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,74,688,0,295538,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 74) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,75,17,23,1,null,7,0,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 75) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,78,2129,0,200,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 78) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,80,2526,0,541,2,0,null,1,{ts '2017-01-04 23:33:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 80) SC1 where (SC1.timestamp < {ts '2017-01-04 23:33:00'}) or (SC1.timestamp is null)) on duplicate key update Sell = Values(Sell), Buy = Values(Buy), Demand = Values(Demand), DemandLevel = Values(DemandLevel), Supply = Values(Supply), SupplyLevel = Values(SupplyLevel), Sources_id = Values(Sources_id), timestamp = Values(timestamp)>(master)
04.01.2017 23:33:03 : at IBE.SQL.DBConnector.Execute(String CommandText) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 353
at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2900
--------------------------------------------------------------------------------
04.01.2017 23:33:03 : Cannot add or update a child row: a foreign key constraint fails (`elite_db`.`tbcommoditydata`, CONSTRAINT `fk_tbStations_has_tbCommodities_tbCommodities1` FOREIGN KEY (`commodity_id`) REFERENCES `tbcommodity` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
04.01.2017 23:33:03 : at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at IBE.SQL.DBConnector.Execute(String CommandText) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 346
********************************************************************************
04.01.2017 23:34:17 : 04.01.2017 23:34:17 : ED-IBE v0.5.8.1
04.01.2017 23:34:17 : Error in cmdEventLanded_Click
--------------------------------------------------------------------------------
04.01.2017 23:34:17 : Error while collecting market data from external tool
04.01.2017 23:34:17 : at IBE.IBECompanion.DataEventBase.ImportMarketData() in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 108
at IBE.IBECompanion.CompanionData.RefreshAndImport() in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\CompanionData.cs:line 629
--------------------------------------------------------------------------------
04.01.2017 23:34:17 : Error while importing prices from companion interface
04.01.2017 23:34:17 : at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3234
at IBE.IBECompanion.DataEventBase.ImportMarketData() in E:\dev\RN\ED-IBE\ED-IBE\IBECompanion\DataEventBase.cs:line 97
--------------------------------------------------------------------------------
04.01.2017 23:34:17 : Error while importing self collected price data
04.01.2017 23:34:17 : at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3170
at IBE.SQL.EliteDBIO.ImportPrices(JObject companionData) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3230
--------------------------------------------------------------------------------
04.01.2017 23:34:17 : Error while importing prices
04.01.2017 23:34:17 : at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2939
at IBE.SQL.EliteDBIO.ImportPricesFromCSVStrings(String[] CSV_Strings, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 3152
--------------------------------------------------------------------------------
04.01.2017 23:34:17 : Error on 'ExecuteNonQuery', SQLString = <insert into tbCommodityData(id, station_id, commodity_id, Sell, Buy,Demand, DemandLevel, Supply, SupplyLevel, Sources_id, timestamp) (select if(SC1.cnt = 0, 0, SC1.id),16089,2,131,137,1,null,7930,0,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 2) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,271,287,0,2092,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 271) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,5,515,0,11430,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 5) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,6,7363,0,1570,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 6) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,7,782,0,3413,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 7) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,14,1387,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 14) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,15,1387,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 15) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,16,627,0,882,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 16) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,17,141,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 17) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,18,515,0,2858,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 18) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,19,380,0,19068,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 19) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,20,436,0,5536,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 20) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,21,1894,0,1437,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 21) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,22,557,0,423065,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 22) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,23,1418,0,381424,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 23) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,24,7578,0,11571,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 24) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,25,627,0,4409,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 25) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,30,982,0,60438,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 30) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,31,741,0,106419,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 31) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,305,1531,0,3495,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 305) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,33,315,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 33) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,42,9164,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 42) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,97,7503,0,652,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 97) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,45,13100,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 45) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,46,18259,0,30,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 46) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,47,4705,0,0,0,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 47) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,-4,56756,0,131,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = -4) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,8,343,0,8243,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 8) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,9,902,0,980,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 9) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,12,436,0,6129,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 12) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,63,465,0,26642,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 63) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,68,5473,0,34087,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 68) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,74,688,0,295538,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 74) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,75,17,23,1,null,7,0,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 75) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,78,2129,0,200,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 78) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) union all (select if(SC1.cnt = 0, 0, SC1.id),16089,80,2526,0,541,2,0,null,1,{ts '2017-01-04 23:34:00'} from (select ID, station_id, commodity_id, Count(*) As cnt, timestamp from tbCommodityData where station_id = 16089 and commodity_id = 80) SC1 where (SC1.timestamp < {ts '2017-01-04 23:34:00'}) or (SC1.timestamp is null)) on duplicate key update Sell = Values(Sell), Buy = Values(Buy), Demand = Values(Demand), DemandLevel = Values(DemandLevel), Supply = Values(Supply), SupplyLevel = Values(SupplyLevel), Sources_id = Values(Sources_id), timestamp = Values(timestamp)>(master)
04.01.2017 23:34:17 : at IBE.SQL.DBConnector.Execute(String CommandText) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 353
at IBE.SQL.EliteDBIO.ImportPrices(List`1 Stations, enImportBehaviour importBehaviour, enDataSource dataSource) in E:\dev\RN\ED-IBE\ED-IBE\SQL\EliteDBIO.cs:line 2900
--------------------------------------------------------------------------------
04.01.2017 23:34:17 : Cannot add or update a child row: a foreign key constraint fails (`elite_db`.`tbcommoditydata`, CONSTRAINT `fk_tbStations_has_tbCommodities_tbCommodities1` FOREIGN KEY (`commodity_id`) REFERENCES `tbcommodity` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
04.01.2017 23:34:17 : at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at IBE.SQL.DBConnector.Execute(String CommandText) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 346
********************************************************************************
Last edited:
