UKC

Plesk Backup Manager Not Working – Missing Tables BackupsSettings, BackupsScheduled, BackupsRunning

Re: Backup Manager Not Working in Plesk

If you get the following message when trying to run a backup in Plesk using the Backup Manager then it is likely that a previous upgrade or installation of the Backup Manager did not complete and so there will be some missing tables.

0: common_func.php3:206
db_query(string 'select `value` from `BackupsSettings` WHERE `param` = 'backup_ftp_settinghost' AND `id` = 6 AND `type` = 'domain'')
1: common_func.php3:253
db_query_ex(string 'select `value` from `BackupsSettings` WHERE `param` = '?(paramName)' AND `id` = ?(objectId) AND `type` = '?(objectType)'', array)
2: BackupFTPRepositorySettings.php:205
BackupFTPRepositorySettings->getRepositorySettingsValue(string 'backup_ftp_settinghost')
3: BackupFTPRepositorySettings.php:43
BackupFTPRepositorySettings->init()
4: BackupFTPRepositorySettings.php:25
BackupFTPRepositorySettings->__construct()
5: BackupFTPRepositorySettings.php:283
BackupFTPRepositorySettingsDomain->__construct(integer '6')
6: client.domain.backup.php:8
plesk__client__domain__backup->getBackupFTPRepositorySettings()
7: backup.ftp-repository.php:35
__backup__ftp_repository->getDumpsStorageCredentials()
8: backup.ftp-repository.php:29
__backup__ftp_repository->getRepositoryList()
9: backup.abstract-repository.php:44
__backup__abstract_repository->accessItemsList(string 'GET', NULL null)
10: backup.abstract-repository.php:26
__backup__abstract_repository->accessItem(string 'GET', NULL null)
11: UIPointer.php:596
UIPointer->access(string 'GET')
12: plesk.php:38

The Plesk Backup Manager needs the following tables in the PSA database:

  • BackupsSettings
  • BackupsScheduled
  • BackupsRunning

Execute the following SQL in phpMyAdmin to create the missing tables:

CREATE TABLE IF NOT EXISTS `BackupsSettings` (
`id` int(10) unsigned default NULL,
`type` enum('domain','client','server') NOT NULL default 'domain',
`param` varchar(255) NOT NULL default '',
`value` varchar(255) character set utf8 default NULL,
UNIQUE KEY `index1` (`id`,`type`,`param`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `BackupsScheduled` (
`id` int(10) unsigned NOT NULL auto_increment,
`obj_id` int(10) unsigned NOT NULL,
`obj_type` enum('server','reseller','client','domain') NOT NULL,
`repository` enum('local','ftp') NOT NULL default 'local',
`last` datetime default NULL,
`period` int(10) unsigned NOT NULL,
`active` enum('true','false') NOT NULL,
`processed` enum('true','false') NOT NULL,
`rotation` int(11) NOT NULL default '0',
`prefix` varchar(255) character set utf8 default NULL,
`email` varchar(255) character set utf8 default NULL,
`split_size` int(10) unsigned NOT NULL default '0',
`suspend` enum('true','false') NOT NULL default 'false',
`with_content` enum('true','false') NOT NULL default 'true',
`backup_day` int(10) unsigned NOT NULL default '0',
`backup_time` time NOT NULL default '00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

CREATE TABLE IF NOT EXISTS `BackupsRunning` (
`sessionId` varbinary(250) NOT NULL,
`param` varchar(250) character set ascii NOT NULL,
`val` varbinary(255) default NULL,
PRIMARY KEY (`sessionId`,`param`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

This will resolve the problem, the Backup Manager will now work correctly!

Parked Domain Services – Infrastructure Upgrades (18th/19th August 2012)

We are shortly commencing the upgrades of all hardware and infrastructure related to the parked domain name services. This will improve security, performance and reliability of all related domain services including:

  • DNS Management
  • Email forwarding
  • Web Forwarding
  • Parked Mailboxes
  • Domain Homepages

These upgrades only concern parked domain name customers and not any hosting accounts will be affected. If your domain name is using name servers other than ns.microlite1.com then this upgrade will not  concern any of your services.

The hardware will be installed and tested by 1st August and migration testing will begin 7th August. We anticipate final completion of the migration to commence weekend 18th/19th August. The entire process will be complete by midnight on Sunday 19th August.

We will disable the Domain Control Panel at 0300 Saturday 18th and it will be re-enabled 0300 Monday 20th. During this period there may be intermittent outages or propagation issues which we endeavour to keep to a minimum. Our priority will be to have the services 100% active by 0300 Monday 20th August.

For information purposes (you do not need to do anything) the parked domain name servers host names will remain the same however the IP addresses will change as follows:

  • ns.microlite1.com -> currently 66.98.136.44 -> changes to 109.75.164.106
  • ns2.microlite1.com -> currently 66.98.137.170 -> changes to 109.75.164.107

This will mean that there will be a propagation delay between changes however this should cause minimal disruption as both sets of IP addresses will remain active during this period.

Thank you for your patience and support during this time. If you have any questions do not hesitate to contact us.

How to get removed from Google Blacklist

Re: Site Blacklisted in Google because of Malware

Ok, so you have cleaned up the malware on your website but find that your site is still blacklisted by Google and you are too impatient to wait for Google to automatically re-scan your website. Then it’s time for you to request a review directly to Google.

This is required if you want to quickly remove your site from Google’s blacklist. Once you submit the request, it’ll take just a few hours to complete the review and remove the warning if your site is clean. Without the request, it may take

The request does two important things:several days before your site’s status is cleared.

1) It tells Google that the owner of the site is aware of the problem and has already taken action to remove malicious content. This shifts the odds in your favour when they make decisions after ambiguous results of scans.

2) It puts the site on a priority list (it should be scanned within 24 hours)

Don’t be afraid to request the review even if you are not sure that your site is completely clean. If any security issues are detected during the review, they will be reported in your Webmaster Tools account. Then you can fix them and request another review.

Blacklisted sites are not removed from search results (they are just labeled as potentially harmful), so you only need to remove the warning.

You can request a review of your site using Google Webmaster Tools:

http://www.google.com/webmasters/tools/

More information about the review process is available in Google’s Webmaster Help Center.

http://www.google.com/support/webmasters/bin/answer.py?answer=45432

Why do I get a blank page or 500 Internal Server error?

Re: Blank page or 500 Internal Server error

The problems are caused by your code failing. A blank page is usually a PHP error so checking your PHP error_log within your Plesk panel will provide causes as to what the problem is. Usually the best course of action is to re-upload your website or restore from a recent backup.

A 500 internal server error is usually related to a scripting issue using CGI or Perl scripts. Again, this means the script is unable to execute and this generic error which does not give much away means you need to check your scripts or simply upload / restore to your last working copy.

Both of these errors means a quick call to your web designer or just restore from your latest backup in the Backup manager (You do take backups right?!)