라이브러리: EAX_Mysql - MySQL library - 기고글, 라이브러리 코멘트 - MQL5 프로그래밍 포럼

Matvey Alekseev 2015.01.04 03:09 #11

Ndaaaa...

EM 2 04:58:14.300 tExp_a_1.0 (EURUSD.m,M15) 2015.01.01 00:00:00 0x00007FFD08F4C3DF에서 0x000000000000C8890D70으로 읽은 액세스 위반 '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 크래시 --> 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 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 치명적 오류

Libraries: EAX_Mysql - mysql Discussion of article "A 기고글 토론 "Named Pipes를

Thitikorn Jaksurak 2017.01.10 08:18 #12

오류를 발견했습니다 .

DS 2 14:14:56.980 DbTest01 (CHG,M5) 2015.01.01 00:00:00 0x00007FFE02A4560E에서 0x0000000088FE0C50을 읽음 'C:\사용자\아르노\앱데이터\로밍\메타쿼츠\테스터\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 크래시 --> 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 로그 파일 "C:\사용자\아르노\앱데이터\로밍\MetaQuotes\Tester\D0E8209F77C8CF37AD8BF550E51FF075\Agent-127.0.0.1-3000\logs\20170110.log" 작성되었습니다.

Libraries: EAX_Mysql - mysql Discussion of article "A 기고글 토론 "Named Pipes를

Vladimir Zuikov 2017.08.12 22:03 #13

Matvey Alekseev:

Ndaaaa...

고칠 수 있습니다:

1. dll 버전 v. 5.7.17.0

2. OS 버전이 64비트이기 때문에 오류가 발생합니다. 내 프로그램의 호출뿐만 아니라 주요 위치에서 int 변수를 긴 변수로 바꿉니다 (EAX_Mysql.mqh의 모든 곳에서 변경했습니다).

Vitaly Muzichenko 2017.08.12 23:38 #14

Vladimir Zuikov:

수정할 수 있습니다:

1. dll 버전 v. 5.7.17.0

2. OS 버전이 64 비트이기 때문에 오류가 발생합니다. 내 프로그램의 호출뿐만 아니라 주요 위치에서 int 변수를 긴 변수로 바꾸십시오 (EAX_Mysql.mqh의 모든 곳에서 변경했습니다).

2.5 년 동안 코드를 수정하지 않고 답변을 기다리고 있다고 생각하십니까?

najnudel 2019.12.15 23:19 #15

안녕하세요,

여기서 백 테스트를 실행하려고 하는데 "'mysql_init'을 호출 할 수 없습니다, 'libmysql.dll'이로드되지 않았습니다"라는 오류가 발생합니다.

분명히 DLL 파일을로드 할 수없는 것 같지만 확인해 보니 거기에 있습니다. 어떤 생각이 있으신가요?

추신 : 터미널 옵션 --> 전문가 조언자에서 DLL 허용을 선택했습니다.

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

DavidSmith2018 2022.02.09 18:31 #16

컴파일이 통과되지 않습니다. 오류를 보고합니다.

'db' - 예기치 않은 토큰, 아마도 유형이 누락되었을까요? forTest2.mq5 10 1

tt2918789 2023.03.08 05:03 #17

DavidSmith2018 #:

컴파일이 통과되지 않습니다. 오류가 보고됩니다.

'db' - 예기치 않은 토큰, 아마도 유형이 누락되었을까요? forTest2.mq5 10 1

조심!!!

파일:

gmcb_20230308120239.png 14 kb

Hai Jun Yu 2023.10.30 15:58 #18

코드 감사합니다, 매우 훌륭합니다.

Zheng Yong Hong 2024.06.26 23:19 #19

감사합니다.

Andres Lume 2024.10.09 10:04 #20

2024. 작동하지 않습니다. 64비트를 넣었습니다. 또한 첫 번째 줄 EAX_Mysql *db = new EAX_Mysql(); 총 오류 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 0x00007FF90F5E31A0에서 액세스 위반 'D:D:\_web\mt\fusion\MQL5\Libraries\libmysql.dll'에서 0x000000000000B3240CB0으로 읽기 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) 충돌 --> 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.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: 0x00000000000000579C0A 2024.10.09 10:03:08.08.085 ex1 (AUDUSD,H1)

Libraries: EAX_Mysql - mysql 계량경제학 EURUSD 1단계 예측 SQLite: MQL5로 SQL 데이터베이스의

라이브러리: EAX_Mysql - MySQL library - 페이지 2