Hi Geoffroy, geoffroy.val...@free.fr said: > Thilo, > > This is normal: OSCAR is on top of SIS and you only deleted the image > at the SIS level (we started to work on a prototype for which SIS is > not used). As a result, the image is not there any more but OSCAR knows > nothing about what you did (the image is still into the OSCAR > database).
hhm, i dont agree. to me it looks like the SQL statement which should remove the image from the db is faulty. > > at /usr/bin/mksiimage line 366 > > 2009-7-8 15:48:18 [main :: Line 368] Updating database. > > DBD::mysql::st execute failed: Unknown column 'Images.testimage1' in > > 'where clause' at /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/oda.pm line > > 788. i traced this back to SIS:NewDB del_common (lines 270 to 310)... but my perl foo fails me. to me it looks like the function isnt even running the query (just to prove how ignorant i am). > > If the documentation says that you can delete images with SIS commands, > please let me know that should be removed. the documentation i am referring to is here: http://svn.oscar.openclustergroup.org/trac/oscar/wiki/AdminGuide/Commands which says i can remove an image from oscar by using the mksiimage command. alternatively, i can use the si_rmimage command, but as is correctly explained, that will not remove the image from the oscar db. i think there is a tiny bug in the del_common function which produces invalid SQL, which is why the image is still in the db, even when using mksiimage. please, correct me if i am wrong. > > In order to "clean-up" the system and be sure you are in a coherent > state, you can use the oscar_image_cleanup script. ok - that could perhaps also be mentionend as a last resort. but i would prefer to just get mksiimage fixed... thanks kind regards Thilo > > Regards, > > ----- "Thilo Bangert" <thilo.bang...@gmx.net> a écrit : > > Hi, > > > > earlier i deleted a image with > > # mksiimage --delete --name testimage1 > > > > this successfully deleted the file on disk, but the image still shows > > up in oscar_wizard and is also mentioned in the database. > > rerunning mksiimage now, yields the following error message, which i > > probably missed the first time: > > > > # mksiimage --delete --name testimage1 --verbose > > 2009-7-8 15:48:18 [main :: Line 401] Parsing options. > > 2009-7-8 15:48:18 [main :: Line 349] Checking for existing image > > 2009-7-8 15:48:18 [main :: Line 356] Checking for clients > > 2009-7-8 15:48:18 [main :: Line 363] Deleting image. > > 2009-7-8 15:48:18 [SystemInstaller::Image :: Line 89] si_rmimage > > testimage1 > > FATAL: Can't get path to image testimage1 from image's stub file! > > Nothing has been done. > > Image deletion failed for image testimage1. > > at /usr/bin/mksiimage line 366 > > 2009-7-8 15:48:18 [main :: Line 368] Updating database. > > DBD::mysql::st execute failed: Unknown column 'Images.testimage1' in > > 'where clause' at /usr/lib/perl5/vendor_perl/5.8.8/OSCAR/oda.pm line > > 788. > > Selection had no result. Returning. > > > > > > thanks. > > kind regards > > Thilo > > > > --------------------------------------------------------------------- > >--------- Enter the BlackBerry Developer Challenge > > This is your chance to win up to $100,000 in prizes! For a limited > > time, > > vendors submitting new applications to BlackBerry App World(TM) will > > have > > the opportunity to enter the BlackBerry Developer Challenge. See full > > prize > > details at: http://p.sf.net/sfu/Challenge > > _______________________________________________ > > Oscar-users mailing list > > Oscar-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/oscar-users
signature.asc
Description: This is a digitally signed message part.
------------------------------------------------------------------------------ Enter the BlackBerry Developer Challenge This is your chance to win up to $100,000 in prizes! For a limited time, vendors submitting new applications to BlackBerry App World(TM) will have the opportunity to enter the BlackBerry Developer Challenge. See full prize details at: http://p.sf.net/sfu/Challenge
_______________________________________________ Oscar-users mailing list Oscar-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/oscar-users