Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Øystein Heimark 5 posts 35 karma points
    Jul 28, 2014 @ 16:59
    Øystein Heimark
    0

    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?

  • Anders Burla 2560 posts 8256 karma points
    Jul 29, 2014 @ 08:29
    Anders Burla
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft