Discussion of article "How to Access the MySQL Database from MQL5 (MQL4)" - page 4

New comment
 
ingvar_e:

   Install of 32-bit M5 worked fine and compiling worked fine but I could not get the tickvalue by

  SymbolInfoDouble(pair,SYMBOL_TRADE_TICK_VALUE)

  returns 0;

  Maybe its not a good idea to run a 32 bit MT5 on a windows 64 bit machine. Have other indications too of malfunction. Next try is to install a windows 32 on my 64 bit computer.

 Always these long detours taken you a long way off yourmain course :-(

Seems like I have to give up on this tool and get down to basics with MySQL. To much hassle installing a new windows XP and have no W7 key

I'm working on this issue with service desk, hope to hear from any good news soon.

Regarding TICK_VALUE, I've had the same troubles too even in MT4. Here is workaround I'm using:

tick_value = 0;
while (tick_value<=0) { tick_value = SymbolInfoDouble(symbol, SYMBOL_TRADE_TICK_VALUE);}

 or

tick_value = SymbolInfoDouble(symbol, SYMBOL_TRADE_TICK_VALUE);
while (!MathIsValidNumber(tick_value))
      {
       Sleep(50);
       tick_value = SymbolInfoDouble(symbol, SYMBOL_TRADE_TICK_VALUE); 
      }
 
elugovoy:

I'm working on this issue with service desk, hope to hear from any good news soon.

Regarding TICK_VALUE, I've had the same troubles too even in MT4. Here is workaround I'm using:

 or

  I will try it  :-)

 Did not work. Stuck in loop.

 

I got an idea on the tick value problem. I am running a multicurrency EA and I start out  getting a lot of info for each pair. So it gets a bit like "hammering". I will change that so

that the tickvalue will only be asked for when needed. (and saved)

-   Updated  --

Not completely in the green. Have made the change above. Optimization still works. No error messages when starting EA.  OK will be when the EA has taken a trade ok. Have to wait.

This is running a 32 bit version of the EA in a Windows 7 64 bit environment. It will at least temporarely solve the problem if it works.

I only fetch the Tickvalue when the first order is on its way and save it.

 

OK, running an install of 32-version by appending "/32" to the MT5 installer works fine on a windows 7 64 bit computer and the mysql tool also works fine.

Back to basic design problems and testing with the EA,

 
mat.twg:

Thanks for the article! How many solutions have not tried everywhere the same thing, if you do not bother please look at the log, I can not understand anything....

MySQL server:

  • Server: localhost via TCP/IP
  • Server version: 5.6.10
  • Protocol version: 10
  • User: root@localhost
  • MySQL encoding: UTF-8 Unicode (utf8 )
  • InnoDB database, UTF8-General-Ci

MT5 build 1035

OS: Win8.1 x64

This is an MT5 build 1035, x64 error. Service Desk has been notified and they guarantee a fix in the next build.

The problem lies in the MQL programme accepting string values from a dynamic library.

In MT5 build 1035 x32, it works without this error.

 
ingvar_e:

OK, running an install of 32-version by appending "/32" to the MT5 installer works fine on a windows 7 64 bit computer and the mysql tool also works fine.

Back to basic design problems and testing with the EA,

Hello Ingvar,

The MetaQuotes service desk promised to fix it in next MT5 build.

So, we only have to wait release of next MT5 build.

 

Thanks 

 
elugovoy:

Hello Ingvar,

The MetaQuotes service desk promised to fix it in next MT5 build.

So, we only have to wait release of next MT5 build.

 

Thanks 

   Thanks for information elugovoy. In the meantime i run a 32 bit version. Installing with option /32. works fine.

  Nice piece of SW. Storing tradeparameters with a script from file and retrieve them in the EA. MySQL runs on my server so I

can retrieve parameters both on  EA running on another server and on local developing computers.

 

Hi again.

New build 1060 out. Have you tested if they fixd it? 

 
ingvar_e:

Hi again.

New build 1060 out. Have you tested if they fixd it? 

Yeah, it is worked fine now (have tested build 1062)
 

OK, I have tested 1060 now and it works ok too

Good, simplifies my testing. Get rid of 32-bits 

1234567891011...30
New comment