[Plugin] [REL] MySQL Plugin (Now on github!)

Still getting errors with the latest linux version. Works fine with R20.

Код:
undefined symbol: _ZNSt12out_of_rangeD2Ev
Reply

Are you sure that you updated the libboost_thread.a with that from R25?
Reply

R25 for linux hasn't been released, at least it wasn't in the project site 10 minutes ago.
Reply

https://code.******.com/p/sa-mp-mysq...ce/detail?r=25
Try R25 and tell us if it works or if there are still errors
Reply

http://realcop228.net/downloads/mysql.so

That's the non-static build of R25 compiled on CentOS 6. It doesn't work for me. Perhaps it'll work for someone else?

It seems to load the plugin, but the server crashes soon after.
Reply

Can you provide more informations, like from crashdetect lr mysql_log.txt?
Reply

Quote:
Originally Posted by Pain123
Посмотреть сообщение
Can you provide more informations, like from crashdetect lr mysql_log.txt?
I wish I could. The plugin loads and then the server crashes immediately. I even ran crashdetect and it didn't have time to print anything.
Reply

Same goes for me, there's no logs on it. It crashes the instant it tries to load the plugin.
Reply

Unfortunately, I also believe that the multithreading is causing random crashes still... I turned my server on and crashdetect printed this directly before any MySQL queries were sent.

Код:
[19:22:09] [debug] Server crashed while executing main.amx
[19:22:09] [debug] AMX backtrace:
[19:22:09] [debug] #0 native mysql_log () [7273a060] from mysql.DLL
[19:22:09] [debug] #1 0009f6c0 in public IRC_OnGameModeInit () from main.amx
[19:22:09] [debug] #2 native CallLocalFunction () [00471c30] from samp-server.exe
[19:22:09] [debug] #3 0001d0ec in public FC_OnGameModeInit () from main.amx
[19:22:09] [debug] #4 native CallLocalFunction () [00471c30] from samp-server.exe
[19:22:09] [debug] #5 0001bb04 in ?? () from main.amx
[19:22:09] [debug] #6 00011f8c in public zcmd_OnGameModeInit () from main.amx
[19:22:09] [debug] #7 native CallLocalFunction () [00471c30] from samp-server.exe
[19:22:09] [debug] #8 00011a48 in public Streamer_OnGameModeInit () from main.amx
[19:22:09] [debug] #9 native CallLocalFunction () [00471c30] from samp-server.exe
[19:22:09] [debug] #10 00011334 in ?? () from main.amx
[19:22:09] [debug] #11 0000b358 in public Itter_OnGameModeInit () from main.amx
[19:22:09] [debug] #12 native CallLocalFunction () [00471c30] from samp-server.exe
[19:22:09] [debug] #13 000081e4 in ?? () from main.amx
[19:22:09] [debug] #14 0000545c in public FIXES_OnGameModeInit () from main.amx
[19:22:09] [debug] #15 native CallLocalFunction () [00471c30] from samp-server.exe
[19:22:09] [debug] #16 00000d14 in public OnGameModeInit () from main.amx
[19:22:09] Incoming connection: 127.0.0.1:60387
[19:22:10] [debug] Native backtrace:
[19:22:10] [debug] #0 727412db in ?? () from C:\Infinitum Role Play\plugins\mysql.DLL
[19:22:10] [debug] #1 72744473 in ?? () from C:\Infinitum Role Play\plugins\mysql.DLL
[19:22:10] [debug] #2 69aef2e9 in ?? () from C:\Windows\SYSTEM32\MSVCR110.dll
[19:22:10] [debug] #3 69aef2cd in ?? () from C:\Windows\SYSTEM32\MSVCR110.dll
[19:22:10] [debug] #4 76381866 in ?? () from C:\Windows\system32\KERNEL32.DLL
[19:22:10] [debug] #5 76fe6911 in ?? () from C:\Windows\SYSTEM32\ntdll.dll
[19:22:10] [debug] #6 76fe68bd in ?? () from C:\Windows\SYSTEM32\ntdll.dll
I turned the server back on and it was OK. Then I restarted and it crashed, producing this code:

Код:
[19:25:27] [debug] Server crashed due to an unknown error
[19:25:27] [debug] Native backtrace:
[19:25:27] [debug] #0 0000006c in ?? () from C:\Infinitum Role Play\samp-server.exe
[19:25:27] [debug] #1 1001e7f2 in ?? () from C:\Infinitum Role Play\LIBMYSQL.dll
[19:25:27] [debug] #2 7273a4a0 in ?? () from C:\Infinitum Role Play\plugins\mysql.DLL
[19:25:27] [debug] #3 7273bbf3 in ?? () from C:\Infinitum Role Play\plugins\mysql.DLL
[19:25:27] [debug] #4 7273b8cd in ?? () from C:\Infinitum Role Play\plugins\mysql.DLL
[19:25:27] [debug] #5 72744473 in ?? () from C:\Infinitum Role Play\plugins\mysql.DLL
[19:25:27] [debug] #6 6669f2e9 in ?? () from C:\Windows\SYSTEM32\MSVCR110.dll
[19:25:27] [debug] #7 6669f2cd in ?? () from C:\Windows\SYSTEM32\MSVCR110.dll
[19:25:27] [debug] #8 76381866 in ?? () from C:\Windows\system32\KERNEL32.DLL
[19:25:27] [debug] #9 76fe6911 in ?? () from C:\Windows\SYSTEM32\ntdll.dll
[19:25:27] [debug] #10 76fe68bd in ?? () from C:\Windows\SYSTEM32\ntdll.dll
Reply

Quote:
Originally Posted by RealCop228
Посмотреть сообщение
I can do "DELETE * FROM `accounts`" and all of the rows in that table would be deleted. Or, I could do "DELETE FROM `accounts` WHERE `money` > 999999". I'm 99.99999998% positive that both of those queries would delete what I wanted them to.
Try it. "DELETE *" is not a valid statement. If you wish to delete all rows from one table, the right syntax is "DELETE FROM `table`".
Reply

Quote:
Originally Posted by RealCop228
Посмотреть сообщение
Unfortunately, I also believe that the multithreading is causing random crashes still... I turned my server on and crashdetect printed this directly before any MySQL queries were sent.

Код:
[19:22:09] [debug] Server crashed while executing main.amx
[19:22:09] [debug] AMX backtrace:
[19:22:09] [debug] #0 native mysql_log () [7273a060] from mysql.DLL
[19:22:09] [debug] #1 0009f6c0 in public IRC_OnGameModeInit () from main.amx
[19:22:09] [debug] #2 native CallLocalFunction () [00471c30] from samp-server.exe
[19:22:09] [debug] #3 0001d0ec in public FC_OnGameModeInit () from main.amx
[19:22:09] [debug] #4 native CallLocalFunction () [00471c30] from samp-server.exe
[19:22:09] [debug] #5 0001bb04 in ?? () from main.amx
[19:22:09] [debug] #6 00011f8c in public zcmd_OnGameModeInit () from main.amx
[19:22:09] [debug] #7 native CallLocalFunction () [00471c30] from samp-server.exe
[19:22:09] [debug] #8 00011a48 in public Streamer_OnGameModeInit () from main.amx
[19:22:09] [debug] #9 native CallLocalFunction () [00471c30] from samp-server.exe
[19:22:09] [debug] #10 00011334 in ?? () from main.amx
[19:22:09] [debug] #11 0000b358 in public Itter_OnGameModeInit () from main.amx
[19:22:09] [debug] #12 native CallLocalFunction () [00471c30] from samp-server.exe
[19:22:09] [debug] #13 000081e4 in ?? () from main.amx
[19:22:09] [debug] #14 0000545c in public FIXES_OnGameModeInit () from main.amx
[19:22:09] [debug] #15 native CallLocalFunction () [00471c30] from samp-server.exe
[19:22:09] [debug] #16 00000d14 in public OnGameModeInit () from main.amx
[19:22:09] Incoming connection: 127.0.0.1:60387
[19:22:10] [debug] Native backtrace:
[19:22:10] [debug] #0 727412db in ?? () from C:\Infinitum Role Play\plugins\mysql.DLL
[19:22:10] [debug] #1 72744473 in ?? () from C:\Infinitum Role Play\plugins\mysql.DLL
[19:22:10] [debug] #2 69aef2e9 in ?? () from C:\Windows\SYSTEM32\MSVCR110.dll
[19:22:10] [debug] #3 69aef2cd in ?? () from C:\Windows\SYSTEM32\MSVCR110.dll
[19:22:10] [debug] #4 76381866 in ?? () from C:\Windows\system32\KERNEL32.DLL
[19:22:10] [debug] #5 76fe6911 in ?? () from C:\Windows\SYSTEM32\ntdll.dll
[19:22:10] [debug] #6 76fe68bd in ?? () from C:\Windows\SYSTEM32\ntdll.dll
I turned the server back on and it was OK. Then I restarted and it crashed, producing this code:

Код:
[19:25:27] [debug] Server crashed due to an unknown error
[19:25:27] [debug] Native backtrace:
[19:25:27] [debug] #0 0000006c in ?? () from C:\Infinitum Role Play\samp-server.exe
[19:25:27] [debug] #1 1001e7f2 in ?? () from C:\Infinitum Role Play\LIBMYSQL.dll
[19:25:27] [debug] #2 7273a4a0 in ?? () from C:\Infinitum Role Play\plugins\mysql.DLL
[19:25:27] [debug] #3 7273bbf3 in ?? () from C:\Infinitum Role Play\plugins\mysql.DLL
[19:25:27] [debug] #4 7273b8cd in ?? () from C:\Infinitum Role Play\plugins\mysql.DLL
[19:25:27] [debug] #5 72744473 in ?? () from C:\Infinitum Role Play\plugins\mysql.DLL
[19:25:27] [debug] #6 6669f2e9 in ?? () from C:\Windows\SYSTEM32\MSVCR110.dll
[19:25:27] [debug] #7 6669f2cd in ?? () from C:\Windows\SYSTEM32\MSVCR110.dll
[19:25:27] [debug] #8 76381866 in ?? () from C:\Windows\system32\KERNEL32.DLL
[19:25:27] [debug] #9 76fe6911 in ?? () from C:\Windows\SYSTEM32\ntdll.dll
[19:25:27] [debug] #10 76fe68bd in ?? () from C:\Windows\SYSTEM32\ntdll.dll
If you copy the .pdb file to the server program's main folder you can get the functions names that cause the crash.


For those on linux getting the exception with out of range make sure that #include <stdexcept> is there, with windows it tends to auto include it with linux it has to be told to include it (haven't checked the code but I ran into this problem before with the CSTL plugin).
Reply

Quote:
Originally Posted by cyber_punk
Посмотреть сообщение
For those on linux getting the exception with out of range make sure that #include <stdexcept> is there, with windows it tends to auto include it with linux it has to be told to include it (haven't checked the code but I ran into this problem before with the CSTL plugin).
That isn't talking about this error "/usr/bin/ld: cannot find -lmysqlclient_r", right?
Reply

Quote:
Originally Posted by Chaprnks
Посмотреть сообщение
That isn't talking about this error "/usr/bin/ld: cannot find -lmysqlclient_r", right?
No this error.

Quote:
Originally Posted by Knappen
Посмотреть сообщение
Still getting errors with the latest linux version. Works fine with R20.

Код:
undefined symbol: _ZNSt12out_of_rangeD2Ev
Reply

thats just wierd r25 told me i loaded r24 i think its a typo.
Reply

Since this has become a ****** Code project, it's been rocketing through development.
Reply

It was supposed to be a joke
Reply

It's windows XP SP2, the plugin author has to fix that
Reply

He should update to SP2, maybe then it will work. I can't do anything against such errors.
Reply

It's SP3 and R24 don't give that error...
Reply

I didn't changed anything which could cause that error, maybe you did something?
Reply


Forum Jump:


Users browsing this thread: 7 Guest(s)