Get More Deeply Acquainted With Moodle 3.3’s Data Model Using This Tool

Source: Get More Deeply Acquainted With Moodle 3.3’s Data Model Using This Tool | Moodle News https://pixnio.com/textures-and-patterns/metal-texture/new-metal-round-pipes Moodler Marcus Green has updated his “X-Rays for Moodle” tool, called Moodle ER Diagram, a comprehensive display of the Moodle database. This time, it shows the intricacies of the model that powers Moodle 3.3. See our coverage on a…

error/invalidmssqlnativetype

I wrote a plugin for a client that worked perfectly on my localhost LAMP installation, but failed when running on their production site that uses MSSQL as the database. The error occurred when setting the status of a column in the database to ‘1’. Viewing the insert does not reveal to much, so at first…

Query blocks instances and positions through the database – Moodle Tips

Source: Query blocks instances and positions through the database – Moodle Tips The following query gives you an idea of all the moodle blocks that have been added to various pages on your site and where they are positioned: select bi.*, bp.*, x.* from mdl_block_instances bi inner join mdl_block_positions bp on bi.id = bp.blockinstanceid inner…

Verify your Moodle Database Schema against XMLDB

Source: Verify your Moodle Database Schema against XMLDB – Moodle Tips There is a very handy CLI tool admin/cli/check_database_schema.php which compares the structure of your Moodle database against the XMLDB metadata and looks for any issues. These might includes issues such as: Missing tables – they exist in XMLDB but not in your DB (not…