Hi,
You have move all Joomla files from subfolder to main root folder. Database will be this same so you do not have to change it.
---
I guess this same will tell your Hosting support.
or
you have something wrong with SEF settings.
But this is not a template problem!