SOLVED

[DoppioConPanda]

Why does the following XML code work but the seemingly identical SQL does not? I hate XML, but if that's the only way to get it to work, so be it.

<GameData>
  <Improvement_TechYieldChanges>
    <Row>
      <ImprovementType>IMPROVEMENT_MINE</ImprovementType>
      <TechType>TECH_STEEL</TechType>
      <YieldType>YIELD_PRODUCTION</YieldType>
      <Yield>1</Yield>
    </Row>
  </Improvement_TechYieldChanges>
</GameData>"

Vs.

INSERT INTO Improvement_TechYieldChanges (ImprovementType, TechType, YieldType, Yield)
    VALUES ('IMPROVEMENT_MINE', 'TECH_STEEL', 'YIELD_PRODUCTION', 1);

 

[LeeS]

what is in Database.log ?

Is there anything else higher up in the SQL file that might contain a syntax error ?

Are you sure your SQL file is even being executed by the game ?
(ie, have you forgotten to add a OnModActivated -- UpdateDatabase for that file when attempting the SQL code)

 

[DoppioConPanda]

I'm unfamiliar with database.log. Wanna point me in the right direction? I'll try running the code as its own file, but I'm 100% certain the rest of the file works. Thanks for the speedy response.

EDIT: It works fine as its own file. Must be an error in the file, but everything above is working as intended... Line by line dissection it is then. 99 glitches and bugs in the code, 99 glitches and bugs, you take one down, you patch it around, 106 glitches and bugs in the code.

 

[LeeS]

If you're unfamiliar with Database.log then you've probably never enabled error logging. Use this tutorial, which shows you how to enable logging and how to use it: whoward69's enable error logging tutorial

 

[DoppioConPanda]

Whoward is a godsend. I've used so many of his tutorials. That guy knows everything, I swear! Thanks.

Edit: FOUND IT HOLY COW