Moodle Adminer

General plugins (Local) ::: local_adminer
Maintained by Andreas Grabs
This plugin is based on the great tool adminer. The main advantage of this plugin is, it can handle different types of database. So it works with MySQL/MariaDB, PostgreSQL, Oracle and MSSQL.
Latest release:
2923 sites
1k downloads
80 fans
Moodle 2.0, 2.1, 2.2, 2.3

This plugin is based on the great tool adminer. The main advantage of this plugin is, it can handle different types of database.
So it works with:

  • MySQL/MariaDB
  • PostgreSQL
  • Oracle
  • MSSQL

Here are some of the key-features:

  1. you can define trigger
  2. you can change the order of fields
  3. you can easy create or alter views
  4. you can create stored procedures
  5. if you rename a database so the database is altered and not copied like phpMyAdmin it does
  6. you can define foreign key with referential integrity

To install it you only have to copy it into the "local" folder in your moodle-installation and call the notification-page. After the installation you will find a new link "Moodle Adminer" below "Site administration / Server".

Screenshots

Screenshot #0
Screenshot #1
Screenshot #2
Screenshot #3
Screenshot #4

Contributors

Andreas Grabs (Lead maintainer)
Please login to view contributors details and/or to contact them

Comments RSS

Show comments
  • Tue, Jul 2, 2019, 10:58 PM
    Hi Andreas! Is there a reason that the version here on Moodle.org is one version ahead of the version on GitHub?
  • Wed, Jul 3, 2019, 3:16 AM
    oops, I forgot to push it to github. I only pushed it in my private repostory.
    Now it is up to date.
    Thank you Michael for this info!
  • Mon, Oct 5, 2020, 7:22 PM
    Hi Michael, thanks for such a wonderfully useful plugin! Would it be possible to get the Github 3.5 branch updated to 4.7.7 as well? TIA smile
  • Mon, Oct 5, 2020, 8:14 PM
    Hi Karen, it's actually Andreas ;). For Moodle 3.5 to 3.8 please use the branch "MOODLE_38_STABLE".
    Best regards
    Andreas
  • Tue, Nov 3, 2020, 9:35 PM
    Is this plugin compatible with moodle version 3.9 ?

    Best regards
  • Tue, Nov 3, 2020, 9:35 PM
    Is this plugin compatible with MariaDB ?

    Regards
  • Tue, Nov 3, 2020, 11:29 PM
    Hi Rainer,
    yes this plugin runs in Moodle 3.9 and works fine with MariaDB.
    Best regards
    Andreas
  • Sun, Nov 22, 2020, 1:19 PM

    I have a problem in version 3.10+, namely when I choose Indonesian, all videos cannot be played. an error message appears on json. how to handle it?
  • Sun, Nov 22, 2020, 7:26 PM
    Hi Zeinal, I am sure you are in the wrong place. The Adminer plugin has nothing to do with videos. You might be looking for a different plugin.
    Best regards
    Andreas
  • Tue, Dec 8, 2020, 4:36 AM
    I'm trying to install it on: Moodle 3.9.3 (Build: 20201109) and mysql (5.7.32-0ubuntu0.18.04.1), but I got the following message:

    Nombre de la extensión / Directorio Versión actual Nueva versión Requiere Origen / Estado
    Moodle Adminer /local/adminer 2020120600 Moodle 2018050800 Fallido

    I'm installing it from Moodle plugins Directory. Is there something wrong? Am I doing any mistake? Thanks in advance.
  • Tue, Dec 8, 2020, 8:01 AM
    Hi Nicolás,
    thank you for this info! I have increased the version so you should now be able to install this plugin.
    Best regards
    Andreas
  • Mon, Mar 8, 2021, 3:19 PM
    When installing the newest version 4.8 on Moodle 3.8.4, I am getting errors upon launching Adminer on line 76 of the adminer.php file. I reverted back to 4.78 and it works fine.
  • Wazza
    Mon, Mar 8, 2021, 3:49 PM
    Same problem here. Last version is not working. Does this have to do with PHP version? We are on PHP 7.4.15 with PHP-fpm enabled
  • Wazza
    Mon, Mar 8, 2021, 3:52 PM
    Warning: Use of undefined constant DRIVER - assumed 'DRIVER' (this will throw an Error in a future version of PHP) in /home/learn/public_html/local/adminer/lib/adminer.php on line 76

    Warning: Use of undefined constant SERVER - assumed 'SERVER' (this will throw an Error in a future version of PHP) in /home/learn/public_html/local/adminer/lib/adminer.php on line 76

    Warning: session_start(): Cannot start session when headers already sent in /home/learn/public_html/local/adminer/lib/adminer.php on line 75

    Warning: Cannot modify header information - headers already sent by (output started at /home/learn/public_html/local/adminer/lib/adminer.php:76) in /home/learn/public_html/local/adminer/lib/adminer.php on line 1479

    Warning: session_start(): Cannot start session when headers already sent in /home/learn/public_html/local/adminer/lib/adminer.php on line 74

    Warning: Cannot modify header information - headers already sent by (output started at /home/learn/public_html/local/adminer/lib/adminer.php:76) in /home/learn/public_html/local/adminer/lib/adminer.php on line 73

    Warning: Cannot modify header information - headers already sent by (output started at /home/learn/public_html/local/adminer/lib/adminer.php:76) in /home/learn/public_html/local/adminer/lib/adminer.php on line 73

    Warning: Cannot modify header information - headers already sent by (output started at /home/learn/public_html/local/adminer/lib/adminer.php:76) in /home/learn/public_html/local/adminer/lib/adminer.php on line 1444

    Warning: Cannot modify header information - headers already sent by (output started at /home/learn/public_html/local/adminer/lib/adminer.php:76) in /home/learn/public_html/local/adminer/lib/adminer.php on line 1444

    Warning: Cannot modify header information - headers already sent by (output started at /home/learn/public_html/local/adminer/lib/adminer.php:76) in /home/learn/public_html/local/adminer/lib/adminer.php on line 1444

    Warning: Cannot modify header information - headers already sent by (output started at /home/learn/public_html/local/adminer/lib/adminer.php:76) in /home/learn/public_html/local/adminer/lib/adminer.php on line 1444

    Warning: Cannot modify header information - headers already sent by (output started at /home/learn/public_html/local/adminer/lib/adminer.php:76) in /home/learn/public_html/local/adminer/lib/adminer.php on line 1444

    Warning: Cannot modify header information - headers already sent by (output started at /home/learn/public_html/local/adminer/lib/adminer.php:76) in /home/learn/public_html/local/adminer/lib/adminer.php on line 1444

    Warning: Cannot modify header information - headers already sent by (output started at /home/learn/public_html/local/adminer/lib/adminer.php:76) in /home/learn/public_html/local/adminer/lib/adminer.php on line 1445

    Warning: Cannot modify header information - headers already sent by (output started at /home/learn/public_html/local/adminer/lib/adminer.php:76) in /home/learn/public_html/local/adminer/lib/plugins/frames.php on line 23
    Login

    Warning: session_start(): Cannot start session when headers already sent in /home/learn/public_html/local/adminer/lib/adminer.php on line 74
    This page can not be used in Moodle
    Back
  • Mon, Mar 8, 2021, 4:59 PM
    Thanks for reporting. For now I went back to 4.7.9. I will look into version v4.8.0 later.
1 2 3 4
Please login to post comments