Rob Shortt wrote:
TC Wan wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Wed, April 6, 2005 7:31 pm, Rob Shortt said:

DatabaseError: no such table: admin


Ok, get_version() in db_sqlite() is returning "0.0.0" because it failed
to select version from versioning. I think the problem is that it made
it that far when it shouldn't have, maybe the following check is failing:


try:
self.db = sqlite.connect(dbpath, client_encoding='utf-8',
timeout=10)
break
except OperationalError, e:
notifier.step(False, False)


... maybe there's no database.  Do you have sqlite installed in addition
to pysqlite?  I will look at catching this problem better.



Yes, I have sqlite-2.8.16-1.1.fc3.rf and pysqlite-1.0.1-1_fc3 installed. The /var/lib/freevo/epgdb file is 0 bytes, so it's not a valid database, since I don't have any XMLTV feeds to populate it with. Basically, I believe you need to check that the database is firstly valid, and if not, catch the exception.


No, that's not the case. When the database doesn't have any guide data it still has size, which comes from the tables and some initial data. Try removing the file and restarting Freevo.

I just added some checking for zero length epgdb and also for sqlite command. In adition I found a dumb typo bug on my part where fresh 0.1.1 databases would be missing their versioning table.


Please cvs update and try again. Even with no XMLTV data you should be seeing channels with 'NO DATA' or something.

Thanks,
-Rob



-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Freevo-devel mailing list
Freevo-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/freevo-devel

Reply via email to