Bug Reports: SEDB70, MP4 v7.0.0, SEDCS v7.0.0

[II/JG54_Emil]

Not sure if this is a bug but when connecting to the DB with the DCS (v7.0.8 and also the earlier versions) I get this message:

Code: Select all

SEDCS::modUtilities.subLoadCampaignSettings: 3265: Ein Objekt, das dem angeforderten Namen oder dem Ordinalverweis entspricht, kann nicht gefunden werden.: SELECT * FROM Campaign_Settings;
Error : 3265
Description : Ein Objekt, das dem angeforderten Namen oder dem Ordinalverweis entspricht, kann nicht gefunden werden.

SEDCS::modUtilities.subLoadCampaignSettings: 3265: Ein Objekt, das dem angeforderten Namen oder dem Ordinalverweis entspricht, kann nicht gefunden werden.: SELECT * FROM Campaign_Settings;
Error : 3265
Description : Ein Objekt, das dem angeforderten Namen oder dem Ordinalverweis entspricht, kann nicht gefunden werden.

And whenever I select a different tab, I get the following, message:

Code: Select all

SEDCS::modDB.executeDBCommand: failed SQL ... UPDATE Campaign_Settings SET Mission_Length = 1, Duration_Air_Allied = 120, Duration_Ground_Allied = 120, Duration_Air_Axis = 120, Duration_Ground_Axis = 120, Idle_Aircraft = 10, Idle_Armour = 40, Idle_Artillery = 20, Idle_Engineer = 40, Idle_Shipping = 5, Idle_Vehicle = 20, Idle_Default = 30, Heavy_Rail_Freight = 1, HistorySFX_Mod = 1, Artillery_Furniture = 1, CCCI_Restriction = 1, 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 = 5000, Chief_Endpoints = 0, Active_SPGs = 1, Entrenchments = 50, Upload_Files = 0, Auto_Archive_Folder = 'undefined', Web_Service_URL = 'undefined';
Error : -2147217900
Description : [MySQL][ODBC 3.51 Driver][mysqld-5.5.34-0ubuntu0.13.04.1]Unknown column 'Entrenchments' in 'field list'

Ah and the one who reads has an advantage...
This fixed it:
http://seowhq.net/seowforum/viewtopic.php?t=1063

[IV/JG7_4Shades]

New DCS v7.0.8, New MP update v7.0.24, new Statistics update v7.0.10

Hotkeys
Scannon suggested that we should put hotkeys into the MP to support rapid waypoint editing etc. This MP update has contextual support for case-sensitive hotkeys. This allows planners to:

• select waypoint tasks with a single key click
• delete the latest waypoint with a single key click
• activate any of the logistics tools with a shift+key click

A green icon with a white "H" shows active hotkey data.

Statistics
Factory plates are now widely used in SEOW campaigns, but they have not been well supported in the Statistics engine, until now. From v7.0.10 of the Statistics engine, the following features are available:

The statistics pages can be configured to display damage data on combat events for ships and factory plates, using the following setting in the MP-StatisticsMetadata.php file. Set it to true if display is required, false to hide it (default).

Code: Select all

$StatsShowDamage = false;

Pilot pages also count all damage successes against factories and also tally up the production points lost by the enemy, based on production rates and damage repair times.

These Statistics features require DCS v7.0.8 to be used to write the damage percentages into the ActionData table for later use by the Statistics engine.

Cheers,
4S

[SirAthlon]

Hi all,
I always get this error message, what should I do exactly to fix the error. (SEDCS 7.0.3 - 7.0.10)

Code: Select all

SEDCS::modUtilities.subLoadCampaignSettings: 3265: Ein Objekt, das dem angeforderten Namen oder dem Ordinalverweis entspricht, kann nicht gefunden werden.: SELECT * FROM 

Campaign_Settings;
Error : 3265
Description : Ein Objekt, das dem angeforderten Namen oder dem Ordinalverweis entspricht, kann nicht gefunden werden.

SEDCS::modUtilities.subLoadCampaignSettings: 3265: Ein Objekt, das dem angeforderten Namen oder dem Ordinalverweis entspricht, kann nicht gefunden werden.: SELECT * FROM 

Campaign_Settings;
Error : 3265
Description : Ein Objekt, das dem angeforderten Namen oder dem Ordinalverweis entspricht, kann nicht gefunden werden.

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 = 1, 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, Upload_Files = 0, Auto_Archive_Folder = 'undefined', Web_Service_URL = 'undefined';
Error : -2147217900
Description : [MySQL][ODBC 3.51 Driver][mysqld-5.5.8]Unknown column 'Entrenchments' in 'field list'

second trouble, in the mission planner, I have no icons on the map?
The change of phates but bring nothing! as below altered by me.


//This MUST be a web server virtual absolute pathname - it CANNOT be a Windows pathname
$IconLocation="127.0.0.1/SEOW/MP4public/uniticons/";



sry for my bad english

SirAthlon

[IV/JG7_4Shades]

Servus Athlon!

Problem 1: you have a mist-match between your DCS and your DB. Your DCS is expecting some revisions to the DB that are not there. Make sure you have applied all the "SEDB Update Scripts" that are listed in the sticky thread in this forum.

Problem 2: This is similar to problem 1. Try your MP again after applying the update scripts to the DB. Finally, in your $IconLocation value you should probably always use "localhost" instead of "127.0.0.1"


If you still have problems please tell me your DB, CS and MP versions.

Cheers,
4S

PS: I will shortly release a new DB set, once I have Thor's new Kursk map information.