_condition in select statement in ver 801

[Thristam]

Im getting the following error when trying to run version 7.0.801

[Error] Error in PopulateZoneLists query 'SELECT id, spawngroupID, x, y, z, head
ing, respawntime, variance, pathgrid, timeleft, _condition, cond_value FROM spaw
n2 WHERE zone='felwithea'': #1054: Unknown column '_condition' in 'field list'
[Error] Loading spawn2 points failed.

_condition is not set in the DB Schema in the newest PEQ DB, but condition is.....is this column renamed and not changed on the schema? or is this an issue where _ got added to the front by accident?

[aza77]

http://www.eqemulator.net/releases/logs/EQEmu-0.7.0-801.txt

that should help ;)

ALTER TABLE spawn2 CHANGE `condition` `_condition` MEDIUMINT(8) UNSIGNED NOT
NULL DEFAULT '0';

[Thristam]

Thanks for the replay, but i was more concerned that there was a disparity between the daily db schema and the new code:

http://www.projecteq.net/sql/ shows spawn2 with condition instead of _condition

Im just worried its a typo and after i change this there going to change it back to plain ol condition.

[aza77]

it's not a typo .. condition is a keyword at mysql5 and got changed to _condition to make the server compatible with both mysql4 and 5

[fathernitwit]

the scheme on the PEQ site is a reflection of what is currently running on PEQ, and these changes have not yet made it there. Nothing to be concerned about. The changelog is always the authority for the latest code.