Jump to content

Database Result Uncolllected After 5 Minutes Error!


Ramsey

Recommended Posts

Posted

Hi everbody!

There is an error in the system I built and the debug window repeats continuously.

/debugscript 3 said:
Database Result Uncolllected After 5 Minutes Error! ( customS.lua:54 )

 

Codes:

Spoiler

 


addEvent("removeTemplate",true)
addEventHandler("removeTemplate",root,function(player,dbid)

	if dbQuery(connection,"DELETE FROM inttemplates WHERE dim=?",getElementDimension(player)) then

		dbExec(connection, "UPDATE interiors SET fee = ? WHERE id = ?",0,getElementDimension(player))
		loadOneInteriorWhereID(getElementDimension(player))
		
		for k, v in ipairs(getElementsByType("object")) do
			if getElementDimension(v) == getElementDimension(player) then
				destroyElement(v)
				triggerClientEvent(player,"send->template",player,"nothing")

				dbQuery(connection,"DELETE FROM intobjects WHERE dim=?",getElementDimension(player))

			end
		end

		for k,v in ipairs(getElementsByType("marker")) do
			if getElementData(v,"doorMarker") then
				if getElementDimension(v) == getElementDimension(player) then
					destroyElement(v)
				end
			end
		end
	end

 

Posted (edited)

Always use

dbFree()

after every dbQuery() function.

local query = dbQUery()
dbFree (query)

 

Edited by MadnessReloaded

tJ5zeFm.gif

Proud owner and developer of ZNEXT: Aftermath.

Enter a post-apocalyptic San Andreas and fight over 30 types of enemies and bosses with varying difficulties and skills, improve and customize your character by leveling up, completing challenges and a solid lootbox system with no Pay-to-Win mechanics that will break your experience.

Meet new characters, creatures and weapon metas, experience an innovative combo-based melee system, or join our solid PvP modes to show other survivors who’s boss. 

Español, Pусский, Türk, عربى, Polski, Português

IP: mtasa://104.36.110.227:22003 - Discord: https://discord.gg/CxMxjvC5pB

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...