Joe E. on "[Plugin: Optimize Database after Deleting Revisions] Version 4.1.9 just spins endlesslessy"

Hi,

The latest version installed today just ends up with a constantly spinning ajax spinner in the admin.

The problem appears to be that the Ajax runner is not getting dismissed, so it blocks interaction with the buttons and essentially just disables the option to "start Optimization".

If I open dev tools and removed the fixed position of the spinner then I can click the start button, and the optimization process runs normally.

This:

#odb-running { background: rgba(0,0,0,.08)url(../images/running.gif) no-repeat 50% 50%; width: 100%; height: 100%; position: fixed; top: 0; left: 0; z-index: 999;
}

https://wordpress.org/plugins/rvg-optimize-database/

I am just finding the exact same constantly spinning spinner on two sites I just updated on... A cross spinning counter clockwise on the inside, four little rectangles on the outside spinning clockwise, to be specific... It seems to lock things up a bit...

Edit- and to confirm, site I didn't update on, nearly exact to one I did, issue doesn't exist...

Same problem here....constantly spinning

It is being caused because the Ajax callback to dismiss the overlay once the frame content has finished loading is not firing, so the #odb-running overlay (with spinner) is not getting dismissed.

You can temporarily solve the problem by opening your browser dev tools, then select the overlay and delete the line for "position: fixed" from the css.

Obviously this is something that needs a permanent fix by the developer though, but if you want to run the tool in the meantime then that is a simple solution.

It would be better if people didn't post "me too" replies, they don't add anything to the conversation, so please wait for the plugin author to reply...

For your information:
There is no ajax involved here, so, also no call backs...

The 'running indicator' (NOT 'ajax loader') is shown when the optimization starts.

echo "<script>jQuery('#odb-running').show();</script>";

When it's done it writes:

echo "<script>jQuery('#odb-running').hide();</script>";

Can you look at the source of the page and see if this previous line is in there?

Rolf

And, which browser are you guys using?

Chrome for me...

I'll let the first poster answer your first question...

Works fine in Chrome for me...

It's happening in all browsers with all other plugins disabled and with either of the default 2015 or 2012 themes active.

Okay, thanks, but do you see the following line in the source of the page:
<script>jQuery('#odb-running').hide();</script>
And do you get any javascript errors?

<script>jQuery('#odb-running').hide();</script>

No, this is not being loaded, all I can see is:

<script>jQuery('#odb-running').show();</script>

Also, not getting any errors in the console, checked with everything else disabled in both Chrome Dev Tools and the Firefox debugger

Also, I tried this on two different PC's now, maybe it is relevant that they are both Windows versions of those browsers...

Bizarre...
I see this in the page source:

<tr> <td align="right" class="odb-bold">TOTAL SAVINGS SINCE THE FIRST RUN</td> <td align="right" class="odb-border-top odb-bold">2.6 MB</td> </tr> </table> </div><!-- /odb-savings -->
<script>jQuery('#odb-running').hide();</script>

I'm on a Mac, OS X 10.11.5...

If there is anything I can look to with some direction from you that could be helpful.... I'm not a coder...

When you scroll down the 'spinning' page do you see the 'optimization took...' line?

Optimization took 0.2171 seconds.

I have the same problem on Win7 with Chrom browser
This is sad 4.1.7 was also a very bad version!!!

I know, Joe... I haven't been lucky with recent releases... :-(

The page that shows current settings is where the spinning icon is... The buttons on that page are non functional... But when I click the Optimize DB (1 click) in the admin bar it does an optimization and shows the time it took at the bottom of that...

@Joe E, it's just a glitch and the developer is working with us right now to solve it.

@cageehv, no, not seeing that.

The optimization can't be run while the overlay and spinner is active because it prevents interaction with the buttons.

I'm going to try a different site now.