[Plugin] [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/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 ?
Reply

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
Reply

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.
Reply

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

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?
Reply

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

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

WTF?
Reply

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.
Reply

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.
Reply

Код:
[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:



And server crash...
Reply

Код:
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...
Reply

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.
Reply

same error or dont you re-uploaded it yet?
Reply

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

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
Reply

Are you getting the same error with the linux plugin?
Reply

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?
Reply

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

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
Reply

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


Forum Jump:


Users browsing this thread: 12 Guest(s)