chenqingyu / auto-sub

Automatically exported from code.google.com/p/auto-sub
0 stars 0 forks source link

Error in upgrade database #164

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Starting autosub

This generates an error

AutoSub: Initializing variables and loading config
upgradeDb: Upgrading database  from version 1 to version 3
upgradeDb: More than 1 upgrade required. Starting subupgrades
upgradeDb: Upgrading database  from version 1 to version 2
Traceback (most recent call last):
  File "AutoSub.py", line 119, in <module>
    sys.exit(main())
  File "AutoSub.py", line 96, in main
    autosub.Db.initDatabase()
  File "<rootdir>/auto-sub/                                                                             autosub/Db.py", line 181, in initDatabase
    upgradeDb(autosub.DBVERSION, version.dbversion)
  File "<rootdir>/auto-sub/                                                                             autosub/Db.py", line 134, in upgradeDb
    upgradeDb((from_version - 1) + x, x + 1)
  File "<rootdir>/auto-sub/                                                                             autosub/Db.py", line 141, in upgradeDb
    cursor.execute("ALTER TABLE last_downloads ADD COLUMN '%s' 'TEXT'" % 'codec'                                                                             )
sqlite3.OperationalError: no such table: last_downloads

Original issue reported on code.google.com by dji...@gmail.com on 12 Dec 2012 at 10:18

GoogleCodeExporter commented 9 years ago
Workaround is to add
return true

on line 129 in autosub/Db.py

Original comment by dji...@gmail.com on 12 Dec 2012 at 10:20

GoogleCodeExporter commented 9 years ago
Missing information to correctly address this issue. 

Original comment by romke.va...@gmail.com on 7 Feb 2013 at 11:49

GoogleCodeExporter commented 9 years ago
Can you tell me what information is lacking? I'll see I can add it.

Original comment by dji...@gmail.com on 7 Feb 2013 at 7:16

GoogleCodeExporter commented 9 years ago
Please upload your database file, your config file and supply as many 
information as possible on your system (os, browser, 32bit or 64 bit etc..)

Original comment by romke.va...@gmail.com on 15 Feb 2013 at 6:42

GoogleCodeExporter commented 9 years ago
Hi,
my system (HDX1000) crashed and had to do a full reinstall of all apps. I 
haven't been able to recreate the error after that, so I guess my system was 
already unstable.

Thanks anyway.

Regards,
Joost

Original comment by dji...@gmail.com on 16 Feb 2013 at 8:42

GoogleCodeExporter commented 9 years ago

Original comment by romke.va...@gmail.com on 16 Apr 2013 at 8:20