Si_Hibbard
asked on
DotNetNuke SQL problem
HI All,
I have been trying to install DotNetNuke but failing constantly on the DB table generation maybe someone here has an idea. It seems to be failing on things i thought SQL Server (which is the one I am using) should support. E.g:
----------
System.Data.SqlClient.SqlE xception: Type bigint is not a defined system type.
The sum or average aggregate operation cannot take a void type data type as an argument.
at System.Data.SqlClient.SqlC onnection. OnError(Sq lException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection)
at System.Data.SqlClient.TdsP arser.Thro wException AndWarning (TdsParser StateObjec t stateObj)
at System.Data.SqlClient.TdsP arser.Run( RunBehavio r runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlC ommand.Run ExecuteNon QueryTds(S tring methodName, Boolean async)
at System.Data.SqlClient.SqlC ommand.Int ernalExecu teNonQuery (DbAsyncRe sult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlC ommand.Exe cuteNonQue ry()
at DotNetNuke.Data.SqlDataPro vider.Exec uteADOScri pt(String SQL)
at DotNetNuke.Data.SqlDataPro vider.Exec uteScript( String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.dnn_GetPortalSpaceUsed
@PortalId int
AS
SELECT 'SpaceUsed' = SUM(CAST(Size as bigint))
FROM dnn_Files
WHERE ((PortalId = @PortalId) OR (@PortalId is null and PortalId is null))
System.Data.SqlClient.SqlE xception: Line 2: Incorrect syntax near 'FUNCTION'.
Must declare the variable '@PropertyName'.
A RETURN statement with a return status can only be used in a stored procedure.
Must declare the variable '@PortalID'.
Must declare the variable '@POrtalID'.
Must declare the variable '@PortalID'.
A RETURN statement with a return status can only be used in a stored procedure.
at System.Data.SqlClient.SqlC onnection. OnError(Sq lException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection)
at System.Data.SqlClient.TdsP arser.Thro wException AndWarning (TdsParser StateObjec t stateObj)
at System.Data.SqlClient.TdsP arser.Run( RunBehavio r runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlC ommand.Run ExecuteNon QueryTds(S tring methodName, Boolean async)
at System.Data.SqlClient.SqlC ommand.Int ernalExecu teNonQuery (DbAsyncRe sult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlC ommand.Exe cuteNonQue ry()
at DotNetNuke.Data.SqlDataPro vider.Exec uteADOScri pt(String SQL)
at DotNetNuke.Data.SqlDataPro vider.Exec uteScript( String Script, Boolean UseTransactions)
---------------
System.Data.SqlClient.SqlE xception: Cannot group by a bit column.
at System.Data.SqlClient.SqlC onnection. OnError(Sq lException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection)
at System.Data.SqlClient.TdsP arser.Thro wException AndWarning (TdsParser StateObjec t stateObj)
at System.Data.SqlClient.TdsP arser.Run( RunBehavio r runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlC ommand.Run ExecuteNon QueryTds(S tring methodName, Boolean async)
at System.Data.SqlClient.SqlC ommand.Int ernalExecu teNonQuery (DbAsyncRe sult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlC ommand.Exe cuteNonQue ry()
at DotNetNuke.Data.SqlDataPro vider.Exec uteADOScri pt(String SQL)
at DotNetNuke.Data.SqlDataPro vider.Exec uteScript( String Script, Boolean UseTransactions)
--------------------
System.Data.SqlClient.SqlE xception: 'SCOPE_IDENTITY' is not a recognized function name.
at System.Data.SqlClient.SqlC onnection. OnError(Sq lException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection)
at System.Data.SqlClient.TdsP arser.Thro wException AndWarning (TdsParser StateObjec t stateObj)
at System.Data.SqlClient.TdsP arser.Run( RunBehavio r runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlC ommand.Run ExecuteNon QueryTds(S tring methodName, Boolean async)
at System.Data.SqlClient.SqlC ommand.Int ernalExecu teNonQuery (DbAsyncRe sult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlC ommand.Exe cuteNonQue ry()
at DotNetNuke.Data.SqlDataPro vider.Exec uteADOScri pt(String SQL)
at DotNetNuke.Data.SqlDataPro vider.Exec uteScript( String Script, Boolean UseTransactions)
I have been trying to install DotNetNuke but failing constantly on the DB table generation maybe someone here has an idea. It seems to be failing on things i thought SQL Server (which is the one I am using) should support. E.g:
----------
System.Data.SqlClient.SqlE
The sum or average aggregate operation cannot take a void type data type as an argument.
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at DotNetNuke.Data.SqlDataPro
at DotNetNuke.Data.SqlDataPro
CREATE PROCEDURE dbo.dnn_GetPortalSpaceUsed
@PortalId int
AS
SELECT 'SpaceUsed' = SUM(CAST(Size as bigint))
FROM dnn_Files
WHERE ((PortalId = @PortalId) OR (@PortalId is null and PortalId is null))
System.Data.SqlClient.SqlE
Must declare the variable '@PropertyName'.
A RETURN statement with a return status can only be used in a stored procedure.
Must declare the variable '@PortalID'.
Must declare the variable '@POrtalID'.
Must declare the variable '@PortalID'.
A RETURN statement with a return status can only be used in a stored procedure.
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at DotNetNuke.Data.SqlDataPro
at DotNetNuke.Data.SqlDataPro
---------------
System.Data.SqlClient.SqlE
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at DotNetNuke.Data.SqlDataPro
at DotNetNuke.Data.SqlDataPro
--------------------
System.Data.SqlClient.SqlE
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.TdsP
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlC
at DotNetNuke.Data.SqlDataPro
at DotNetNuke.Data.SqlDataPro
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Forgot to ask - what level should it be set to?
At least 80 (SQL Server 2000)
But you will have to have at least SQL Server 2000 in order to do that.
ASKER
Yes its 2000, thanks again.
ASKER