Setup

From Customer365 for SageCRM

The visitor table should be updated to cater for longer values than is has. We do this using the following SQL.

ALTER TABLE visitor ALTER COLUMN Visi_LogonId [nvarchar](255)

If this SQL does not work (some servers dont seem to allow it) try the following

Create a new table based on the visitor table but with larger size columns

 CREATE TABLE [dbo].[visitor_new](	[Visi_VisitorId] [int] IDENTITY(1,1) NOT NULL,

[Visi_VisitorKey] [nvarchar](50) NULL, [Visi_LogonId] [nvarchar](255) NULL, [Visi_Password] [nvarchar](12) NULL, [Visi_PersonId] [int] NULL, [Visi_CompanyId] [int] NULL, [Visi_IpAddress] [nvarchar](15) NULL, [Visi_Salutation] [nvarchar](10) NULL, [Visi_FirstName] [nvarchar](30) NULL, [Visi_LastName] [nvarchar](40) NULL, [Visi_MiddleName] [nvarchar](30) NULL, [Visi_Suffix] [nvarchar](20) NULL, [Visi_Gender] [nvarchar](6) NULL, [Visi_Title] [nvarchar](30) NULL, [Visi_TitleCode] [nvarchar](15) NULL, [Visi_CompanyName] [nvarchar](60) NULL, [Visi_PhoneCountryCode] [nvarchar](5) NULL, [Visi_PhoneAreaCode] [nvarchar](20) NULL, [Visi_PhoneNumber] [nvarchar](200) NULL, [Visi_FaxCountryCode] [nvarchar](5) NULL, [Visi_FaxAreaCode] [nvarchar](20) NULL, [Visi_FaxNumber] [nvarchar](20) NULL, [Visi_EmailAddress] [nvarchar](200) NULL, [Visi_Address1] [nvarchar](40) NULL, [Visi_Address2] [nvarchar](40) NULL, [Visi_Address3] [nvarchar](40) NULL, [Visi_Address4] [nvarchar](40) NULL, [Visi_Address5] [nvarchar](40) NULL, [Visi_City] [nvarchar](30) NULL, [Visi_State] [nvarchar](30) NULL, [Visi_Country] [nvarchar](30) NULL, [Visi_PostCode] [nvarchar](10) NULL, [Visi_Language] [nvarchar](5) NULL, [Visi_CreatedDate] [datetime] NULL, [Visi_UpdatedDate] [datetime] NULL, [visi_userid] [int] NULL

 ) ON [PRIMARY]

We then run the following to populate the table based on the visitor table (assuming self-service is already in use)

 SET IDENTITY_INSERT visitor_new on
 GO
 INSERT INTO visitor_new (
 [Visi_VisitorId] ,

[Visi_VisitorKey] , [Visi_LogonId], [Visi_Password] , [Visi_PersonId], [Visi_CompanyId] , [Visi_IpAddress] , [Visi_Salutation] , [Visi_FirstName] , [Visi_LastName] , [Visi_MiddleName], [Visi_Suffix], [Visi_Gender] , [Visi_Title] , [Visi_TitleCode], [Visi_CompanyName], [Visi_PhoneCountryCode], [Visi_PhoneAreaCode] , [Visi_PhoneNumber], [Visi_FaxCountryCode] , [Visi_FaxAreaCode] , [Visi_FaxNumber] , [Visi_EmailAddress], [Visi_Address1] , [Visi_Address2], [Visi_Address3] , [Visi_Address4], [Visi_Address5] , [Visi_City] , [Visi_State] , [Visi_Country], [Visi_PostCode], [Visi_Language] , [Visi_CreatedDate], [Visi_UpdatedDate] , [visi_userid]

 )
 SELECT 
 [Visi_VisitorId] ,

[Visi_VisitorKey] , [Visi_LogonId], [Visi_Password] , [Visi_PersonId], [Visi_CompanyId] , [Visi_IpAddress] , [Visi_Salutation] , [Visi_FirstName] , [Visi_LastName] , [Visi_MiddleName], [Visi_Suffix], [Visi_Gender] , [Visi_Title] , [Visi_TitleCode], [Visi_CompanyName], [Visi_PhoneCountryCode], [Visi_PhoneAreaCode] , [Visi_PhoneNumber], [Visi_FaxCountryCode] , [Visi_FaxAreaCode] , [Visi_FaxNumber] , [Visi_EmailAddress], [Visi_Address1] , [Visi_Address2], [Visi_Address3] , [Visi_Address4], [Visi_Address5] , [Visi_City] , [Visi_State] , [Visi_Country], [Visi_PostCode], [Visi_Language] , [Visi_CreatedDate], [Visi_UpdatedDate] , [visi_userid]

 from visitor
 GO
 SET IDENTITY_INSERT visitor_new Off

Rename the "visitor" table to "visitor_old" and then rename "vistor_new" to "visitor".



Could not load file or assembly 'SageCRM' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.

  • To fix this change the CRM App pool to use .net40