Jason Tackaberry wrote: > On Wed, 2006-08-02 at 16:40 +0200, Dirk Meyer wrote: >> Yes. I add 'file' and get None. Checking the db using sqlite on the >> command line gives the same result. The first entry is 'dir', all >> other added later are empty. > > Ok weird. Can you output the sql query used? (In _db_query() there is > a print statement that's commented out. Just uncomment it.)
| QUERY (0): SELECT * from types fresh db | QUERY (0): INSERT OR REPLACE INTO types VALUES(?, ?, ?, ?) | QUERY (1): SELECT * from types | 1 dir <type 'buffer'> <type 'buffer'> one entry | QUERY (0): ALTER TABLE objects_dir_tmp RENAME TO objects_dir | QUERY (0): CREATE TRIGGER delete_object_dir DELETE ON objects_dir BEGIN UPDATE meta SET value=value-1 WHERE attr='keywords_objectcount'; END | QUERY (0): CREATE INDEX objects_dir_parent_idx on objects_dir (parent_id, parent_type) | QUERY (0): CREATE INDEX objects_dir_media_idx ON objects_dir (media) | QUERY (0): CREATE INDEX objects_dir_name_parent_type_parent_id_idx ON objects_dir (name,parent_type,parent_id) | QUERY (0): CREATE TABLE objects_file_tmp (name BLOB,media INTEGER,parent_type INTEGER,parent_id INTEGER,pickle BLOB,id INTEGER PRIMARY KEY AUTOINCREMENT) ok, now I want to add 'file' | QUERY (1): SELECT * from types | 1 dir <type 'buffer'> <type 'buffer'> ok, still only a dir | QUERY (0): INSERT OR REPLACE INTO types VALUES(?, ?, ?, ?) insert | QUERY (2): SELECT * from types 1 dir <type 'buffer'> <type 'buffer'> 2 None <type 'NoneType'> <type 'NoneType'> CRASH! > Also weird, given that I can't reproduce this. I wonder what's > different about our setups? No idea. >> Maybe a bug with your ObjectRow code? > > Well, that would be where I'd point my finger too, simply by virtue of > the fact that it was working before ObjectRow and now it isn't. :) Yes > Nevertheless, I can't say where the bug is until I can reproduce it -- > or until you can narrow it down anyway :) I can't do that, I have no idea where to look. Dischi -- ~/.signature: No such file or directory
pgppAxcQqMord.pgp
Description: PGP signature
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________ Freevo-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/freevo-devel
