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

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies