-
Bug
-
Resolution: Fixed
-
Minor
-
4.5
-
MOODLE_405_STABLE
-
MOODLE_405_STABLE
-
MDL-83970-405 -
MDL-83970-main -
SETUP
1. To quickly generate some AI usage data for this manual test, run the file MDL-83970-generate-data.php
attached to this issue. Save the file to the root of your Moodle installation and then run it via CLI:php MDL-83970-generate-data.php
2. Install another language, for example: *Français (fr)*
Testing 1
- Don't apply the patch yet.
- Note which branch you are working on. e.g., "main" branch.
- Run the command on SETUP number 1.
- Check your database by running the below query:
SELECT * from mdl_ai_action_register - VERIFY that there are five new sets of data, consisting of three sets of data with "OpenAI API provider" as their provider and two with "Azure AI API provider" as their provider.
- Apply the patch and run the site upgrade.
- Check your database again by running the SQL query on step 2
- VERIFY that the "OpenAI API provider" changed to "aiprovider_openai" and "Azure AI API provider" changed to "aiprovider_azureai".
- --- The next steps is only available in the main version (5.0). -----
- Return to your Moodle web. Navigate to Site Admin > Reports > AI Usage
- VERIFY that the table with the provider column display "OpenAI API provider" and "Azure AI API provider".
Testing 2
- Checkout the "main" branch
- Run the file fixversion.php via CLI:
php fixversion.php - Truncate data in database table mdl_ai_action_register with following query:
truncate table mdl_ai_action_register; - Run the command on SETUP number 1.
- Navigate to Site Admin > General > Language customisation
- Choose Français (fr)
- Click the Open language packfor editing button.
- Wait for language pack loaded and then click the Continue button
- Select aiprovider_openai
- Fill the String identifier input with pluginname
- Fill the Local customisation with Fournisseur OpenAI
- Click the Save changes button.
- Change the language to *Français (fr)*
- Apply the patch and run the site upgrade.
- VERIFY that the upgrade process was successful without any errors.
SETUP 1. To quickly generate some AI usage data for this manual test, run the file MDL-83970-generate-data.php attached to this issue. Save the file to the root of your Moodle installation and then run it via CLI: php MDL- 83970 -generate-data.php 2. Install another language, for example: *Français (fr)* Testing 1 Don't apply the patch yet. Note which branch you are working on. e.g., " main " branch. Run the command on SETUP number 1. Check your database by running the below query: SELECT * from mdl_ai_action_register VERIFY that there are five new sets of data, consisting of three sets of data with "OpenAI API provider" as their provider and two with "Azure AI API provider" as their provider. Apply the patch and run the site upgrade. Check your database again by running the SQL query on step 2 VERIFY that the "OpenAI API provider" changed to " aiprovider_openai " and "Azure AI API provider" changed to " aiprovider_azureai ". --- The next steps is only available in the main version (5.0). ----- Return to your Moodle web. Navigate to Site Admin > Reports > AI Usage VERIFY that the table with the provider column display "OpenAI API provider" and "Azure AI API provider". Testing 2 Checkout the " main " branch Run the file fixversion.php via CLI: php fixversion.php Truncate data in database table mdl_ai_action_register with following query: truncate table mdl_ai_action_register; Run the command on SETUP number 1. Navigate to Site Admin > General > Language customisation Choose Français (fr) Click the Open language packfor editing button. Wait for language pack loaded and then click the Continue button Select aiprovider_openai Fill the String identifier input with pluginname Fill the Local customisation with Fournisseur OpenAI Click the Save changes button. Change the language to *Français (fr)* Apply the patch and run the site upgrade. VERIFY that the upgrade process was successful without any errors. -
Code verified against automated checks. 
Checked
MDL-83970using repository: https://github.com/meirzamoodle/moodle.git
MOODLE_405_STABLE (0 errors / 0 warnings) [branch: MDL-83970-405 | CI Job]- main (0 errors / 0 warnings) [branch: MDL-83970-main | CI Job]
More information about this report
Built on: Fri Feb 14 04:30:40 PM UTC 2025
Code verified against automated checks. Checked MDL-83970 using repository: https://github.com/meirzamoodle/moodle.git MOODLE_405_STABLE (0 errors / 0 warnings) [branch: MDL-83970-405 | CI Job ] main (0 errors / 0 warnings) [branch: MDL-83970-main | CI Job ] More information about this report Built on: Fri Feb 14 04:30:40 PM UTC 2025 -
-
2
-
Team Dragons 2025 Sprint 1.2
There are a couple of places where we are storing data using the AI provider "pluginname" string instead of the provider component name e.g. aiprovider_openai
This results in translated entries being add to the registration hub data. This will make it harder to parse the data correctly, see below for an example:
{"Fournisseur API OpenAI":{"summarise_text":{"success_count":0,"fail_count":17,"predominant_error":401}},"time_range":{"timefrom":1731538874,"timeto":1732143670}}
{"Provedor da API do OpenAI":{"generate_text":{"success_count":0,"fail_count":2,"predominant_error":404}},"time_range":{"timefrom":1731451506,"timeto":1731835082}}
This is also the case in the "ai_action_register" table. in this table we should also store the provider component name
