Another update is currently in progress Error in wordpress 4.9.7

Hello there,

I recommended following this steps for failed update https://codex.www.ads-software.com/Updating_WordPress.

Hope this helps! you.

After trying all the available solutions to this, I finally found the problem. For reasons best known to my hosting company, the underlying MySQL database had no space left ( in fact is was over the available allocation ). After a bit of pain and migration to larger database with space available, the upgrade went fine.

Nothing on the file system was changed and it was a complete DB migration so I’m fairly sure that the “Another update is currently in progress.” was resulting from a failure into insert into a “full” DB.

Here was the problem for me. There was more than one row in the wp_options table where option_id = 0. I deleted these in phpMyAdmin, then dropped the indexes on the table and recreated them.

--
-- Indexes for table wp_options
--
ALTER TABLE wp_options
  ADD PRIMARY KEY (option_id),
  ADD UNIQUE KEY option_name (option_name);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table wp_options
--
ALTER TABLE wp_options
  MODIFY option_id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;COMMIT;

• This reply was modified 5 years, 11 months ago by Mark.
• This reply was modified 5 years, 11 months ago by Mark.