Hi,

Are you using Magento 1.7 or lower, aren’t you? If so, you should be upgrade to 1.8 version or greater.
The method Mage_Catalog_Model_Resource_Category_Flat was introduced in Magento 1.8 and does not exist in any versions prior. After upgrading, if still error please let me know.

Thanks you,