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

[Plugin] [REL] MySQL Plugin (Now on github!) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: [Plugin] [REL] MySQL Plugin (Now on github!) (/showthread.php?tid=56564)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128

Re: [REL] MySQL Plugin R6-2 - ikkentim - 11.11.2011

Quote:

Originally Posted by robanswe

It's not an bug... Sa-mp is single thread so it can only do one thing at the time... So if mysql_query takes 20ms to execute it will stop the server for 20ms. The time it takes for mysql_query to execute depends on the mysql servers load and the ping to the mysql server. But yes using mysql_query_callback would fix that problem.

Thanks

Respuesta: [REL] MySQL Plugin R6-2 - Yue Rexie - 14.11.2011

Hello, if I have help. First of all do not speak English, and this is a big problem, so I use the ****** translator.

Well my question is whether Joomla! Server 1.7.11-Orion I used for testing on localhost, and how do I configure it, then try to throw a example and gives me error in an entry to start the server.

I appreciate the help possible.

Respuesta: [REL] MySQL Plugin R6-2 - Yue Rexie - 14.11.2011

Debug.txt

This means that if I connected to the database correctly?

Quote:

[13:36:35] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[13:36:35] CMySQLHandler::FreeResult() - The result is already empty.

[13:36:35] CMySQLHandler:

isconnect() - Connection was closed.

[13:36:38]

[13:36:38] ---------------------------

[13:36:38] MySQL Debugging activated (11/14/11)

[13:36:38] ---------------------------

[13:36:38]

[13:36:38] >> mysql_connect( )

[13:36:38] CMySQLHandler::CMySQLHandler() - constructor called.

[13:36:38] CMySQLHandler::CMySQLHandler() - Connecting to "127.0.0.1" | DB: "Joomla15" | Username: "root" ...

[13:36:38] CMySQLHandler::Connect() - Connection was successful.

[13:36:38] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

Re: [REL] MySQL Plugin R6-2 - hclj - 15.11.2011

mysql_format does not work with negative numbers?

Re: [REL] MySQL Plugin R6-2 - Walk_M4n - 20.11.2011

I have a problem with mysql_fetch_field_row (mysql_get_field). In all queries
when I try to use this function more than one time I get segmentation fault.
I've already found thread about the same problem, but there is no solution found.

OS: Ubuntu 10.10 x64 [also tried on Ubuntu 10.10 x32]
MySQL version: 5.1.54-1ubuntu4
Server version: 0.3d RC9
Plugin version: R6-2

Query:

Код:

SELECT `id`, `column1`, `column2` FROM `table` WHERE `column3`=0

PAWN code:

pawn Код:

mysql_query("SELECT `id`, `column1`, `column2` FROM `table` WHERE `column3`=0");
mysql_store_result();
while(mysql_retrieve_row())
{
    mysql_get_field("column1",tmp);
    if(strval(tmp) > 0)
    {
        mysql_get_field("id",tmp);      
        // some stuff       
        mysql_get_field("column2",tmp);
    }
}
mysql_free_result();

Debug.txt:

Код:

[10:28:54] ---------------------------
[10:28:54] MySQL Debugging activated (11/20/11)
[10:28:54] ---------------------------
[10:28:54]
[10:28:54] >> mysql_set_charset( Connection handle: 1 )
[10:28:54] >> mysql_query( Connection handle: 1 )
[10:28:54] CMySQLHandler::Query(SET NAMES 'cp1251') - Successfully executed.
[10:28:54] >> mysql_query( Connection handle: 1 )
[10:28:54] CMySQLHandler::Query(UPDATE `table2` SET `somecolumn` = 0) - Successfully executed.
[10:28:54] >> mysql_query( Connection handle: 1 )
[10:28:54] CMySQLHandler::Query(SELECT `id`, `column1`, `column2` FROM `table` WHERE `column3`=0) - Successfully executed.
[10:28:54] >> mysql_store_result( Connection handle: 1 )
[10:28:54] CMySQLHandler::StoreResult() - Result was stored.
[10:28:54] >> mysql_retrieve_row( Connection handle: 1 )
[10:28:54] >> mysql_fetch_field_row( Connection handle: 1 )
[10:28:54] CMySQLHandler::FetchField("column1") - 1309637542
[10:28:54] >> mysql_fetch_field_row( Connection handle: 1 )

There is nothing significant in server_log.txt. Server just crashes with message "Segmentation fault" in shell.

Does anyone know how to solve it? Thanks in advance.

P.S. Also tried to use mysql-client libraries from Mow's post, but it stills segfaulting.

Re: [REL] MySQL Plugin R6-2 - Alec24 - 22.11.2011

It appears that mysql_close crashes the server, I have used it under gamemodeexit.

Re: [REL] MySQL Plugin R6-2 - GhoulSlayeR - 23.11.2011

Quote:

Originally Posted by hclj

mysql_format does not work with negative numbers?

Yeah, I've reported it several months ago. Seems like it was never patched up.

AW: [REL] MySQL Plugin R6-2 - AirPlus - 23.11.2011

On my Linux server it donґt works.
On My Windows Server it Works?
Ubuntu 6

Re: [REL] MySQL Plugin R6-2 - Saurik - 27.11.2011

This crashes the server. I used another plugin by blue g and it worked fine. i got vps and im using the r-6 debian 5 plugin

code is here

Код:

if(strlen(params) == 0 || strlen(params) > 24) return IRC_GroupSay(gGroupID,IRC_ADMIN, "4 Enter a valid User..");
	new escname[200], msg[256], query[256];
    mysql_real_escape_string(params, escname);
    format(query, sizeof(query), "SELECT * FROM `bans` WHERE  `name` = '%s'  LIMIT 1 ", escname);
	mysql_query(query);
    mysql_store_result();
    if (mysql_num_rows() == 0) return IRC_GroupSay(gGroupID,IRC_ADMIN,"1 Sorry, This user is not found in bans list.");
    new banner[64], reason[256], bandate[64], index, line[50], buffer[149], banl[64], result[200];

    if (mysql_retrieve_row())
    {
        mysql_fetch_field_row(banner,"banner");
        mysql_fetch_field_row(reason,"reason");
        mysql_fetch_field_row(banl,"banlength");
        mysql_fetch_field_row(bandate,"bandate");
    }

//// REST NOT SHOWN (DOESN'T CAUSE CRASH)

Re: [REL] MySQL Plugin R6-2 - EleMenTalL - 28.11.2011

When i try to connect on my server and register an account , the server don`t show me the box where to write password etc....
Can someone give me a mysql dump without any user or a test user etc... please

What do to?

p.s at compile i don`t get any errors/warns

Re: [REL] MySQL Plugin R6-2 - kurta999 - 28.11.2011

Sorry, but please fix the mysql_ping() crash.

Thanks!

Код:

[2011/11/28 16:31:04] --- Crashdetect v3.6.6 loaded
[2011/11/28 16:31:04] Loaded debug info from 'filterscripts\*******.amx'
[2011/11/28 16:31:04] Loaded debug info from 'gamemodes\nmss.amx'
[2011/11/28 16:42:05] Server crash caused by native mysql_ping() called at line 36304 in 'C:\Program Files (x86)\Rockstar Games\GTA San Andreas\SERVER\gamemodes\nmss.pwn'
[2011/11/28 16:42:05] Call stack (most recent call first):
[2011/11/28 16:42:05]   File 'C:\Program Files (x86)\Rockstar Games\GTA San Andreas\SERVER\gamemodes\nmss.pwn', line 36289
[2011/11/28 16:42:05]     CallFlag()

Re: [REL] MySQL Plugin R6-2 - LEA - 28.11.2011

Same problem here!!! PLEASE FIX mysql_ping(). Server is crashing randomly.

Re: [REL] MySQL Plugin R6-2 - whitedragon - 28.11.2011

Quote:

Originally Posted by Saurik

This crashes the server. I used another plugin by blue g and it worked fine. i got vps and im using the r-6 debian 5 plugin

code is here

Код:

if(strlen(params) == 0 || strlen(params) > 24) return IRC_GroupSay(gGroupID,IRC_ADMIN, "4 Enter a valid User..");
	new escname[200], msg[256], query[256];
    mysql_real_escape_string(params, escname);
    format(query, sizeof(query), "SELECT * FROM `bans` WHERE  `name` = '%s'  LIMIT 1 ", escname);
	mysql_query(query);
    mysql_store_result();
    if (mysql_num_rows() == 0) return IRC_GroupSay(gGroupID,IRC_ADMIN,"1 Sorry, This user is not found in bans list.");
    new banner[64], reason[256], bandate[64], index, line[50], buffer[149], banl[64], result[200];

    if (mysql_retrieve_row())
    {
        mysql_fetch_field_row(banner,"banner");
        mysql_fetch_field_row(reason,"reason");
        mysql_fetch_field_row(banl,"banlength");
        mysql_fetch_field_row(bandate,"bandate");
    }

//// REST NOT SHOWN (DOESN'T CAUSE CRASH)

What Debug.txt say about that?

AW: [REL] MySQL Plugin R6-2 - Prio - 29.11.2011

Hey Guy's,

i didn't want to read through all the sites here so i don't know if someone had this problem before but when i try to compile my GM the compiler crashes without any error. Do you know why?

Prio

Re: AW: [REL] MySQL Plugin R6-2 - Nodroz - 29.11.2011

Quote:

Originally Posted by Prio

Hey Guy's,

i didn't want to read through all the sites here so i don't know if someone had this problem before but when i try to compile my GM the compiler crashes without any error. Do you know why?

Prio

This isn't the correct topic to post this...

I'm having trouble. I'd like to use this plugin on Debian 6.0, but there isn't a plugin for that yet. Is it possible to add this, or not ?

AW: [REL] MySQL Plugin R6-2 - Prio - 30.11.2011

Sure it is because the Mysql plugin is the reason.

Re: AW: [REL] MySQL Plugin R6-2 - Lenny the Cup - 30.11.2011

Quote:

Originally Posted by Prio

Sure it is because the Mysql plugin is the reason.

No, the plugin has nothing to do with your compiler. You've probably forgot to close something, check for missing { and }

AW: [REL] MySQL Plugin R6-2 - Mischi - 30.11.2011

i get the following error when i try to compile the plugin (OS: Debian 6, MySQL Version: 5.1.49-3):

samp@Debian-60-squeeze-64-minimal:~/gsql/mysql_rel$ make
gcc -c -O3 -w -DLINUX -Wall -I../SDK/amx/ ../SDK/amx/*.c
g++ -c -O3 -w -DLINUX -Wall -I../SDK/amx/ ../SDK/*.cpp
g++ -c -O3 -w -DLINUX -Wall -I../SDK/amx/ main.cpp
g++ -c -O3 -w -DLINUX -Wall -I../SDK/amx/ source/*.cpp
g++ -O2 -fshort-wchar -shared -o "../mysql.so" *.o -L/usr/lib/mysql -lmysqlclient_r -lpthread
/usr/bin/ld: CAmxString.o: relocation R_X86_64_32 against `.bss' can not be used when making a shared object; recompile with -fPIC
CAmxString.o: could not read symbols: Bad value
collect2: ld returned 1 exit status
make: *** [all] Error 1

Re: AW: [REL] MySQL Plugin R6-2 - whitedragon - 01.12.2011

Quote:

Originally Posted by Mischi

i get the following error when i try to compile the plugin (OS: Debian 6, MySQL Version: 5.1.49-3):

samp@Debian-60-squeeze-64-minimal:~/gsql/mysql_rel$ make
gcc -c -O3 -w -DLINUX -Wall -I../SDK/amx/ ../SDK/amx/*.c
g++ -c -O3 -w -DLINUX -Wall -I../SDK/amx/ ../SDK/*.cpp
g++ -c -O3 -w -DLINUX -Wall -I../SDK/amx/ main.cpp
g++ -c -O3 -w -DLINUX -Wall -I../SDK/amx/ source/*.cpp
g++ -O2 -fshort-wchar -shared -o "../mysql.so" *.o -L/usr/lib/mysql -lmysqlclient_r -lpthread
/usr/bin/ld: CAmxString.o: relocation R_X86_64_32 against `.bss' can not be used when making a shared object; recompile with -fPIC
CAmxString.o: could not read symbols: Bad value
collect2: ld returned 1 exit status
make: *** [all] Error 1

You use 64 bit Debian 6.0 ? You need to compile with 32 bit system

Re: [REL] MySQL Plugin R6-2 - xxmitsu - 01.12.2011

Try if anything from here is useful: http://www.egaming.ro/MySQL/