Last June our university upgraded from 1.6 to 1.8. It went well, except that access to the front page is really slow.
Anyway, we just noticed that things have been scrambled in our questions bank. The name and question text of one question has now replaced the name and question text of all questions (about 3000 questions altogether). And also the <parent> field of all questions is the same number (4105), which is meaningless.
As a consequence, no question whatsoever is visible in any course and in existing quizzes, the questions are displayed with that same question text, which makes them useless.
Another curious side effect is that, when a teacher wants to do a backup of their course (and e.g. only back up their quizzes), the whole lot of 3,000 "mangled" questions are exported in the backup!
We do have a copy of the whole moodle database prior to upgrading to 1.8. Can anyone sugggest how we might use a mySql command to only restore the questions tables, without messing up anything else? Since this is just before the new academic year, it does not matter at all that questions and quizzes attempts are reset to none, but it would be nice if we could at least get back those 3,000 questions.
On the other hand, careful teachers who had made a course backup in June can restore their own questions & quizzes and it works fine, but not everyone has done backups...
Any suggestions welcome,
Joseph