well, I tried a couple more templates, and the result were the same, extension is installed, all files available under templates, but no style.
since I am on windows and SQL Server I ran the SQL Server profiler to see the SQL statements ran. It turns out that Joomla tries to run
Code:
INSERT INTO jos_template_styles
SET template=N'gameon-fjt'
, client_id=N'0'
, home=0
, title=N'GameOn-FJT - Default'
, params=N'{"slogandisable":"1","slogan":"Custom slogan","footerdisable":"1","footertext":"Custom text here","analyticsdisable":"1","googleanalytics":"UA-1111111-22","socialbuttons":"1","googletranslate":"1","jchecker":"1","jcopyright":"1","jscroll":"1","jtabs":"1","tab1":"Tab content 1","tab2":"Tab content 2","tab3":"Tab content 3","addthis":"http:\\/\\/s7.addthis.com\\/js\\/250\\/addthis_widget.js#pubid=xa-4dd788572198c717","slidedisable":"1","slidedesc1":"Description slide 1","url1":"\\/","slidedesc2":"Description slide 2","url2":"\\/","slidedesc3":"Description slide 3","url3":"\\/","slidedesc4":"Description slide 4","url4":"\\/"}'
The INSERT INTO .. SET syntax is not a valid SQL Server statement, its MySQL proprietary, so thats the problem…
So I guess the SQL Server support is not as good as I hoped for. If I'll have time I'll try to find out if this is error is specific to the template functionality, or if it is a general problem with the database layer (I have no idea how the multi-database-support is implemented in Joomla)
Meanwhile, is there some other forum I should post this bug report ?
