Register schlägt fehl

exiLe

Guten Abend Community
ich bekomme ständig den selben Fehler und ich schaffe es nicht ihn zu fixen.
Wäre Lieb wenn ich eure Hilfe bekommen könnte.

Fehlercode:

Bash

[2016-11-17 22:58:07] ERROR: register_login_server.lua:782: attempt to index local 'dsatz' (a nil value)
[2016-11-17 22:58:07] WARNING: register_login_server.lua:186: dbExec failed; (1364) Field 'Spezial' doesn't have a default value
[2016-11-17 22:58:07] WARNING: register_login_server.lua:778: dbExec failed; (1364) Field 'Spezial' doesn't have a default value
[2016-11-17 22:58:16] QUIT: exiLe left the game [Quit]
[2016-11-17 22:58:16] ERROR: data_server.lua:31: attempt to concatenate a boolean value

Zeilen: (register_login)

Lua

local result = dbExec ( handler, "INSERT INTO inventar (UID) VALUES (?)", id )
				if not result then
					outputDebugString ( "[register_func 3] Error executing the query" )
				end

Lua

function inventoryload ( player )


	local pname = getPlayerName ( player )
	vioSetElementData ( player, "playerid", playerUID[pname] )


	local dsatz
	local result = dbPoll ( dbQuery ( handler, "SELECT * from inventar WHERE UID = ?", playerUID[pname] ), -1 )
	if not result or not result[1] then
		dbExec ( handler, "INSERT INTO inventar (UID) VALUES (?)", playerUID[pname] )
		result = dbPoll ( dbQuery ( handler, "SELECT * from inventar WHERE UID = ?", playerUID[pname] ), -1 )
	end
	dsatz = result[1]
	if dsatz["Wuerfel"] then
		vioSetElementData ( player, "dice", tonumber ( dsatz["Wuerfel"] ) )
	else
		vioSetElementData ( player, "dice", 0 )
	end
	vioSetElementData ( player, "flowerseeds", tonumber ( dsatz["Blumensamen"] ) )
	vioSetElementData ( player, "food1", tonumber ( dsatz["Essensslot1"] ) )
	vioSetElementData ( player, "food2", tonumber ( dsatz["Essensslot2"] ) )
	vioSetElementData ( player, "food3", tonumber ( dsatz["Essensslot3"] ) )
	vioSetElementData ( player, "zigaretten", tonumber ( dsatz["Zigaretten"] ) )
	vioSetElementData ( player, "mats", tonumber ( dsatz["Materials"] ) )
	vioSetElementData ( player, "benzinkannister", tonumber ( dsatz["Benzinkanister"] ) )
	vioSetElementData ( player, "fruitNotebook", tonumber ( dsatz["FruitNotebook"] ) )
	vioSetElementData ( player, "casinoChips", tonumber ( dsatz["Chips"] ) )
	vioSetElementData ( player, "gameboy", tonumber ( dsatz["Gameboy"] ) )
	vioSetElementData ( player, "medikits", tonumber ( dsatz["Medikit"] ) )
	vioSetElementData ( player, "repairkits", tonumber ( dsatz["Repairkit"] ) )
	-- X-MAS --
	-- vioSetElementData ( player, "presents", tonumber ( dsatz["Geschenke"] ) )
	-- X-MAS --
end

Alles anzeigen

Zeilen (data_server)

Lua

function saveAddictionsForPlayer ( player )


	local pname = getPlayerName ( player )
	local dataString1 = vioGetElementData ( player, "cigarettFlushPoints" ).."|"..vioGetElementData ( player, "alcoholFlushPoints" ).."|"..vioGetElementData ( player, "drugFlushPoints" ).."|"
	local dataString2 = vioGetElementData ( player, "cigarettAddictPoints" ).."|"..vioGetElementData ( player, "alcoholAddictPoints" ).."|"..vioGetElementData ( player, "drugAddictPoints" ).."|"
	dbExec ( handler, "UPDATE ?? SET ??=?, ??=? WHERE ??=?", "userdata", "Rausch", dataString1, "Sucht", dataString2, "UID", playerUID[pname] )
end

Über eure Hilfe freue ich mich.

LG exiLe

Jetzt mitmachen!