I had this problem when trying to import an SQL file which was a dump from a MySQL database for Mambo: ERROR 1064 (42000) at line 142: You have an [...]
Apr
2008
MySQL Collation and Character Set Notes
When I was importing SQL data files into MySQL 5 (exported from MySQL 3.23) I ran into problems with collation types receiving the following error: ERROR 1071 (42000) at line [...]
Apr
2008
2404 MySql Database Search Class
The MySQL Search Class available from 2404.co.uk is a useful quick way to implement a database search in PHP. However there is an error when doing table joins on approx [...]
Apr
2008
Joomla Latest Events Component Error
Using the Joomla Latest Events module I received the following error message: Warning: array_key_exists(): The second argument should be either an array or an object in /path/to/website/modules/mod_events_latest.lib.php on line 241 [...]
Apr
2008
Beginner Rsync
Rsync comes pre-installed on many systems including Red Hat, Ubuntu and Solaris. Rsync is a useful tool for performing remote backups. It is very efficient as it only backs up [...]
Apr
2008
Solaris 8 NFS shares
Directories can be shared across the network using NFS on Solaris 8. I used the following to mount a directory from a remote system (named servermachine in the listings below) [...]
Apr
2008
Defaulting SSH to a non-standard host port
If the SSH server on a host has been configured to listen on a non-standard port for example port 92 then normally we would connect with: ssh -p 92 theserver.tld [...]
Apr
2008
Squid access.log file over 2Gb
I had a problem with Squid which required removing the access.log file as it had grown over 2Gb in size which has caused Squid to terminate and also stopped Squid [...]
Apr
2008
Exchange 2007 Identifier Limits
Exchange 2007 Event Viewer reports errors such as: Failed to create a new named property for database "First Storage Group\Mailbox Database 1" because the number of named properties reached the [...]
Apr
2008
CPAN Perl Modules – LWP failed with code
I had a little difficulty today installing some Perl modules from CPAN. I was getting messages like: Fetching with Net::FTP: ftp://ftp.flirble.org/pub/CPAN/authors/01mailrc.txt.gzCouldn't fetch 01mailrc.txt.gz from ftp.flirble.org Fetching with LWP: ftp://ftp.mirror.anlx.net/CPAN/authors/01mailrc.txt.gzLWP failed [...]

