Bug: Missing delimeter in SQL Statement

For bug reports and fixes, installation issues, and new ideas for technical features.

Moderator: SEOW Developers

Post Reply
II./JG1_Krupinski
Posts: 37
Joined: Wed 17 Oct 2007 9:18 pm

Bug: Missing delimeter in SQL Statement

Post by II./JG1_Krupinski »

There is a unwanted feature in DCS 3.1.3.

In the screenshot listed below notice the missing field delimiter in the sql statement right before the AND,

... WHERE Obj_Group_Name = 'Kriegsmarine09 AND ...

http://www.fly-eaglesnest.com/downloads ... _error.JPG

This error occurres everytime I build a new mission.

Is there some work around I can try in 3.1.3? I dont want to go to 3.1.4 quite yet.

Best regards,

Raven
IV/JG7_4Shades
Posts: 2211
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

Post by IV/JG7_4Shades »

Yes, there is a broken SQL query right there in the Supply tracking code. It is missing a quotation mark ' right after Kriegsmarin09. No work around. The fuel update calculation for that unit will fail. I think that is fixed for 3.1.4. Hopefully it won't cause lasting problems for your 3.1.3 campaign.

Cheers,
4Shades
IV/JG7_4Shades
SEOW Developer

Image
II./JG1_Krupinski
Posts: 37
Joined: Wed 17 Oct 2007 9:18 pm

Post by II./JG1_Krupinski »

IV/JG7_4Shades wrote:Yes, there is a broken SQL query right there in the Supply tracking code. It is missing a quotation mark ' right after Kriegsmarin09. No work around. The fuel update calculation for that unit will fail. I think that is fixed for 3.1.4. Hopefully it won't cause lasting problems for your 3.1.3 campaign.

Cheers,
4Shades
Can I run the statement manually?
IV/JG7_4Shades
Posts: 2211
Joined: Mon 08 Jan 2007 11:10 pm
Location: Perth, Western Australia

Post by IV/JG7_4Shades »

Yes, as long as you put the missing quote mark in.

As I recall, the broken query code lies in the Task Force update function.

Cheers,
4Shades
IV/JG7_4Shades
SEOW Developer

Image
Post Reply