| 0/0 |   |
|
Edit: Gizmo tech support got in touch with me. The tables already existed but was no big deal. It functions just as it should.
I'm so close to being upgrade to DNN3. I used the Gizmo Bulk User transfer tool from Snowcovered and it successfully ported my userinfo from my DNN2.1.2 site into a .csv file. I then uploaded their PA onto my new DNN3.2.2 site where I should be able to import my users from that .csv file. Unfortunately, the install of that module had the SQL errors posted below. Has anyone else used this module or have any vis on it? I'm wondering if the claim of support for ASP2.0 should have been "requires ASP2.0" - but I don't know. I'm not using the new framework. If anyone has any experience with this I'd appreciate any tips. I'm in a time crunch and their support on the other side of the world is probably sleeping. The module installed but I don't want to try to upload my old userinfo for fear this module may mess up my database. The SQL errors from the module installation were:
| StartJob |
Begin Sql execution |
| Info |
Executing 01.00.00.SqlDataProvider |
| StartJob |
Start Sql execution: 01.00.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot DROP PROCEDURE 'dbo.fn_GetElement' because it is being referenced by object 'fn_GetProfileElement'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.fn_GetElement') and xtype in (N'FN', N'IF', N'TF')) drop function dbo.fn_GetElement System.Data.SqlClient.SqlException: Cannot DROP PROCEDURE 'dbo.fn_GetProfileElement' because it is being referenced by object 'fn_ProfileGeoLookup'. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'dbo.fn_GetProfileElement') and xtype in (N'FN', N'IF', N'TF')) drop function dbo.fn_GetProfileElement System.Data.SqlClient.SqlException: There is already an object named 'fn_GetElement' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE FUNCTION dbo.fn_GetElement ( @ord AS INT, @str AS VARCHAR(8000), @delim AS VARCHAR(1) ) RETURNS INT AS BEGIN -- If input is invalid, return null. IF @str IS NULL OR LEN(@str) = 0 OR @ord IS NULL OR @ord < 1 -- @ord > [is the] expression that calculates the number of elements. OR @ord > LEN(@str) - LEN(REPLACE(@str, @delim, '')) + 1 RETURN NULL DECLARE @pos AS INT, @curord AS INT SELECT @pos = 1, @curord = 1 -- Find next element's start position and increment index. WHILE @curord < @ord SELECT @pos = CHARINDEX(@delim, @str, @pos) + 1, @curord = @curord + 1 RETURN CAST(SUBSTRING(@str, @pos, CHARINDEX(@delim, @str + @delim, @pos) - @pos) AS INT) END System.Data.SqlClient.SqlException: There is already an object named 'fn_GetProfileElement' in the database. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE FUNCTION dbo.fn_GetProfileElement ( @fieldName AS NVARCHAR(100), @fields AS NVARCHAR(4000), @values AS NVARCHAR(4000)) RETURNS NVARCHAR(4000) AS BEGIN -- If input is invalid, return null. IF @fieldName IS NULL OR LEN(@fieldName) = 0 OR @fields IS NULL OR LEN(@fields) = 0 OR @values IS NULL OR LEN(@values) = 0 RETURN NULL -- locate FieldName in Fields DECLARE @fieldNameToken AS NVARCHAR(20) DECLARE @fieldNameStart AS INTEGER, @valueStart AS INTEGER, @valueLength AS INTEGER -- Only handle string type fields (:S:) SET @fieldNameStart = CHARINDEX(@fieldName + ':S',@Fields,0) -- If field is not found, return null IF @fieldNameStart = 0 RETURN NULL SET @fieldNameStart = @fieldNameStart + LEN(@fieldName) + 3 -- Get the field token which I've defined as the start of the field offset to the end of the length SET @fieldNameToken = SUBSTRING(@Fields,@fieldNameStart,LEN(@Fields)-@fieldNameStart) -- Get the values for the offset and length SET @valueStart = dbo.fn_getelement(1,@fieldNameToken,':') SET @valueLength = dbo.fn_getelement(2,@fieldNameToken,':') -- Check for sane values, 0 length means the profile item was stored, just no data IF @valueLength = 0 RETURN '' -- Return the string RETURN SUBSTRING(@values, @valueStart+1, @valueLength) END |
| EndJob |
End Sql execution: 01.00.00.SqlDataProvider file |
| |
| EndJob |
Finished Sql execution |
 |