Copied to clipboard

Flag this post as spam?

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


  • Craig Rowe 22 posts 175 karma points
    Aug 17, 2016 @ 07:56
    Craig Rowe
    0

    Cannot view store tree in tea commerce backend

    Having installed tea commerce from the package manager into a pretty much vanilla Umbraco 7.4.3 (using MySQL) I can create a store but when attempting to drop down the tree beneath the store I get:

    Server error: Contact administrator, see log for full details.
    Failed to retrieve data for child nodes undefined
    

    And the loading bar continues to animate. There is nothing in the App_Data\Logs regarding Tea.

    Looking at the JS console I can see that a request to:

    /umbraco/backoffice/UmbracoTrees/LegacyTree/GetNodes

    returns a 500 MySQL Error.

    "Table 'umbraco-tea.teacommerce_rule' doesn't exist"
    

    Does this mean tea commece failed to install initially?

    It looks like this table should have been created via:

    TeaCommerce.Api.Persistence.Installation.SqlScripts.MySql.007.sql
    

    executed by:

    TeaCommerce.Api.Persistence.Installation.PersistenceInstaller
    
  • Anders Burla 2560 posts 8256 karma points
    Aug 17, 2016 @ 09:37
    Anders Burla
    0

    Hi Craig

    Looks like something went wrong with the install of the DB. Please write an email to [email protected] and we will send you the sql scripts. Then you can maybe help us if there is a bug in the scripts somewhere.

    Kind regards

    Anders

  • Craig Rowe 22 posts 175 karma points
    Aug 17, 2016 @ 10:00
    Craig Rowe
    100

    Hi Anders, I decompiled the package dll's and found the scripts in resources. Looks like the bug is this accidental double T:

    RuleGroupId CHAR(36) NOTT NULL,
    

    When trying to create the rule table.

  • Anders Burla 2560 posts 8256 karma points
    Aug 17, 2016 @ 10:49
    Anders Burla
    0

    Great find! Fixed in the core and comitted for next build

Please Sign in or register to post replies

Write your reply to:

Draft