[quelledave]

Good day,
I am now you last night at my script it and have time for an error I can not find it.
I Connect aufen test server then me only "<>" Spawn "is displayed, and if I then click on 'Spawn'
Click then I will from the server so geschmiessen "server closed the connection".
Does anyone know what I can do that my login screen comes and I can send me?

Under 'localhost' the error occur in the mysql_log.txt

Quote:

[12:00:30] [ERROR] CMySQLHandler::Connect() - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (error ID: 2002). [12:00:30] [ERROR] CMySQLHandler::Statistics() - You cannot call this function now (connection is dead). [12:02:11] [ERROR] CMySQLHandler::Connect() - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (error ID: 2002). [12:02:11] [ERROR] CMySQLHandler::Statistics() - You cannot call this function now (connection is dead). [12:03:37] [ERROR] CMySQLHandler::Connect() - Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) (error ID: 2002). [12:03:37] [ERROR] CMySQLHandler::Statistics() - You cannot call this function now (connection is dead).

Und der Server Startet nichtmal...

And if I stand '127 .0.0.1 'in the script then starts the server, and then are the things in the logs there.

'server.cfg'
[expander]echo Executing Server Config...
lanmode 0
rcon_password egrergeeg
maxplayers 500
port 7777
hostname Test Server
gamemode0 script
plugins mysql_static.so crashdetect.so streamer.so sscanf.so nativechecker.so
filterscripts JunkBuster
announce 0
query 1
chatlogging 0
weburl www.sa-mp.com
onfoot_rate 40
incar_rate 40
weapon_rate 40
stream_distance 300.0
stream_rate 1000
maxnpc 200
logtimeformat [%H:%M:%S][/expander]

'mysql_log.txt'
[12:12:21] [WARNING] 'mysql_debug' is deprecated, use 'mysql_log' instead.


'server.log'
[expander]
----------
Loaded log file: "server_log.txt".
----------

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

[12:12:21]
[12:12:21] Server Plugins
[12:12:21] --------------
[12:12:21] Loading plugin: mysql_static.so
[12:12:21] plugin.mysql: R20 successfully loaded.
[12:12:21] Loaded.
[12:12:21] Loading plugin: crashdetect.so
[12:12:21] crashdetect v4.9 is OK.
[12:12:21] Loaded.
[12:12:21] Loading plugin: streamer.so
[12:12:21] Loaded.
[12:12:21] Loading plugin: sscanf.so
[12:12:21]

[12:12:21] ===============================

[12:12:21] sscanf plugin loaded.

[12:12:21] Version: 2.8.1

[12:12:21] © 2012 Alex "******" Cole

[12:12:21] ===============================

[12:12:21] Loaded.
[12:12:21] Loading plugin: nativechecker.so
[12:12:21] Loaded.
[12:12:21] Loaded 5 plugins.

[12:12:21]
[12:12:21] Filterscripts
[12:12:21] ---------------
[12:12:21] Loading filterscript 'JunkBuster.amx'...
[12:12:21] [junkbuster] Loading JunkBuster...
[12:12:21]
[12:12:21] [junkbuster] Current TL-System configuration:
[12:12:21] [junkbuster] - WeaponHack = 1
[12:12:21] [junkbuster] - MoneyHack = 1
[12:12:21] [junkbuster] - Jetpack = 1
[12:12:21] [junkbuster] - HealthHack = 1
[12:12:21] [junkbuster] - ArmourHack = 1
[12:12:21] [junkbuster] - DriveBy = 0
[12:12:21] [junkbuster] - Spam = 1
[12:12:21] [junkbuster] - CommandSpam = 0
[12:12:21] [junkbuster] - BadWords = 0
[12:12:21] [junkbuster] - CarJackHack = 0
[12:12:21] [junkbuster] - TeleportHack = 1
[12:12:21] [junkbuster] - MaxPing = 1000
[12:12:21] [junkbuster] - SpectateHack = 0
[12:12:21] [junkbuster] - Blacklist = 0
[12:12:21] [junkbuster] - IpBans = 0
[12:12:21] [junkbuster] - TempBans = 0
[12:12:21] [junkbuster] - SpawnKill = 1
[12:12:21] [junkbuster] - CapsLock = 1
[12:12:21] [junkbuster] - 3DSpeed = 0
[12:12:21] [junkbuster] - MaxSpeed = 550
[12:12:21] [junkbuster] - AdminImmunity = 1
[12:12:21] [junkbuster] - Advertisement = 0
[12:12:21] [junkbuster] - FreezeUpdate = 1
[12:12:21] [junkbuster] - SpawnTime = 10
[12:12:21] [junkbuster] - CheckpointTeleport = 1
[12:12:21] [junkbuster] - Airbrake = 100
[12:12:21] [junkbuster] - TankMode = 1
[12:12:21] [junkbuster] - WarnPlayers = 0
[12:12:21] [junkbuster] - SingleplayerCheats = 1
[12:12:21] [junkbuster] - MinFPS = 1
[12:12:21] [junkbuster] - DisableBadWeapons = 1
[12:12:21] [junkbuster] - CBug = 0
[12:12:21] [junkbuster] - AntiBugKill = 1
[12:12:21] [junkbuster] - NoReload = 1
[12:12:21] [junkbuster] - NoReloadForSawnOff = 1
[12:12:21] [junkbuster] - ActiveGMC = 2
[12:12:21] [junkbuster] - GMCBan = 0
[12:12:21] [junkbuster] - ServerSideHealth = 1
[12:12:21] [junkbuster] - CheckVMPos = 0
[12:12:21] [junkbuster] - QuickTurn = 1
[12:12:21] [junkbuster] - VehicleTeleport = 1
[12:12:21] [junkbuster] - Wallride = 170
[12:12:21] [junkbuster] - DisplayTextDraw = 1
[12:12:21] [junkbuster] - AFK = 0
[12:12:21] [junkbuster] - PickupTeleport = 1
[12:12:21] [junkbuster] - FlyHack = 40
[12:12:21] [junkbuster] - JunkBusterChrome = 0
[12:12:21] [junkbuster] - CheckWalkAnims = 1
[12:12:21] [junkbuster] - ReportMoneyHack = 0
[12:12:21] [junkbuster] - SpeedhackAdvanced = 20
[12:12:21] [junkbuster] - Joypad = 2
[12:12:21] [junkbuster] - ArmedVehicles = 0
[12:12:21] [junkbuster] - VehicleRepair = 2
[12:12:21] [junkbuster] - TuningHack = 1
[12:12:21] [junkbuster] - PayForGuns = 1
[12:12:21] [junkbuster] - SpawnVehicles = 2
[12:12:21] [junkbuster] - MaxTotalWarnings = 0
[12:12:21] [junkbuster] - TooManyWarningsAction = 0
[12:12:21] [junkbuster] - AirbrakeDetection = 1
[12:12:21] [junkbuster] - SpeedhackDetection = 1
[12:12:21]
[12:12:21] [junkbuster] 0 IP-bans have been loaded.
[12:12:21] [junkbuster] 0 temporary bans have been loaded.
[12:12:21] [junkbuster] 0 whitelist entries have been loaded.
[12:12:21] [junkbuster] 5 blacklist entries have been loaded.
[12:12:21] [junkbuster] 41 bad words have been loaded.
[12:12:21] [junkbuster] 4 forbidden weapons have been loaded.
[12:12:21] [junkbuster] System has been configurated.
[12:12:21] [junkbuster] JunkBuster (v11) has successfully been loaded.
[12:12:21] Loaded 1 filterscripts.

[12:12:21] Uptime: 1386402 Threads: 1 Questions: 599997 Slow queries: 0 Opens: 427 Flush tables: 1 Open tables: 107 Queries per second avg: 0.432
[12:12:21] [MySQL:] MySQL wurde erfolgreich geladen.
[12:12:21] function 'mysql_debug' is deprecated, use 'mysql_log' instead.
[12:12:21] Incoming connection: 127.0.0.1:47403
[12:12:21] BizzInfo:0 Owner:The State Message:~w~Gun Shop 1 Entfee:0 Till:0 Products:100/500 Interior:1.

[12:12:21] BizzInfo:1 Owner:The State Message:~w~Gun Shop 2 Entfee:0 Till:0 Products:100/500 Interior:4.

[12:12:21] BizzInfo:2 Owner:The State Message:~w~Restaurant Entfee:0 Till:0 Products:100/500 Interior:1.

[12:12:21] BizzInfo:3 Owner:The State Message:~B~ [][] Police ~G~ Armoury[][] Entfee:0 Till:0 Products:500/500 Interior:10.

[12:12:21] BizzInfo:4 Owner:The State Message:~w~City Bank Entfee:0 Till:0 Products:99999/100000 Interior:0.

[12:12:21] BizzInfo:5 Owner:The State Message:~w~City Bank Entfee:0 Till:0 Products:99999/100000 Interior:0.

[12:12:21] BizzInfo:6 Owner:The State Message:~w~City Bank Entfee:0 Till:0 Products:99999/100000 Interior:0.

[12:12:21] BizzInfo:7 Owner:The State Message:~w~City Bank Entfee:0 Till:0 Products:99999/100000 Interior:0.

[12:12:21] SBizzInfo:0 Owner:The State Message:~w~Car Renting 1 Commodity:0 Till:0 Products:99/100 Interior:0.

[12:12:21] SBizzInfo:1 Owner:The State Message:~w~Wang Cars Commodity:0 Till:0 Products:99/100 Interior:0.

[12:12:21] SBizzInfo:2 Owner:The State Message:~w~Phone Company Commodity:0 Till:0 Products:100/100 Interior:0.

[12:12:21] SBizzInfo:3 Owner:The State Message:~w~Gas Company Commodity:1 Till:0 Products:100/100 Interior:0.

[12:12:21] SBizzInfo:4 Owner:The State Message:~w~Electricity Company Commodity:0 Till:5 Products:100/100 Interior:0.

[12:12:21] SBizzInfo:5 Owner:The State Message:~w~Car Delivery Commodity:0 Till:50000 Products:99/100 Interior:0.

[12:12:21] SBizzInfo:6 Owner:The State Message:~w~House Upgrade Commodity:0 Till:0 Products:100/100 Interior:0.

[12:12:21] SBizzInfo:7 Owner:The State Message:~w~CNN Studio Commodity:0 Till:0 Products:100/100 Interior:0.

[12:12:21] SBizzInfo:8 Owner:The State Message:~w~Tow Car Service Commodity:0 Till:0 Products:100/100 Interior:0.

[12:12:21] SBizzInfo:9 Owner:The State Message:~w~General Store Commodity:0 Till:0 Products:100/100 Interior:0.

[12:12:21] SBizzInfo:10 Owner:The State Message:~w~Paintball Arena Commodity:0 Till:0 Products:100/100 Interior:0.

[12:12:21] SBizzInfo:11 Owner:The State Message:~w~Kart Track Commodity:0 Till:0 Products:99/100 Interior:0.

[12:12:21] SBizzInfo:12 Owner:The State Message:~w~Boat Renting Commodity:5000 Till:0 Products:96/100 Interior:0.

[12:12:21] IRC:0 Admin: MOTD: Password: NeedPass: 0 Lock: 0
[12:12:21] IRC:1 Admin: MOTD: Password: NeedPass: 0 Lock: 0
[12:12:21] IRC:2 Admin: MOTD: Password: NeedPass: 0 Lock: 0
[12:12:21] IRC:3 Admin: MOTD: Password: NeedPass: 0 Lock: 0
[12:12:21] IRC:4 Admin: MOTD: Password: NeedPass: 0 Lock: 0
[12:12:21] IRC:5 Admin: MOTD: Password: NeedPass: 0 Lock: 0
[12:12:21] IRC:6 Admin: MOTD: Password: NeedPass: 0 Lock: 0
[12:12:21] IRC:7 Admin: MOTD: Password: NeedPass: 0 Lock: 0
[12:12:21] IRC:8 Admin: MOTD: Password: NeedPass: 0 Lock: 0
[12:12:21] IRC:9 Admin: MOTD: Password: NeedPass: 0 Lock: 0
[12:12:21] CK:0 Taken: 0 Sendername:No-one Giveplayer: No-one
[12:12:21] CK:1 Taken: 0 Sendername:No-one Giveplayer: No-one
[12:12:21] CK:2 Taken: 0 Sendername:No-one Giveplayer: No-one
[12:12:21] CK:3 Taken: 0 Sendername:No-one Giveplayer: No-one
[12:12:21] CK:4 Taken: 0 Sendername:No-one Giveplayer: No-one
[12:12:21] CK:5 Taken: 0 Sendername:No-one Giveplayer: No-one
[12:12:21] CK:6 Taken: 0 Sendername:No-one Giveplayer: No-one
[12:12:21] CK:7 Taken: 0 Sendername:No-one Giveplayer: No-one
[12:12:21] CK:8 Taken: 0 Sendername:No-one Giveplayer: No-one
[12:12:21] CK:9 Taken: 0 Sendername:No-one Giveplayer: No-one
[12:12:21] AllowAdminTeleport() : function is deprecated. Please see OnPlayerClickMap()
[12:12:21]
[12:12:21]
[12:12:21] Copyright by Jaybinda
[12:12:21]
[12:12:21] Number of vehicle models: 159
[12:15:47] Incoming connection: 37.**.***.***:26854
[12:15:48] [join] Amssios has joined the server (127:37.**.***.***)
[12:15:51] 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 'Amssios' at line 1
[12:18:26] [part] Amssios has left the server (127:2)
[/expander]

[Misiur]

Quote:

syntax to use near 'Amssios' at line 1

You have passed a string parameter without quotes.
Something like

Quote:

SELECT dickbutt FROM users WHERE user = %e

While it should be

Quote:

SELECT dickbutt FROM users WHERE user = '%e'

[quelledave]

Quote:

Zitat: syntax to use near 'Amssios' at line 1 You have passed a string parameter without quotes. Something like Zitat: SELECT dickbutt FROM users WHERE user = %e While it should be Zitat: SELECT dickbutt FROM users WHERE user = '%e'

And how can I find out where I did that?

[Anzipane]

Check your MySQL queries, it seems that the problem appears when you connect, maybe try looking at OnPlayerConnect.