ActiveRecord::StatementInvalid

[lgs]

I just tryed to port the DB to SQLite3. I've got the app, up & running, can create galleries, upload new photos and everything seems all right but when I try to delete a photo, or an entire gallery, I get the following error :

ActiveRecord::StatementInvalid (SQLite3::SQLException: gallery_photos.position may not be NULL: UPDATE "gallery_photos" SET "updated_at" = '2010-05-30 14:36:58', "position" = NULL WHERE "id" = 29):

( I really didn't try the same with MySQL (I've not that possibility), so I don't know if it fail too or is just SQLite3 )

Does you have any suggestion ?
Thanks in advance
Luca G. Soave

[lgs]

Ok, I've finally been able to have a MySQL env where to test the same deploy as before ... I can say that with MySQL, everithing is all right. No errors deleting galleries or photos. That's just an SQLite3 issue, if someone wold like to dig into, please let us know!

Thanks in advance
Luca G. S.

[rapind]

I think this may have been a rails 2.3.5 issue. Updated the app to use 2.3.8 which may fix it.