SEDCS 7.3.25 - Errors after connecting to Database / Campaign Settings
Posted: Tue 15 Oct 2024 8:40 pm
I've come back after a while, had reinstalled my OS, and I've either forgot something or run into some issues with SEDCS and SEDB...
Any campaign I try to load the .sql from in SEDB75 seems to give me these errors, but I feel like I may have screwed up something when installing MariaDB and playing with the my.ini
After connecting to my DB I get these errors in SEDCS every time I switch tabs or try to do something. Evidently something is wrong with my Campaign_Settings table?
Edit: I am using mariadb-10.4.25-winx64
Any campaign I try to load the .sql from in SEDB75 seems to give me these errors, but I feel like I may have screwed up something when installing MariaDB and playing with the my.ini
After connecting to my DB I get these errors in SEDCS every time I switch tabs or try to do something. Evidently something is wrong with my Campaign_Settings table?
Code: Select all
SEDCS::modDB.executeDBCommand: failed SQL ... UPDATE Campaign_Settings SET Mission_Length = 1, Duration_Air_Allied = 60, Duration_Ground_Allied = 60, Duration_Air_Axis = 60, Duration_Ground_Axis = 60, Idle_Aircraft = 10, Idle_Armour = 40, Idle_Artillery = 20, Idle_Engineer = 40, Idle_Shipping = 5, Idle_Vehicle = 20, Idle_Default = 30, Heavy_Rail_Freight = 0, HistorySFX_Mod = 0, Artillery_Furniture = 100, CCCI_Restriction = 0, Radar = 0, Radar_Ground_Allied = 0, Radar_Ship_Allied = 0, Radar_IFF_Allied = 0, Radar_Ground_Axis = 0, Radar_Ship_Axis = 0, Radar_IFF_Axis = 0, Runway_Lights = 100, Ace_Charisma = 1, Create_Supply_Points = 0, Enemy_Proximity = 500, Landing_Penalties = 0, Lock_Production_Allied = 0, Lock_Production_Axis = 0, Lock_Dissolve = 0, Forward_Supply = 0, Coop_Mod_Slot = 0, Supply_Drop_Limit = 0, Dead_Zone = 0, Single_Player_Mode = 0, Weak_Force = 2, Overwhelming_Force_Ratio = 5, Delegation_Mode = 0, Combat_Effectiveness = 1, Ground_Skill_Updates = 0, Freight_Radius = 3000, Chief_Endpoints = 0, Active_SPGs = 1, Entrenchments = 50, Use_Triggers = 0, Meta_Mode = 2, Observation_Cameras = 1, Meta_DMZ_Width = 1000, Barrage_Time_Delay = 2, Upload_Files = 0, Auto_Archive_Folder = 'undefined', Initialization_Mode = 0, Web_Service_URL = 'undefined';
Error : -2147217900
Description : [MySQL][ODBC 3.51 Driver][mysqld-5.5.5-10.4.25-MariaDB-log]Unknown column 'Barrage_Time_Delay' in 'field list'<p>
Code: Select all
SEDCS::modUtilities.subLoadCampaignSettings: 3265: Item cannot be found in the collection corresponding to the requested name or ordinal.: SELECT * FROM Campaign_Settings;
Error : 3265
Description : Item cannot be found in the collection corresponding to the requested name or ordinal.<p>