Cant figure out the error on my mod?

[cof125]

Please all the database log say's is Update syntax error no idea where or what it is. If anyone could help that would be great.

 

[LeeS]

Update TriggeredBehaviorTrees SET Priority = 1 Where TriggerType = 'TRIGGER_CAPTURE_BARBARIAN'


Insert Into RequirementSets (RequirementSetId,RequirementSetType) Values
('GAME_SPEED_QUICK','REQUIREMENTSET_TEST_ALL')
('GAME_SPEED_ONLINE','REQUIREMENTSET_TEST_ALL');

Insert Into Requirements (RequirementId,RequirementType) Values
('GAME_SPEED_QUICK','REQUIREMENT_GAME_SPEED_QUICK')
('GAME_SPEED_ONLINE','REQUIREMENT_GAME_SPEED_ONLINE');

You are missing the needed semi-colon in the first chunk and needed commas at the end of lines in the second and third chunks of code.

When database.log gives you a syntax error message like the one you said you are getting, then the problem is in an SQL fle. You need to compare the timestamp at the beginning of the error message to timestamps in file modding.log to determine which file was being handled at about the same point in time. Then you need to closely inspect the indicated SQL file for syntax errors.

Also bear in mind that if an SQL or XML file contains multiple syntax errors, the game ceases to read anything further from within that file upon hitting the first such error. So fixing the topmost error you find within a file does not always cure the issue -- it just allows the game to hit the 2nd such syntax error before erroring. This is why you need to try to look through the entire file even after you think you found the error that was causing the message in Database.log, or else be ready to make multiple tries at getting the mod to load properly repeating the process of eliminating one error, discovering another, fixing, rinse, repeat.

----

I only looked through one of your SQL files. The other may have errors as well.

 

[cof125]

Crap really