Libraries: EAX_Mysql - mysql library - page 2

New comment
 

Ndaaaa...

Forum on trading, automated trading systems and testing trading strategies.

Libraries: EAX_Mysql - MySQL library


EM 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 Access violation at 0x00007FFD08F4C3DF read to 0x000000000000C8890D70 in 'C:\Users\matAppData\Roaming\MetaQuotes\Tester\...\Agent-127.0.0.1-3000\MQL5\Libraries\libmysql.dll'

OD 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C360 4053 push rbx
QD 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C362 55 push rbp
ME 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C363 56 push rsi
DD 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C364 57 push rdi
QD 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C365 4155 push r13
EG 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C367 4156 push r14
EG 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C369 4157 push r15
DI 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C36B 4881EC90020000 sub rsp, 0x290
NI 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C372 488B0547893C00 mov rax, [rip+0x3c8947]
HJ 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C379 4833C4 xor rax, rsp
IH 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 01 00:00:00 00 00007FFD08F4C37C 4889842470020000 mov [rsp+0x270], rax
QP 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C384 4C8BBC2400030000 mov r15, [rsp+0x300]
JQ 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C38C 488BAC24F0020000 mov rbp, [rsp+0x2f0]
IL 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C394 4533F6 xor r14d, r14d
RQ 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C397 498BF9 mov rdi, r9
IN 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C39A 4C898C24C0000000 mov [rsp+0xc0], r9
PF 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3A2 498BF0 mov rsi, r8
PG 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3A5 4889AC24C8000000 mov [rsp+0xc8], rbp
HE 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3AD 4C897C2478 mov [rsp+0x78], r15
IH 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3B2 4C897C2468 mov [rsp+0x68], r15
OS 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3B7 4C898424D0000000 mov [rsp+0xd0], r8
FR 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3BF 4C8BEA mov r13, rdx
RM 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3C2 4889542470 mov [rsp+0x70], rdx
OS 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3C7 488BD9 mov rbx, rcx
MM 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3CA 4889542460 mov [rsp+0x60], rdx
NL 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3CF 4489B42488000000 mov [rsp+0x88], r14d
OG 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3D7 4C89B42480000000 mov [rsp+0x80], r14
NF 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 crash --> 00007FFD08F4C3DF 4C3931 cmp [rcx], r14
CJ 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3E2 7418 jz 0x7ffd08f4c3fc
QJ 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00
MR 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3E4 4C8B05A58C3C00 mov r8, [rip+0x3c8ca5]
RF 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3EB BA0A080000 mov edx, 0x80a
RE 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3F0 E8EBC5FFFF call 0x7ffd08f489e0 ; mysql_get_server_version (libmysql.dll)
IP 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3F5 33C0 xor eax, eax
PQ 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 00 00007FFD08F4C3F7 E99C0F0000 jmp 0x7ffd08f4d398
CO 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 01 00:00:00
KG 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00
IN 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01.01 00:00:00 00 00: 0x00007FFD08F4C3DF
IL 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01.01 00:00:00
OF 2 04:58:14.300 Tester OnInit critical error
 

I found error  .

DS 2 14:14:56.980 DbTest01 (CHG,M5) 2015.01.01 00:00:00   Access violation at 0x00007FFE02A4560E read to 0x0000000088FE0C50 in 'C:\Users\arno\AppData\Roaming\MetaQuotes\Tester\D0E8209F77C8CF37AD8BF550E51FF075\Agent-127.0.0.1-3000\MQL5\Libraries\libmysql.dll'
DL 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455A0 4055              push       rbp
FO 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455A2 53                push       rbx
LO 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455A3 56                push       rsi
EO 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455A4 57                push       rdi
PP 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455A5 4154              push       r12
HP 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455A7 4155              push       r13
DQ 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455A9 4156              push       r14
CN 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455AB 4157              push       r15
GP 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455AD 488DAC2478FEFFFF  lea        rbp, [rsp-0x188]
MN 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455B5 4881EC88020000    sub        rsp, 0x288
DP 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455BC 488B052D684300    mov        rax, [rip+0x43682d]
QO 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455C3 4833C4            xor        rax, rsp
OR 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455C6 48898570010000    mov        [rbp+0x170], rax
PM 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455CD 4C8BAD00020000    mov        r13, [rbp+0x200]
NR 2 14:14:56.989 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455D4 488BB5F0010000    mov        rsi, [rbp+0x1f0]
QN 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455DB 4533FF            xor        r15d, r15d
HM 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455DE 498BF9            mov        rdi, r9
GR 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455E1 4C894DB8          mov        [rbp-0x48], r9
MS 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455E5 4D8BE0            mov        r12, r8
LP 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455E8 488975C0          mov        [rbp-0x40], rsi
IG 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455EC 4C896C2470        mov        [rsp+0x70], r13
HI 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455F1 4C896C2468        mov        [rsp+0x68], r13
RE 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455F6 4C8945C8          mov        [rbp-0x38], r8
CJ 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455FA 4C8BF2            mov        r14, rdx
RD 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A455FD 488BD9            mov        rbx, rcx
ME 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A45600 4889542460        mov        [rsp+0x60], rdx
OG 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A45605 44897C2478        mov        [rsp+0x78], r15d
QK 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A4560A 4C897DB0          mov        [rbp-0x50], r15
HH 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00      crash -->  00007FFE02A4560E 4C3939            cmp        [rcx], r15
RJ 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A45611 7416              jz         0x7ffe02a45629
GG 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00   
NN 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A45613 4C8B052E694300    mov        r8, [rip+0x43692e]
MM 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A4561A BA0A080000        mov        edx, 0x80a
RR 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A4561F E86CC0FFFF        call       0x7ffe02a41690  ; mysql_session_track_get_next (libmysql.dll)
QI 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A45624 E914070000        jmp        0x7ffe02a45d3d
HH 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00   
KN 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00                 00007FFE02A45629 488D5510          lea        rdx, [rbp+0x10]
MP 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00   
PI 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00   00: 0x00007FFE02A4560E
IH 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00   01: 0x0000000000040018
IL 2 14:14:56.990 DbTest01 (CHG,M5) 2015.01.01 00:00:00   
QI 2 14:14:56.990 Tester OnInit critical error
FQ 0 14:14:56.991 Tester log file "C:\Users\arno\AppData\Roaming\MetaQuotes\Tester\D0E8209F77C8CF37AD8BF550E51FF075\Agent-127.0.0.1-3000\logs\20170110.log" written

 
Matvey Alekseev:

Ndaaaa...


It can be fixed:

1. use dll version v. 5.7.17.0

2. The error occurs because the OS version is 64-bit. Replace int variables with long ones in key places (I changed them everywhere in EAX_Mysql.mqh), as well as in calls in my programme

 
Vladimir Zuikov:

It can be fixed:

1. use dll version v. 5.7.17.0

2. the error occurs because the OS version is 64 bit. Replace int variables with long ones in key places (I changed them everywhere in EAX_Mysql.mqh), as well as in calls in my programme

Do you think that a person has not fixed the code for 2.5 years and is waiting for an answer?

 

Hey man,

I am trying to run a backtest here and I get an error "Cannot call 'mysql_init', 'libmysql.dll' is not loaded".

Apparently he is not being able to load the DLL file but I checked and it is there. Any idea?

PS: I have the Allow DLL checked in the Terminal Options --> Expert Advisor

Testing trading strategies on real ticks
Testing trading strategies on real ticks
  • www.mql5.com
The article provides the results of testing a simple trading strategy in three modes: "1 minute OHLC" using only Open, High, Low and Close prices of minute bars; detailed modeling in "Every tick" mode, as well as the most accurate "Every tick based on real ticks" mode applying actual historical data. Comparing the results allows us to assess...
 

The compilation does not pass. It will report an error

'db' - unexpected token, probably type is missing? forTest2.mq5 10 1


 
DavidSmith2018 #:

The compilation does not pass. An error will be reported.

'db' - unexpected token, probably type is missing? forTest2.mq5 10 1


watch out!!!

Files:
gmcb_20230308120239.png  14 kb
 

Thank you for your code, it's very good

 
Thank you, sir.
 
2024. does not work. libmysql put 64 bits. Also the first line EAX_Mysql *db = new EAX_Mysql(); Total error 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) Access violation at 0x00007FF90F5E31A0 read to 0x000000000000B3240CB0 in 'D:D:\_web\mt\fusion\MQL5\Libraries\libmysql.dll' 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) crash --> 00007FF90F5E31A0 4C3929 cmp [rcx], r13 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 00007FF90F5E31A3 7416 jz 0x00007FF90F5E31BB 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 00007FF90F5E31A5 4C8B0594DD0F00 mov r8, [0x00007FF90F90F6E0F40] 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 00007FF90F5E31AC BA0A080000 mov edx, 0x80A 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 00007FF90F5E31B1 E85AB4FFFF call 0x00007FF90F5DE610 2024.10.09 10:03:08.08.085 ex1 (AUDUSD,H1) 00007FF90F5E31B6 E969060000 jmp 0x00007FF90F5E3824 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 00007FF90F5E31BB 488D55E0 lea rdx, [rbp-0x20] 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 00007FF90F5E31BF 41B854010000 mov r8d, 0x154 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 00007FF90F5E31C5 E866F3FF call 0x00007FF90F5E2530 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 00007FF90F5E31CA 85C0 test eax, eax 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 00007FF90F5E31CC 0F8552060000 jnz 0x00007FF90F5E3824 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 2024.10.09 10:03:08.08 085 ex1 (AUDUSD,H1) 00007FF90F5E31D2 488D0537DF0F00 lea rax, [0x00007FF90F6E1110] 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 00007FF90F5E31D9 4C892B mov [rbx], r13 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 00: 0x00007FF90F5E31A0 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 01: 0x000002AFB32245E8 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 02: 0x000000000000000000000030 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 03: 0x00007FF723595C57 2024.10.09 10:03:08:08.085 ex1 (AUDUSD,H1) 04: 0x000000007FF7000000000000 2024.10.09 10:03:08.08.085 ex1 (AUDUSD,H1) 05: 0x000002AFC3202450 2024.10.09 10:03:08.08.085 ex1 (AUDUSD,H1) 06: 0x000002AFCAFBBAB8 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 07: 0x000002AFC335D200 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 08: 0x000002AFB3221B41 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 09: 0x000002AFB322D100 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 10: 0x0000007FF7233092F6 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 11: 0x000002AFC3802480 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 12: 0x0000000000000000000000000002 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 13: 0x000002AFB08A40D0 2024.10.09 10:03:08.08 ex1 (AUDUSD,H1) 14: 0x000002AFB09D0000 2024.10.09 10:03:08.08.085 ex1 (AUDUSD,H1) 15: 0x000002AFCAFBAFD0 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 16: 0x00000000000000579C0A 2024.10.09 10:03:08.08.085 ex1 (AUDUSD,H1)
123
New comment