[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 (Now on github!) - Gigi-The-Beast - 14.05.2014

Hey maddinator.
What would be the easiest way to debug this problem?

Код:

[11:10:08] [ERROR] mysql_escape_string - destination size is too small (must be at least as big as source)

I am expiriencing it only on my live server and I use mysql_escape_string alot in my gamemode.
Any suggestions before I need to do line by line debugging? ( I am a bit lazy )

Re: [REL] MySQL Plugin (Now on github!) - iZN - 14.05.2014

Quote:

Originally Posted by Gigi-The-Beast

Hey maddinator.
What would be the easiest way to debug this problem?

Код:

[11:10:08] [ERROR] mysql_escape_string - destination size is too small (must be at least as big as source)

I am expiriencing it only on my live server and I use mysql_escape_string alot in my gamemode.
Any suggestions before I need to do line by line debugging? ( I am a bit lazy )

Use mysql_format instead or just change the destination size of mysql_escape_string to higher values or you can just remove the last parameter as it's already getting the destination size so you won't need to insert the size always.

pawn Код:

native mysql_escape_string(const source[], destination[], connectionHandle = 1, max_len = sizeof(destination));

Re: [REL] MySQL Plugin (Now on github!) - Gigi-The-Beast - 14.05.2014

I know that, it just prints the error for one use of function, I use it like 500 times in my gm. I asked if there is a debug level that would show some more information so I could easily find the line that causes the issue.

Re: [REL] MySQL Plugin (Now on github!) - iZN - 14.05.2014

Quote:

Originally Posted by Gigi-The-Beast

I know that, it just prints the error for one use of function, I use it like 500 times in my gm. I asked if there is a debug level that would show some more information so I could easily find the line that causes the issue.

Can't you CTRL + F and write mysql_escape_string to find them and change their destination size.

Re: [REL] MySQL Plugin (Now on github!) - Gigi-The-Beast - 14.05.2014

The problem is not with every one of them. Anyway thanks for your help, I'll just debug one by one.

Re: [REL] MySQL Plugin (Now on github!) - B-Matt - 14.05.2014

Quote:

Originally Posted by Gigi-The-Beast

The problem is not with every one of them. Anyway thanks for your help, I'll just debug one by one.

There is no easier way to find that error. Maybe you should try with using mysql_log(LOG_ALL). Query will be printed before the error so you will be able to see where the error is.

Re: [REL] MySQL Plugin (Now on github!) - Gigi-The-Beast - 14.05.2014

Hey B-Matt, that is what I was looking for, I didn't know that LOG_ALL logs the query, so it would be LOT easier to find the problematic one.
The only problem is that the log will be massive, as this is a live server with 100+ players.
Will try that way and see. Thanks.

Re: [REL] MySQL Plugin (Now on github!) - B-Matt - 15.05.2014

Quote:

Originally Posted by Gigi-The-Beast

Hey B-Matt, that is what I was looking for, I didn't know that LOG_ALL logs the query, so it would be LOT easier to find the problematic one.
The only problem is that the log will be massive, as this is a live server with 100+ players.
Will try that way and see. Thanks.

Open it in Notepad++ and then CTRL+F "Error", then you will have less lag. I do it with my server_log.txt.

Re: [REL] MySQL Plugin (Now on github!) - Derryd - 17.05.2014

Can I get a download link for R6-2? The standard R6 posted here doesn't have mysql_format.

Re: [REL] MySQL Plugin (Now on github!) - VladimirMark - 22.05.2014

Where can I find MySQL R33+
I am trying to find it but nothing :/
Just need help, thanks

Re: [REL] MySQL Plugin (Now on github!) - Konstantinos - 22.05.2014

Quote:

Originally Posted by VladimirMark

Where can I find MySQL R33+
I am trying to find it but nothing :/
Just need help, thanks

It's on the first post: https://github.com/pBlueG/SA-MP-MySQL/releases

Re: [REL] MySQL Plugin (Now on github!) - VladimirMark - 22.05.2014

Quote:

Originally Posted by Konstantinos

It's on the first post: https://github.com/pBlueG/SA-MP-MySQL/releases

Isn't that R38? When I scroll down I find R33 but is it the same with R33+ ?
I just got confused :/

EDIT:
It meant R33 or higher? I really don't know :P

Re: [REL] MySQL Plugin (Now on github!) - Konstantinos - 22.05.2014

The latest versions exist in that page (R33 to R38). Some bugs have been fixed, new functions have been added and there have been performance improvements after R33 got out so it's recommended to use the latest one R38.

Re: [REL] MySQL Plugin (Now on github!) - VladimirMark - 22.05.2014

Quote:

Originally Posted by Konstantinos

The latest versions exist in that page (R33 to R3

. Some bugs have been fixed, new functions have been added and there have been performance improvements after R33 got out so it's recommended to use the latest one R38.

Yea but I want the R33+ plugin

EDIT:
What does that mean?

Код:

Failed (libmysqlclient.so.18: cannot open shared object file: No such file or directory)

Re: [REL] MySQL Plugin (Now on github!) - Konstantinos - 22.05.2014

"R33+" means any version from R33 and above (up to R38). If you want to use R33 version, go ahead but using the latest version for plugins/includes etc is always recommended.

Re: [REL] MySQL Plugin (Now on github!) - VladimirMark - 22.05.2014

What does that mean?

Код:

Failed (libmysqlclient.so.18: cannot open shared object file: No such file or directory)

Re: [REL] MySQL Plugin (Now on github!) - Konstantinos - 22.05.2014

I'm not that good on Linux so I can't help you installing those libraries are needed but you can get rid of it by using a static version of the plugin.

Re: [REL] MySQL Plugin (Now on github!) - VladimirMark - 22.05.2014

Thank you very much Konstantino

I speak Greek also

REP+

Re : [REL] MySQL Plugin (Now on github!) - khalildz - 25.05.2014

i want R6 by ubuntu plz

Re: Re : [REL] MySQL Plugin (Now on github!) - iZN - 26.05.2014

Quote:

Originally Posted by khalildz

i want R6 by ubuntu plz

At least check the main post.

Quote:

Originally Posted by BlueG

Downloads: (for newer updates, use the github project site above!)

NOTE: DON'T USE VERSION R7 OR ABOVE IF YOU HAVE NO IDEA WHAT THREADING MEANS OR HOW IT WORKS. YOU MIGHT HARM YOUR SERVER WHEN USING IT NOT PROPERLY.

Windows: (requires .NET Framework)
- R7: Server plugin (VS9)
- R6: Server plugin (VS9)
- R5: Server plugin (VS9)
- libmysql.dll
Linux: (x86 (32-bit) version is cross compatible)
- R7: Ubuntu, x86 (compiled on Ubuntu)
- R6: CentOS, Debian 5, x86 (compiled on CentOS), x86 (compiled on Debian5)
- R5: CentOS, Debian 5, x86
- libmysqlclient.so.15 - Getting this error.. 'libmysqlclient.so.15: cannot open shared [..]' ? - Read this
Scripting:
- R7: a_mysql.inc, Sample Script (shows how to use the cache_*() functions), Blank Gamemode (uses the cache method)
- R5, R6: a_mysql.inc, Sample PAWN script
- Archive: PHP class, Modified sample script (by nemesis) (only >= R5 compatible)
Source: (Cross-Compatible)
- R7: Source code
- R6: Source code
- R5: Source code