Invalid object name 'FacebookPixelConfiguration' ?

I've tried to install this plugin/widget, but it just kills my site dead, with the "SqlException: Invalid object name 'FacebookPixelConfiguration'." error.

Going to start page of the sites creates some other exotic messages with widgets and stuff, but it's still the same SQL Exception causing this.

Anyone else has the same problem? I have to remove it manually and restart everything so I can use the site again... And wait until the session dies out. Weird.

I have solve this error by adding table "FacebookPixelConfiguration" in database.
Please execute below script to add table

CREATE TABLE dbo.FacebookPixelConfiguration (
  Id int IDENTITY,
  PixelId nvarchar(max) NULL,
  Enabled bit NOT NULL,
  DisableForUsersNotAcceptingCookieConsent bit NOT NULL,
  StoreId int NOT NULL,
  PassUserProperties bit NOT NULL,
  UseAdvancedMatching bit NOT NULL,
  TrackPageView bit NOT NULL,
  TrackAddToCart bit NOT NULL,
  TrackPurchase bit NOT NULL,
  TrackViewContent bit NOT NULL,
  TrackAddToWishlist bit NOT NULL,
  TrackInitiateCheckout bit NOT NULL,
  TrackSearch bit NOT NULL,
  TrackContact bit NOT NULL,
  TrackCompleteRegistration bit NOT NULL,
  CustomEvents nvarchar(max) NULL,
  CONSTRAINT PK_FacebookPixelConfiguration PRIMARY KEY CLUSTERED (Id)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

jaydeeprsakariya wrote:

Thanks a lot, it solves the problem for me

Hi I am geting following error when using this script on 4.3

  
Incorrect syntax near 'GO'.

Please help

Kakoli

Please clarify "when using this script on 4.3"
This script is run using a database tool like SSMS.  
Are you using SQL Server database?

I have spent all day trying to fix this issue which includes many attempts at removing, uninstalling and each it , it crashes the website and results in the sql error. I came to the forums and saw this solution, tried and worked straight away. many thanks to the poster for this solution!