Mysql File or function is not found - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql File or function is not found (/showthread.php?tid=556157)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Mysql File or function is not found (/showthread.php?tid=556157)
Mysql File or function is not found - ilepopivanov - 09.01.2015
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.
http://pastebin.com/61eRF5jK
Database:
http://prntscr.com/5qjzvf
Respuesta: Mysql File or function is not found - Zume - 09.01.2015
you forgot to add the "whirlpool" plugin to your server.cfg
Re: Mysql File or function is not found - bgedition - 09.01.2015
You need to compile it.
Re: Respuesta: Mysql File or function is not found - ilepopivanov - 09.01.2015
Lolz thanks
+rep
Re: Respuesta: Mysql File or function is not found - ilepopivanov - 09.01.2015
Now when I type password to register dialog is closing but it don't save
Re: Mysql File or function is not found - bgedition - 09.01.2015
Is this script is from this tutoiral - https://sampforum.blast.hk/showthread.php?tid=485633?
Re: Mysql File or function is not found - ilepopivanov - 09.01.2015
Yes ..
Re: Mysql File or function is not found - bgedition - 09.01.2015
I have the same problem please show mysql_log
Re: Mysql File or function is not found - ilepopivanov - 09.01.2015
[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
Re: Mysql File or function is not found - bgedition - 09.01.2015
now show the script