| Administrator's Handbook |
| Edutizer manuals | Administrator handbook | A2 Manage | Various database scripts | Undelete questions deleted by accidentally deliting a folder |
Undelete questions deleted by accidentally deliting a folder
Task: get back folder questionsthat got deleted when user accidentally archived a folder
DISCLAIMER: This script has been tested by MWX engineers. This script is provided without any warranty. Do back up you database before using this script.Step 1. Get the topic_id of the archived folder.
SELECT topic_id FROM Topics WHERE topic_name = '<topic_that_just_got_archived>';
Step 2. Undelete all questions in that folder
UPDATE Questions SET state = 1 WHERE topic_id = <topic_id>;
Step 3. Set folder as passive, so it becomes visible again in teacher application.
UPDATE Topics SET state = 2 WHERE topic_id = <topic_id>;
Step 4. Recreate folder tree cache.
In teacher application, create a new root level topic.
Archive it.
|
||||||
| ||||||
|
||||||
