Tag Archives: drupal

Do You Need To Take Care Of A Website Hosting Account?

Do You Need To Take Care Of A Website Hosting Account?

Do You Need To Take Care Of A Website Hosting Account?

Setting up a website is become easier day-by-day. Whether it is paying for hosting or buying a template or installing a CMS, everything now requires just a couple of clicks. However, there are some things which are unavoidable and must be followed as a set of best practices to keep your website and web hosting account in good health.

Virus and Malware Scan

Adding this to your weekly maintenance check list is a must. Scanning your entire hosting account for virus and malware activity will help you stop a disaster in time. Although most of the time you will see that you account is clean, sometimes, in public upload folders or in incoming mail attachments you may notice a trigger being set off. Cleaning up these infections will help you to avoid more maintenance in future. As they say “A stitch in time saves nine”.

Resource Usage Check

Some hosts allow you to see your Resource usage on the shared hosting server and also show you how much of RAM, CPU and Apache Processes your account has used in the past few days. This can be a key factor in diagnosing issues and understanding how your website performs under different conditions. Noticing irregular behaviour at an early stage can avoid a major outage of your account. One of our clients noticed a large spike in CPU resources every night. Upon further investigation he identified a runaway rsync script as the cause. This avoided his site being throttled or limited by the server software. Checking the resource usage atleast once in 7 days is a good practice.

Backups

We don’t need to say this, but taking regular backups has hurt no one. Not only should you take backups for an emergency or downtime, but taking backups before each modification to your website will allow you to revert to a backed up version in case your code gets corrupt or your programmer goofs up. Before installing anything new or updating your CMS version be sure to take a backup. Spending a little money on backup will save you hundreds of dollars when you really need to go back to a previous version of your website. As a standard practice, you should backup your entire account atleast once a week preferably at off-peak hours. Download the backup on a remote machine.

Updates

You will be surprised at the amount of updates you will need to carry out on your website, especially if you have a database driven CMS. WordPress, Joomla, Drupal and other similar CMs systems push out updates atleast a couple of times a month. with auto installer software, updating is a piece of cake and can be done in seconds. However, you must also understand the implications of every update on your website code and customizations to the system. Ideally you should check for new updates every 2 days, so that a critical security flaw in your web app can be quickly patched before it is exploited by hackers or malware.

Suspicious Activity

Your web hosting control panel will definitely have the ability of showing you the activity and error logs of your account. These can be especially useful when you want to diagnose an error or understand your web apps behavior. An additional utility of the logs is to detect patterns of suspicious activity and timings of such behavior. Logs can help you avoid a major problem by showing you the patterns of the activity that you really want to know. An ideal interval for checking logs would be atleast once a week. Checking the visitor logs, apache error logs and any custom logs that your CMS generates can be extremely helpful.

Does Your Auto-Installer Software Improve Your WordPress Experience? Softaculous, Fantastico and more

Does Your Auto-Installer Software Improve Your WordPress Experience?

Till recently, WordPress had to be manually installed if you planned to run a self-hosted WordPress website. You had to download the files from WordPress.org, upload them to your hosting account, unzip them and then run the php file to install it along with the database. Prior to the inbuilt php installer file, even the database had to be manually created and configuration information added to the config file in WordPress. All this is pretty much history, in fact all these steps are done instantly using an Auto-Installer Software. These software also have many other features, which make your entire WordPress experience a pleasure. While it is not mandatory to have an Auto-Installer to manage WordPress,it becomes safer, secure and more convenient when using an Auto-Installer to perform various tasks. This article explains some of the other reasons why Auto-Installers are recommended by us, if you are looking at setting up a WordPress website.

Backups

Auto-installers not only allow you to install scripts like WordPress, they also allow you to manage your website and help you back it up as well. The backups are stored in the home directory of your account and you can download them to your local computer at a later time. The auto-installers only create a backup of the software and not of your entire hosting account. Hence, only your WordPress files will be backed up. This is ideal when you are making changes or major modifications to your website files and want a copy of the files to keep in case your changes are broken. The ability to create these backups comes along with the power to restore them in case of lost or damaged files. The restore process allows you to use the backups that you have created in the past and restore the website to its exact state as on the date of the backup.

Upgrades

You can setup the auto-installer to notify you of any available updates or you can set it to upgrade WordPress automatically. As soon as a new version is available, the software will send out an email alert to you. You can also set it up to run a cron job to take a backup and process the upgrade automatically without your intervention, but in case of lack of space, the upgrade might not work out.

Software Information

Auto-Installers also provide you with handy information for each installed application. They list out the details like: Installation Directory, Live URL, Database Name, Database Username, Database Password, Database hostname, Software version installed, Installation time etc. This allows you to work with multiple installations of different software in the same hosting account. It prevents confusion and allows you to see the details in a single screen in a GUI, rather than searching the config file for details. You can use it to give the details to your developer or support teams.

Frequent Updates

The main advantage of an auto-installer is the frequency of updates and the ability to notify you when an update becomes available. This allows you to update WordPress to the latest stable version and also to implement quick fixes or patch vulnerabilities which may be a threat to the security of your website.

Setting up WordPress is easy - it becomes easier when you have an Auto-Installer in your arsenal. You can choose from many different Auto-Installers for your Control Panel, but we recommend Softaculous, Installatron and Fantastico.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near … at line …

This error is often encountered on PHP MySQL content management systems when updating data or filling out a form for submission. It is also seen in WordPress, Drupal, Joomla installations which have broken themes or plugins.

Possible Causes

  • You have a broken software or application. You will need to contact your programmer or developer to fix the issue with the SQL statement in the application or form.
  • If you are using WordPress, Joomla, Drupal or any other CMS, this may be due to broken plugins or addons which you installed.
  • The SQL statement used by the programmer to add or update information to the database is incorrect or contains reserved (column) names.
  • You have entered special characters like ‘ ; ” , etc. which your application is unable to understand. Your software should have automatically detected this and corrected it. Consult with your software developer.
  • You are entering incorrect values into the form. Eg: Entering alphabets where only numbers are allowed.

This error is not related to the software or hardware on the server. It indicates an issue with the coding.