I'm currently trying to install Tea Commerce on Umbraco 7. The site is hosted on Azure, and the site is also using a Azure SQL DB. When I try to add the Tea Commerce package to my site, the installation initially seems to be successfull. However, none of the Tea Commerce Db tables are created, and if I try to open the Tea Commerce section I get some SQL error message telling me that some Tea Commerce table does not exist.
Now, I've previously been able to escape this problem by manually creating the Tea Commerce tables using a subset of the DB script that is included in the Tea Commerce starter kit, running this on my Azure Db with a few minor changes(I have to remove all ON[PRIMARY] statements).
Trying to repeat this approach on a Umbraco 7 site however, it does not seem to work. I get an error saying "Invalid column name 'PricesIsSpecifiedWithVat'".
So my question is first and foremost, is there any recommended way of installing Tea Commerce on a Umbraco 7 site that is hosted in Azure(and uses Azure SQL)? If not, are there any differences between the DB that is used in the Starter Kit and the one that is used in the Umbraco 7 compatible version of TeaCommerce? If so, would it be possible to get an updated script that creates a compatible Db for Umbraco 7?
Installing Tea Commerce using Azure SQL
Hi,
I'm currently trying to install Tea Commerce on Umbraco 7. The site is hosted on Azure, and the site is also using a Azure SQL DB. When I try to add the Tea Commerce package to my site, the installation initially seems to be successfull. However, none of the Tea Commerce Db tables are created, and if I try to open the Tea Commerce section I get some SQL error message telling me that some Tea Commerce table does not exist.
Now, I've previously been able to escape this problem by manually creating the Tea Commerce tables using a subset of the DB script that is included in the Tea Commerce starter kit, running this on my Azure Db with a few minor changes(I have to remove all ON[PRIMARY] statements).
Trying to repeat this approach on a Umbraco 7 site however, it does not seem to work. I get an error saying "Invalid column name 'PricesIsSpecifiedWithVat'".
So my question is first and foremost, is there any recommended way of installing Tea Commerce on a Umbraco 7 site that is hosted in Azure(and uses Azure SQL)? If not, are there any differences between the DB that is used in the Starter Kit and the one that is used in the Umbraco 7 compatible version of TeaCommerce? If so, would it be possible to get an updated script that creates a compatible Db for Umbraco 7?
Could you write us an e-mail - info (at) teacommerce.net. I will send you the sql scripts for Azure so you could maybe see which one fails.
Kind regards
Anders
is working on a reply...