Weird Problem with Rearranging the Tech Web

[Starrynite120]

I'm having a strange problem with rearranging the tech web. I've gotten rid of most leaf techs. Geophysics is on tier 2 directly down of Habitation. On tier 3 I placed Geoscaping, Planetary Engineering, and Astrodynamics. For some reason, with the below code none of these techs are recognizing any prerequisites, and I'm at a loss as to why. Anyone know why its not working?


INSERT INTO Technology_Connections(FirstTech, SecondTech) VALUES
('TECH_GEOPHYSICS', 'TECH_GEOSCAPING'),
('TECH_BIONICS', 'TECH_PLANETARY_ENGINEERING'),
('TECH_GEOPHYSICS', 'TECH_PLANETARY_ENGINEERING'),
('TECH_GEOPHYSICS', 'TECH_ASTRODYNAMICS'),
('TECH_BALLISTICS', 'TECH_ASTRODYNAMICS'),

UPDATE Technologies SET LeafTech = '0', Cost = 200, GridRadius = 2, GridDegrees = 90 WHERE Type = 'TECH_GEOPHYSICS'
UPDATE Technologies SET LeafTech = '0', Cost = 1000, GridRadius = 3, GridDegrees = 90 WHERE Type = 'TECH_GEOSCAPING';
UPDATE Technologies SET LeafTech = '0', Cost = 1000, GridRadius = 3, GridDegrees = 75 WHERE Type = 'TECH_PLANETARY_ENGINEERING';
UPDATE Technologies SET LeafTech = '0', Cost = 1000, GridRadius = 3, GridDegrees = 105 WHERE Type = 'TECH_ASTRODYNAMICS';

 

[Starrynite120]

Actually, all technology connections I write are not working right now. I really don't understand why.

 

[HandyVac]

Leaf techs should not have any values set for GridRadius or GridDegrees, that seems to confuse the game when it's trying to place them on the techweb screen.

Also, order is important when defining connections between leaf techs and branch techs. The Leaf must be FirstTech and the Branch SecondTech, or it will not display correctly.

Hope that helps.

 

[Starrynite120]

I somewhat fixed it. I found out anything I posted after

('TECH_GENETIC_MAPPING', 'TECH_SYNERGETICS');

was not working. Once I moved everything to before it it worked. Weird.

 

[Starrynite120]

HandyVac, yeah I realized that after having issues from it for about 2 hours, finally hunted down that problem. This one is not with leaf techs though because I set all of those techs as branch techs, though some were leaf's before.

 

[Machiavelli24]

INSERT INTO Technology_Connections(FirstTech, SecondTech) VALUES
('TECH_GEOPHYSICS', 'TECH_GEOSCAPING'),
('TECH_BIONICS', 'TECH_PLANETARY_ENGINEERING'),
('TECH_GEOPHYSICS', 'TECH_PLANETARY_ENGINEERING'),
('TECH_GEOPHYSICS', 'TECH_ASTRODYNAMICS'),
('TECH_BALLISTICS', 'TECH_ASTRODYNAMICS'),

I'm skeptical that this is your problem -- this sql wouldn't work because it doesn't have a ; on the end. However, since it is likely an except that does end in a ; than it isn't your underlying cause.

 

[Starrynite120]

Ah I see what I did. I started putting things after the ; thanks!