MySQL, Errors. Help. - 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, Errors. Help. (
/showthread.php?tid=495551)
MySQL, Errors. Help. -
X|Dragon|X - 17.02.2014
Код:
SA-MP Dedicated Server
----------------------
v0.3z, ©2005-2014 SA-MP Team
[23:10:29]
[23:10:29] Server Plugins
[23:10:29] --------------
[23:10:29] Loading plugin: streamer
[23:10:29]
*** Streamer Plugin v2.6.1 by Incognito loaded ***
[23:10:29] Loaded.
[23:10:29] Loading plugin: sscanf
[23:10:29]
[23:10:29] ===============================
[23:10:29] sscanf plugin loaded.
[23:10:29] © 2009 Alex "******" Cole
[23:10:29] 0.3d-R2 500 Players "dnee"
[23:10:29] ===============================
[23:10:29] Loaded.
[23:10:29] Loading plugin: mysql
[23:10:29] Failed.
[23:10:29] Loading plugin: Whirlpool
[23:10:30]
[23:10:30] ==================
[23:10:30]
[23:10:30] Whirlpool loaded
[23:10:30]
[23:10:30] ==================
[23:10:30]
[23:10:30] Loaded.
[23:10:30] Loading plugin: nativechecker
[23:10:30] Loaded.
[23:10:30] Loaded 4 plugins.
[23:10:30]
[23:10:30] Ban list
[23:10:30] --------
[23:10:30] Loaded: samp.ban
[23:10:30]
[23:10:30]
[23:10:30] Filterscripts
[23:10:30] ---------------
[23:10:30] Loading filterscript 'yom_buttons.amx'...
[23:10:30] Loading filterscript 'gcustom.amx'...
[23:10:30] Loaded 2 filterscripts.
[23:10:32] Error: Function not registered: 'mysql_tquery'
[23:10:32] Error: Function not registered: 'mysql_escape_string'
[23:10:32] Error: Function not registered: 'cache_get_data'
[23:10:32] Error: Function not registered: 'cache_get_field_content'
[23:10:32] Error: Function not registered: 'mysql_stat'
[23:10:32] Error: Function not registered: 'mysql_log'
[23:10:32] Error: Function not registered: 'mysql_connect'
[23:10:32] Error: Function not registered: 'mysql_close'
[23:10:32] Error: Function not registered: 'cache_get_row'
[23:10:32] Error: Function not registered: 'cache_insert_id'
[23:10:32] Error: Function not registered: 'cache_affected_rows'
[23:10:32] Script[gamemodes/VGNRP.amx]: Run time error 19: "File or function is not found"
[23:10:32] Number of vehicle models: 0
I've already set up my MYSQL on XAMPP and Navicat and eveything, but idk what's wrong, it should work.
Re: MySQL, Errors. Help. -
iZN - 17.02.2014
Using the wrong version of plugin (Get R37) or using any custom .dll (instead of that download Visual C++ 2012 Runtime x86 even if your system is x64)
Re: MySQL, Errors. Help. -
X|Dragon|X - 17.02.2014
Alright, Thanks everything worked fine, BUTTT, I need another help, now the script is a little bugged i guess, or it might be a problem with my mysql.. look.
Код:
[23:36:06]
[23:36:27] [MySQL] Query Error - (ErrorID: 2006) (Handle: 1)
[23:36:27] [MySQL] Check mysql_log.txt to review the query that threw the error.
[23:36:27] Dumping query from 2014/2/17 (23:36:27)
Description: MySQL server has gone away (index 0). Query:
[23:36:27] SELECT `gMOTD`,`aMOTD`,`vMOTD`,`cMOTD`,`pMOTD`,`ShopTechPay`,`GiftCode`,`GiftCodeBypass`,`TotalCitizens`,`TRCitizens`,`SecurityCode`,`ShopClosed`,`RimMod`,`CarVoucher`,`PVIPVoucher`, `GarageVW`, `PumpkinStock`, `HalloweenShop` FROM `misc`
[23:36:27] [MySQL] Connection Error Detected in Threaded Query
[23:36:43] Incoming connection: 192.168.100.12:63404
[23:36:43] [join] Alaric_Cilean has joined the server (0:192.168.100.12)
[23:36:48] [MySQL] Query Error - (ErrorID: 2006) (Handle: 1)
[23:36:48] [MySQL] Check mysql_log.txt to review the query that threw the error.
[23:36:48] Dumping query from 2014/2/17 (23:36:48)
Description: MySQL server has gone away (index 0). Query:
[23:36:48] UPDATE `accounts` SET `Online` = 0 WHERE `Online` = 0
[23:36:48] [MySQL] Connection Error Detected in Threaded Query
[23:36:56] [chat] [Alaric_Cilean]: .
[23:37:09] [MySQL] Query Error - (ErrorID: 2006) (Handle: 1)
[23:37:09] [MySQL] Check mysql_log.txt to review the query that threw the error.
[23:37:09] Dumping query from 2014/2/17 (23:37:9)
Description: MySQL server has gone away (index 0). Query:
[23:37:09] SELECT * FROM `giftbox`
[23:37:09] [MySQL] Connection Error Detected in Threaded Query
[23:37:30] [MySQL] Query Error - (ErrorID: 2006) (Handle: 1)
[23:37:30] [MySQL] Check mysql_log.txt to review the query that threw the error.
[23:37:30] Dumping query from 2014/2/17 (23:37:30)
Description: MySQL server has gone away (index 0). Query:
[23:37:30] SELECT * FROM `crates`
[23:37:30] [MySQL] Connection Error Detected in Threaded Query
[23:37:55] [MySQL] Query Error - (ErrorID: 2006) (Handle: 1)
[23:37:55] [MySQL] Check mysql_log.txt to review the query that threw the error.
[23:37:55] Dumping query from 2014/2/17 (23:37:55)
Description: MySQL server has gone away (index 0). Query:
[23:37:55] SELECT OwnerName.Username, h.* FROM houses h LEFT JOIN accounts OwnerName ON h.OwnerID = OwnerName.id
[23:37:55] [MySQL] Connection Error Detected in Threaded Query