[Sielly]

Hello,
I am connected to my database and i am trying to make query:

pawn Код:

new query[256], nick[32];
                GetPlayerName(playerid,nick,32);
                mysql_format(MySql, query, 256, "INSERT INTO `konta` (`nick`, `haslo`, `datazalozenia`) VALUES ('%s', '%s', '0')",nick,HasloPrzyRejestracji[playerid]);
                mysql_query(MySql, query);

of course i created database and table, but it still doesn't work..
i'm using this: https://sampforum.blast.hk/showthread.php?tid=56564

[zaibaslr2]

Always look in your mysql log file for information.

[Sielly]

Код:

[15:27:14] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '192.167.1.11' (10060)
[15:27:35] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '192.167.1.11' (10060)
[15:27:35] [ERROR] CMySQLConnection::Connect - (error #2003) Can't connect to MySQL server on '192.167.1.11' (10060)
[15:27:57] [ERROR] CMySQLQuery::Execute - (error #2006) MySQL server has gone away

[zaibaslr2]

That solves your problem - your mysql connection is wrong. Check your password and username

[Vince]

Use localhost to connect. Remote connections usually aren't allowed for security reasons. Also they are slower.

[MORJAN5566]

Remove this 192.167.1.11 and post Localhost

[Sielly]

Vince it worked. rep+