Bibliothèque: EAX_Mysql - MySQL library - Articles, commentaires de la bibliothèque - Forum de programmation MQL5

Matvey Alekseev 2015.01.04 03:09 #11

Ndaaaa...

Forum sur le trading, les systèmes de trading automatisés et les tests de stratégies de trading.

Bibliothèques : EAX_Mysql - Bibliothèque MySQL

EM 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 Violation d'accès à 0x00007FFD08F4C3DF lu à 0x00000000C8890D70 dans '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

Libraries: EAX_Mysql - mysql Discussion de l'article "Une Discussion of article "A

Thitikorn Jaksurak 2017.01.10 08:18 #12

J'ai trouvé l'erreur .

DS 2 14:14:56.980 DbTest01 (CHG,M5) 2015.01.01 00:00:00 Violation d'accès à 0x00007FFE02A4560E lu à 0x0000000088FE0C50 dans 'C:\Users\arnoAppData\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 :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 fichier journal "C:\sers\arno\AppData\Roaming\MetaQuotes\Tester\D0E8209F77C8CF37AD8BF550E51FF075\Agent-127.0.0.1-3000\logs\20170110.log" écrit

Libraries: EAX_Mysql - mysql Discussion de l'article "Une Discussion of article "A

Vladimir Zuikov 2017.08.12 22:03 #13

Matvey Alekseev:

Ndaaaa...

Cela peut être corrigé :

1. utiliser la version v. 5.7.17.0

2. l'erreur se produit parce que la version du système d'exploitation est 64-bit. Remplacer les variables int par des variables long aux endroits clés (je les ai changées partout dans EAX_Mysql.mqh), ainsi que dans les appels de mon programme

Libraries: EAX_Mysql - mysql Questions d'un "mannequin Comment surcharger Compare() dans

Vitaly Muzichenko 2017.08.12 23:38 #14

Vladimir Zuikov:

Ce problème peut être résolu :

1. utiliser la version v. 5.7.17.0

2. l'erreur se produit parce que la version du système d'exploitation est 64 bit. Remplacer les variables int par des variables long aux endroits clés (je les ai changées partout dans EAX_Mysql.mqh), ainsi que dans les appels de mon programme.

Pensez-vous qu'une personne n'a pas corrigé le code depuis 2,5 ans et qu'elle attend une réponse ?

najnudel 2019.12.15 23:19 #15

Bonjour à tous,

J'essaie d'exécuter un backtest ici et j'obtiens une erreur "Cannot call 'mysql_init', 'libmysql.dll' is not loaded".

Apparemment il n'arrive pas à charger le fichier DLL mais j'ai vérifié et il est bien là. Une idée ?

PS : J'ai coché la case Autoriser DLL dans les Options du terminal --> Expert Advisor

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...

Discussion de l'article "Comment Erreurs, bugs, questions Un système de trading

DavidSmith2018 2022.02.09 18:31 #16

La compilation ne réussit pas. Elle signale une erreur

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

tt2918789 2023.03.08 05:03 #17

DavidSmith2018 #:

La compilation ne réussit pas. Une erreur sera signalée.

'db' - token inattendu, probablement le type est manquant ? forTest2.mq5 10 1

attention !!!

Dossiers :

gmcb_20230308120239.png 14 kb

Hai Jun Yu 2023.10.30 15:58 #18

Merci pour votre code, il est très bon.

Zheng Yong Hong 2024.06.26 23:19 #19

Merci, Monsieur.

Andres Lume 2024.10.09 10:04 #20

2024. ne fonctionne pas. La première ligne 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\mtfusion\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.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 : 0x00000000000000000030 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 : 0x000000000000000000000002 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 : 0x0000000000579C0A 2024.10.09 10:03:08.08.085 ex1 (AUDUSD,H1)

Libraries: EAX_Mysql - mysql Access violation at 0x000000007FFF00D6 Econometrics - Prévisions à

Bibliothèque: EAX_Mysql - MySQL library - page 2