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

Threaded Mode
[Ajuda] problema com mysql
iSoaD
Big Clucker
***
Posts: 189
Threads: 34
Joined: Jan 2016
Reputation: 0
#1

11.03.2018, 16:15
gente do nada apareceu esse problema no meu mysql logs
alguйm me ajude por favor


Код:
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:25:13 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:26:54 03/11/18] [WARNING] CMySQLResult::GetRowDataByName - field not found ("campID") (Query: "SELECT * FROM `players` WHERE `playerName` = 'Vagina'")
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[12:57:11 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
Код:
	new query[160];
	format(query, sizeof(query), "SELECT * FROM `players` WHERE `playerName` = '%s'", ReturnName(playerid));
	mysql_tquery(Conexao, query, "PlayerConnected", "d", playerid);
Find
Reply
Marllun
Gangsta
*****
Posts: 907
Threads: 45
Joined: Oct 2016
Reputation: 0
#2

11.03.2018, 16:18
O identificador de conexгo 0 significa que nгo hб conexгo. Ou vocк simplesmente esqueceu de abri-lo, ou os parвmetros de conexгo estгo errados.


Vince
Find
Reply
GuiKommander
Gangsta
*****
Posts: 827
Threads: 143
Joined: Dec 2016
Reputation: 0
#3

11.03.2018, 16:19
Se vocк estб fazendo Login/Registro em MySQL, use minha base, n tem nenhum erro Nгo, Crie a database 'samp' com a tabela:
Код:
CREATE TABLE IF NOT EXISTS `Contas`(`Nome` VARCHAR(21) NOT NULL, `Senha` VARCHAR(20) NOT NULL, `Dinheiro` INT NOT NULL)
PHP код:
http://forum.sa-mp.com/showthread.php?t=650292 
Find
Reply
iSoaD
Big Clucker
***
Posts: 189
Threads: 34
Joined: Jan 2016
Reputation: 0
#4

11.03.2018, 16:59
Quote:
Originally Posted by Marllun
Посмотреть сообщение
O identificador de conexгo 0 significa que nгo hб conexгo. Ou vocк simplesmente esqueceu de abri-lo, ou os parвmetros de conexгo estгo errados.


Vince
eu arrumei aquele mas agora estб esse
Код:
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_format - invalid connection handle (id: 0)
[13:53:57 03/11/18] [ERROR] mysql_tquery - invalid connection handle (id: 0)
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