Mysql Prob

x.X-Daniel-X.x · 26. November 2011

Hallo com,
ich hab meinen server nun auf mysql umgeschrieben.
ich bekomme folgende erorrs in der server log:

Code

[19:34:24] [MySQL] Error (2): Function: mysql_close called when not connected to any database.
[19:34:36] Function: mysql_connect called with incorrect parameter count.
[19:34:36] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap()
[19:34:36] 
----------------------------------
[19:34:36] Reality Real Life Gamemode v1.0      
[19:34:36] ----------------------------------


[19:34:36] Number of vehicle models: 32

meine zeille im script:
mysql = mysql_init(LOG_ALL);
mysql_connect("server", "user", "pw", "db", mysql);

Grex · 26. November 2011

Poste mal die mysql.inc bitte.

x.X-Daniel-X.x · 26. November 2011

Code

/**
 *     SA:MP MySQL v2.1 Functions
 *  (c) Copyright 2011, StrickenKid
 *
 **/


#if defined __mysql_included
	#endinput
#endif


#define __mysql_included
#pragma library mysql


// plugin error id's


#define P_ERROR_NONE                                0
#define P_ERROR_INCPARAMCNT                         1
#define P_ERROR_INCVALUE                            2
#define P_ERROR_MAXCONN                             3
#define P_ERROR_DBNOCONN                            4
#define P_ERROR_NORES                               5
#define P_ERROR_RES                                 6
#define P_ERROR_NOFIELD                             7
#define P_ERROR_NOFIELDDATA                         8
#define P_ERROR_NOROWDATA                           9
#define P_ERROR_CANTALLOC                           10
#define P_ERROR_NOCALLBACK                          11
#define P_ERROR_NOQUERY                             12


// mysql headers defines


#define REFRESH_GRANT								1
#define REFRESH_LOG									2
#define REFRESH_TABLES								4
#define REFRESH_HOSTS								8
#define REFRESH_STATUS								16
#define REFRESH_THREADS								32
#define REFRESH_SLAVE   							64
#define REFRESH_MASTER 							 	128


// mysql error id's


#define CR_ERROR_FIRST  							2000
#define CR_UNKNOWN_ERROR							2000
#define CR_SOCKET_CREATE_ERROR						2001
#define CR_CONNECTION_ERROR							2002
#define CR_CONN_HOST_ERROR							2003
#define CR_IPSOCK_ERROR								2004
#define CR_UNKNOWN_HOST								2005
#define CR_SERVER_GONE_ERROR						2006
#define CR_VERSION_ERROR							2007
#define CR_OUT_OF_MEMORY							2008
#define CR_WRONG_HOST_INFO							2009
#define CR_LOCALHOST_CONNECTION 					2010
#define CR_TCP_CONNECTION							2011
#define CR_SERVER_HANDSHAKE_ERR 					2012
#define CR_SERVER_LOST								2013
#define CR_COMMANDS_OUT_OF_SYNC 					2014
#define CR_NAMEDPIPE_CONNECTION 					2015
#define CR_NAMEDPIPEWAIT_ERROR  					2016
#define CR_NAMEDPIPEOPEN_ERROR  					2017
#define CR_NAMEDPIPESETSTATE_ERROR 					2018
#define CR_CANT_READ_CHARSET						2019
#define CR_NET_PACKET_TOO_LARGE						2020
#define CR_EMBEDDED_CONNECTION						2021
#define CR_PROBE_SLAVE_STATUS   					2022
#define CR_PROBE_SLAVE_HOSTS    					2023
#define CR_PROBE_SLAVE_CONNECT  					2024
#define CR_PROBE_MASTER_CONNECT 					2025
#define CR_SSL_CONNECTION_ERROR 					2026
#define CR_MALFORMED_PACKET     					2027
#define CR_WRONG_LICENSE							2028
#define CR_NULL_POINTER								2029
#define CR_NO_PREPARE_STMT							2030
#define CR_PARAMS_NOT_BOUND							2031
#define CR_DATA_TRUNCATED							2032
#define CR_NO_PARAMETERS_EXISTS 					2033
#define CR_INVALID_PARAMETER_NO 					2034
#define CR_INVALID_BUFFER_USE						2035
#define CR_UNSUPPORTED_PARAM_TYPE 					2036
#define CR_SHARED_MEMORY_CONNECTION             	2037
#define CR_SHARED_MEMORY_CONNECT_REQUEST_ERROR 		2038
#define CR_SHARED_MEMORY_CONNECT_ANSWER_ERROR   	2039
#define CR_SHARED_MEMORY_CONNECT_FILE_MAP_ERROR 	2040
#define CR_SHARED_MEMORY_CONNECT_MAP_ERROR      	2041
#define CR_SHARED_MEMORY_FILE_MAP_ERROR         	2042
#define CR_SHARED_MEMORY_MAP_ERROR              	2043
#define CR_SHARED_MEMORY_EVENT_ERROR     			2044
#define CR_SHARED_MEMORY_CONNECT_ABANDONED_ERROR 	2045
#define CR_SHARED_MEMORY_CONNECT_SET_ERROR      	2046
#define CR_CONN_UNKNOW_PROTOCOL 					2047
#define CR_INVALID_CONN_HANDLE						2048
#define CR_SECURE_AUTH                          	2049
#define CR_FETCH_CANCELED                       	2050
#define CR_NO_DATA                              	2051
#define CR_NO_STMT_METADATA                     	2052
#define CR_NO_RESULT_SET                        	2053
#define CR_NOT_IMPLEMENTED                      	2054
#define CR_SERVER_LOST_EXTENDED						2055
#define CR_STMT_CLOSED								2056
#define CR_NEW_STMT_METADATA                    	2057
#define CR_ERROR_LAST                      			2057


// logging types


#define INVALID_MYSQL_ID							(-1)
#define LOG_OFF										(0)
#define LOG_ALL           							(1)
#define LOG_ONLY_ERRORS   							(2)


// function defines


#define mysql_reload(%1) mysql_refresh(REFRESH_GRANT, %1)


// plugin callbacks


forward OnMysqlQueryArray(resultid, extravars[], MySQL:handle);
forward OnMysqlQuery(resultid, spareid, MySQL:handle);
forward OnMysqlError(error[], errorid, MySQL:handle);


// plugin natives


native MySQL:mysql_init(logtype = LOG_ONLY_ERRORS, printerrors = 1);
native mysql_connect(const host[], const user[], const pass[], const db[], MySQL:handle = (MySQL:0), auto_reconnect = 0);
native mysql_close(MySQL:handle = (MySQL:0));
native mysql_refresh(options, MySQL:handle = (MySQL:0));
native mysql_select_db(const db[], MySQL:handle = (MySQL:0));
native mysql_query(const query[], resultid = (-1), spareid = (0), MySQL:handle = (MySQL:0));
native mysql_query_array(const query[], resultid = (-1), {Float,_}:extravars[], MySQL:handle = (MySQL:0));
native mysql_store_result(MySQL:handle = (MySQL:0));
native mysql_free_result(MySQL:handle = (MySQL:0));
native mysql_result_stored(MySQL:handle = (MySQL:0));
native mysql_fetch_field(const fieldname[], dest[], MySQL:handle = (MySQL:0));
native mysql_fetch_field_num(fieldnum, dest[], MySQL:handle = (MySQL:0));
native mysql_fetch_row(dest[], const splitter[] = "|", MySQL:handle = (MySQL:0));
native mysql_fetch_row_data(MySQL:handle = (MySQL:0));
native mysql_real_escape_string(const string[], dest[], MySQL:handle = (MySQL:0));
native mysql_num_rows(MySQL:handle = (MySQL:0));
native mysql_num_fields(MySQL:handle = (MySQL:0));
native mysql_affected_rows(MySQL:handle = (MySQL:0));
native mysql_insert_id(MySQL:handle = (MySQL:0));
native mysql_ping(MySQL:handle = (MySQL:0));
native mysql_error(dest[], MySQL:handle = (MySQL:0));
native mysql_errno(MySQL:handle = (MySQL:0));
native mysql_warning_count(MySQL:handle = (MySQL:0));
native mysql_info(dest[], MySQL:handle = (MySQL:0));
native mysql_stat(dest[], MySQL:handle = (MySQL:0));
native mysql_get_server_info(dest[], MySQL:handle = (MySQL:0));
native mysql_get_host_info(dest[], MySQL:handle = (MySQL:0));
native mysql_data_seek(rownum, MySQL:handle = (MySQL:0));
native mysql_set_character_set(const csname[], MySQL:handle = (MySQL:0));
native mysql_get_character_set(csname[], MySQL:handle = (MySQL:0));
native mysql_fetch_int(MySQL:handle = (MySQL:0));
native Float:mysql_fetch_float(MySQL:handle = (MySQL:0));
native mysql_fetch_string(dest[], MySQL:handle = (MySQL:0));


#if !defined split
// split function - thanks to Blacklite
stock split(const strsrc[], strdest[][], delimiter = '|')
{
	new i, li, aNum, len, srclen = strlen(strsrc);
	while(i <= srclen)
	{
		if (strsrc[i] == delimiter || i == srclen)
		{
			len = strmid(strdest[aNum], strsrc, li, i, 128);
			strdest[aNum][len] = 0;
			li = i + 1;
			aNum++;
		}
		i++;
	}
}
#endif

Alles anzeigen

Grex · 26. November 2011

Zitat von Daniel123

mysql_connect("server", "user", "pw", "db", mysql);

Was soll dieses mysql am Schluss?
Und hat du i.wo im Script mysql_close stehen?, wenn ja wo? zufällig vor dem mysql_connect?

x.X-Daniel-X.x · 26. November 2011

mysql_init(LOG_ALL);
so das machen

Grex · 26. November 2011

bitte was?

x.X-Daniel-X.x · 26. November 2011

public OnGameModeExit()
{
mysql_close(mysql);
return 1;
}
so und das mysql ruft diese funktion auf:
mysql_init(LOG_ALL);

Akino Kiritani · 26. November 2011

mysql_connect("server", "user", "pw", "db", mysql);

Du musst hier auch eintragen wohin sich das connecten soll.

Ich kann mir nicht vorstellen das deine IP server ist dein User user etc

Du musst das dann so machen

mysql_connect("localhost oder IP", "root oder wie dein user/account heißt", "dein pw", "die datenbank wo deine tabellen drin sind", mysql);

x.X-Daniel-X.x · 26. November 2011

hab ich ja auch so gemachaber des geht dorzdem net

Akino Kiritani · 26. November 2011

mysql_connect("localhost oder IP", "root oder wie dein user/account heißt", "dein pw", "die datenbank wo deine tabellen drin sind", mysql);
Dir ist aber bewusst das du das alles in deine Daten ändern musst?

x.X-Daniel-X.x · 26. November 2011

ja

Zunno · 26. November 2011

Mach die Varriable mysql weg, die benötigst du nicht bei StrickenKid, da dies automatisch gesetzt wird, durch das Include

sprich so:
mysql_init(LOG_ALL);
mysql_connect("server", "user", "pw", "db");
mysql_close();

x.X-Daniel-X.x · 26. November 2011

ok Danke ich probiere es aus
geht immer noch net

Code

SA-MP Dedicated Server
----------------------
v0.3d-RC9, (C)2005-2011 SA-MP Team


[21:41:55] 
[21:41:55] Server Plugins
[21:41:55] --------------
[21:41:55]  Loading plugin: streamer.so
[21:41:55] 


*** Streamer Plugin v2.5.2 by Incognito loaded ***


[21:41:55]   Loaded.
[21:41:55]  Loading plugin: mysql.so
[21:41:55]  SA:MP MySQL Plugin v2.1.1 Loaded.
[21:41:55]   Loaded.
[21:41:55]  Loaded 2 plugins.


[21:41:55] [MySQL] Thread running. Threadsafe: Yes.
[21:41:55] 
[21:41:55] Ban list
[21:41:55] --------
[21:41:55]  Loaded: samp.ban
[21:41:55] 
[21:41:56] 
[21:41:56] Filterscripts
[21:41:56] ---------------
[21:41:56]   Loading filterscript 'gl_realtime.amx'...
[21:41:56]   Loaded 1 filterscripts.


[21:41:56] Function: mysql_connect called with incorrect parameter count.
[21:41:56] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap()
[21:41:56] 
----------------------------------
[21:41:56] Reality Real Life Gamemode v1.0      
[21:41:56] ----------------------------------


[21:41:56] Number of vehicle models: 32


----------
Loaded log file: "server_log.txt".
----------


SA-MP Dedicated Server
----------------------
v0.3d-RC9, (C)2005-2011 SA-MP Team


[21:42:38] 
[21:42:38] Server Plugins
[21:42:38] --------------
[21:42:38]  Loading plugin: streamer.so
[21:42:38] 


*** Streamer Plugin v2.5.2 by Incognito loaded ***


[21:42:38]   Loaded.
[21:42:38]  Loading plugin: mysql.so
[21:42:38]  SA:MP MySQL Plugin v2.1.1 Loaded.
[21:42:38]   Loaded.
[21:42:38] [MySQL] Thread running. Threadsafe: Yes.
[21:42:38]  Loaded 2 plugins.


[21:42:38] 
[21:42:38] Ban list
[21:42:38] --------
[21:42:38]  Loaded: samp.ban
[21:42:38] 
[21:42:38] 
[21:42:38] Filterscripts
[21:42:38] ---------------
[21:42:38]   Loading filterscript 'gl_realtime.amx'...
[21:42:38]   Loaded 1 filterscripts.


[21:42:38] Function: mysql_connect called with incorrect parameter count.
[21:42:38] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap()
[21:42:38] 
----------------------------------
[21:42:38] Reality Real Life Gamemode v1.0      
[21:42:38] ----------------------------------


[21:42:38] Number of vehicle models: 32

Alles anzeigen

Akino Kiritani · 26. November 2011

Zitat

Function: mysql_connect called with incorrect parameter count.

x.X-Daniel-X.x · 26. November 2011

?

Akino Kiritani · 26. November 2011

Du kannst doch englisch oder?

Übersetz das doch mal...

x.X-Daniel-X.x · 26. November 2011

der parameter ist zu kurz oder zu lag aber es passt ja alles daten sind richtig und so

Akino Kiritani · 26. November 2011

Nein, der Parameter ist nicht zu kurz -.-

Zitat

incorrect parameter count

falsche Anzahl an Paramtern

x.X-Daniel-X.x · 26. November 2011

ja aber des stimm doch mysql_connect("server", "user", "pw", "db");

Grex · 26. November 2011

Welches MySQL Plugin benutzt du?