magento rant

First, their javascript validation for setup Fail big time!
once it failed to validate, no matter what you have change in that field, it will not validate anymore!
need to refresh the page, that sucks big time!

installation, took more than 2minutes!
200+tables, omg, do we need that much?

PHP Memory limit of 256MB ?? omg...

openbase_dir problem on plesk subdomains

http://enarion.net/web/plesk/subdomains-and-open_basedir/

ubuntu virtualbox alt+click

i find it troublesome that i couldn't alt click in my Virtualbox client.
one way to fix it is by resetting the alt key in the host file to super(windows) key.

Go to windows preferences in setting, and change "movement key" from "alt" to "Super"

samba sharing on linux

After several frustration to get sharing working from linux,
finally found the root of the problem.

It is often that ubuntu / linux seems to add invalid charactor to the sharing name.
The solution is to remove them.

Exampke: user-intel (Linux mint)
Change to userintel

Qmail route email to external smtp relay

Edit

/var/qmail/control/smtproutes

content:

:hostname.com

Example:

:smtp.tm.net.my

References:

http://wiki.qmailtoaster.com/index.php/Smtproutes

Kloxo Yum Gave Error... Trying Again

If you ever tried to install kloxo, and encounter this error,

it might be that you are trying to install kloxo on 64bits system.

Do a uname -m to see if its x86_64 (if yes, then its 64bits).

If its a i686, its not.

If you encounter that error, its likely that your /etc/php.ini is configured to disallow function "system".

Edit the php.ini and find for all line with:

disable_functions =exec,passthru,shell_exec,system...

and comment it off by adding #

Try to find for more of these line. Sometimes its been set more than once.

Updated: 24 Sept 2012:
Okay, normally this error comes out when an installation is incomplete along the process.
So the system have been configured to reject system call, therefore reinstalling it is not possible.
Best way is to reformat your server and install from fresh again.
Normally happen to 64 bits os, best to fall back to 32bits.

MySQL Lock tables and subqueries

Example error:

Table 'table' was not locked with LOCK TABLES

Example:

LOCK TABLES x write, y write;

select * from x; #works

select * from y; #works

But:

select *,

(select fieldname from y where fieldcond=x.field2) as yname

from x where field1='xxx'; #failed with

#y tables is not locked

Solution:

LOCK TABLES x write, y write, y as yalias write;

select *,

(select fieldname from y yalias where fieldcond=x.field2) as yname

from x where field1='xxx';

#WORKS!