Syntax Error

[Horem]

After spending hours and hours trying to track a couple of weird unhelpfull looking error's I thought I would share what I gained through my bug hunting.

This was the error:-

near "," Syntax Error

Had this listed twice, the first one related to a , in 1 of my art define files instead of a . like so:

		<Row>
			<Type>ART_DEF_UNIT_MEMBER_HOUSECARL_C</Type>
			<Scale>[COLOR="Red"]1,22[/COLOR]</Scale>
			<ZOffset>NULL</ZOffset>
			<Model>Art/housecarl_c.fxsxml</Model>
			<MaterialTypeTag>CLOTH</MaterialTypeTag>
			<MaterialTypeSoundOverrideTag>FLESH</MaterialTypeSoundOverrideTag>
		</Row>

Should have been:-

			<Scale>[COLOR="Red"]1.22[/COLOR]</Scale>

That was not to bad in tracking down with the SQLite Addon for Firefox. So I thought the second instance of the same error would be a similar typo, alas after many hrs of hunting through my sql files, and finding no other typo I decided to search through all my xmls too, to only find that I had left a field empty:-

		<Update>
			<Set Flavor="1"/>
			<Where AIGrandStrategyType=[COLOR="Red"]""[/COLOR] FlavorType="FLAVOR_EXPANSION"/>
		</Update>

Where it should have been:-

		<Update>
			<Set Flavor="1"/>
			<Where AIGrandStrategyType=[COLOR="Red"]"AIGRANDSTRATEGY_CULTURE"[/COLOR] FlavorType="FLAVOR_EXPANSION"/>
		</Update>

Hopefully this will help some other poor soul in trackign down them unhelpfull error messages in the database log.