Skip to main content

PostfixAdmin: Invalid query: Table 'postfix.vacation_notification' doesn't exist,

Bug Fix:

After login, click on “Fetch email” I got error “Invalid query: FUNCTION postfix.FROM_BASE64 does not exist” To fix it, edit /home/username/public_html/postfixadmin/model/PFAHandler.php at line 572:
# vi /home/datahead/public_html/postfixadmin/model/PFAHandler.php

$base64_decode = "###KEY###"; 

Unable to Delete any Email Address:

When I am trying to delete any email address, I'm getting below the error
Unable to Delete any Email Address
Login to PhpMyAdmin using root user  and select the postfix database from left side and Select SQL and paste the below code then click on go button .
 CREATE TABLE `vacation_notification` (
  `on_vacation` varchar(255) NOT NULL,
  `notified` varchar(255) NOT NULL,
  `notified_at` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`on_vacation`,`notified`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Postfix Admin - Virtual Vacation Notifications'; 

Helpful Link:
Link 1
Link 2