[ilepopivanov]

Server Log:

Код:

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

SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team

[00:59:59] filterscripts = ""  (string)
[00:59:59] 
[00:59:59] Server Plugins
[00:59:59] --------------
[00:59:59]  Loading plugin: streamer
[00:59:59]   Failed.
[00:59:59]  Loading plugin: sscanf
[00:59:59] 

[00:59:59]  ===============================

[00:59:59]       sscanf plugin loaded.     

[00:59:59]          Version:  2.8.1        

[00:59:59]    © 2012 Alex "******" Cole  

[00:59:59]  ===============================

[00:59:59]   Loaded.
[00:59:59]  Loading plugin: mysql
[00:59:59]  >> plugin.mysql: R39-2 successfully loaded.
[00:59:59]   Loaded.
[00:59:59]  Loaded 2 plugins.

[00:59:59] 
[00:59:59] Filterscripts
[00:59:59] ---------------
[00:59:59]   Loaded 0 filterscripts.

[00:59:59] Script[gamemodes/test.amx]: Run time error 19: "File or function is not found"
[00:59:59] Number of vehicle models: 0
[01:00:01] --- Server Shutting Down.
[01:00:01] 

[01:00:01]  ===============================

[01:00:01]      sscanf plugin unloaded.    

[01:00:01]  ===============================

[01:00:01] plugin.mysql: Unloading plugin...
[01:00:01] plugin.mysql: Plugin unloaded.

Script:
http://pastebin.com/61eRF5jK

Database:
http://prntscr.com/5qjzvf

[Zume]

you forgot to add the "whirlpool" plugin to your server.cfg

[bgedition]

You need to compile it.

[ilepopivanov]

Lolz thanks
+rep

[ilepopivanov]

Now when I type password to register dialog is closing but it don't save

[bgedition]

Is this script is from this tutoiral - https://sampforum.blast.hk/showthread.php?tid=485633?

[ilepopivanov]

Yes ..

[bgedition]

I have the same problem please show mysql_log

[ilepopivanov]

[01:06:02] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "server", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[01:06:02] [DEBUG] CMySQLHandle::Create - creating new connection..
[01:06:02] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[01:06:02] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[01:06:02] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[01:06:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[01:06:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[01:06:02] [DEBUG] mysql_errno - connection: 1
[01:06:02] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[01:06:02] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[01:06:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[01:06:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[01:06:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[01:06:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[01:06:02] [DEBUG] CMySQLConnection::Connect - connection was successful
[01:06:02] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[01:06:40] [DEBUG] CMySQLConnection:isconnect - connection was closed
[01:06:40] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called
[01:06:43] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "server", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[01:06:43] [DEBUG] CMySQLHandle::Create - creating new connection..
[01:06:43] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[01:06:43] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[01:06:43] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[01:06:43] [DEBUG] CMySQLConnection::Connect - connection was successful
[01:06:43] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[01:06:43] [DEBUG] mysql_errno - connection: 1
[01:06:43] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[01:06:43] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[01:06:43] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[01:06:43] [DEBUG] CMySQLConnection::Connect - connection was successful
[01:06:43] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[01:06:44] [DEBUG] CMySQLConnection::Connect - connection was successful
[01:06:44] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[01:06:44] [DEBUG] CMySQLConnection::Connect - connection was successful
[01:06:44] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[01:07:13] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1"
[01:07:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = 'Ile_P", callback: "OnAccountCheck", format: "i"
[01:07:13] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[01:07:13] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.537 milliseconds
[01:07:13] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[01:07:13] [DEBUG] Calling callback "OnAccountCheck"..
[01:07:13] [DEBUG] cache_get_data - connection: 1
[01:07:13] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[01:08:03] [DEBUG] mysql_format - connection: 1, len: 300, format: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `VIP`, `Money`, `PosX` ,`PosY`, `PosZ`) VALUES ('%e', '%s', '%s', ..."
[01:08:03] [ERROR] mysql_format - destination size is too small
[01:08:03] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `V", callback: "OnAccountRegister", format: "i"
[01:08:03] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - starting query execution
[01:08:03] [ERROR] CMySQLQuery::Execute[OnAccountRegister] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[01:08:03] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - error will be triggered in OnQueryError
[01:08:10] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `players` SET `Admin`=%d, `VIP`=%d, `Money`=%d, `posX`=%f, `posY`=%f, `posZ`=%f WHERE `ID`=%d"
[01:08:10] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Admin`=0, `VIP`=0, `Money`=0, `posX`=0.0, ", callback: "(null)", format: "(null)"
[01:08:10] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[01:08:10] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 39.672 milliseconds
[01:08:10] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[01:08:53] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1"
[01:08:53] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `players` WHERE `Username` = 'Ile_P", callback: "OnAccountCheck", format: "i"
[01:08:53] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[01:08:53] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.893 milliseconds
[01:08:53] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[01:08:53] [DEBUG] Calling callback "OnAccountCheck"..
[01:08:53] [DEBUG] cache_get_data - connection: 1
[01:08:53] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[01:08:59] [DEBUG] mysql_format - connection: 1, len: 300, format: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `VIP`, `Money`, `PosX` ,`PosY`, `PosZ`) VALUES ('%e', '%s', '%s', ..."
[01:08:59] [ERROR] mysql_format - destination size is too small
[01:08:59] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `V", callback: "OnAccountRegister", format: "i"
[01:08:59] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - starting query execution
[01:08:59] [ERROR] CMySQLQuery::Execute[OnAccountRegister] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[01:08:59] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - error will be triggered in OnQueryError
[01:09:04] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `players` SET `Admin`=%d, `VIP`=%d, `Money`=%d, `posX`=%f, `posY`=%f, `posZ`=%f WHERE `ID`=%d"
[01:09:04] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Admin`=0, `VIP`=0, `Money`=0, `posX`=0.0, ", callback: "(null)", format: "(null)"
[01:09:04] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[01:09:04] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.363 milliseconds
[01:09:04] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[01:15:34] [DEBUG] CMySQLConnection:isconnect - connection was closed
[01:15:34] [DEBUG] CMySQLConnection:isconnect - connection was closed
[01:15:34] [DEBUG] CMySQLHandle::~CMySQLHandle - deconstructor called

[bgedition]

now show the script