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:
4394 sites
2k downloads
111 fans
Current versions available: 10

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

Comments

  • Karen Holland
    Mon, 5 Oct 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
  • Andreas Grabs
    Mon, 5 Oct 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
  • Rainer Busch
    Tue, 3 Nov 2020, 9:35 PM
    Is this plugin compatible with moodle version 3.9 ?

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

    Regards
  • Andreas Grabs
    Tue, 3 Nov 2020, 11:29 PM
    Hi Rainer,
    yes this plugin runs in Moodle 3.9 and works fine with MariaDB.
    Best regards
    Andreas
  • zeinal 85
    Sun, 22 Nov 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?
  • Andreas Grabs
    Sun, 22 Nov 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
  • Nicolás Gómez
    Tue, 8 Dec 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.
  • Andreas Grabs
    Tue, 8 Dec 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
  • Stephen Wallace
    Mon, 8 Mar 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, 8 Mar 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, 8 Mar 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
  • Andreas Grabs
    Mon, 8 Mar 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.
  • Melanie Scott
    Mon, 20 Sept 2021, 9:00 PM
    Andreas,
    I'm on 3.11.2 (just upgraded) and using 4.8.1 Adminer (which I love). I've been having trouble the past 18 months with JSON string syntax errors impacting performance of other stuff. When we upgraded, Adminer went AWOL and the JSON error got resolved. This last week I got my Adminer back and now the errors are back, too. They could be completely unrelated but (prob resolved, Adminer installed, problem reoccurs...) a couple of posts from a year or so ago on the general forums implied that sometimes plugins can cause this. Do you know of anything Adminer that does this or have a solution?
  • Edgardo Palazzo
    Mon, 19 June 2023, 2:32 AM
    I love this plugin. Thank you!
Please login to post comments