Skip to main content

How to install Moodle Adminer and get logs for technical support

When an error occurs with the POK Proof of Knowledge plugin in Moodle, the support team needs the plugin logs to diagnose it. To get them, install the Moodle Adminer plugin, run a SQL query against the log table, and export the results as a CSV file. You only need access to the Moodle administrator panel.

Part 1: Install the Moodle Adminer plugin​

  1. Download the plugin from the official Moodle directory: https://moodle.org/plugins/local_adminer
  2. In your Moodle platform, open the administration panel: Site Administration → Plugins → Install plugins.
  3. Select Install plugin from the Moodle plugins directory.
  4. Log in to the Moodle plugins directory.
  5. Search for the plugin Moodle Adminer.
  6. Click Install.
  7. Continue through the screens until the installation is complete.

Part 2: Open Moodle Adminer​

Once the plugin is installed:

  1. Go to the Moodle administrator panel.
  2. Navigate to Site Administration → Server → Moodle Adminer.

This opens the database administration interface.

Part 3: Get the POK logs​

Inside Moodle Adminer:

  1. In the left menu, click SQL Command.
  2. Copy and paste the following query, adjusting the dates to the period you want to review:
SELECT * FROM moodle.mdl_pokcertificate_log
WHERE timecreated BETWEEN UNIX_TIMESTAMP('2026-03-01')
AND UNIX_TIMESTAMP('2026-03-06');

Run the query​

  1. Click Execute.

Adminer displays the log entries for the selected period.

Export the logs​

To share the logs with support:

  1. Click the Export button.
  2. Select the CSV format.
  3. Download the generated file.

Send this file to the support team so they can analyze the error.

Result​

With these steps you can:

  • Install Moodle Adminer.
  • Query the POK plugin logs.
  • Export the records in CSV format.
  • Share the information the support team needs for a technical diagnosis.