Αναρτήσεις που έγιναν από τον/την Visvanath Ratnaweera

Moodle in English -> Quiz and question banks -> [qtype_crossword] Can't create new questions nor duplicate courses (Moodle 4.5.5) -> [qtype_crossword] Can't create new questions nor duplicate courses (Moodle 4.5.5)

από Visvanath Ratnaweera -
Φωτογραφία Particularly helpful Moodlers Φωτογραφία Translators
Hi Anupama

This is taking us in a completely unexpected direction. Needs to be investigated before we do anything else.

First thing, only a very small team of sys admins, including myself, have direct (CLI) access to the database. And we share the changes we do. I can guarantee that nobody changed mdl_qtype_crossword_words table manually to mdl_qtype_crossword_subquestions - 100% certain.

Alas! There is a record on qtype_crossword. You can find the same here [qtype_crossword] Upgrade says "Table qtype_crossword_words does not exist." Sorry, very long (people were bringing new ideas). The root cause in short is "some sort of name clash" (and the posts following it).
 
A longer version: The qtype_crossword we had was https://github.com/eLearning-BS23/moodle-qtype_crossword. During the upgrade 4.1 > 4.5 we've replaced it with https://moodle.org/plugins/qtype_crossword !
 
Now, where to from here? Switching back to https://github.com/eLearning-BS23/moodle-qtype_crossword doesn't sound promising - that plug-in was last updated 4 years ago. So the only remaining path (as I see) is to uninstall the "BS23" plug-in  and replace it with the OU plug-in. My problem now is how to delete all the BS23 questions from the site so that I can properly uninstall it. Any advice?
Μέσος όρος βαθμολογίας: -

Moodle in English -> Quiz and question banks -> [qtype_crossword] Can't create new questions nor duplicate courses (Moodle 4.5.5) -> [qtype_crossword] Can't create new questions nor duplicate courses (Moodle 4.5.5)

από Visvanath Ratnaweera -
Φωτογραφία Particularly helpful Moodlers Φωτογραφία Translators
Done! See https://github.com/moodleou/moodle-qtype_crossword/issues/41.

Thanks for the quick response! Because of the end of the academic year course copying the matter is urgent, say max. 2 weeks. If that is not realistic, we can delete the question instances. The problem we have is that deletion (in the GUI) too is not possible due to the same cause. I want to avoid manipulating the DB directly, we have a huge number of question types and close to a million questions, 95% duplicates, originating from a previous incident.
Μέσος όρος βαθμολογίας: -

Moodle in English -> Quiz and question banks -> [qtype_crossword] Can't create new questions nor duplicate courses (Moodle 4.5.5)

από Visvanath Ratnaweera -
Φωτογραφία Particularly helpful Moodlers Φωτογραφία Translators

Moodle: 4.5.5 (recently upgraded from 4.1)

qtype_crossword:

v1.1.0 for Moodle 4.4+

When one creates a crossword type question and tries to save, it runs in to an error mdl_qtype_crossword_words does not exist. Indeed there are only two tables belonging to crossword, mdl_qtype_crossword_options and mdl_qtype_crossword_subquestions.

I removed the crossword/ directory and reinstalled crossword from the Moodle GUI. Still the same two tables. Interestingly the install.xml of the plug-in has qtype_crossword_options, qtype_crossword_words but no mdl_qtype_crossword_subquestions.

The site has somehow a dozen of old crossword questions which I don't want to lose.

Trying do duplicate courses which contain such questions also run in to the same error, "no qtype_crossword_words". That is a huge blockade since the last courses from the academic year just ended are being duplicated for the new academic year starting through CSV uploads and they fail when they encounter a course with crossword questions.

Μέσος όρος βαθμολογίας: -

Moodle in English -> Hardware and performance -> How to act with Benchmark plugin results -> How to act with Benchmark plugin results

από Visvanath Ratnaweera -
Φωτογραφία Particularly helpful Moodlers Φωτογραφία Translators
The fact that the benchmark didn't run at all should have rung alarm bells!

Well, improving performance is most often not a binary question, unless you site is deeply under-powered or misconfigured. The analysis needs numbers, the "input" (server specs, network connection), how it was made (software and their configuration) and the load (users, what they are doing). And balancing them. 
 
 Before you post... read this... is the compulsory starting point. Then comes the this forum's documentation, Performance and Performance_FAQ.
 
Yes, leaving the previous discussion, Page response is very slow, and starting a new one is generally a bad idea. Some information needed in this discussion are in the old thread and people will not find them immediately. Now it happened, may be you can close that thread posting the link to this discussion as the continuation.
 
I saw that, your server runs on Windows, or MS SQL Server at least. So I will not be able to help, I'm from the Linux Dept. But there are others.
Μέσος όρος βαθμολογίας:Useful (1)

Moodle in English -> General help -> Can I flag a site to bypass registration? -> Can I flag a site to bypass registration? [SOLVED]

από Visvanath Ratnaweera -
Φωτογραφία Particularly helpful Moodlers Φωτογραφία Translators
RESOLVED

During the testing period we had various copies of the site. Apparently some of them got registered as independent sites and another "replaced" the official record in the registration database. In communication with moodle.com support got all cleared.

P.S. I see the increasingly nagging site registration as the root cause of the problem. Yeah, there is a technical solution, the (new to me) flag in config.php. I don't know how many aspiring Moodle admins know that. But all that is not the subject here.
Μέσος όρος βαθμολογίας: -