[Plugin] [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011

[Plugin] [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - 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] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 (/showthread.php?tid=122983)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - MahmutBey - 01.03.2011

[19:42:03] Script[gamemodes/rlrpg.amx]: Run time error 19: "File or function is not found"

what is this ?? who can help me ?

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Unknown123 - 01.03.2011

Quote:

Originally Posted by MahmutBey

[19:42:03] Script[gamemodes/rlrpg.amx]: Run time error 19: "File or function is not found"

what is this ?? who can help me ?

That means it dont find the file or function...
Look in your includes and see if you have all installed.

Example:
if you have

pawn Код:

#include <mysql>

in ur gamemode

and if you DONT have the mysql.inc inside "pawno/includes/*"
then you will get that Error

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Burridge - 01.03.2011

Unknown123: Wrong. That error is shown when the server is started up. Because as you can clearly see, the gamemode has already compiled to be an .amx file, which is what the server uses to load the gamemodes and filterscripts.

MahmutBey: Make sure you have the plugin in the plugins folder, and then make sure your have it set in your server.cfg file so the plugin can run when the server starts.

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - CJ101 - 02.03.2011

If you are using a old system you should update to the newest version (2.1.1)

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Redirect Left - 06.03.2011

Any one know any reason for mysql_fetch_field to crash a server?

It doesn't happen all the time, but occasionaly, it crashes and the logs report mysql_fetch_field being the last thing initiated.

[Sun Mar 6 20:51:49 2011] Function: mysql_query executed: "SELECT * FROM accounts WHERE `username`='Redirect_Left'" with result: "0".
[Sun Mar 6 20:51:49 2011] Function: mysql_store_result executed with result: "1"
[Sun Mar 6 20:51:49 2011] Function: mysql_fetch_field executed.
>> CRASH <<

Any ideas what might be happening?
I've put the affects bits of SQL into phpMyAdmin, and it parses and fetches stuff fine, so it should have the field to fetch?

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - CraZy_KiLLaH - 08.03.2011

How do i connect a MySQL server to an UCP MySQL based?

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - tr.power - 08.03.2011

[MySQL] Error (0): Function: mysql_connect failed, mysql was not initialized on this handle.

WTF?

Re: AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - HACKHERS - 08.03.2011

Quote:

Originally Posted by tr.power

[MySQL] Error (0): Function: mysql_connect failed, mysql was not initialized on this handle.

WTF?

mysql_init();

add this before connection.

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - StrickenKid - 15.03.2011

Thank you for the bug report, I will look into this immediately.

I just need a little information, what function were you using to retrieve the data?
If you can send me the pawn script used in your testing it would help a lot so I can pinpoint the problem in the source.

EDIT: I've found and fixed the problem.
It actually wasn't caused by the null values, mysql_fetch_row was not adding the trailing null character at the end of the character array.

I will be uploading latest update shortly.

EDIT2:

Updated - Build 162.

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Fro1sha - 16.03.2011

Код:

[Wed Mar 16 06:22:03 2011] Function: mysql_query executed: "SELECT * FROM `fraction`" with result: "0".
[Wed Mar 16 06:22:03 2011] Function: mysql_store_result executed with result: "1"
[Wed Mar 16 06:22:03 2011] Function: mysql_fetch_row executed with result: "xћ1|1".

What is it?

Quote:

xћ

And server crash...

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Akmet - 16.03.2011

Код:

Function: mysql_fetch_row executed with result: "xIxI18|-2154.73|-2460.99|30.8516|364.942|-11.808|1001.85|9|Cluckin Bell Angelpine|0|0".
[...]
Function: mysql_fetch_row executed with result: "€I€I25|660.627|-573.314|16.3359|662.642|-573.21|16.3416|0|Dillimore Tanke|7|21".
[...]

i also get this after the update... but after that it runs the mysql_fetch_row function some times more...

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - StrickenKid - 16.03.2011

Hmm, are you running the plugin on windows or linux?

EDIT: Found the problem, I took out a function for testing and forgot to put it back in.

Sorry guys... I'll compile and re-upload.

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Akmet - 16.03.2011

same error or dont you re-uploaded it yet?

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - StrickenKid - 16.03.2011

Ok, I've uploaded it. Let me know if its fixed!

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Akmet - 16.03.2011

did you also upload the latest source?

i get the same errors like before

Код:

Function: mysql_fetch_row executed with result: "xIxI3|596|1|1|1591.63|-1710.95|5.61235|359.781|154|1|80|1000|0|5|LS".

PS: the compiled windows file runs perfect

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - StrickenKid - 16.03.2011

Are you getting the same error with the linux plugin?

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Akmet - 16.03.2011

i have no linux here at the moment

with compiled windows file i mean the dll you uploaded

i tried to compile it myself, but then i get these errors, so i think its an old version?

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - StrickenKid - 16.03.2011

The source on the website is the latest verson, make sure your compiling the correct source and copying over the correct dll.

AW: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - Akmet - 16.03.2011

hmm i compile it again and the same errors came...
also im wondered about the fact that the xIxI3 is not at each row...

which compiler are u using?
im using microsoft visual c++ 2010

Re: [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011 - StrickenKid - 19.03.2011

That might be your problem, don't use visual c++ 2010, use 2008.
Visual c++ 2010 is horrible.