I had attempted to import categories into my magento using SQL, but looks like it hasn't worked. In manage categories section it looks like this:
The numbers suggest correct product linking but other than that broken, clicking the expand button also does nothing.
I have got the categories, and sub-categories to display. But the products although correctly showing in the count next to the categories, they are not appearing when I click on the actual category and got to the category products tab: