MySQL error with darkrp_position

[mcNuggets1]

Description of the bug

Jail positions are bugged for some reason. I didn't modify anything about the table in mysql.

How to make the bug happen

Unknown

Lua errors

Lua Error: gamemodes/darkrp/gamemode/libraries/mysqlite/mysqlite.lua:265: Unknown column 'T' in 'where clause' (DELETE FROM darkrp_position WHERE type = 'J' AND map = "rp_retribution_v2";)

Why the developer of DarkRP is responsible for this issue

darkrp_position table

[FPtje]

Head to the forums: forum.darkrp.com

[mcNuggets1]

Wait, no. This is not a an issue I provoked at all.

I didn't do anything to the mysql tables.

This error occured by themself and prevents deleting positions. I couldn't yet reproduce why it happens, but it has something to do with jail positions, I think.

[FPtje]

The error happens either when setting a jail position, or when an addon does something weird.

The error is whack too, by the way. The 'T' referenced by the error does not occur in the query. Could you do some debugging?

[mcNuggets1]

I did most of my addons myself. Nowhere I fuck with the darkrp mysql tables.

I will try to reproduce, this issue is ancient btw, I had it happen over years, I just cleared the columns all the time.

[mcNuggets1]

I have reset the entire table now, let's see if it occurs again, will report back sooner or later.

[FPtje]

Does the Lua error have a stack trace by the way?

[mcNuggets1]

No. It's a mysql error.

[FPtje]

It should be re-thrown as a Lua error, which should give a stack trace

[mcNuggets1]

no, it's just that.

https://i.imgur.com/vhmBYxy.png

[FPtje]

That may be your log file being inaccurate. Turn on lua_log_sv 1 and see if that shows the entire stack trace.

[Kefta]

Stack traces aren't displayed for errors in callbacks since it's originating from a C call.

[FPtje]

Ah that's true. I'm still mystified by the error itself though. Column T, What column T?

[mcNuggets1]

It's back.

Lua Error: gamemodes/darkrp/gamemode/libraries/mysqlite/mysqlite.lua:265: Unknown column 'T' in 'where clause' (DELETE FROM darkrp_position WHERE type = 'J' AND map = "rp_bangclaw";)

I didn't do anything.