Forum LAMS for Tech-Heads - General Forum: Re: Deleting Course in public folder


 
Search: 

3: Re: Deleting Course in public folder
In response to 1 08/11/10 10:12 PM
[ Reply | Forward ]
I am not able to delete , Is this whoever is uploaded the sequence in public folder only they can delete or full control of LAMS users will delete the sequences.

I tried my own stuff, i am not able to delete. But i could remember it was working few months back. I restarted Lams Server one week back after that only i am facing this problem.

If you could tell me the steps to be followed to remove sequence from public folder or any thing need to be updated in DB for the particular user means do let me know.

Thanks for you previous comment.

Regards,
Gopinath.M

Posted by gopinath mohanraj

5: Re: Re: Deleting Course in public folder
In response to 3 08/15/10 09:48 PM
[ Reply | Forward ] 
Hi Gopinath, 

Here's how you can permanently delete a learning design from the public folder. 

1) Find out the workspace_folder_id for the Public Folder

mysql> select workspace_folder_id, name from lams_workspace_folder where name = 'Public Folder';
+---------------------+---------------+
| workspace_folder_id | name          |
+---------------------+---------------+
|                  46 | Public Folder |
+---------------------+---------------+
1 row in set (0.00 sec)

2) Find the learning_design_id of the sequence you want to delete in the Public folder (workspace_folder_id = 46)

mysql> select learning_design_id, title, user_id from lams_learning_design where workspace_folder_id = 46;
+--------------------+-------+---------+
| learning_design_id | title | user_id |
+--------------------+-------+---------+
|                  6 | Random sequence     |       5 |
+--------------------+-------+---------+
1 row in set (0.01 sec)


3) Start deleting the transitions

mysql> delete from lams_learning_transition where learning_design_id = 6; 
Query OK, 1 row affected (0.00 sec)

4) Then delete the activities

mysql> delete from lams_learning_activity where learning_design_id = 6; 
Query OK, 2 rows affected (0.04 sec)


5) And finally the design 

mysql> delete from lams_learning_design where learning_design_id = 6;
Query OK, 1 row affected (0.00 sec)


Sequence is now permanently gone. 

Ernie

Posted by Ernie Ghiglione

Reply to first post on this page
Back to LAMS for Tech-Heads - General Forum
.LRN Home