Cannot successfully add item to generic collection

Debug notes:

Nothing showing up in the logcat when failing to add item. Item is actually added to the db.

However there might be 2 reasons:
- pulling a db from under collectionista when running robotium tests -> SQLException. See monkey logs of 2011-02-09.
- TRIGGERS wrongly written and some queries are running into constraintss -> SQLException, see sqlite_triggers.sql.

Once a generic item has been added with empty name and empty text, all subsequent may not be shown possibly.

Noteworthy that even after killing app, and reloading list of items, it still does not show all, while they are actually in the db and ok, but with faulty ones amongst them.

Experiments with "" (empty strings) and <null> do not reproduce this:

sqlite> SELECT * FROM items_generic;
_id|created|modified|subtype|name|text|image
1|1297375866315|1297375868395|/items/generic|A|A|2130837526
2|1297375548767|1297375548767|/items/generic|||2130837526 -> empty
3|1297376458397|1297376463616|/items/generic|C|C|2130837526
4|1297375548767|1297375548767|/items/generic|||2130837526 -> null

Changed ABORT into ROLLBACK in triggers to see if that helps. Split out some other db related bugs.

Not seen in a long time.