1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Português/Portuguese

Threaded Mode
[Ajuda] qual problema no codigo?
iSoaD
Big Clucker
***
Posts: 189
Threads: 34
Joined: Jan 2016
Reputation: 0
#1

12.03.2018, 01:27
pessoal estou comeзando a mexer em mysql agora e nгo estou conseguindo resolver meu problema.
nos logs do servidor dб isso:

Код:
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:19:22 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[22:20:16 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
meu cуdigo
Код:
forward PlayerConnected(playerid);
public PlayerConnected(playerid)
{
	if (!IsPlayerConnected(playerid))
	    return 0;

	static
	    rows,
	    fields;

    cache_get_data(rows, fields, Conexao);

	if (!rows)
	{
		static query[160];

		mysql_format(Conexao, query, sizeof(query), "INSERT INTO `players` (`playerName`) VALUES('%s')", ReturnName(playerid));
		return mysql_tquery(Conexao, query,"","");
	}

	pCampLD[playerid] = cache_get_field_int(0, "campID");
	pCampID[playerid] = cache_get_field_int(0, "playerCampID");
	pStationID[playerid] = cache_get_field_int(0, "playerStationID");
	pCampSuccessor[playerid] = cache_get_field_int(0, "playerCampSuccessor");
 	pObjects[playerid] = cache_get_field_int(0, "playerObjects");
	return 1;
}

stock connectvarsbase(playerid)
{
	pCamps[playerid] = 1;
	pCampID[playerid] = -1;
	pEditAntenna[playerid] = -1;
	pAntennas[playerid] = 1;
	pStationID[playerid] = -1;
	pActualDistance[playerid] = 0.0;
	pCampInvited[playerid] = -1;
	pInvitedLeader[playerid] = INVALID_PLAYER_ID;
	pCampSuccessor[playerid] = -1;

	pSelected[playerid] = -1;
	pObjects[playerid] = 999999;

	new Query[70];

	mysql_format(Conexao, Query, sizeof(Query), "SELECT * FROM `players` WHERE `playerName` = '%s'", ReturnName(playerid));
	mysql_tquery(Conexao, Query, "PlayerConnected", "d", playerid);

return 1;
}
Find
Reply
PowerMwK
Big Clucker
***
Posts: 175
Threads: 13
Joined: Sep 2016
Reputation: 0
#2

14.03.2018, 11:08
acho que falta a tabela rows.
Find
Reply
F1N4L
High-roller
*****
Posts: 2,723
Threads: 110
Joined: Jun 2013
Reputation: 0
#3

14.03.2018, 11:45
Quote:
Originally Posted by PowerMwK
Посмотреть сообщение
acho que falta a tabela rows.
Isso nгo tem relaзгo nenhuma ao problema...

@TOPIC

https://sampwiki.blast.hk/wiki/MySQL#mysql_connect
Find
Reply
PowerMwK
Big Clucker
***
Posts: 175
Threads: 13
Joined: Sep 2016
Reputation: 0
#4

14.03.2018, 12:42
Quote:
Originally Posted by F1N4L
Посмотреть сообщение
Isso nгo tem relaзгo nenhuma ao problema...

@TOPIC

https://sampwiki.blast.hk/wiki/MySQL#mysql_connect
Pois pois, responda antes kk
Find
Reply
F1N4L
High-roller
*****
Posts: 2,723
Threads: 110
Joined: Jun 2013
Reputation: 0
#5

14.03.2018, 12:53
Quote:
Originally Posted by PowerMwK
Посмотреть сообщение
Pois pois, responda antes kk
Aparentemente a variбvel Conexao nгo tem nenhuma conexгo vбlida, ou seja, informaзхes de login na base de dados estгo invбlidas.
Se certifique que as informaзхes de conexгo estгo corretas, como no link que eu mandei.

Olha o exemplo na wiki (adaptado):

Код:
new MySQL:Conexao;
// ...
public OnGameModeInit()
{
	Conexao = mysql_connect("127.0.0.1", "root", "mypass", "mydatabase"); // Conecta а database com base nas informaзхes digitadas.

	if(mysql_errno(Conexao) != 0)  print("Erro ao se conectar а base de dados.!"); // Verifica se a conexгo й vбlida, ou seja, sem erros.
	return 1;
}
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Português/Portuguese