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:
2892 sites
1k downloads
79 fans
Current versions available: 9
Download

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".

Useful links

Source control URL
Bug tracker

Screenshots

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

Contributors

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

Awards

Early bird 3.5
Early bird 3.5
Privacy friendly
Privacy friendly
Early bird 3.6
Early bird 3.6
Early bird 3.7
Early bird 3.7
Early bird 3.8
Early bird 3.8
Early bird 3.9
Early bird 3.9
Early bird 3.10
Early bird 3.10

Comments RSS

Comments

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

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

    Regards
  • Andreas Grabs
    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
  • zeinal 85
    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?
  • Andreas Grabs
    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
  • Nicolás Gómez
    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.
  • Andreas Grabs
    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
  • Stephen Wallace
    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
    Richard van Iwaarden
    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
    Richard van Iwaarden
    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
  • Andreas Grabs
    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.
Please login to post comments