Forum LAMS for Tech-Heads - General Forum: Re: Re: Deleting sequences from run sequences directory

I'm sure there's a way to do this in the db. Let me have a look and we'll let you know shortly.

Ernie

Posted by Ernie Ghiglione

Sorry for the delay... Fiona had sent me some info on this and I was waiting for trying it myself before I post it here.

Ok to do this in the DB directly (and I must say, please be really careful and be certain that the things you are about to change are correct before you do this and also make a database backup before you do this just in case) by doing the following:

Go into mysql command line (or your favorite mysql browser) and run:

to get the folder ID for the user you want to:

select workspace_folder_id, name, user_id from lams_workspace_folder;

This will list the name of the users and their workspace_folder_ids. Pick the workspace_folder_id for the user you want to move the design to his/her folder.

Then find the name of the design you want to move by running this:

select learning_design_id, workspace_folder_id, title, user_id from lams_learning_design;

Once you identify the design, change its workspace_folder_id by running:

(once again, make sure you double check all the ids before you do this)

update lams_learning_design set workspace_folder_id = (here goes the number for the user's workspace_folder_id) where learning_design_id = (where goes the number for the learning_design_id that is in the wrong workspace folder);

Now, re open the authoring environment and the learning design now should be able to be deleted from the user's workspace folder!

Thanks,

Ernie

Posted by Ernie Ghiglione