package frontaccounting 2.2.10-3 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1

[Michael Lager]

On ubuntu 12.04, AMD64:
 using apt-get to install reported at end:

Setting up frontaccounting (2.2.10-3) ...
ERROR 1064 (42000) at line 12: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=2' at line 7
dpkg: error processing frontaccounting (--configure):
 subprocess installed post-installation script returned error exit status 1
E: Sub-process /usr/bin/dpkg returned an error code (1)

Expected behaviour:L no error.

ProblemType: Package
DistroRelease: Ubuntu 12.04
Package: frontaccounting 2.2.10-3
ProcVersionSignature: Ubuntu 3.2.0-27.43-generic 3.2.21
Uname: Linux 3.2.0-27-generic x86_64
ApportVersion: 2.0.1-0ubuntu12
AptOrdering:
 frontaccounting: Install
 frontaccounting: Configure
Architecture: amd64
Date: Sun Aug 12 23:25:36 2012
DpkgTerminalLog:
 Unpacking frontaccounting (from .../frontaccounting_2.2.10-3_all.deb) ...
 Setting up frontaccounting (2.2.10-3) ...
 ERROR 1064 (42000) at line 12: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=2' at line 7
 dpkg: error processing frontaccounting (--configure):
  subprocess installed post-installation script returned error exit status 1
DuplicateSignature:
 Setting up frontaccounting (2.2.10-3) ...
 ERROR 1064 (42000) at line 12: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=2' at line 7
 dpkg: error processing frontaccounting (--configure):
  subprocess installed post-installation script returned error exit status 1
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
PackageArchitecture: all
SourcePackage: frontaccounting
Title: package frontaccounting 2.2.10-3 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
UpgradeStatus: No upgrade log present (probably fresh install)

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Terje Andersen (terander)]

Looks to be fixed upstream:

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=682249