Support

Akeeba Backup for WordPress

#28575 1054 Application Error Unknown column 'quickicon'

Posted in ‘Akeeba Backup for WordPress’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

WordPress version
n/a
PHP version
n/a
Akeeba Backup version
n/a

Latest post by on Monday, 06 November 2017 17:17 CST

joomark
Hello,

I'm working on a local server WAMP, I have restored a wordpress website to test all upgrades.
After installation of Akeeba Backup WP Pro version 2.4.0 I get this error when I'm trying to open Akeeba backup page :

1054 :: Unknown column 'quickicon' in 'where clause' SQL=SELECT `id`,`description` FROM `#######_ak_profiles` WHERE `quickicon` = '1' ORDER BY `id` ASC in

I checked the database and indeed that column is not there (I believe it's correct it's not there)
I noticed when I take out this line:

$this->quickIconProfiles   = $model->getQuickIconProfiles();

in file: wp-content\plugins\akeebabackupwp\app\Solo\View\Main\Html.php(48)

it seems solved.
Feels like this line belongs to the joomla plugin?
Any suggestions on why the error is caused ?


When I run Wordpress in debug mode I see:
(I've shortened url's for readability and security)

( ! ) Warning: Cannot modify header information - headers already sent by (output started at \wp-admin\includes\template.php:2020) in \wp-content\plugins\akeebabackupwp\helpers\templates\wp\error.php on line 34

Call Stack
# Time Memory Function Location
1 0.0010 303904 {main}( ) ...\admin.php:0
2 1.3086 53021960 do_action( ) ...\admin.php:222
3 1.3086 53022680 WP_Hook->do_action( ) ...\plugin.php:453
4 1.3087 53022760 WP_Hook->apply_filters( ) ...\class-wp-hook.php:323
5 1.3087 53023560 call_user_func_array:{\wp-includes\class-wp-hook.php:298} ( ) ...\class-wp-hook.php:298
6 1.3087 53024128 AkeebaBackupWP::boot( ) ...\class-wp-hook.php:298
7 1.3107 53038616 include_once( '\wp-content\plugins\akeebabackupwp\helpers\bootstrap.php' ) ...\AkeebaBackupWP.php:250
8 2.4377 60612280 include( '\wp-content\plugins\akeebabackupwp\helpers\templates\wp\error.php' ) ...\bootstrap.php:77
9 2.4377 60612480 header ( ) ...\error.php:34
1054 Application Error


Please submit the following error message and trace in its entirety when requesting support

1054 :: Unknown column 'quickicon' in 'where clause' SQL=SELECT `id`,`description` FROM `#####_ak_profiles` WHERE `quickicon` = '1' ORDER BY `id` ASC in \wp-content\plugins\akeebabackupwp\app\Awf\Database\Driver\Mysqli.php L 530

Debug backtrace

#0 \wp-content\plugins\akeebabackupwp\app\Awf\Database\Driver.php(1009): Awf\Database\Driver\Mysqli->execute()
#1 \wp-content\plugins\akeebabackupwp\app\Solo\Model\Main.php(113): Awf\Database\Driver->loadObjectList()
#2 \wp-content\plugins\akeebabackupwp\app\Solo\View\Main\Html.php(48): Solo\Model\Main->getQuickIconProfiles()
#3 \wp-content\plugins\akeebabackupwp\app\Awf\Mvc\View.php(517): Solo\View\Main\Html->onBeforeMain(NULL)
#4 \wp-content\plugins\akeebabackupwp\app\Solo\View\Html.php(32): Awf\Mvc\View->display(NULL)
#5 \wp-content\plugins\akeebabackupwp\app\Awf\Mvc\Controller.php(432): Solo\View\Html->display()
#6 \wp-content\plugins\akeebabackupwp\app\Awf\Mvc\Controller.php(442): Awf\Mvc\Controller->display()
#7 \wp-content\plugins\akeebabackupwp\app\Awf\Mvc\Controller.php(387): Awf\Mvc\Controller->main()
#8 \wp-content\plugins\akeebabackupwp\app\Solo\Controller\ControllerDefault.php(68): Awf\Mvc\Controller->execute('default')
#9 \wp-content\plugins\akeebabackupwp\app\Awf\Dispatcher\Dispatcher.php(113): Solo\Controller\ControllerDefault->execute('default')
#10 \wp-content\plugins\akeebabackupwp\app\Awf\Application\Application.php(248): Awf\Dispatcher\Dispatcher->dispatch()
#11 \wp-content\plugins\akeebabackupwp\helpers\Solo\Application.php(278): Awf\Application\Application->dispatch()
#12 \wp-content\plugins\akeebabackupwp\helpers\bootstrap.php(37): Solo\Application->dispatch()
#13 \wp-content\plugins\akeebabackupwp\helpers\AkeebaBackupWP.php(250): include_once('C:\\wamp64\\www\\...')
#14 [internal function]: AkeebaBackupWP::boot('')
#15 \wp-includes\class-wp-hook.php(298): call_user_func_array(Array, Array)
#16 \wp-includes\class-wp-hook.php(323): WP_Hook->apply_filters('', Array)
#17 \wp-includes\plugin.php(453): WP_Hook->do_action(Array)
#18 \wp-admin\admin.php(222): do_action('toplevel_page_a...')
#19 {main}


Thanks for your help in advance !

nicholas
Akeeba Staff
Manager
This is a column that is expected to be there and has absolutely nothing to do with Joomla!. When this column is set to 1 you will get a one click backup icon ("quick icon") in your Akeeba Backup Control Panel page.

You might remember quickicon from Joomla! since there is a plugin type called "quickicon". Plugins in that group render quick action icons in Joomla!'s Control Panel. I wrote that code in Joomla! back in the Joomla! 1.7 days, about 8 years ago. Written by the same developer, having the same intent. That's why the name is the same.

Back to your issue. This column is normally created automatically when it's missing. It would seem that the database user you have configured WordPress to run under does not have the ALTER TABLE privilege and, as a result, Akeeba Backup is unable to add the missing column. Please ask your host to grant your database user the ALTER TABLE privilege and retry accessing Akeeba Backup.

Finally note that with the modification you have created it will be impossible to see any one click backup icons. Also, since the table structure has not been fixed you will most likely be unable to save any changes in the Configuration page.

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

joomark
Hello Nicholas,

Thank you for your fast help. Indeed soemthing was wrong with my installation, and user rights.
I did a new installation and manually updated Akeeba and all works fine now.

Thanks again

nicholas
Akeeba Staff
Manager
You're welcome!

Nicholas K. Dionysopoulos

Lead Developer and Director

πŸ‡¬πŸ‡·Greek: native πŸ‡¬πŸ‡§English: excellent πŸ‡«πŸ‡·French: basic β€’ πŸ• My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

System Task
system
This ticket has been automatically closed. All tickets which have been inactive for a long time are automatically closed. If you believe that this ticket was closed in error, please contact us.

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!