WordPress Plugin: Fix Database

Place fixdb.php in your /wp-content/plugins/ folder and the login to your admin area. Activate the plugin. Now in the admin area, when you click Options there will be a sub-menu titled “Fix Database.” Go to that link, if you click the button on that page titled “Fix Database” the script will then check all the tables within that database. If any report an error it will attempt to repair the table. Once that is done it will optimize the tables.

Good for when the comments table is left open and nobody is able to make or view comments until it is repaired. Now you don’t have to log into phpMyAdmin to repair the table, just run this.

fixdb.zip (875 bytes)

Update: This works with Wordpress 2.3, no update to the plugin needed.

103 Responses to “WordPress Plugin: Fix Database”

  1. Orlando Says:

    Thks for the Plugin. Very useful.

  2. Best WordPress Plugins Says:

    [...] Fix Database A quick and easy way to have old, unused references cleared out of your MySQL database. It will also identify problems with tables although I’m not sure how that part works as my tables have never had a problem. [...]

  3. coosblues Says:

    Thanks! I’m new to wordpress and managed to mess up my sidebar. Not sure what I did but I can’t edid it. Any suggestions would be greatly appreciated. You can find my blog in my profile. Again, great plugin!

  4. Mari Says:

    Thanks for the great plugin!

    Cheers,

    M

  5. 狗车志 » 优化worpress的数据库 Says:

    [...] Fix Database:安装过,在后台有会Fix [...]

  6. WP Plugins DB » Blog Archive » Fix Database Says:

    [...] Visit [...]

  7. MINGER.NET | Optimize Wordpress Tables with Fix Database Plugin Says:

    [...] out the target table was proving to be a pain.  So another quick search turned up Slapyo’s Database Fix WP plugin.  This solution fixed my problem [...]

  8. Martino Says:

    Looks like the issue resolved itself. Everything looks great, thanks for the excellent plugin. :)

  9. PluginFiles.com - Wordpress Plugins » Blog Archive » Fix Database Says:

    [...] Plugin Author: Donnie La Curan [...]

  10. 50+ Tools For The WordPress Admin Says:

    [...] Fix Database - Will check your WordPress database for errors and attempt to fix them. [...]

  11. 50+ Tools For The WordPress Admin — Scott Fish Says:

    [...] Fix Database - Will check your WordPress database for errors and attempt to fix them. [...]

  12. The sky of Daemon! » Blog Archive » 译文:50多个Wordpress管理员使用的插件 Says:

    [...] Fix Database - 帮助你尝试修复数据库错误. [...]

  13. links for 2007-07-28 at orioa Says:

    [...] Slapyo.com » Blog Archive » WordPress Plugin: Fix Database DBエラーをチェックして修復してくれるらしい。 (tags: wordpress plugin) [...]

  14. Choco Says:

    It would be nice if you could add some screenshots.

  15. 译文:50多个Wordpress管理员使用的插件 | Iread Says:

    [...] Fix Database - 帮助你尝试修复数据库错误. [...]

  16. 译文:50多个Wordpress管理员使用的插件 | wordpress blog xqxp.com Says:

    [...] Fix Database - 帮助你尝试修复数据库错误. [...]

  17. 5 WordPress Plugins That Make Life Easier | Daily Moolah dot Com Says:

    [...] Fix Database - Will check your WordPress database for errors and attempt to fix them. [...]

  18. Chad’s dailies » Blog Archive » links for 2007-08-01 Says:

    [...] WordPress Plugin: Fix Database (tags: wordpress plugin) [...]

  19. [轉貼] 50多個Wordpress管理員使用的插件 | 艾德的部落格天空 | 亂寫、亂拍、亂來。 — 持續亂改更新中 — Says:

    [...] FeedSmith - 確信你的所有RSS訂閱都被統計到FeedBurner Feed中。 Fix Database - 幫助你嘗試修複數據庫錯誤. Genki Announcement - [...]

  20. [轉貼] 50多個Wordpress管理員使用的插件 « 艾德的部落格天空 Says:

    [...] FeedSmith - 確信你的所有RSS訂閱都被統計到FeedBurner Feed中。 Fix Database - 幫助你嘗試修複數據庫錯誤. Genki Announcement - [...]

  21. Lanooz.net » Fix Wordpress’s Database Says:

    [...] wczoraj wszystko to zaczęło działać! :D Albo to czary, albo jest to skutek użycia wtyczki Fix Database. Sprawdza bazę danych wordpressa w poszukiwaniu błędów, które będzie próbował naprawić, [...]

  22. » 50 Herramientas para administrar Wordpress | Informática Práctica | Says:

    [...] Fix Database: busca cualquier tipo de error en la base de datos de Wordpress y trata de repararlo. [...]

  23. Pimp My Posts (with Word Press Plugins) | BloodhoundBlog: Real estate marketing and technology blog | Realtors and real estate, mortgages, lending, investments Says:

    [...] Fix Database - Will check your WordPress database for errors and attempt to fix them. [...]

  24. WORDPRESS GOD:300+ Tools for Running Your WordPress Blog Says:

    [...] Fix Database - Checks your WordPress database for errors and attempts to fix them. [...]

  25. 53 Plugins para Administrar Wordpress Says:

    [...] Fix Database: comprueba tu base de datos para comprobar si hay errores, y los corrige. [...]

  26. voozzy.com » Blog Archive » Плагины для WordPress Says:

    [...] проводить подписку на фид вашего блога через Feedburner. Fix Database - плагин проверяющий базу данных WordPress на наличие [...]

  27. corym Says:

    THANK YOU!

    For three weeks I wasn’t able to upgrade Wordpress due to a database error. Your plugin corrected this.

  28. jameswillisisthebest Says:

    This is my first post
    just saying HI

  29. Блог интернет-разработчика » WordPress: Плагины админа Says:

    [...] Fix Database - Проверит базу данных блога на наличие ошибок и попробует их исправить. [...]

  30. WordPress Plugins To Help You Administer Your Blog « Lorelle on WordPress Says:

    [...] Fix Database WordPress Plugin attempts to repair your database, checking it for errors and fixing what it can, as well as optimizing the tables. Be sure and backup your database before using. [...]

  31. Бизнес » Архив блога » Плагины для wordpress Says:

    [...] проводить подписку на фид вашего блога через Feedburner. Fix Database - плагин проверяющий базу данных WordPress на наличие [...]

  32. 300+ Popular Plugins for Running Your WordPress Blog Says:

    [...] Fix Database - Checks your WordPress database for errors and attempts to fix them. [...]

  33.   Подборка Wordpress Плагинов by Блог Читера Says:

    [...] Fix Database - плагин проверяющий базу данных WordPress на наличие ошибок и устраняющий их [...]

  34. MikeF Says:

    Will this work for Wordpress 2.3?

  35. Wordpress god300 tools for running your wordpress blog by mashabale.com · Cyber Space in One Hand Says:

    [...] Fix Database - Checks your WordPress database for errors and attempts to fix them. [...]

  36. dada Says:

    Nice Site!

  37. 床垫|席梦思|棕垫|??? » WP插件汇总(2):50多个Wordpress管理员使用的插件 Says:

    [...] FeedBurner FeedSmith - 确信你的所有RSS订阅都被统计到FeedBurner Feed中。 Fix Database - 帮助你尝试修复数据库错误. Genki Announcement - [...]

  38. 53 Plugins to Manage Wordpress Says:

    [...] Fix Database: check your database to see if there mistakes, and corrects. [...]

  39. Get More Reviews - Blog » Blog Archive » The Ultimate WordPress Plugin Library Says:

    [...] Fix Database - Checks your WordPress database for errors and attempts to fix them. [...]

  40. Exploring & Tuning The WordPress Backend (Admin Panel) at WordPress Themes, Plugins, Blog Tips, Make Money Online >> WPthemesplugin.com Says:

    [...] Fix Database - Will check all the tables within your WordPress database and fix it if it need fixing. [...]

  41. 10 Tools per WordPress - MAMBRO MP3 & WAREZ FREE DOWNLOAD NETWORK Says:

    [...] Fix Database - Cerca errori nel database e li corregge. [...]

  42. 10 Tools per WordPress | La Guida Informatica Says:

    [...] Fix Database - Cerca errori nel database e li corregge. [...]

  43. windyconditions » I’m alive! (My blog was not) Says:

    [...] a month. But I fixed the MYSQL database and updated Wordpress, so I think I’m good to go. The Fix Database Plugin helped a [...]

  44. On-line дневник оптимизатора » Архив блога » Плагины для Wordpress с описанием на русском в 3-х частях. Часть 1. Says:

    [...] проводить подписку на фид вашего блога через Feedburner. Fix Database - плагин проверяющий базу данных WordPress на наличие [...]

  45. Плагины для Wordpress на русском! | Простой блог Says:

    [...] проводить подписку на фид вашего блога через Feedburner. Fix Database - плагин проверяющий базу данных WordPress на наличие [...]

  46. 与管理相关的50个Wordpress插件 : : MoonShow Says:

    [...] Fix Database - 检查Wordpress数据库错误并尝试修复。 [...]

  47. WordPress: +100 plugins et applications pour votre blog WP Says:

    [...] Fix Database - Check les erreurs sur votre base de données WordPress et vous aide à les règler. [...]

  48. Плагины для WordPress Says:

    [...] проводить подписку на фид вашего блога через Feedburner. Fix Database - плагин проверяющий базу данных WordPress на наличие [...]

  49. 对影成三人 » Blog Archive » Wordpress插件归类整理 Says:

    [...] Fix Database - 检查Wordpress数据库错误并尝试修复。 [...]

  50. Things I am interested in… » My del.icio.us bookmarks for November 19th Says:

    [...] Slapyo.com » Blog Archive » WordPress Plugin: Fix Database - [...]

  51. Fix Database | TROMPYX Says:

    [...] Plugin Page [...]

  52. Плагины для WordPress | Блог Дениса Лизунова Says:

    [...] проводить подписку на фид вашего блога через Feedburner. Fix Database - плагин проверяющий базу данных WordPress на наличие [...]

  53. 何昕博客 » Blog Archive » 50个与管理相关的Wordpress插件 Says:

    [...] Fix Database - 检查Wordpress数据库错误并尝试修复。 [...]

  54. David Bradley Says:

    One spammer in particular was causing me repeated problems with that error. I’ve just ran your plugin and am awaiting his next ping with interest to see if i can finally train Akismet that this person’s trackbacks are nothing but spam.

    Meanwhile, I actually wrote a post today entitled “Send Me Your Spam”, not sure why, check it out…it’s post dated December 3, 2007 on http://www.sciencetext.com

    db

  55. 管理相关的Wordpress插件 | 53vi.com >梦想视觉-资讯|软件|设计|酷站|Icons|素材 Says:

    [...] FeedBurner FeedSmith - 确保所有的Feed地址都被重定向到FeedBurner。 Fix Database - 检查Wordpress数据库错误并尝试修复。 Genki Announcement - [...]

  56. ARHI » Blog Archive » Pluginuri de baza pentru un blogger Says:

    [...] Fix Database - Checks your WordPress database for errors and attempts to fix them. [...]

  57. Wordpress站长使用的插件50个 : 和意博客 Says:

    [...] Fix Database - 帮助你尝试修复数据库错误. [...]

  58. dyohanan.com » Great Tools To Use With Your Wordpress Blog Says:

    [...] Fix Database - Checks your WordPress database for errors and attempts to fix them. [...]

  59. Converse Says:

    thanks for this great tool!

  60. dimanet » Архив блога » Список разных плагинов для WordPress Says:

    [...] проводить подписку на фид вашего блога через Feedburner. Fix Database - плагин проверяющий базу данных WordPress на наличие [...]

  61. Fix Database on Database Plugins | WordPress Says:

    [...] Posted by admin in Database Plugins, … | 07.13.2007 - 3:51 am Plugin Author: Donnie La Curan [...]

  62. 50个与管理相关的Wordpress插件 : Zollman.Net Says:

    [...] Fix Database - 检查Wordpress数据库错误并尝试修复。 [...]

  63. nowe samochody Says:

    it should work also for Wordpress 2.3

  64. Art-Life » 50个与管理相关的Wordpress插件 Says:

    [...] Fix Database - 检查Wordpress数据库错误并尝试修复。 [...]

  65. Wordpress各类插件归类整理 - Booto’Blog Says:

    [...] Fix Database - 检查Wordpress数据库错误并尝试修复。 [...]

  66. GuXiang.info » Blog Archive » 50+ Tools For The WordPress Admin Says:

    [...] Fix Database - 帮助你尝试修复数据库错误. [...]

  67. Các plugin cần thiết hỗ trợ việc quản lý Wordpress Says:

    [...] Fix Database - Kiểm tra Database của Wordpress và sửa nếu phát hiện lỗi. [...]

  68. Wordpress插件大全之55个管理相关插件 | 望月 Says:

    [...] Fix Database - 检查Wordpress数据库错误并尝试修复。 [...]

  69. Life Of A Borneo Gurl » It’s Okay Now! Says:

    [...] me that I can fix my comments database section just by installing and activating a plugin called Fix Database, my blog is now back to normal again! [...]

  70. Admin Plugins | The Daily Punt Says:

    [...] FeedSmith - Ensures all your RSS feed subscribers get counted in your FeedBurner subscriber count.Fix Database - Checks your WordPress database for errors and attempts to fix them.Genki Announcement - Allows [...]

  71. Top 50 Tools For The WordPress Admin - Top 100 Directory Says:

    [...] Fix Database - Will check your WordPress database for errors and attempt to fix them. [...]

  72. NilDesign.ru » 300+ плагинов для WordPress Says:

    [...] проводить подписку на фид вашего блога через Feedburner.Fix Database - плагин проверяющий базу данных WordPress на наличие [...]

  73. Karpacz Noclegi Says:

    Hmm, plugin 4 fix database? Could the plugin fix my comments database?

  74. Karpacz Noclegi Says:

    Oh sorry, i didn’t see the post above

  75. Deen Yusoff Says:

    Hey thanks for the plugin. It worked.

    Had the unknown column “pingback_views” error when I deleted comments and your plugin fixed it. :D

  76. Oh God: more than 300 tools move to yours WORDPRESS | 灵度O-Town Says:

    [...] Fix Database - Checks your WordPress database for errors and attempts to fix them. [...]

  77. one and more wordpress plugin and tools party on wordpress | 灵度O-Town Says:

    [...] FeedBurner FeedSmith - 确保所有的Feed地址都被重定向到FeedBurner。 Fix Database - 检查Wordpress数据库错误并尝试修复。 Genki Announcement - [...]

  78. Fix Database | Wordpress Files Resources Themes and Tutorials Says:

    [...] Click here to visit the Wordpress Fix Database Plugin Now  [...]

  79. » Плагины для этого блога > Блог php-программиста Says:

    [...] проводить подписку на фид вашего блога через Feedburner. Fix Database - плагин проверяющий базу данных WordPress на наличие [...]

  80. roshan Says:

    Very useful thank you very much! I am currently using it on two of my blogs

    http://www.earnbux.net and roshan.earnbux.net

    thanks again!

  81. Torrent » Blog Archive » Wordpress插件归类整理 Says:

    [...] Fix Database - 检查Wordpress数据库错误并尝试修复。 [...]

  82. Wordpress插件大整理 | 何必呢 Says:

    [...] FeedBurner FeedSmith - 确保所有的Feed地址都被重定向到FeedBurner。 Fix Database - 检查Wordpress数据库错误并尝试修复。 Genki Announcement - [...]

  83. 左八::z8′blog::自然醒 » Blog Archive » wordpress插件集锦(转的,留着以后用) Says:

    [...] Old-Style Upload - 自定义上传任意文件到任意文件夹。 Fix Database - [...]

  84. 维纳斯 » Blog Archive » wordpress插件集锦(不断添加中…) Says:

    [...] Old-Style Upload - 自定义上传任意文件到任意文件夹。 Fix Database - [...]

  85. 50 plugins utilisimos para administrar wordpress | Blog! Estudio Creativo. Diseño grafico y mucho más Says:

    [...] Fix Database: comprueba tu base de datos para comprobar si hay errores, y los corrige. [...]

  86. 50 plugins wordpress | Blog Gootum.com Says:

    [...] Fix Database: comprueba tu base de datos para comprobar si hay errores, y los corrige. [...]

  87. Listado con más de 50 plugins muy útiles para Wordpress « Helektron.com Says:

    [...] Fix Database: comprueba tu base de datos para comprobar si hay errores, y los corrige. [...]

  88. 38 ways to optimize and speed up your WordPress blog | WordPressGarage.com Says:

    [...] WordPress Plugin: Fix Database to check all tables in your database and fix any [...]

  89. 50+ plugins para la administración de Wordpress en Cesarius Revolutions | Cibercultura, GNU/Linux y Software Libre. Says:

    [...] Fix Database: comprueba tu base de datos para comprobar si hay errores, y los corrige. [...]

  90. Plugins para la administración de Wordpress « [ Balrof ] Says:

    [...] Fix Database: comprueba tu base de datos para comprobar si hay errores, y los corrige. [...]

  91. BBiTT’s Life blog. » Blog Archive » wordpress插件集锦(转帖备用) Says:

    [...] Old-Style Upload - 自定义上传任意文件到任意文件夹。 Fix Database - [...]

  92. wordpress插件集锦(不断添加中…) Says:

    [...] 动态显示存档。 Filosofo Old-Style Upload - 自定义上传任意文件到任意文件夹。 Fix Database - 检查Wordpress数据库错误并尝试修复。 Front Page Excluded Categories - [...]

  93. New1’s trip » WP插件汇总(2):Wordpress管理员使用的插件 Says:

    [...] Fix Database - 帮助你尝试修复数据库错误. [...]

  94. 南阳SEO网络营销博客 » wordpress插件集锦,收藏留着用 Says:

    [...] 动态显示存档。 Filosofo Old-Style Upload - 自定义上传任意文件到任意文件夹。 Fix Database - 检查Wordpress数据库错误并尝试修复。 Front Page Excluded Categories - [...]

  95. (很好很强大,收藏备用)wordpress插件集锦 | 睡到自然醒blog Says:

    [...] 动态显示存档。 Filosofo Old-Style Upload - 自定义上传任意文件到任意文件夹。 Fix Database - 检查Wordpress数据库错误并尝试修复。 Front Page Excluded Categories - [...]

  96. wordpress Plug-in Category collect | 王标 Says:

    [...] Old-Style Upload - 自定义上传任意文件到任意文件夹。 Fix Database - [...]

  97. wordpress插件超级大集锦 | 听 雨 轩 Says:

    [...] 动态显示存档。 Filosofo Old-Style Upload - 自定义上传任意文件到任意文件夹。 Fix Database - 检查Wordpress数据库错误并尝试修复。 Front Page Excluded Categories - [...]

  98. 25 formas de optimizar e acelerar o seu blog Wordpress | Fique Rico Online Says:

    [...] Optimize DB para optimizar as tabelas da base de dados do seu blog. [21] Utilize também o plugin WordPress Plugin: Fix Database para verificar as tabelas e a base de dados, e neste caso encontrar possíveis erros a arranjar. [...]

  99. 丰富你的wp-wordpress插件集锦 - 笑傲网志 - Jets blog Says:

    [...] 动态显示存档。 Filosofo Old-Style Upload - 自定义上传任意文件到任意文件夹。 Fix Database - 检查Wordpress数据库错误并尝试修复。 Front Page Excluded Categories - [...]

  100. Mis principios con Wordpress | La coctelera tecnologica Says:

    [...] Fix Database [...]

  101. 网站优化 Says:

    1.分析选择关键词
    网站优化服务,网站排名服务网络营销推广。2.分析竞争对手
    搜索引擎优化提高网站排名.
    3.分析客户网站SEO工具4.反向链接建立.向国内外各大搜索引擎地址、分类目录、黄业等提交您的网站.

  102. wordpress插件集锦(不断添加中…) | Sharing Says:

    [...] Old-Style Upload - 自定义上传任意文件到任意文件夹。 Fix Database - [...]

  103. IndoProTech.com Says:

    120+ WordPress Plugins…

    Running your Wordpress blog can feel like a full-time job sometimes. We have compiled an A-Z list of more than 120 plugins to help you streamline everything you need to do out back.
    AJAX-Powered WordPress Plugins
    The WordPress blogging platform has tho…

Leave a Reply


Blog Post Times