Logging: Standard log table 'other' field should use JSON format, not PHP serialize

1. Using an existing Moodle install (i.e. you did not install it freshly after this patch), check the new setting 'JSON format' in the site settings under the logstore_standard plugin. It should be OFF.
2. Using a fresh Moodle install that was installed after this patch (e.g. a Behat test environment), check the same setting. It should be ON.
3. With either install, turn the setting OFF and carry out some actions in a test course. I suggest viewing a course page, viewing a forum, and starting a forum discussion.
4. Now turn the setting ON and carry out the same actions again.
5. Look at the log report for the course.
   • EXPECTED: You should see the actions you carried out, both times (there should be no difference).
6. Look in the database and find the relevant rows from the mdl_logstore_standard_log table, for example SELECT * FROM mdl_logstore_standard_log WHERE courseid = 1234 ORDER BY id DESC LIMIT 20;
7. Look at the 'other' field in these results.
   • EXPECTED: The older rows should have the data in PHP serialised format, usually beginning 'a:'. The newer rows should have the data in JSON format, usually beginning '{'.

Now test for the logstore_database plugin:

1. Turn off standard logging.
2. Turn on database logging and set the configuration so that it points to a suitable Moodle database that contains the (mdl_)logstore_standard_log table. (If you don't have a different install, I think it's OK to set the database fields so that it points to the same database.)
3. Repeat steps 3-7 from the above steps, looking in the selected remote database when finished (if not using the same one).