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



Attachment: 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

Reply via email to