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.
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]
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.
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.
Error after installation
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
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
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
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
Hi Adam,
I'll let you know how it goes. We're quite happy about the SQL dependency ;-)
Ian
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:
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?
Cheers,
Ian
So I've resolved this by creating the table ncBtVisitorSegment with the following definition:
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
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.
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.
I just released a 1.4.2 release. it should fix the above issues. https://our.umbraco.org/projects/website-utilities/footprint/
Adam
Hi Adam,
That's great news - I'll have another go then.
Ian
is working on a reply...