Bibliotecas: EAX_Mysql - MySQL library - página 2

 

Ndaaaa...

Fórum sobre negociação, sistemas de negociação automatizados e teste de estratégias de negociação.

Bibliotecas: EAX_Mysql - Biblioteca MySQL


EM 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 Violação de acesso em 0x00007FFD08F4C3DF lido em 0x000000000000C8890D70 em '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 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 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 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 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
 

Encontrei um erro.

DS 2 14:14:56.980 DbTest01 (CHG,M5) 2015.01.01 00:00:00 Violação de acesso em 0x00007FFE02A4560E lido para 0x0000000088FE0C50 em '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: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 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 Erro crítico OnInit
FQ 0 14:14:56.991 Testador arquivo de registro "C:\Users\arno\AppData\Roaming\MetaQuotes\Tester\D0E8209F77C8CF37AD8BF550E51FF075\Agent-127.0.0.1-3000\logs\20170110.log" escrito

 
Matvey Alekseev:

Ndaaaa...


Isso pode ser corrigido:

1. use a versão da dll v. 5.7.17.0

2. o erro ocorre porque a versão do sistema operacional é de 64 bits. Substitua as variáveis int por variáveis long em locais importantes (eu as alterei em todos os lugares no EAX_Mysql.mqh), bem como nas chamadas do meu programa

 
Vladimir Zuikov:

Isso pode ser corrigido:

1. usar a versão da dll v. 5.7.17.0

2. o erro ocorre porque a versão do sistema operacional é de 64 bits. Substitua as variáveis int por variáveis long em lugares importantes (eu as mudei em todos os lugares no EAX_Mysql.mqh), bem como nas chamadas do meu programa

Você acha que uma pessoa não corrigiu o código por 2,5 anos e está esperando uma resposta?

 

Olá,

Estou tentando executar um backtest aqui e recebo um erro "Cannot call 'mysql_init', 'libmysql.dll' is not loaded".

Aparentemente, ele não está conseguindo carregar o arquivo DLL, mas eu verifiquei e ele está lá. Alguma ideia?

PS: Tenho a opção Allow DLL marcada nas Opções do Terminal --> 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...
 

A compilação não é aprovada. Ele relatará um erro

'db' - token inesperado, provavelmente o tipo está faltando? forTest2.mq5 10 1


 
DavidSmith2018 #:

A compilação não é aprovada. Um erro será relatado.

'db' - token inesperado, provavelmente o tipo está faltando? forTest2.mq5 10 1


cuidado!!!

Arquivos anexados:
 

Obrigado por seu código, ele é muito bom

 
Obrigado, senhor.
 
2024. não funciona. A libmysql colocou 64 bits. Também a primeira linha EAX_Mysql *db = new EAX_Mysql(); Erro total 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) Violação de acesso em 0x00007FF90F5E31A0 lido para 0x000000000000B3240CB0 em '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: 0x0000000000000000000000000030 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 03: 0x00007FF723595C57 2024.10.09 10:03:08:08.085 ex1 (AUDUSD,H1) 04: 0x000000007FF70000000000000000 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)