Plugin Contributor
cageehv
(@cageehv)
Hey Fabio,
That’s strange…
Can you please run the following query on your database (phpMyAdmin)?
SELECT engine, (
data_length + index_length
) AS size, table_rows
FROM information_schema.TABLES
WHERE table_schema = '<your database name>'
AND table_name = '<one of your tables>'
Please let me know the result.
Ciao,
Rolf
I have recently moved the DB from MySql 5.0 to 5.5
Plugin Contributor
cageehv
(@cageehv)
Hey Fabio,
Okay, so the query works… Thanks for testing.
I have to look further into it to see what can be the problem.
I’ll get back to you when I know more.
Ciao,
Rolf
Plugin Contributor
cageehv
(@cageehv)
Hey Fabio,
The result after optimization shows for instance:
# - table name - optimization result - engine - table rows - table size
1 wp_options OK myISAM 586 773.2 KB
Is it correct that for you it only shows the first 3 columns? (#, table name and optimization result) and leaves out the last 3 columns? (engine, table rows and table size)
Ciao,
Rolf
Correct. The first 3 columns are OK. Then it shows an empty value for “engine” and 0 both for table rows and size.
Plugin Contributor
cageehv
(@cageehv)
Hey Fabio,
Is is possible to switch your site into ‘debug-mode’ for moment and check if using my plugin generates any errors?
To switch to ‘debug-mode’ make a change to the wp-config.php file in the root of your WP installation:
define(‘WP_DEBUG’, true);
Grazie!
Rolf
Hi Rolf,
yes I am getting a lot of errors.
First this one, at the very beginning:
Notice: Undefined offset: 0 in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1835
Notice: Trying to get property of non-object in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1835
Then, in the “engine” column of every row:
Notice: Undefined offset: 0 in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1633
Notice: Trying to get property of non-object in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1633
In table rows column:
Notice: Undefined offset: 0 in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1634
Notice: Trying to get property of non-object in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1634
and in table size column:
Notice: Undefined offset: 0 in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1635
Notice: Trying to get property of non-object in /web/htdocs/www.atopon.it/home/wp-content/plugins/rvg-optimize-database/rvg-optimize-db.php on line 1635
Thank you for your assistance.
Fabio
Plugin Contributor
cageehv
(@cageehv)
Hey Fabio,
Thanks for your testing!
It’s a strange problem but I did an attempt to fix it.
I created a new (BETA) version for you: v3.1.4
You can download it from:
http://cagewebdev.com/fabio/rvg-optimize-database-3.1.4.zip
First uninstall the current version (v3.1.3) and add v3.1.4 by uploading the zip file (‘add new plugin – upload’)
Please let me know if that fixes your problem!
Ciao,
Rolf
The site is in production… Do I risk to break things?
Plugin Contributor
cageehv
(@cageehv)
Good question, but the answer is ‘no, no risk’.
Just minor changes and only at the backend (not frontend)
Besides I, of course, tested it on my own sites 😉
Nope…
The page doesn’t load and the browser hangs.
Enabled debug, I got this in the log:
[Fri Feb 27 16:23:21 2015] [warn] [client 94.34.60.246:60444] - AH01220: Timeout waiting for output from CGI script /web/htdocs/www.atopon.it/home/wp-admin/tools.php, referer http://www.atopon.it/wp-admin/tools.php?page=rvg-optimize-db.php
Interesting thing is that I ran it on another site, with the same mysql version, and it works…
Could be something in mysql settings?
Plugin Contributor
cageehv
(@cageehv)
Yes, it definitely has to do something with MySQL settings.
Question: is your database name mixed case (upper and lowercase characters mixed?) on the site with the problem?
