
This has happened to about 50% of my maps now. Only the top 4 rows render and then half of the next. When I close the editor while on one of these maps it tells me "Operation is not allowed when object is open" and highlights
Code:
DB_RS.Open "SELECT id FROM npcs ORDER BY id DESC LIMIT 1", DB_Conn, adOpenStatic, adLockOptimistic
The database is not already open, nothing is accessing it. It is a completely stock editor with a completely stock database, the only difference is that there are more entries, but there are no syntax errors anywhere or alterations to any of the tables.
It seems to make my map's lifespans around 2 months until they get this issue and then never return to the living. Which is highly annoying, because if I don't find a solution I'll be remapping around a hundred maps eventually.
I can't find the solution and it's driving me crazy.