Home

Database error 1071 when installing PHPList

Tue, 24/06/2008 - 11:27 — Finn

Tyring to install PHP list on a server with MySQL 5 resulted in the following error 

Database error 1071 while doing query Specified key was too long; max key length is 1000 bytes

This arises  because PHPList is trying to create the table "user_blacklist_data" with a combined index key of email(255) and name(100).

That is a total of 355 characters. If you are running a database in utf, each characters count as 3 bytes. So 355 x 3 bytes = 1065 bytes which is over mySQL's 1000 bytes key limit.

Modify PHP settings for a local domain in Plesk

Wed, 13/08/2008 - 11:23 — Finn

When running multplie domains on Plesk, we often need to modify the PHP settings for a local domain, for example to increase the max_file_size directive, or php_memory_limit.

To do this in PLesk (8.2) we do the following:

SSH into the server as root.

In the DOMAIN.TLD/conf/ directory of the domain in question, either modify or create a file called vhost.conf

vi vhost.conf

In there add the required directives, for example:

Viewing your hosted domain before the DNS has propagated

Thu, 13/05/2010 - 11:23 — Finn

Often you will want to preview your hosted domain on a new server before you have updated the DNS on the domain.

This can be achieved by editing your computer's 'hosts' file to fool your local browsers into thinking that your domain points to a different IP address.

The hosts file lives in different places on different operating systems.

This is a useful post on how to modify the hosts file on various operating systems.

DNS - typical settings for a hosted domain

Mon, 27/09/2010 - 13:12 — Finn

Domain registrars vary in how they offer advanced DNS management, and this is a guide to the principles of setting up the DNS on your domain name. If in doubt, you should contact your registrar.

A Records

The first DNS record we need is an A record. This tells computers the IP address associated with a particular domain name.

For example, you may want to point www.domain.com to 80.240.88.45

In this case you would add an A record as follows: