Database Repair [](https://github.com/YOURLS/awesome-yourls/)

July 16, 2026 ยท View on GitHub

Deleted some links from your database? Then this plugin is for you!
Developed for Your Own URL Shortener (YOURLS) v1.10.4 and above.

Demonstration

screenshot

I use the Sleeky backend, but the default works just as well.

Usage

Say you deleted some links from your database, but now the click ID and total click count per link are off. Go to settings page for this plugin (after its been activated), and click run to fix the tables in your database. If you remove more links in the future, simply run it again, as it is completely safe to do so.

Specifics

  • Resets the AUTO_INCREMENT counter on the table so new IDs fill in sequentially.
  • Recalculates the aggregate click counts in based on the actual number of rows remaining in your logs.

Installation

  1. In /user/plugins, create a new folder named database-repair.
  2. Download the plugin.php file from this repository and add it to that folder.
  3. Go to the Plugins admin page (eg. http://sho.rt/admin/plugins.php) and activate it.

Alternatively, this plugin is compatible with both Download Plugins and Download Delete, so copy and paste the URL of this repository and set the branch to be main to install it.

Contributors

Sachin Agrawal: I'm a self-taught programmer who knows many languages and I'm into app, game, and web development. For more information, check out my website or Github profile. If you would like to contact me, my email is github@sachin.email.

License

This package is licensed under the MIT License.