[Nitro] Sqlite/Mysql problem

Jonathan Buch john at oxyliquit.de
Sat Sep 16 12:51:29 EDT 2006


Hi,

due to some patch, I'm now getting the following errors:

Mysql
=========================

DELETE FROM ogtc_deletesrelationship_item WHERE oid=1

DELETE FROM ogj_tc_deletesrelationship_item_tc_deletesrelationship_user  
WHERE item_oid=1
DELETE FROM ogtc_deletesrelationship_category WHERE item_oid=1
DELETE FROM ogtc_deletesrelationship_picture WHERE item_oid=1

DELETE FROM ogtc_deletesrelationship_tag
DB error Commands out of sync;  You can't run this command now, [DELETE  
 FROM ogtc_deletesrelationship_tag]


Sqlite
=========================

DEBUG: DELETE FROM ogtc_deletesrelationship_item WHERE oid=1
DEBUG: DELETE FROM  
ogj_tc_deletesrelationship_item_tc_deletesrelationship_user WHERE  
item_oid=1
DEBUG: DELETE FROM ogtc_deletesrelationship_category WHERE item_oid=1
DEBUG: DELETE FROM ogtc_deletesrelationship_picture WHERE item_oid=1
DEBUG: DELETE FROM ogtc_deletesrelationship_tag
DEBUG: DELETE FROM ogtc_deletesrelationship_item
DEBUG: DELETE FROM ogtc_deletesrelationship_category
DEBUG: DELETE FROM ogtc_deletesrelationship_picture
DEBUG: DELETE FROM ogtc_deletesrelationship_figure
DEBUG: DELETE FROM ogtc_deletesrelationship_user

DEBUG: DELETE FROM  
ogj_tc_deletesrelationship_item_tc_deletesrelationship_user
/usr/local/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0/lib/sqlite3/errors.rb:94:in  
`check': cannot commit transaction - SQL statements in progress  
(SQLite3::SQLException)

=========================

Those are not the same testcases, but they do exactly the same.  They both  
check, when one end of the relation is deleted, if the rules are obeyed  
that refers_to are kept and belongs_to relations are deleted.

Giving you the testcase would make no difference, and the real patch is  
too dependand on manverus repo.

So, what I'm asking here is:

Has someone seen similar errors, where could those come from and how would  
one resolve those?  (All in a general case.)

Jo

-- 
Feel the love
http://pinkjuice.com/pics/ruby.png


More information about the Nitro-general mailing list