Problems with version 2.8 and 2.8.1

Hey Malae,

This problem already has been reported:

see here

Apparently it’s only going wrong for just a few sites…

I’m working on a solution, so stay tuned!

peace,
Rolf van Gelder

Hey Malae,

I just released v2.8.2 of the plugin.
The table name issue finally should be resolved with this new version.

Please try it and let me know if it works or not! Thanks!

peace,
Rolf

Hi Rolf,

Thanks for the quick reply.

I just noticed that the previous run with version 3.8.1 had actually left two less revisions than the number specified! I then made extra updates to increase the number of revisions for deletion.

I have installed version 3.8.2 and it now shows the list of tables, but as with version 3.8.1, the Optimisation Result shows: ‘Table does not support optimize, doing recreate + analyze instead’ for all InnoDB engine items.

Shows negative savings!
SAVINGS:
size of the database
BEFORE optimization 8.419 MB
AFTER optimization 9.188 MB
SAVINGS THIS TIME -788.246 KB
TOTAL SAVINGS SINCE THE FIRST RUN 237.614 MB

I am holding on updating my other sites until I hear further.

Hey Malae,

The InnoDB message is normal.

For InnoDB tables it uses a different way for optimizing the tables than for MyISAM (see the FAQ of the plugin)

So it does work, just in a different way.

Don’t worry about the negative value. The database is dynamic so the size changes all the time while visitors are visiting it, while posts / pages are added / deleted / modified…

peace,
Rolf

Hi Rolf,

Thanks for your explanation. My test site is running on XAMPP and has 44 items in the database list, of which 21 are MyISAM and the rest InnoDB. On the hosted site (same WordPress and theme versions), all 44 tables are MyISAM. I had not paid much attention until the present problems, but it does seem the list is much longer now. I do not recall seeing the Table does not support optimize, doing recreate + analyse instead message previously, perhaps the InnoDB items were not listed by earlier versions.

I understand the possible reasons for the negative value, but the test site has only fixed pages, no postings, no visitors and no changes made before the optimization. Also, the number of retained revisions has always been 6 and the disappearance of 2 revisions leaving 4, gave me cause for concern because, if it had occurred on my hosted site, which retains only 2 revisions, they could have been deleted leaving 0.

Frankly, I would feel more comfortable reverting to an earlier version.

Hey Malae,

Thanks for the info.

You safely can use v2.8.2.
The only difference between the last stable version (v2.7.9) and the current one is the way the table names are retrieved from the database.

The whole process of cleaning and optimizing the tables didn’t change at all…

peace,
Rolf

Hi Rolf,

You did not address my comments about the disappearing revisions, nevertheless I updated to version 2.8.2 on my hosted sites. For both sites the plug-in is set to retain 2 (two) revisions. I ran the plug-in and found no revisions showing on the Edit page. On refreshing, one revision appeared, but after running the optimisation again, it too disappeared. Similar issues on the second site.

It seems that the plug-in may be affecting the display of revisions on the Edit page as well as deleting them unnecessarily. I have removed version 2.8.2 and reinstalled version 2.7.9 and these issues have not reoccurred.

Hey Malae,

I looked into your problem but couldn’t find any flaws in the software. I cannot reproduce the problem on my sites.

Can you disable all other plugins for a moment and try it again?
The only thing I can think ofa this moment is maybe a clash with another plugin…

Please let me know the result!

peace,
Rolf

Hi Rolf,
Thanks for your reply. It may well be a conflict with another plug-in. I will do some further testing of version 2.8.2. as soon as I have some spare time and will let you know.