XF 2.1 Admin CP [ only ] in state of stasis

Claverhouse

Active member
As per this post:


Not blaming the add-on --- repeated from there:

Tried to install the latest, and the process stalls for hours.

Stuck on:

Upgrading…
Upgrading s9e/MediaSites 2.3.23 .

The Admin Control Panel says:

One or more add-ons currently have actions pending and may be in an inconsistent state. Because of this, some errors may be suppressed and unexpected behavior may occur. If this does not change shortly, please contact the add-on author for guidance.


The settings button doesn't work to uninstall, and I have tried re-upgrading; and deleting by FTP which continued that message; and reuploading by FTP...



I have deleted the add-on files in /src. no change: added them back to see if they would finally install. Nothing helps and can't use any of the settings buttons on the add-ons page nor upgrade languages.

The forum works OK, and that particular excellent add-on still works as ever. But most of the Admin CP is not working very well.


A few Server Errors of this type over the week:

Code:
    XF\Db\Exception: MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction src/XF/Db/AbstractStatement.php:228

    Generated by: Unknown account Feb 5, 2020 at 6:43 PM

Stack trace

UPDATE  `xf_job` SET `trigger_date` = ?, `last_run_date` = ? WHERE job_id = ? AND trigger_date = ?
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1205, 'HY000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1205, 'HY000')
#2 src/XF/Db/AbstractAdapter.php(94): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/AbstractAdapter.php(322): XF\Db\AbstractAdapter->query('UPDATE  `xf_job...', Array)
#4 src/XF/Job/Manager.php(188): XF\Db\AbstractAdapter->update('xf_job', Array, 'job_id = ? AND ...', Array)
#5 src/XF/Job/Manager.php(79): XF\Job\Manager->runJobEntry(Array, G)
#6 job.php(42): XF\Job\Manager->runQueue(false, 8)
#7 {main}


I am running the latest XenForo and nearly every add-on is up-to-date. Health checks pass OK. There don't seem to be the options to optimise and repair the mylsql databases as in the ancient vBull of so many years ago, and I don't want to mess about with stuff I am rusty on now.

The only recent change was a week or so ago going from ( I think ) 7.3 to 7.4 in cPanel. Would reverting this, or going even lower to 7.2 --- my hosts frown on even 7.1 --- solve this, or should I reinstall XenForo again ?

Many thanks.
 

Claverhouse

Active member
s9e/MediaSites that is the one permanently pending.

The rest are all working as normal [ presumably until I might attempt to upgrade them... ]


From the page direct, suppressing the developers for clarity.


Code:
[ITD] Mini Clip Games 2.0.0

[KL] Admin Tools
[KL] Admin Tools 1.0.0 Beta 2
Advanced administration tools to simplify your forum management.


[KL] Profile Cover
[KL] Profile Cover 1.0.0 Beta 2
Beautify your user profiles with profile banners.


[SC] Highlighting Threads User Participated In 1.0.0
This extension allow you to highlight every thread the user has posts in.



[TH] Auto Merge Double Posts
[TH] Auto Merge Double Posts 1.1.1 Patch Level 2
Automatically merge double posts.



[xFT] Photopea Editor
[xFT] Photopea Editor 2.0.0 Beta 6
Graphical editor Photopea on HTML5 for xenForo.



[xFT] Pixlr Editor
[xFT] Pixlr Editor 2.0.0 Beta 6
Graphical editor Pixlr on Flash for xenForo.



Alert Improvements 2.6.2
A collection of improvements to the XenForo 2 Alerts system.



Artodia: WebDav 0.0.1
WebDav client for editing templates in editor of your choice.



Attachment Improvements 2.2.0
A collection of improvements to XF's attachment system



BB Code: Thread and Post 2.1.3


Change Content Owner 2.0.0 Release Candidate 2
Change Content Owner is an add-on that allows you to change content owner



Change Post Date 2.1.2
Change Post Date as an inline moderator option


Change Title length (STCTL2)
Change Title length (STCTL2) 1.1.0
Allows you to change the length of the thread and node title.


Code 2.1.2
Makes [code] bbcode and code editor way more functional by adding copy, expand, collapse buttons, resizer bar, code line numbers and ability to highlight lines.



Content Downloader 2.0.0
Download entire thread or user content as standalone file



Content Title Edit History 2.1.5
Logs title changes to the XF edit history system.


CopyCode 2.0.7
This add-on ads a button to copy code from [CODE] to the clipboard.



Country Flags by IP Address 2.0.10
Displays the flag of the country members are in using their IP Address location


DragonByte Member Map
DragonByte Member Map 2.3.8
Geolocate your members and plot them on an interactive Google map!


DragonByte Preview Last Post
DragonByte Preview Last Post 1.0.0
Provides a preview tooltip for the last post in a thread.



Editor & BB Code Manager
Editor & BB Code Manager 1.2.1 Patch Level 1
Take full control over your BB codes and rich text editor.


Email Full Message Text Permission 2.1.3
Adds permissions to include full message text in emails, per usergroup


Email Queuing Enhancements 2.0.1
Persistent retry logic for delivering to the mail transport


Force HTTPS Images 2.0.1
Forces users to use HTTPS images


Force Users to Read a Thread (STFRT2)
Force Users to Read a Thread (STFRT2) 1.2.2
Force a user to read a thread before he can perform further actions in the forum.



Install & Upgrade
Install & Upgrade 1.1.5
Installation and upgrades made easy.


ITD Embeded Flash Games 2.0.0

Jump To Permissions 2.0.0
This add-on allows you to quickly switch between permission interface.


Known Bots 2.0.0
Adds additional definitions for bot detection in sessions



Limit Bots 2.1.1


Local Time Indicator 1.0.0


Login as User (LAU2)
Login as User (LAU2) 1.2.4
Log in to another user's account with a click



Math 2.1.1
Math support and a handy button to insert it all rolled into one addon!


Nested Quotes
Nested Quotes 1.0.0
Allows quotes to be nested more than one level deep.



No replies to closed threads 2.0.0
Removes quick reply from closed threads


Notice Time Replaceables 2.0.4
Adds replacables to expose the start/end time of a notice.



Post Content Find / Replace
Post Content Find / Replace 2.0.1
Allows an administrator to do a regular expression find and replace in the content of all posts.



Post Delete Time Limit 2.0.0


Preserve Logs 1.2
Preserves moderator logs for spam and registration



Prism Antivirus 1.0.0 Alpha 1
Antivirus check of uploaded content via VirusTotal API.



Search Improvements 2.2.7
Minor search improvements



Tapatalk
Tapatalk 1.2.5
Tapatalk - Mobile First Community Platform - Free forum mobile app, Free forum hosting, Managed Hosting for forums



Username Restrictions 2.0.1
Prevents usernames from matching usergroups (helps user group tagging)



Who Replied 2.0.7
Show the users who replied to a specific thread



Word Count Search 2.4.4
Word-count range searches



XenForo Importers
XenForo Importers 1.3.0
Collection of importers for XenForo.


XenForo Redirects for vBulletin
XenForo Redirects for vBulletin 1.1.5
Seamless redirection for any vBulletin URLs to imported XenForo content


A few are inactive.  Many thanks.

It is a very tiny forum.
 
Last edited:

Max Taxable

Well-known member
Country Flags by IP Address -- Not sure but disable this one, See if doing that clears the mud for you. I suspected you might have it. When you re-enable it the cron in this one titled “ Update MaxMind GeoIP database file" needs to be disabled.
 
Last edited:

Claverhouse

Active member
Thanks very much again; but the problem includes the fact I can't disable anything etc. from the admin panel. The settings button just doesn't respond for any add-on.

A Three-Pipe problem, I guess...
🚬🚬🚬
 

Max Taxable

Well-known member
the problem includes the fact I can't disable anything etc. from the admin panel.
At the very least, make sure that cron is disabled if you can.. Tools>Cron Entries
Since Country Flags is not the one pending action, it would not be the cause of the other addon pending actions.
I thought so, I just remembered that error for the guy who tried to install a copy he still had of it, AFTER the addon was deleted. Did it happen as well when someone with that addon installed, tried to upgrade xF?
 

Ozzy47

Well-known member
This poster was updating an addon, not XF. Ultimately something went wrong in the update process and the upgrade was interrupted, but now can’t restart.
 

Max Taxable

Well-known member
I only brought it up because the only other time I saw that error, (One or more add-ons currently have actions pending and may be in an inconsistent state.) was related to the country flags addon. Not saying the same is true here, was just something for him to check. Harmless.
 

JoshyPHP

Well-known member
Judging by the SQL error message, my guess is there's a long-running query that needs to be killed. Current queries can be found in phpMyAdmin, in Status > Server.

One possible cause for the lock timeout is that tables use MyISAM and not InnoDB.
 

Claverhouse

Active member
Not yet, thank you. We had a few storms and nearly 30 hours without electricity, and I didn't get back to it yet.

I am now trying with a different browser... Heaven bless this venture.
 

Claverhouse

Active member
Yes ! Using Seamonkey sent it through normally. I suspect the javascript on my Firefox is slightly borked.

Trouble is after 30 odd years of the internet we are down to a pitiful handful of 'competing' browsers, with still fewer engines, smaller than a man's hand.

Worse probably on Linux as Windows has a few more shells/overlays masquerading as separate browsers.

I blame Google.


Many thanks to all.
 

JoshyPHP

Well-known member
There's no relation between browsers and SQL errors. If the SQL error spontaneously disappeared, it's probably just that the underlying cause disappeared while you weren't looking. If the issue is a long-running query as I suspect, it's possible that it either finished running or it was automatically killed.

The main point is that there's a good chance the same error will reappear at some point in the future.
 

Claverhouse

Active member
Well, all I can say is that updating on my Firefox doesn't work any more, and using another browser works. As for SQL errors I daresay an XenForo version update will cure that.

Thank you though.
 
Top