In need help... Downloaded templatemonster

[pmartin]

Hi, I made the mistake of installing a Templatemonster template. It was all working fine until I ran the short sql script that was recommended. Now my home page doesn't load properly. I used to run Future Zen which displayed products in the middle section. I realize, now, that this was all a big mistake and should at least have tested before going live but it is done now and I would appreciate it if someone could help. I have tried TM support, for nearly three days they tell me they are working on it! I am having my doubts.
The offending page is:
http://www.vanloonsnursery.com.au/sh...php?main_page=
I am using zen cart version 1.3.8a
Server is HTTP Apache 2.0.51
Server OS is: Linux
PHP version: 5.0.4
MYSQL: 4.1.14
I have tried reverting to Future Zen & Classic, still get poor results.
I have searched the FAQs and Forum, this has solved many things in the past, but not this time. Please help!

[pmartin]

I think I have resolved this issue. Played around with Short SQL.