Log in

View Full Version : instanceid VS instance_id


Trackye
09-22-2015, 09:28 PM
It appears that in the source at times Instance_id is used and other times Instanceid.

My world sometimes throws up the error
Unknown column 'instanceid' in WHERE clause
SELECT id, charid FROM character_corpses WHERE instanceid = xx

Looking at the Database Character_corpses uses instance_id but it seems the server in this case is looking for the old format of instanceid.

Just a heads up.

Uleat
09-22-2015, 09:48 PM
A quick grepwin review only showed the one instance of this:
https://github.com/EQEmu/Server/blob/master/world/adventure.cpp#L386

- I don't have commit access atm...

AdrianD
09-23-2015, 01:38 AM
I've noticed the source doesn't use underscores when referring to the database. When the source queries the database then, it should be in line with it. Please correct me if I'm mistaken.

It looks like a typo.

Uleat
09-23-2015, 11:28 AM
There were player profile and database accessor changes that occurred at roughly the same time.

TBH, we've had very few issues from either system individually..much less both being co-deployed.