Hi everyone,

I'm having a mare! and i'm sure it's all my own fault :) please help

Have small client site and installed a new package to it which failed with a series of errors and everything was then messed-up, templaes, macros, everything.

reinstalled the SQLDB via a restore command - site up, admin up, all looks good apart from there is no design. - no templates showing externally.

www.theinterviewonline.co.uk - see what i mean.

templates are present in the admin UI - just not showing on site.

I followed a few posts about templates and ran an sql query to check the templates sql-wise

found this on an old forum post

SELECT

ct.pk as TemplateID, ct.nodeId as TemplateNodeID, ct.alias as TemplateAliasName, un.text as TemplateDescription FROM cmsTemplate ct INNER JOIN umbracoNode un ON un.id = ct.nodeId order by templatealiasname

returns a list of the templates and aliases (showing no duplicates)

11           1210       Blog       Blog

12           1211       BlogMaster         BlogMaster

13           1212       BlogPost              BlogPost

14           1213       Rss         Rss

17           1227       tioBlog  tioBlog

15           1225       tioBlogMaster   tioBlogMaster

18           1228       tioBlogPost         tioBlogPost

3              1044       tioGenericArticle              tioGenericArticle

4              1045       tioHome              tioHome

5              1046       tioHomeMaster                tioHomeMaster

6              1047       tioInterview       tioInterview

7              1048       tioInterviewMaster        tioInterviewMaster

8              1049       tioMaster            tioMaster

9              1050       tioSearch             tioSearch

10           1051       XSLTsearch         XSLTsearch

Umbraco 4.02, ASP.Net 2.0, dedicated environment (with plesk), full admin and RDP rights

Any help???

(thanks a lot in advance)