Support

I got this error in my error log — https://archeofact.ca/

Not sure ?

[15-Oct-2018 14:30:40 UTC] PHP Fatal error:  Uncaught RuntimeException: Unknown column '*' in 'field list' SQL=SELECT `*`
FROM `wp_admintools_storage`
WHERE `at_key` LIKE 'mail_%' in /mysitepath/public_html/wp-content/plugins/admintoolswp/app/library/database/driver/mysqli.php:530
Stack trace:
#0 /mysitepath/public_html/wp-content/plugins/admintoolswp/app/library/database/driver.php(989): Akeeba\AdminTools\Library\Database\Driver\Mysqli->execute()
#1 /mysitepath/public_html/wp-content/plugins/admintoolswp/helpers/admintoolswp.php(118): Akeeba\AdminTools\Library\Database\Driver->loadObjectList()
#2 /mysitepath/public_html/wp-includes/class-wp-hook.php(286): AdminToolsWP::cron()
#3 /mysitepath/public_html/wp-includes/class-wp-hook.php(310): WP_Hook->apply_filters('', Array)
#4 /mysitepath/public_html/wp-includes/plugin.php(515): WP_Hook->do_action(Array)
#5 /mysitepath/public_html/wp-cron.php(126): do_action_ref_array('admintoolswp_cr...', Array)
#6 {main}
  thrown in /mysitepath/public_html/wp-content/plugins/admintoolswp/app/library/database/driver/mysqli.php on line 530

Hello,

this is a pretty strange issue. Can you please get in touch with your host and ask him to check this error message? I suspect your database is corrupted.

Let me explain a little the logic behind that statement. SELECT * is a shorthand to ask MySQL to return all columns of a given table: the asterisk has a special meaning, so there is no way the * field is not in the column list, because we're asking for them all!
However, MySQL keeps an internal dictionary of all the columns of all tables. My hunch is that such dictionary become corrupted, hence the error.

I’m investigating this, curiously it don’t seem to happen, so far, on load or a specific action.

The error happen at an unknow point ? — I can reload the site many times, go to pages, no error???
At one point, it just appear.

I send this to my host provider.

Do you see anything that will help me pinpoint the error or what table is problematic?

I analyse & check & Optimized the database in phpmyadmin - No Errors, seems OK ?
I repair anyway....

I just try to deactivate & uninstall Admintools on my Mamp local copy just to see.

Difficulty to deactivate WP Admintools on localhost Mamp even if the deactivation (firewall) was off

I turn on and off and I was able to deactivate

And after that it stay stuck on the suppression message when I want to uninstall (more than 15 minutes)

On refresh the wp page —> Admin was gone

I check the database and I got these after a sql search of (admintools) — See Image —What to do now ?

After half uninstall Admin on my localhost (Mamp) no more error.
• I need to clean up the database of admintools remnant. ( Need some hints here...)

• After — I will reinstall Admintools.

What you are seeing are leftovers used by Admin Tools to display some messages or store internal info.
It won't affect your site, but thanks for reporting it, I'll update the uninstall script to leave a clean environment.

And after that it stay stuck on the suppression message when I want to uninstall (more than 15 minutes)

What do you mean with that? What was the message?

Thanks David.
We getting somewhere...

My hosting service answer:

We have made the necessary changes at the /home/pathtomysite/public_html/wp-content/plugins/admintoolswp/app/library/database/driver/mysqli.php path which was been showing up in error logs and tried to access the site.

There are no error logs been reported now.

• I ask them to define these changes, waiting for the answer. What do you think they did?

• Now the error log show only this ?
[code][16-Oct-2018 13:05:08 UTC] PHP Warning: Invalid argument supplied for foreach() in /pathtomysite/public_html/wp-content/plugins/admintoolswp/helpers/admintoolswp.php on line 120

• What do you think ?

• For my local copy (where I uninstall Admintools, Can I safely reinstall it ?

Can you please download the latest dev release and try again?

————————————————————————————————
— 1—

And after that it stay stuck on the suppression message when I want to uninstall (more than 15 minutes)

You Ask...

What do you mean with that? What was the message?

No message, when I try to delete Admintools in WP admin, you see de WP Admin message “Suppression...” under the plugin name (This version of WP Admin is in french... You should have another message in an english WP Admin, something like “Deleting... I guess...

I leave this message for more than 15 minutes before refreshing the page, Admintools, but it was gone from the WP plugin listing.
————————————————————————————————

————————————————————————————————
• LOCALHOST MAMP SITE COPY
— 2—
I just download the version revBDA28AD Alpha, ready to install on my localhost and after the live site.

QUESTION 1: Do you think I can safely install this version over my localhost Mamp version (the one with remnants of Admintools or should I clean manually the database before install?
————————————————————————————————

————————————————————————————————
• LIVE SITE
— 3—
I have the answer from my hosting service of how they take out the error

...Unknown column '*' in 'field list' SQL=SELECT `*`
FROM `wp_admintools_storage`
WHERE `at_key` LIKE 'mail_%' in /mylivesitepath/wp-content/plugins/admintoolswp/app/library/database/driver/mysqli.php:530...

They say...

We have commented the line on which the error was been showing up which fixed this issue.

— I guess —> /admintoolswp/app/library/database/driver/mysqli.php —> Line 530 ???

This is what I have —> mysqli.php —> Line 530 —>
QUESTION 2: Is this modified ?

			}
527:			// The server was not disconnected.
528:			else
529			{
530: #				throw new \RuntimeException($this->errorMsg, $this->errorNum);
531:			}
532:		}

QUESTION 3: Can I safely install this Alpha version over my Live Admintools version (even if modified by hosting service) ?

QUESTION 4: In Wordpress, Can you install over or I have to uninstall first ?

Joomla Guy All The Way here... Not sure

————————————————————————————————

Sorry for my long post, I just don’t want to mess up :)

Plugin uninstall: Thank you very much for your report, I will take a look onto it.

Localhost MAMP: Yes, you can safely install it even if there are leftovers from the previous install. In the screenshot you attached, some of them are created directly from WordPress (like the most recent activated plugins), others are Admin Tools temporary data that you can ignore (however in the next version we will take care of removing them, too).

Live site:

• Commented file: Well, they simply commented the code so you wouldn't get the error... Please install the latest dev release where we actually address the problem.
• Live install: Yes, you can install it. Most likely this alpha version will be the next stable one
• WordPress installation: WordPress doesn't allow you to overwrite plugins. You have to uninstall it and then re-install or upload the new plugin using FTP

I’m just trying your —> admintoolswp-revBDA28AD-pro.zip release

Curiously, on my mac the download do not seem to complete
See pict attach.

On Safari

It stay like that forever, it seem???

Seem to work on chrome

Ok install on local

If I uninstall on live site, do I loose my settings ?

For the download, I think it’s the quality of my internet provider, I switch and I was able to download by safari without problem

ON Localhost - No more errors — Thanks

• Installation on local site of alpha revBDA28AD without any problems

• After 15 minutes of reloading pages, using menus.... Not one errors in the logs


GREAT — Now I have to reinstall (uninstall and reinstall) on the live site. Hopefully I will not loose my settings

Note: Another crappy reality about Wordpress, no wonder I never use it for my new clients

Let me jump in here since Nicholas is gone for the day.

You will lose your settings when you uninstall. You need to export them first and import after you've reinstalled. That will preserve your settings.

Thanks Dale

I really hate Wordpress, To late, I install and loose every settings in my Admintools, Redirection, htaccess, everything.... Few hours of fine tuning.... GRRRRRRRRRRRRR!

I have a Akeeaba backup.

I will install it on my local site.

What sql table I have to import.

Ok, Install, the fronted work correctly at http://thelocalpathtomysite/

But the administration send me to —> https://thelocalpathtomysite/wp-login

I’m using http. not https on the local server

I take out all .htaccess & .htpassword, also empty admintools-waf.php and take out the file inside the mu-plugins and rename main.php

Any idea,

I really like to recover the Admintools setup, it was a lot of redirection and special settings in the hatches maker and others.

Closing shop for today... Still hate WP :(

• This Morning No more errors with the Alpha Version on the live site — Great!

• I just see the import/export settings buttons in AdminTools (My Bad)

My last question here
Do you think I can retrieve the Htaccess Maker from a backup database ?

I ask because, so far, I cannot access my administration on my backup copy on my local mamp installation — As I say before, it always want to send me to the https version of the site (https://thelocalpathtomysite/wp-login)
Dont work on my Mamp installation.

Technically yes, you can extract it, but it's quite painful: all the options are stored in JSON object inside the database and you have to extract only the things that are really needed to you.

I guess it's easier to simply rewrote the settings you applied before.

Regarding the HTTPS issue in your local machine, please check if your wp-config file has a line with FORCE_SSL_ADMIN and remove it. That's an option used by WordPress to force HTTPS no matter what.

You guys are the best and WP is the worst !

THANKS A MILLION TIME DAVIDE !

Regarding the HTTPS issue in your local machine, please check if your wp-config file has a line with FORCE_SSL_ADMIN and remove it. That's an option used by WordPress to force HTTPS no matter what.

In my case, commenting it out, give me a white page

But passing from;

// +-+-+ Admin Tools for WordPress - Start
define('FORCE_SSL_ADMIN', true);

to

// +-+-+ Admin Tools for WordPress - Start
define('FORCE_SSL_ADMIN', false);

Work Perfectly and I can now access all my old settings in Admintools

This is close for me, thanks again...