Title: Plugin version 2.7.3 gives error
Last modified: August 21, 2016

---

# Plugin version 2.7.3 gives error

 *  Resolved [LittleBert](https://wordpress.org/support/users/littlebert/)
 * (@littlebert)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/plugin-version-273-gives-error/)
 * Version 2.7.3. doesn’t work for me. At the settings it won’t display the tables(
   to check or uncheck). Instead it gives the following message:
 * Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given 
   in /home/devalkroofvogels.nl/public_html/wp-content/plugins/rvg-optimize-database/
   rvg-optimize-db.php on line 362.
 * I use version 2.6 in other sites without any problems (all multi-site websites).
 * Any help would be appreciated.
 * [http://wordpress.org/plugins/rvg-optimize-database/](http://wordpress.org/plugins/rvg-optimize-database/)

Viewing 7 replies - 1 through 7 (of 7 total)

 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/plugin-version-273-gives-error/#post-4399393)
 * Hey LittleBert,
 * I’ll have a look at it asap.
 * Sounds like a problem with a query.
 * Thanks for the feedback!
    Rolf
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/plugin-version-273-gives-error/#post-4399414)
 * Hey LittleBert,
 * I had a quick look at it and the problem is caused by the query:
    $names = mysql_query(“
   SHOW TABLES FROM “.DB_NAME);
 * So, to me it looks like you are running an old version of MySQL.
 * Try to run the query ‘SHOW TABLES FROM [database name]’ in PHPMyAdmin.
    (replace[
   database name] with the actual name of your database)
 * See what happens and please let me know!
 * Thanks,
    Rolf
 *  Thread Starter [LittleBert](https://wordpress.org/support/users/littlebert/)
 * (@littlebert)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/plugin-version-273-gives-error/#post-4399441)
 * Hi Rolf,
 * Thanks for the quick reply. I know what the problem is. My hosting provider automatically
   generates the names for my databases. It uses names with ‘-‘ followed by a unique
   number. In my case that would be something like name-10.
 * When running a query like SHOW TABLES FROM name-10 it will fail.
 * When running the same query but the database name between special quotes (backticks)
   it works.
 * Working query: SHOW TABLES FROM `name-10`
 * Unfortunately I’m not able to change the name of the database so I hope you’re
   able to help me out here.
 * Thanks in advance!
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/plugin-version-273-gives-error/#post-4399445)
 * hey LittleBert,
 * That’s useful information!
    I can add the backticks and then your problem probably
   will be solved.
 * Will release the next version tomorrow (1:19am here now ;-))
 * Rolf
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/plugin-version-273-gives-error/#post-4399520)
 * Hey LittleBert,
 * Just released version 2.7.4 of the plugin which will fix your problem.
 * Enjoy!
 * Rolf
 *  Thread Starter [LittleBert](https://wordpress.org/support/users/littlebert/)
 * (@littlebert)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/plugin-version-273-gives-error/#post-4399626)
 * Sorry for the late reply but it works perfectly now!
    Thanks Rolf for the quick
   response (and working too late at night 🙂
 * Bert
 *  Plugin Contributor [cageehv](https://wordpress.org/support/users/cageehv/)
 * (@cageehv)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/plugin-version-273-gives-error/#post-4399627)
 * Hey Bert,
 * Good to hear your problem has been fixed.
    And thanks for the compliments!
 * Best,
    Rolf

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Plugin version 2.7.3 gives error’ is closed to new replies.

 * ![](https://ps.w.org/rvg-optimize-database/assets/icon-256x256.png?rev=3350597)
 * [Optimize Database after Deleting Revisions](https://wordpress.org/plugins/rvg-optimize-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/rvg-optimize-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/rvg-optimize-database/)
 * [Active Topics](https://wordpress.org/support/plugin/rvg-optimize-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/rvg-optimize-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/rvg-optimize-database/reviews/)

 * 7 replies
 * 2 participants
 * Last reply from: [cageehv](https://wordpress.org/support/users/cageehv/)
 * Last activity: [12 years, 5 months ago](https://wordpress.org/support/topic/plugin-version-273-gives-error/#post-4399627)
 * Status: resolved