Check my mod for error

stapano00 · Aug 3, 2014

Hmm... I made a whole conversion of the technology,

but it won't work.

I've put IconAtlases, Technology, Flavor Everything (like action tab)

but it is not working.
Here is the DatabaseLog, a top part

Spoiler :

stapano00 · Aug 3, 2014

Hmm... I made a whole conversion of the technology,

but it won't work.

I've put IconAtlases, Technology, Flavor Everything (like action tab)

but it is not working.
Here is the DatabaseLog, a top part

Spoiler :

LeeS · Aug 3, 2014

Are you making a mod or are you directly editing the files that come with the game ?

stapano00 · Aug 4, 2014

A modbuddy mod not fixing xml of the game

Hm....

Nutty · Aug 4, 2014

Because you're deleting from the Technologies table, you need to reorder your entries. Add a SQL file with the following statements, and make sure it is added to the database (OnModActivated > UpdateDatabase) after Technologies.xml [this makes sure ID starts at 0, and that all your GridX entries are sorted properly].

Code:

CREATE TABLE IDRemapper ( id INTEGER PRIMARY KEY AUTOINCREMENT, Type TEXT );
INSERT INTO IDRemapper (Type) SELECT Type FROM Technologies ORDER BY GridX ASC;
UPDATE Technologies SET ID =	( SELECT IDRemapper.id-1 FROM IDRemapper WHERE Technologies.Type = IDRemapper.Type);
DROP TABLE IDRemapper;

EDIT: Your database errors have nothing to do with this. It looks like you're Adding rows to the Language view instead of Updating. And you're missing a BuildingClasses entry for the Ghetto.

stapano00 · Aug 4, 2014

How can i make a sql in the modbuddy and how can i add it?

By action tab?

LeeS · Aug 4, 2014

SQL is generally activated the same as XML with OnModActivated. I cannot remember if there any exceptions. Make an SQL file by "Add > New Item > SQL file "

stapano00 · Aug 4, 2014

Ok.. I added the sql file and the <id>, and it doesn't work.

stapano00 · Aug 4, 2014

i'LL POST MY TECHNOLOGY AND CAN YOU CHECK IT?

stapano00 · Aug 4, 2014

I posted it,

and added the sql file like this

tech~~~
sql~~~

yup

and

i'm making a total conversion mod so i need to fix it

(b/c i don't want the problem to be bigger)

calcul8or · Aug 5, 2014

One thing I noticed is that TECH_BREEDING and TECH_DAIRY have the same GridX and GridY settings; so do GRANARY and CALENDAR. I would think that's causing problems. I didn't check farther than that for other coordinate conflicts, you may want to do that

Nutty · Aug 5, 2014

LeeS said:
SQL is generally activated the same as XML with OnModActivated. I cannot remember if there any exceptions.

The order they appear in the Actions list governs the order in which they are loaded.

stapano00 said:
I posted it

Please attach your mod, it makes our lives a million times easier.

stapano00 · Aug 5, 2014

Here is the Mod,

I pulled out the art file because it has over 100megabyte.

I put iconatlases

and I hope you guys can find whats wrong with the MOD

Nutty · Aug 5, 2014

The first error comes from you putting <ID>0</ID> outside the <Row> tag.

However, the next error comes from <Delete /> not working (I thought that was how you delete an entire table with XML also, but I've personally only ever used SQL to do that). I added a new SQL file that loads BEFORE Technology.xml that contains one statement:

Code:

DELETE FROM Technologies;

...and that worked. Of course, you now have a bunch of bad references from other tables all over the database, and so CiV immediately crashes as soon as you try to found your first city.

EDIT: The quickie fix would be to use ~~a bunch of <DeleteMissingReferences table="tbl" column="col"/> entries~~--EDIT #2: sorry, make that one:

Code:

<DeleteMissingReferences table="Technologies" column="Type"/>

[at the end of your Technology.XML file (before </GameData>)]

Either way, it's going to cause some serious repercussions to game playability.

stapano00 · Aug 5, 2014

so do I just put the sql like this?

Spoiler :

and I don't understand

EDIT: The quickie fix would be to use a bunch of <DeleteMissingReferences table="tbl" column="col"/> entries, where tbl equals the part before the period and col equals the part after the period of all these:
AICityStrategies.TechPrereq
AIEconomicStrategies.TechObsolete
AIMilitaryStrategies.TechPrereq
Buildings.PrereqTech
Buildings.EnhancedYieldTech
Buildings.ObsoleteTech
Civilization_FreeTechs.TechType
Traits.PrereqTech
Traits.FreeUnitPrereqTech
HandicapInfo_AIFreeTechs.TechType
Processes.TechPrereq
Route_TechMovementChanges.TechType
Beliefs.SpreadModifierDoublingTech
Technology_TradeRouteDomainExtraRange.TechType
Technology_Flavors.TechType
Technology_PrereqTechs.PrereqTech
Technology_PrereqTechs.TechType
Improvement_TechYieldChanges.TechType
Improvement_TechNoFreshWaterYieldChanges.TechType
Improvement_TechFreshWaterYieldChanges.TechType
Resources.TechCityTrade
Resources.TechReveal

can you explain or show me the example?

Nutty · Aug 5, 2014

"DELETE FROM Technologies;" has to go into its own SQL file loaded BEFORE Technology.XML, where the rest must load AFTER.

Re: "<DeleteMissingReferences...>", sorry. See the edit.

stapano00 · Aug 5, 2014

so do I put <DeleteMissingReferences table="Technologies" column="Type"/>

this in <Technologies>(BLABLA)<DeleteMissingReferences table="Technologies" column="Type"/></Technologies>
and

<Technology_Flavor>(BLABLA0<DeleteMissingReferences table="Technology_Flavor" column="Type"/></Technology_Flavor>

like this?

Nutty · Aug 5, 2014

As I said, at the end of Technology.XML, immediately before </GameData> (outside of any table).

[It still crashes on attempting to found a city, however.]

EDIT: It's still getting the error "Duplicate column names detected in <Row>. Name: Row, Value: "

EDIT #2: Put all your other table deletes in the SQL file:

Code:

DELETE FROM Technologies;
DELETE FROM Technology_Flavors;
DELETE FROM Technology_PrereqTechs;
DELETE FROM Technology_FreePromotions;
DELETE FROM Technology_TradeRouteDomainExtraRange;

But there's still a duplicate hiding in there somewhere...

stapano00 · Aug 5, 2014

um.. If i put<DeleteMissingReferences table="Technologies" column="Type"/> this in

every of these

Spoiler :

would this work?

Nutty · Aug 5, 2014

No, that wouldn't be helpful.

This is why I use SQL; XML is so hard to troubleshoot.

EDIT: I've narrowed it down... the error is somewhere in the ~~atomic era (postmodern)~~ modern? Technologies table...

EDIT #2: The problem is TECH_PENICILIN. I can't figure out why, though!

EDIT #3: There it is: <GridY>1<</GridY>

(Note that TECH_ARMS_INSDUSTRY, besides being spelled wrong (as is Penicillin and many other entries), is using the quote from Advanced Architecture.)

Check my mod for error

Chieftain

Chieftain

Attachments

Imperator

Chieftain

Deity

Chieftain

Imperator

Chieftain

Chieftain

Chieftain

Attachments

Warlord

Deity

Chieftain

Attachments

Deity

Chieftain

Deity

Chieftain

Deity

Chieftain

Deity

Similar threads