Error on the Italy map

[DD_Friar]

hi, i hope this has not been reported before.

when building the template i get an "scorced earth dcs alert" window.
ModDB.executeDBCommand: failed SQL...update.Airbases_set_control:
'g' where map='italy' AND Airbase_name=L aquila field'
error -2147217900
you have an error in your sql syntax





B16enk's server in a box. sedcs v3.1.1

DD_Frior

[IV/JG7_4Shades]

OK, that's a character mapping error. Open the Airbases table and change "L'Aquila" to "LAquila" as a quick workaround.

Cheers,
4Shades

[B16Enk]

Fire up the server.
On main screen, the Uniform server screen not SEOW, look in the left hand column under 'Tools'.
Click 'phpMyAdmin'
This opens a new window/tab with the title 'localhost/uniform server'

Again in the right hand column you will see a drop down box under 'Databases' click that and select 'SEOW'.
Once that has loaded in the right hand window you will see a series of tabs, click on the 'SQL' one.
You now have a large text area in the right hand column, paste this into it:

Code: Select all

UPDATE `airbases` SET `Airbase_Name` = 'LAquila Field', `Map` = 'Italy', `Airbase_Type` = 26, `ATC_Mode` = 'normal', `Takeoff_X` = 109936.6, `Takeoff_Y` = 113356.42, `Landing_X` = 111665.23, `Landing_Y` = 113943.73, `Station` = '', `Control` = 'n', `Fuel_Holding` = 0 WHERE  CONVERT(`airbases`.`Airbase_Name` USING utf8) = 'L''Aquila Field' AND CONVERT(`airbases`.`Map` USING utf8) = 'Italy' AND `airbases`.`Airbase_Type` = 26 AND CONVERT(`airbases`.`ATC_Mode` USING utf8) = 'normal' AND CONCAT(`airbases`.`Takeoff_X`) = 109936.6 AND CONCAT(`airbases`.`Takeoff_Y`) = 113356.42 AND CONCAT(`airbases`.`Landing_X`) = 111665.23 AND CONCAT(`airbases`.`Landing_Y`) = 113943.73 AND CONVERT(`airbases`.`Station` USING utf8) = '' AND CONVERT(`airbases`.`Control` USING utf8) = 'n' AND CONCAT(`airbases`.`Fuel_Holding`) = 0;

Then click 'GO' bottom right corner.
Job done, close that window.

[DD_Friar]

Job done, thank you chaps