Thawab crashes when converting .bok files in Ubuntu 12.10

[أحمد المحمودي (Ahmed El-Mahmoudy)]

Thawab crashes when converting .bok files in Ubuntu 12.10. This is the error that gets printed on terminal:

mdb-schema: invalid option -- 'S'
create table [main]
 (
 [bkid] ineteger,
 [bk] text ,
 [betaka] text ,
 [inf] text ,
 [auth] text ,
 [authinf] text ,
 [tafseernam] text ,
 [islamshort] ineteger,
 [onum] ineteger,
 [over] ineteger,
 [seal] text ,
 [oauth] ineteger,
 [bver] ineteger,
 [pdf] ineteger,
 [oauthver] ineteger,
 [vername] text ,
 [cat] text ,
 [lng] text ,
 [higrid] text ,
 [ad] ineteger,
 [aseal] text ,
 [blnk] text ,
 [pdfcs] ineteger,
 [shrtcs] ineteger,bkid INTEGER, bk TEXT, shortname TEXT, cat INTEGER, betaka TEXT, inf TEXT, bkord INTEGER DEFAULT -1, authno INTEGER DEFAULT 0, auth TEXT, authinfo TEXT, higrid INTEGER DEFAULT 0, ad INTEGER DEFAULT 0, islamshort INTEGER DEFAULT 0, blnk TEXT
)
Traceback (most recent call last):
  File "/usr/share/thawab/Thawab/gtkUi.py", line 347, in start
    if not sh.toSqlite():
  File "/usr/share/thawab/Thawab/shamelaUtils.py", line 283, in toSqlite
    self.importTable(t, t.lower())
  File "/usr/share/thawab/Thawab/shamelaUtils.py", line 240, in importTable
    self.importTableSchema(Tb, tb, is_tmp, tb_prefix)
  File "/usr/share/thawab/Thawab/shamelaUtils.py", line 228, in importTableSchema
    try: self.c.execute(l)
sqlite3.OperationalError: duplicate column name: bkid

The system has mdbtools 0.7

ProblemType: Bug
DistroRelease: Ubuntu 12.10
Package: thawab 3.0.13-1
ProcVersionSignature: Ubuntu 3.5.0-23.35-generic 3.5.7.2
Uname: Linux 3.5.0-23-generic x86_64
ApportVersion: 2.6.1-0ubuntu10
Architecture: amd64
Date: Fri Feb 1 21:49:57 2013
InstallationDate: Installed on 2011-07-23 (559 days ago)
InstallationMedia: Ubuntu 11.04 "Natty Narwhal" - Release amd64 (20110426)
MarkForUpload: True
PackageArchitecture: all
SourcePackage: thawab
UpgradeStatus: Upgraded to quantal on 2012-10-24 (100 days ago)

[Launchpad Janitor (janitor)]

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

[Syed Khalil (syedkhalil)]

I confirm this bug in both ubuntu 12.04 and 12.10 32 bit

[أحمد المحمودي (Ahmed El-Mahmoudy) (aelmahmoudy)]

Upstream replied me 2 months ago, that the problem is that the new update of mdbtools no longer accepts '-S' option, which is the option to sanitize names (replace spaces etc. with underscore)

[Adil Ahmed (princefarhaan)]

For your benefit this Ramadhan, you can use this temporary workaround - uninstall the latest version of thawab and mdbtools that comes with 12.04 (possibly 12.10 as well) and install the following in the same order

libmdbtools_0.5.99.0.6pre1.0.20051109-6_i386
mdbtools_0.5.99.0.6pre1.0.20051109-6_i386
thawab_3.0.12-1_all

I have converted a bok file and it worked. Also please note that the latest thwab 3.0.13-1 might also work but don't want to break and test my current working environment.

Happy learning...

Salam

[Launchpad Janitor (janitor)]

This bug was fixed in the package thawab - 3.0.13-2

---------------
thawab (3.0.13-2) unstable; urgency=low

  * debian/watch: Update URL in watch file
  * Bumped python-whoosh dependency to >= 2.5
  * Added mdbtools-0.7.diff patch to fix incompatibility with mdbtools 0.7
    (Closes: #704907) (LP: #1112821)
  * debian/control:
    + Added whoosh-2.5.diff patch to fix incompatibility with Whoosh > 2.5
    + Bumped mdbtools dependency to >= 0.7
    + Bumped Standards-Version to 3.9.5
    + Use canonical URIs in VCS-* fields.
    + Removed obsolete DMUA field.
  * debian/copyright: Update copyright years.

 -- أحمد المحمودي (Ahmed El-Mahmoudy) <email address hidden> Fri, 22 Nov 2013 10:07:33 +0200

[oubid redha (mo3alik)]

thanks

[Mohamed Rashid (rashivkp)]

its happening in ubuntu 13.10 64bit , And I am using Version: 3.0.13-2

using mdbtools 0.7.1-1ubuntu1 ,

create table [main]
 (
 [bkid] ineteger,
 [bk] text ,
 [betaka] text ,
 [inf] text ,
 [auth] text ,
 [authinf] text ,
 [tafseernam] text ,
 [islamshort] ineteger,
 [onum] ineteger,
 [over] ineteger,
 [seal] text ,
 [oauth] ineteger,
 [bver] ineteger,
 [pdf] ineteger,
 [oauthver] ineteger,
 [vername] text ,
 [cat] text ,
 [lng] text ,
 [higrid] text ,
 [ad] ineteger,
 [aseal] text ,
 [blnk] text ,
 [pdfcs] ineteger,
 [shrtcs] ineteger,bkid INTEGER, bk TEXT, shortname TEXT, cat INTEGER, betaka TEXT, inf TEXT, bkord INTEGER DEFAULT -1, authno INTEGER DEFAULT 0, auth TEXT, authinfo TEXT, higrid INTEGER DEFAULT 0, ad INTEGER DEFAULT 0, islamshort INTEGER DEFAULT 0, blnk TEXT
)
Traceback (most recent call last):
  File "/usr/share/thawab/Thawab/gtkUi.py", line 347, in start
    if not sh.toSqlite():
  File "/usr/share/thawab/Thawab/shamelaUtils.py", line 283, in toSqlite
    self.importTable(t, t.lower())
  File "/usr/share/thawab/Thawab/shamelaUtils.py", line 240, in importTable
    self.importTableSchema(Tb, tb, is_tmp, tb_prefix)
  File "/usr/share/thawab/Thawab/shamelaUtils.py", line 228, in importTableSchema
    try: self.c.execute(l)
sqlite3.OperationalError: duplicate column name: bkid
^CTraceback (most recent call last):
  File "/usr/bin/thawab-gtk", line 6, in <module>
    main()
  File "/usr/share/thawab/Thawab/gtkUi.py", line 865, in main
    gtk.main()

[fadlizarli (fadlizarli)]

شكرا
Pada Kamis, 24 April 2014 9:41, Mohamed Rashid <email address hidden> menulis:

its happening in ubuntu 13.10 64bit ,  And I am using Version: 3.0.13-2

using mdbtools 0.7.1-1ubuntu1 ,

create    table  [main]
(
    [bkid]            ineteger,
    [bk]            text ,
    [betaka]            text ,
    [inf]            text ,
    [auth]            text ,
    [authinf]            text ,
    [tafseernam]            text ,
    [islamshort]            ineteger,
    [onum]            ineteger,
    [over]            ineteger,
    [seal]            text ,
    [oauth]            ineteger,
    [bver]            ineteger,
    [pdf]            ineteger,
    [oauthver]            ineteger,
    [vername]            text ,
    [cat]            text ,
    [lng]            text ,
    [higrid]            text ,
    [ad]            ineteger,
    [aseal]            text ,
    [blnk]            text ,
    [pdfcs]            ineteger,
    [shrtcs]            ineteger,bkid INTEGER, bk TEXT, shortname TEXT, cat INTEGER, betaka TEXT, inf TEXT, bkord INTEGER DEFAULT -1, authno INTEGER DEFAULT 0, auth TEXT, authinfo TEXT, higrid INTEGER DEFAULT 0, ad INTEGER DEFAULT 0, islamshort INTEGER DEFAULT 0, blnk TEXT
)
Traceback (most recent call last):
  File "/usr/share/thawab/Thawab/gtkUi.py", line 347, in start
    if not sh.toSqlite():
  File "/usr/share/thawab/Thawab/shamelaUtils.py", line 283, in toSqlite
    self.importTable(t, t.lower())
  File "/usr/share/thawab/Thawab/shamelaUtils.py", line 240, in importTable
    self.importTableSchema(Tb, tb, is_tmp, tb_prefix)
  File "/usr/share/thawab/Thawab/shamelaUtils.py", line 228, in importTableSchema
    try: self.c.execute(l)
sqlite3.OperationalError: duplicate column name: bkid
^CTraceback (most recent call last):
  File "/usr/bin/thawab-gtk", line 6, in <module>
    main()
  File "/usr/share/thawab/Thawab/gtkUi.py", line 865, in main
    gtk.main()

--
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1112821

Title:
  Thawab crashes when converting .bok files in Ubuntu 12.10

Status in “thawab” package in Ubuntu:
  Fix Released

Bug description:
  Thawab crashes when converting .bok files in Ubuntu 12.10. This is the
  error that gets printed on terminal:

  mdb-schema: invalid option -- 'S'
  create    table  [main]
   (
      [bkid]            ineteger,
      [bk]            text ,
      [betaka]            text ,
      [inf]            text ,
      [auth]            text ,
      [authinf]            text ,
      [tafseernam]            text ,
      [islamshort]            ineteger,
      [onum]            ineteger,
      [over]            ineteger,
      [seal]            text ,
      [oauth]            ineteger,
      [bver]            ineteger,
      [pdf]            ineteger,
      [oauthver]            ineteger,
      [vername]            text ,
      [cat]            text ,
      [lng]            text ,
      [higrid]            text ,
      [ad]            ineteger,
      [aseal]            text ,
      [blnk]            text ,
      [pdfcs]            ineteger,
      [shrtcs]          ...