-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On Fri, April 8, 2005 12:03 am, Rob Shortt said: > Rob Shortt wrote: >> TC Wan wrote: >> >>> -----BEGIN PGP SIGNED MESSAGE----- >>> Hash: SHA1 >>> >>> >>> On Wed, April 6, 2005 7:31 pm, Rob Shortt said: >>> >> >> 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. I rebuilt pyepg, then found out that the epg_schema.sql is not automatically included in the build. I'm putting additional install commands in my SPEC file to add the SQL script. I wonder if the python setup script can do that automatically? There's also a typo in db_sqlite.py line 59. it should be: os.system('rm %s' % dbpath) [was 'dbath'] Your fix basically works. Here's the log: [EMAIL PROTECTED] noarch]# freevo EPG database is zero size (invalid), removing it ERROR db_sqlite(58): EPG database is zero size (invalid), removing it EPG database missing, creating it: /usr/bin/sqlite WARNING db_sqlite(77): EPG database missing, creating it: /usr/bin/sqlite [EMAIL PROTECTED] noarch]# T.C. - -- Wan Tat Chee (Senior Lecturer) School of Computer Sciences, Univ. of Science Malaysia, 11800 USM, Penang, Malaysia. Rm.625 Ofc Ph: +604 653-3888 x 3617 NRG Lab Admin: +604 659-4757 Rm.601-F Ofc Ph: +604 653-4396 Internet: [EMAIL PROTECTED] Web: http://nrg.cs.usm.my/~tcwan GPG Key : http://nrg.cs.usm.my/~tcwan/tcwan-nrg-20040805.asc F'print : 4B2E F0BF AAD7 2F51 CB41 4386 F72B 7859 8278 BDC4 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFCVgf59yt4WYJ4vcQRAjqbAJ9Z9OVdphgpoa44QqA9GQfCmnmKwwCguPNW g1X01acLYuk+2GBXnI7dxb0= =/dvj -----END PGP SIGNATURE----- ------------------------------------------------------- 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_ide95&alloc_id396&op=click _______________________________________________ Freevo-devel mailing list Freevo-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/freevo-devel