Bledy w konsoli

[Dzanar2]

Witam. Uzywam systemu debian linux wersja serwera to TFS 0.3.4 kompilowana z najnowszego rev z private SVN i w konsoli pojawiaja sie takie rzeczy.

mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 11112900 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)
mysql_real_query(): DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = 11112900 ORDER BY `time` LIMIT 1); - MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)

Wie ktos co moze byc tego powodem i jak sobie z tym poradzic bo ja nie mam pomyslu.

 

[KaczooH]

A ja mam. Przeczytaj MYSQL ERROR i przemysl co to znaczy...

 

[slaw]

W mysql uzywasz query do sqlite [?]

 

[Dzanar2]

No wlsnie sam jestem zdziwiony czemu tak sie dzieje ;| Tu jak cos podaje moj plik playerdeath.lua

local config = {
	deathListEnabled = getBooleanFromString(getConfigInfo('deathListEnabled')),
	sqlType = getConfigInfo('sqlType'),
	maxDeathRecords = getConfigInfo('maxDeathRecords')
}

config.sqlType = config.sqlType == "sqlite" and DATABASE_ENGINE_SQLITE or DATABASE_ENGINE_MYSQL

function onDeath(cid, corpse, lastHitKiller, mostDamageKiller)
	if(config.deathListEnabled ~= TRUE) then
		return
	end

	local hitKillerName = "field item"
	local damageKillerName = ""
	if(lastHitKiller ~= FALSE) then
		if(isPlayer(lastHitKiller) == TRUE) then
			hitKillerName = getPlayerGUID(lastHitKiller)
		else
			hitKillerName = getCreatureName(lastHitKiller)
		end

		if(mostDamageKiller ~= FALSE and mostDamageKiller ~= lastHitKiller and getCreatureName(mostDamageKiller) ~= getCreatureName(lastHitKiller)) then
			if(isPlayer(mostDamageKiller) == TRUE) then
				damageKillerName = getPlayerGUID(mostDamageKiller)
			else
				damageKillerName = getCreatureName(mostDamageKiller)
			end
		end
	end

	db.executeQuery("INSERT INTO `player_deaths` (`player_id`, `time`, `level`, `killed_by`, `altkilled_by`) VALUES (" .. getPlayerGUID(cid) .. ", " .. os.time() .. ", " .. getPlayerLevel(cid) .. ", " .. db.escapeString(hitKillerName) .. ", " .. db.escapeString(damageKillerName) .. ");")
	local rows = db.getResult("SELECT `player_id` FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. ";")
	if(rows:getID() ~= -1) then
		local amount = rows:getRows(true) - config.maxDeathRecords
		if(amount > 0) then
			if(config.sqlType == DATABASE_ENGINE_SQLITE) then
				for i = 1, amount do
					db.executeQuery("DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. " ORDER BY `time` LIMIT 1);")
				end
			else
				db.executeQuery("DELETE FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. " ORDER BY `time` LIMIT " .. amount .. ";")
			end
		end
	end
end

 

[darex11]

A ja mam. Przeczytaj MYSQL ERROR i przemysl co to znaczy...

@OFFTOPIC
Twoje posty normalnie mnie rozwalaja, piszesz aby pisac, a nie pomagasz. Jezeli tak bardzo chcesz pisac zapraszam do hydepark bo do pisania w tematach sie nie nadajesz, nadajesz sie do offtopicow ; ]

@TOPIC

- MYSQL ERROR: Unknown column 'rowid' in 'where clause' (1054)

Blad wyraznie pokazuje iz 'rowid' jest nieznana kolumna - czyli jej nie masz ; ] Dlaczego ? bo ustawiles w configu ze chcesz uzywac sqlite, a uzywasz mysql.
Zmien:

config.sqlType = config.sqlType == "sqlite"

na:

config.sqlType = config.sqlType == "mysql"

Jezeli nie pomoze, zamien zawartosc swojego pliku z tym:

local config = {
	deathListEnabled = getBooleanFromString(getConfigInfo('deathListEnabled')),
	sqlType = getConfigInfo('sqlType'),
	maxDeathRecords = getConfigInfo('maxDeathRecords')
}
function onDeath(cid, corpse, lastHitKiller, mostDamageKiller)
	if(config.deathListEnabled == TRUE) then
		local hitKillerName = "field item"
		local damageKillerName = ""
		if(lastHitKiller ~= FALSE) then
			if(isPlayer(lastHitKiller) == TRUE) then
				hitKillerName = getPlayerGUID(lastHitKiller)
			else
				hitKillerName = getCreatureName(lastHitKiller)
			end

			if(mostDamageKiller ~= FALSE and mostDamageKiller ~= lastHitKiller and getCreatureName(mostDamageKiller) ~= getCreatureName(lastHitKiller)) then
				if(isPlayer(mostDamageKiller) == TRUE) then
					damageKillerName = getPlayerGUID(mostDamageKiller)
				else
					damageKillerName = getCreatureName(mostDamageKiller)
				end
			end
		end

		db.executeQuery("INSERT INTO `player_deaths` (`player_id`, `time`, `level`, `killed_by`, `altkilled_by`) VALUES (" .. getPlayerGUID(cid) .. ", " .. os.time() .. ", " .. getPlayerLevel(cid) .. ", " .. db.escapeString(hitKillerName) .. ", " .. db.escapeString(damageKillerName) .. ");")
		local rows = db.getResult("SELECT `player_id` FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. ";")
		if(rows:getID() ~= -1) then
			local amount = (rows:numRows(true) - config.maxDeathRecords)
			if(amount > 0) then
				if(config.sqlType == "sqlite") then
					for i = 1, amount do
						db.executeQuery("DELETE FROM `player_deaths` WHERE `rowid` = (SELECT `rowid` FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. " ORDER BY `time` LIMIT 1);")
					end
				else
					db.executeQuery("DELETE FROM `player_deaths` WHERE `player_id` = " .. getPlayerGUID(cid) .. " ORDER BY `time` LIMIT " .. amount .. ";")
				end
			end
		end
	end
end

Dziala na 100% :]

 

[Dzanar2]

AAA dzieki za odpowiedz. Nie zauwazylem tego myslalem ze wystarczy ze ustawilem to w config.lua i ze tu bedzie funkcja pobierajaca to co uzytkownik ustawil sobie w config.lua

EDIT:
A jednak jest tylko troszke zle napisane jest to poprawilem i dziala dzieki za pomoc.

 

[darex11]

Wiec prosze o reputa ; ]