Plugin version 2.7.3 gives error

  • Resolved LittleBert

    (@littlebert)


    12 years, 5 months ago

    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://ww.wp.xz.cn/plugins/rvg-optimize-database/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Contributor cageehv

    (@cageehv)

    12 years, 5 months ago

    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

    (@cageehv)

    12 years, 5 months ago

    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

    (@littlebert)

    12 years, 5 months ago

    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

    (@cageehv)

    12 years, 5 months ago

    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

    (@cageehv)

    12 years, 5 months ago

    Hey LittleBert,

    Just released version 2.7.4 of the plugin which will fix your problem.

    Enjoy!

    Rolf

    Thread Starter LittleBert

    (@littlebert)

    12 years, 5 months ago

    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

    (@cageehv)

    12 years, 5 months ago

    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.