Page 1 of 1
Error on the Italy map
Posted: Mon 15 Oct 2007 5:14 pm
by 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
Posted: Tue 16 Oct 2007 2:34 am
by 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
Posted: Tue 16 Oct 2007 7:18 am
by 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.
Posted: Wed 17 Oct 2007 10:30 am
by DD_Friar
Job done, thank you chaps