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

By: Ernie Ghiglione

[ Reply | Forward ]

Hi Gopinath,

I've just tried to save a sequence in the Public folder and then I was able to delete it.

If I remember correctly, you can only delete your own stuff on the Public Folder though.

Thanks,

Ernie

Posted by Ernie Ghiglione

By: gopinath mohanraj

[ 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

By: Ernie Ghiglione

[ 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

By: gopinath mohanraj

[ Reply | Forward ]

Why system administrator(SYSADMIN USER) could not delete the public sequences ?

Posted by gopinath mohanraj

By: Ernie Ghiglione

[ Reply | Forward ]

Yes, I think sysadmin should be able to delete *any* sequence.

I think I have added a task for this in the past to our bug tracker so sysadmin can also see all groups and lessons created with each one.

Hopefully we can add this with 2.4.

Thanks,

ernie

Posted by Ernie Ghiglione