The green water is just alge, it's not a rare problem with fish tanks.
One way to fix the problem is to do a blackout, cover the tank for four days so no light at -all- can get to it. (This however is just a temporary fix usually, since you aren't getting rid of the cause) Another methods are chemical treatment, diatom filtration, and UV sterilization.
Here's a quote from a website explaining a bit what causes it:
"Green Water: This is a free-floating form of algae. Normally the result of high light, and VERY high nutrient levels. There are water additives that claim to eliminate or clear up green water problems. Water-polishing filters also will clear the water. But these solutions don't address the original cause of the problem: The excess nutrients. Green water can appear if you have high nitrates, but plant growth is insufficient to reduce the nitrate level. This can happen if you don't have enough fast-growing plants, or if the plants don't have the CO2 needed for fast growth. Extremely high nitrate levels, besides being harmful to the fish, reduce plant growth, and actually increase the amount of CO2 needed by the plants. "
For more info you can also do a google search on 'green water'.