资料库: EAX_Mysql - MySQL library - 页 2

 

Ndaaaa...

关于交易、自动交易系统和测试交易策略的论坛。

库: EAX_Mysql - MySQL 库


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
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 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] JQ
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
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 调用 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
 

我发现错误 .

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] 00:00:00 00007FFE02A455BC 488B052D684300 mov rax, [rip+0x43682d] QO
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] 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] 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 调用 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 测试仪 OnInit严重错误
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...


可以修复

1. 使用 dll 版本 v.5.7.17.0

2. 错误发生的原因是操作系统版本为 64 位。在关键位置用 long 变量替换 int 变量(我在 EAX_Mysql.mqh 中的所有地方都进行了更改),以及在我的程序中的调用中进行更改

 
Vladimir Zuikov:

可以解决这个问题:

1. 使用 dll 版本 v.5.7.17.0

2. 错误发生的原因是操作系统版本为 64 位。在关键位置将 int 变量替换为 long 变量(我在 EAX_Mysql.mqh 中的所有地方都进行了更改),以及在我的程序中的调用中替换为 long 变量。

您认为一个人 2.5 年未修改代码,是在等待答案吗?

 

嘿,伙计、

我正试图在这里运行一个回溯测试,结果发现一个错误:"无法调用'mysql_init','libmysql.dll'未加载"。

显然,他无法加载 DLL 文件,但我检查过了,它是存在的。有什么办法吗?

PS: 我在终端选项 --> 专家顾问中勾选了允许 DLL

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

编译不通过。会报错

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


 
DavidSmith2018 #:

编译不通过。会报错

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


watch out!!!

附加的文件:
 

Thank you for your code, it's very good

 
謝謝
 
不工作。第一行 EAX_Mysql *db = new EAX_Mysql(); Totalerror 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) Access violation at 0x00007FF90F5E31A0 read to 0x000000000000B3240CB0 in 'D:D:\_web\mt\fusion\MQL5\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) crash --> 00007FF90F5E31A0 4C3929 cmp [rcx], r13 2024.10.09 10:03:08.085 ex1 (AUDUSD,H1) crash --> 00007FF90F5E31A010.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.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.08.085 ex1 (AUDUSD,H1) 00007FF90F5E31B6 E969060000 jmp 0x00007FF90F5E3824 2024.10.09 10:03:08.08.085 ex1 (AUDUSD,H1) 00007FF90F5E31B6 E96906000010.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: 0x00000000000000579C0A 2024.10.09 10:03:08.08.085 ex1 (AUDUSD,H1)