« Archives in November, 2007

Wholesale domain registration prices increased

It’s been over a month to report but the wholesale prices of domain name for major extensions (.COM, .NET, .ORG, .INFO, .BIZ) increased by about 50 cents/year. For the majority of people with several names, it would not make a different, for those with hundreds or thousands, it’s a more significant impact. The trend for domain names now would be turn-overs (register, delete, register again)

MySQL – Join changes starting 5.0.12

If a SQL suddenly die after an upgrade, check your query and the changes to the JOIN, especially this could cause “Unknown column ‘X.XX’ in ‘on clause’ “. The reason being before 5.0.12, the comma operator and JOIN both had the same precedence, so the join expression t1, t2 JOIN t3 was interpreted as ((t1, t2) JOIN t3). Now JOIN has higher precedence, so the expression is interpreted as (t1, (t2 JOIN t3)). Solution: specifically put the parenthesis.

Source: http://dev.mysql.com/doc/refman/5.0/en/join.html