Problem to store data from Ninjatrader in Mysql

[bascher]

Hallo,

I have some problems to store the data in Mysql:

MyInsertQuery:

string myInsertQuery = String.Format("Insert INTO data1 (date, time, lastprice, volume) Values({0}, {1}, {2}, {3})", now_date_marketlast, now_time_marketlast, e.Price, e.Volume);

My table in Mysql:

CREATE TABLE `data1` ( `id_tick` int(16) NOT NULL auto_increment, `date` varchar(8) NOT NULL, `time` varchar(17) NOT NULL, `lastprice` float NOT NULL, `volume` int(8) NOT NULL, PRIMARY KEY (`id_tick`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

Output in Ninjatrader:

Insert Into data1 (date, time, lastprice, volume) Values(20111018, 1509312430, 1,3724, 4646000)
Error on calling 'OnMarketData' method for indicator 'NinjatraderMysql': Column count doesn´t match value count at row 1

Best regards
Benjamin

[NinjaTrader_Brett]

Hello,

Thanks for the forum post.

Unfortunately this is outside the level of support we are able to provide. I will leave this ticket open in the chance that someone else is able to answer.

Let me know if I can be of further assistance.