Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Ian Binns 8 posts 78 karma points
    Jun 07, 2016 @ 14:58
    Ian Binns
    0

    Error after installation

    Getting started
    Umbraco 7

    Hi,

    I'm trying to set up a site for internal testing and review, but having installed the Footprint plug in (v1.4.1) and configured the SQL data connector I get a YSOD with the following exception:

    Invalid object name 'ncBtSegment'.

    Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'ncBtSegment'.

    I've tried on both 7.3.8 and 7.4.3.

    I'm really keen to demonstrate the potential of this plug-in to some clients so would really appreciate it if you could let me know whether their is a fix for this.

    Cheers,

    Ian

    Copy Link
  • Adam Peter Nielsen 18 posts 222 karma points
    Jun 08, 2016 @ 05:30
    Adam Peter Nielsen
    0

    Hi Ian. It should work. Are you using SQL Ce? Footprint requires a full sql server at the moment. We will try to work around that.

    In the mean time you can show some of the video material from the project page. :)

    Regards Adam

    Copy Link
  • Ian Binns 8 posts 78 karma points
    Jun 09, 2016 @ 10:51
    Ian Binns
    0

    Hi Adam,

    Nope it's a MS-SQL server database.

    I'm going to try installing again from scratch.

    We have shown the videos - they are keen to implement - which is why we need to get it working :S

    Cheers,

    Ian

    Copy Link
  • Adam Peter Nielsen 18 posts 222 karma points
    Jun 09, 2016 @ 10:57
    Adam Peter Nielsen
    0

    Hi Ian.

    Ok. Let me know how it turns out. It should work out of the box with a clean Umbraco install. We just tested with 7.4.3 this morning.

    On another note: If all goes to plan, we have a new version without the SQL server dependency before codegarden.

    /Adam

    Copy Link
  • Ian Binns 8 posts 78 karma points
    Jun 09, 2016 @ 11:10
    Ian Binns
    0

    Hi Adam,

    I'll let you know how it goes. We're quite happy about the SQL dependency ;-)

    Ian

    Copy Link
  • Ian Binns 8 posts 78 karma points
    Jun 09, 2016 @ 11:43
    Ian Binns
    0

    Hi Adam,

    This is very frustrating.

    I created a new Umb 7.4.3 install - wiht the TXT starter kit and SQL server (new database)

    The installed the Footprint package from the Umbraco package Repository. Updated the \App_Data\footprint.config:

        <?xml version="1.0" encoding="utf-8"?>
<footprintConfiguration
  isDisabled="false">

  <cookies />

  <!-- MongoDB
  <mongoDb
    connectionString="mongodb://connection-string-here"
    database="myDatabase"
    collection="umbracoFootprint" />
  -->

  <!-- SQL  -->
  <sql 
    connectionStringName="umbracoDbDSN" />


  <!-- Customer.io
  <customerIo
    siteId="my-site-id"
    apiKey="my-api-key" />
  -->

  <email
    sender="[email protected]" />

  <profile>
    <profileFields>
      <profileField name="name" />
      <profileField name="email" />
      <profileField name="phone" />
    </profileFields>
  </profile>

</footprintConfiguration>

    Then created a segment - just using Browser contains Chrome as the criteris, but when I browse to the site I get the same error:

    Server Error in '/' Application.

    Invalid object name 'ncBtVisitorSegment'.

    Checking the db , i can see a bunch of ncBtxx tables but not one called ncBtVisitorSegment.

    Any ideas?

    Edit - as soon as I delete the segment the error disappears - and adding any segment causes the same issue

    Cheers,

    Ian

    Copy Link
  • Ian Binns 8 posts 78 karma points
    Jun 09, 2016 @ 13:02
    Ian Binns
    0

    So I've resolved this by creating the table ncBtVisitorSegment with the following definition:

        CREATE TABLE [dbo].[ncBtVisitorSegment](
    [VisitorId] [nvarchar](255) NOT NULL,
    [SegmentAlias] [nvarchar](255) NOT NULL,
    [CreatedUtc] [datetime] NOT NULL
) ON [PRIMARY]
    Copy Link
  • Ian Binns 8 posts 78 karma points
    Jun 09, 2016 @ 17:01
    Ian Binns
    0

    Hey Adam,

    So I've sorted the initial issue - but I just do not seem to be able to get this to work. Just seems to be one issue after another.

    Ian

    Copy Link
  • Martin Proks 6 posts 100 karma points
    Jun 11, 2016 @ 17:30
    Martin Proks
    0

    Hey Ian,

    yes we know about the bugs it has. I have just finished changing everything so it is compatible with sql compact. It made the whole project more complicated than we expected. We will do our best to push the new version as soon as possible.

    Copy Link
  • Sam Sussman 14 posts 105 karma points
    Jun 18, 2016 @ 08:02
    Sam Sussman
    0

    I have the same issue with the ncBtVisitorSegment on a fresh install of 7.4.3 with SQL on. If you don't turn on (uncomment) SQL, it doesn't error. Looks like the cookie only version works right now though.

    Copy Link
  • Adam Peter Nielsen 18 posts 222 karma points
    Jun 20, 2016 @ 13:43
    Adam Peter Nielsen
    0

    I just released a 1.4.2 release. it should fix the above issues. https://our.umbraco.org/projects/website-utilities/footprint/

    Adam

    Copy Link
  • Ian Binns 8 posts 78 karma points
    Jun 20, 2016 @ 13:58
    Ian Binns
    0

    Hi Adam,

    That's great news - I'll have another go then.

    Ian

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft