SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Plugin Development

Reply
 
Thread Tools Display Modes
Old 11/01/2018, 12:35 PM   #6131
Meller
Banned
 
Join Date: Dec 2016
Posts: 638
Reputation: 132
Default Re: [REL] MySQL Plugin (Now on github!)

Where can I find the documentary of R39-6?
Meller is offline   Reply With Quote
Old 11/01/2018, 04:32 PM   #6132
maddinat0r
Gangsta
 
maddinat0r's Avatar
 
Join Date: Jun 2010
Location: Germany
Posts: 894
Reputation: 479
Default Re: [REL] MySQL Plugin (Now on github!)

Quote:
Originally Posted by Meller View Post
Where can I find the documentary of R39-6?
http://wiki.sa-mp.com/wiki/MySQL/R33
maddinat0r is offline   Reply With Quote
Old 18/01/2018, 05:28 PM   #6133
Adiiti
Big Clucker
 
Adiiti's Avatar
 
Join Date: Apr 2017
Location: Funchal, Madeira, Portugal
Posts: 161
Reputation: 9
Default Re: [REL] MySQL Plugin (Now on github!)

Where are download of CentOS 7 static file
Adiiti is offline   Reply With Quote
Old 23/01/2018, 04:08 PM   #6134
Irenijus
Little Clucker
 
Join Date: Jul 2013
Posts: 37
Reputation: 2
Default Re: [REL] MySQL Plugin (Now on github!)

I have problem every time with lost connection. Please analyze my debug i dont have idea whats...:
mysql.log

[23/01/2018 02:12:04] [ERROR] error #2013 while executing query "SELECT * FROM accounts WHERE prazaista >'0'": Lost connection to MySQL server during query
[23/01/2018 02:12:04] [DEBUG] CConnection::GetError(this=0xb43ca008, connection=0xa208360)
[23/01/2018 02:12:04] [DEBUG] CCallback::Create(amx=0xa1a9398, name='OnQueryError', format='dsssd)
[23/01/2018 02:12:04] [DEBUG] CCallback::Create - callback index for 'OnQueryError': -10049
[23/01/2018 02:12:04] [DEBUG] processing specifier 'd'
[23/01/2018 02:12:04] [DEBUG] retrieved and pushed value '2013'
[23/01/2018 02:12:04] [DEBUG] processing specifier 's'
[23/01/2018 02:12:04] [DEBUG] retrieved and pushed value 'Lost connection to MySQL server during query'
[23/01/2018 02:12:04] [DEBUG] processing specifier 's'
[23/01/2018 02:12:04] [DEBUG] retrieved and pushed value 'DeleteDataPlayerTimeInServer24'
[23/01/2018 02:12:04] [DEBUG] processing specifier 's'
[23/01/2018 02:12:04] [DEBUG] retrieved and pushed value 'SELECT * FROM accounts WHERE prazaista >'0''
[23/01/2018 02:12:04] [DEBUG] processing specifier 'd'
[23/01/2018 02:12:04] [DEBUG] retrieved and pushed value '1'
[23/01/2018 02:12:04] [INFO] Callback 'OnQueryError' set up for delayed execution.
[23/01/2018 02:12:04] [DEBUG] created delayed callback with 5 parameters
[23/01/2018 02:12:04] [DEBUG] CCallback::Execute(amx=0xa1a9398, index=-10049, num_params=5)

Serverlog

[23/01/2018 02:12:04] [debug] Server crashed due to an unknown error
[23/01/2018 02:12:04] [debug] Native backtrace:
[23/01/2018 02:12:04] [debug] #0 b7417180 in _Z13GetStackTraceRSt6vectorI10StackFrameSaIS0_EEPv () from plugins/crashdetect.so
[23/01/2018 02:12:04] [debug] #1 b740f064 in _ZN11CrashDetect20PrintNativeBacktraceERSoRKN2os7C ontextE () from plugins/crashdetect.so
[23/01/2018 02:12:04] [debug] #2 b740fd64 in _ZN11CrashDetect20PrintNativeBacktraceERKN2os7Cont extE () from plugins/crashdetect.so
[23/01/2018 02:12:04] [debug] #3 b7411cdb in _ZN11CrashDetect7OnCrashERKN2os7ContextE () from plugins/crashdetect.so
[23/01/2018 02:12:04] [debug] #4 b74164d5 in ?? () from plugins/crashdetect.so
[23/01/2018 02:12:04] [debug] #5 b778f600 in ?? ()
[23/01/2018 02:12:04] [debug] #6 b74cd448 in ?? () from /lib/libc.so.6
[23/01/2018 02:12:04] [debug] #7 0809571b in ?? () from ./samp03svr
[23/01/2018 02:12:04] [debug] #8 b72b17cf in ?? () from plugins/mysql.so
[23/01/2018 02:12:04] [debug] #9 b72dc843 in ?? () from plugins/mysql.so
[23/01/2018 02:12:04] [debug] #10 b72c43a4 in ?? () from plugins/mysql.so
[23/01/2018 02:12:04] [debug] #11 bfa02140 in ?? () from €łs(sֽ
[23/01/2018 02:12:04] [debug] ֽ
[23/01/2018 02:12:04] [debug] ŻŲ
[23/01/2018 02:12:04] [debug] ֽ
[23/01/2018 02:12:04] [debug] Ł
[23/01/2018 02:12:04] [debug] Ś
[23/01/2018 02:12:04] [debug] t
[23/01/2018 02:12:04] [debug] Registers:
[23/01/2018 02:12:04] [debug] EAX: bfa01dc0 EBX: b446c008 ECX: 3855c186 EDX: bfa01dc0
[23/01/2018 02:12:04] [debug] ESI: ffffd8bf EDI: 00000008 EBP: bfa01cc8 ESP: bfa01c9c
[23/01/2018 02:12:04] [debug] EIP: b74cd448 EFLAGS: 00000a13
[23/01/2018 02:12:04] [debug] Stack:
[23/01/2018 02:12:04] [debug] ESP+00000000: 0809571b bfa01dc0 3855c186 bfa01fe8
[23/01/2018 02:12:04] [debug] ESP+00000020: b7305000 09dbfca8 00000001 bfa01fe8
[23/01/2018 02:12:04] [debug] ESP+00000040: b7305000 09dbfca8 00000000 b7305000
[23/01/2018 02:12:04] [debug] ESP+00000060: 00000000 00000000 00000020 00000005
[23/01/2018 02:12:04] [debug] ESP+00000080: b76a8c17 0abf3978 00000008 0000000b
[23/01/2018 02:12:04] [debug] ESP+000000a0: b770dc64 00000037 00000035 00000000
[23/01/2018 02:12:04] [debug] ESP+000000c0: b7741000 0a2da9f8 081a199c 0a2da9fc
[23/01/2018 02:12:04] [debug] ESP+000000e0: b74b4c65 0a2b3204 09d9a594 b7741000
[23/01/2018 02:12:04] [debug] ESP+00000100: b72a6000 0000032d 00000000 bfa01dc0
[23/01/2018 02:12:04] [debug] ESP+00000120: b74b5fff 0a1a9398 0a27c67c bfa01dee
[23/01/2018 02:12:04] [debug] ESP+00000140: b74b5fff 00000000 bfa01e70 00000010
[23/01/2018 02:12:04] [debug] ESP+00000160: b74b4c65 00000001 00000000 00000018
[23/01/2018 02:12:04] [debug] ESP+00000180: b7305000 00000001 b75fc420 00000000
[23/01/2018 02:12:04] [debug] ESP+000001a0: 0a2824e0 00000000 bfa01e94 bfa01e88
[23/01/2018 02:12:04] [debug] ESP+000001c0: 0a27ee80 0a28c4c8 0a2a4ae0 bfa01fe8
[23/01/2018 02:12:04] [debug] ESP+000001e0: b76a6a6f 00000000 bfa01e88 b7305000
[23/01/2018 02:12:04] [debug] ESP+00000200: b76a6a6f 00000000 0a28c4cc b72b9319
[23/01/2018 02:12:04] [debug] ESP+00000220: b72b290b 0a27ee80 b7304440 b72f0b14
[23/01/2018 02:12:04] [debug] ESP+00000240: 00000005 0abf3960 0abf3978 bfa01f80
[23/01/2018 02:12:04] [debug] ESP+00000260: 00000000 ffffd8bf 00000000 bfa02028
[23/01/2018 02:12:04] [debug] ESP+00000280: b74105a4 bfa02040 00000000 0077c22c
[23/01/2018 02:12:04] [debug] ESP+000002a0: 09d94da8 0a2bf0f4 00000015 0abee0d8
[23/01/2018 02:12:04] [debug] ESP+000002c0: b743bff4 0a1a9398 bfa01f9c 0a1a9410
[23/01/2018 02:12:04] [debug] ESP+000002e0: bfa01f9c 0a2b5d18 0a27ee80 bfa0201c
[23/01/2018 02:12:04] [debug] ESP+00000300: b75fc000 b72f3ef0 00000063 00000008
[23/01/2018 02:12:04] [debug] ESP+00000320: b74b8468 b7741000 00000015 09d93170
[23/01/2018 02:12:04] [debug] ESP+00000340: b7305000 b0201314 bfa02040 bfa02068
[23/01/2018 02:12:04] [debug] ESP+00000360: b72f3d26 b72f3d25 000007dd b0201314
[23/01/2018 02:12:04] [debug] ESP+00000380: b76a6a6f 00000000 00000001 0a1a9398
[23/01/2018 02:12:04] [debug] ESP+000003a0: b770de0b 0abf3970 0abf3960 00000009
[23/01/2018 02:12:04] [debug] ESP+000003c0: b7305000 081a1990 b0201314 bfa020e0
[23/01/2018 02:12:04] [debug] ESP+000003e0: 09d931c8 00000000 b73f67d4 bfa02158
[23/01/2018 02:12:04] [debug] Loaded modules:
[23/01/2018 02:12:04] [debug] 00000000 - 00187dc3 samp03svr
[23/01/2018 02:12:04] [debug] b7791000 - b7791704
[23/01/2018 02:12:04] [debug] b7764000 - b77666ec /lib/libdl.so.2
[23/01/2018 02:12:04] [debug] b7749000 - b7762b47 /lib/libpthread.so.0
[23/01/2018 02:12:04] [debug] b765e000 - b774fc10 /lib/libstdc++.so.6
[23/01/2018 02:12:04] [debug] b761c000 - b765d138 /lib/libm.so.6
[23/01/2018 02:12:04] [debug] b7600000 - b7619718 /lib/libgcc_s.so.1
[23/01/2018 02:12:04] [debug] b7440000 - b76075f7 /lib/libc.so.6
[23/01/2018 02:12:04] [debug] b776e000 - b7790720 /lib/ld-linux.so.2
[23/01/2018 02:12:04] [debug] b73f9000 - b743bac4 plugins/crashdetect.so
[23/01/2018 02:12:04] [debug] b7323000 - b73f97f0 plugins/streamer.so
[23/01/2018 02:12:04] [debug] b7316000 - b731cc0c /lib/librt.so.1
[23/01/2018 02:12:04] [debug] b7306000 - b73151d4 plugins/sscanf.so
[23/01/2018 02:12:04] [debug] b72a7000 - b7305aec plugins/mysql.so
[23/01/2018 02:12:04] [debug] b7284000 - b72a5108 /root/Samp/samp03/plugins/../log-core.so
[23/01/2018 02:12:04] [debug] b6e72000 - b7285e9f /root/Samp/samp03/plugins/../libmysqlclient.so.18
[23/01/2018 02:12:04] [debug] b645e000 - b646f680 /lib/libnss_files.so.2
[23/01/2018 02:12:04] [debug] b63da000 - b645d8d8 plugins/audio.so
[23/01/2018 02:12:04] [debug] b4465000 - b4469cb8 /lib/libnss_dns.so.2
[23/01/2018 02:12:04] [debug] b444b000 - b4463704 /lib/libresolv.so.2

errorlog

[23/01/2018 02:12:04] [plugins/mysql] error #2013 while executing query "SELECT * FROM accounts WHERE prazaista >'0'": Lost connection to MySQL server during query
[23/01/2018 02:12:04] [log-core] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: 1, exit status: 1042316592)
Irenijus is offline   Reply With Quote
Old 23/01/2018, 11:19 PM   #6135
DobbysGamertag
Gangsta
 
DobbysGamertag's Avatar
 
Join Date: Jan 2013
Location: England
Posts: 809
Reputation: 100
Default Re: [REL] MySQL Plugin (Now on github!)

What gave you the idea to change most, if not ALL function names? It's incredibly time consuming when i have to look at the wiki, or through the include just to find out the syntax.

Code:
cache_get_query_exec_time(UNIT_MILLISECONDS)

That threw an error, even though it is on the wiki (R40). When in fact it is:

Code:
cache_get_query_exec_time(MILLISECONDS)

I wonder what else you'll change.
DobbysGamertag is offline   Reply With Quote
Old 10/03/2018, 01:49 AM   #6136
Winnie
Little Clucker
 
Join Date: May 2014
Posts: 1
Reputation: 0
Default Re: [REL] MySQL Plugin (Now on github!)

Link broken...
Winnie is offline   Reply With Quote
Old 10/03/2018, 02:23 AM   #6137
Jeroen52
Gangsta
 
Jeroen52's Avatar
 
Join Date: Oct 2008
Location: The Netherlands
Posts: 867
Reputation: 71
Default Re: [REL] MySQL Plugin (Now on github!)

Quote:
Originally Posted by Winnie View Post
Link broken...
Are you sure you're using the correct download link?

Remember to NOT use R7, try to use a modern version.
__________________
Jeroen52 is offline   Reply With Quote
Old 17/03/2018, 04:18 PM   #6138
Moras
Little Clucker
 
Join Date: May 2011
Posts: 24
Reputation: 0
Default Re: [REL] MySQL Plugin (Now on github!)

Code:
-- Version: 4.1.0
-- Build type: Release
-- Performing Test HAVE_STD_CPP11_FLAG
-- Performing Test HAVE_STD_CPP11_FLAG - Success
-- Performing Test FMT_CPP11_CMATH
-- Performing Test FMT_CPP11_CMATH - Success
-- Performing Test FMT_CPP11_UNISTD_H
-- Performing Test FMT_CPP11_UNISTD_H - Failed
-- Performing Test FMT_CPP11_SNPRINTF
-- Performing Test FMT_CPP11_SNPRINTF - Success
-- Performing Test HAVE_STD_GNUPP11_FLAG
-- Performing Test HAVE_STD_GNUPP11_FLAG - Failed
-- Performing Test SUPPORTS_VARIADIC_TEMPLATES
-- Performing Test SUPPORTS_VARIADIC_TEMPLATES - Success
-- Performing Test SUPPORTS_INITIALIZER_LIST
-- Performing Test SUPPORTS_INITIALIZER_LIST - Success
-- Performing Test SUPPORTS_ENUM_BASE
-- Performing Test SUPPORTS_ENUM_BASE - Success
-- Performing Test SUPPORTS_TYPE_TRAITS
-- Performing Test SUPPORTS_TYPE_TRAITS - Success
-- Performing Test SUPPORTS_USER_DEFINED_LITERALS
-- Performing Test SUPPORTS_USER_DEFINED_LITERALS - Success
-- Looking for open
-- Looking for open - found
CMake Error at CMakeLists.txt:33 (find_package):
  Could not find a package configuration file provided by "log-core" with any
  of the following names:
    log-coreConfig.cmake
    log-core-config.cmake
  Add the installation prefix of "log-core" to CMAKE_PREFIX_PATH or set
  "log-core_DIR" to a directory containing one of the above files.  If
  "log-core" provides a separate development package or SDK, be sure it has
  been installed.
Build Error. Is there any solution to the problem?
Moras is offline   Reply With Quote
Old 17/03/2018, 07:43 PM   #6139
Jeroen52
Gangsta
 
Jeroen52's Avatar
 
Join Date: Oct 2008
Location: The Netherlands
Posts: 867
Reputation: 71
Default Re: [REL] MySQL Plugin (Now on github!)

Quote:
Originally Posted by Moras View Post
Code:
-- Version: 4.1.0
-- Build type: Release
-- Performing Test HAVE_STD_CPP11_FLAG
-- Performing Test HAVE_STD_CPP11_FLAG - Success
-- Performing Test FMT_CPP11_CMATH
-- Performing Test FMT_CPP11_CMATH - Success
-- Performing Test FMT_CPP11_UNISTD_H
-- Performing Test FMT_CPP11_UNISTD_H - Failed
-- Performing Test FMT_CPP11_SNPRINTF
-- Performing Test FMT_CPP11_SNPRINTF - Success
-- Performing Test HAVE_STD_GNUPP11_FLAG
-- Performing Test HAVE_STD_GNUPP11_FLAG - Failed
-- Performing Test SUPPORTS_VARIADIC_TEMPLATES
-- Performing Test SUPPORTS_VARIADIC_TEMPLATES - Success
-- Performing Test SUPPORTS_INITIALIZER_LIST
-- Performing Test SUPPORTS_INITIALIZER_LIST - Success
-- Performing Test SUPPORTS_ENUM_BASE
-- Performing Test SUPPORTS_ENUM_BASE - Success
-- Performing Test SUPPORTS_TYPE_TRAITS
-- Performing Test SUPPORTS_TYPE_TRAITS - Success
-- Performing Test SUPPORTS_USER_DEFINED_LITERALS
-- Performing Test SUPPORTS_USER_DEFINED_LITERALS - Success
-- Looking for open
-- Looking for open - found
CMake Error at CMakeLists.txt:33 (find_package):
  Could not find a package configuration file provided by "log-core" with any
  of the following names:
    log-coreConfig.cmake
    log-core-config.cmake
  Add the installation prefix of "log-core" to CMAKE_PREFIX_PATH or set
  "log-core_DIR" to a directory containing one of the above files.  If
  "log-core" provides a separate development package or SDK, be sure it has
  been installed.
Build Error. Is there any solution to the problem?
You need to have log-core available.
__________________
Jeroen52 is offline   Reply With Quote
Old 18/03/2018, 10:36 AM   #6140
Moras
Little Clucker
 
Join Date: May 2011
Posts: 24
Reputation: 0
Default Re: [REL] MySQL Plugin (Now on github!)

Quote:
Originally Posted by Jeroen52 View Post
You need to have log-core available.
https://travis-ci.org/pBlueG/SA-MP-M...352727069#L736
Moras is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
****** Project: Glass int3s0 Everything and Nothing 99 26/02/2013 04:22 PM
MySQL Plugin R5 plugin problem dud Scripting Help 12 05/12/2011 06:28 PM
Strikens Mysql vs BlueG's Mysql plugin PrawkC Scripting Help 4 30/09/2011 10:30 AM
[help][plugin] Can't load mysql plugin mariomako Help Archive 8 16/07/2011 02:37 PM
mysql plugin. loading plugin failed ikkentim Help Archive 2 10/02/2011 02:32 PM


All times are GMT. The time now is 12:30 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.