[Ajuda] problema com mysql - Printable Version

[Ajuda] problema com mysql - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Português/Portuguese (https://sampforum.blast.hk/forumdisplay.php?fid=34)
+---- Thread: [Ajuda] problema com mysql (/showthread.php?tid=651011)

problema com mysql - iSoaD - 11.03.2018

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);

Re: problema com mysql - Marllun - 11.03.2018

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

Re: problema com mysql - GuiKommander - 11.03.2018

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

Re: problema com mysql - iSoaD - 11.03.2018

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)