| |
|
|
|
|
|
|
|
|
|
 |  | |
| | |
| | |
| | |
 | | |
|
|
|
| Error on fresh installation |
|
|
I installed the module on a clean DNN 4.8.2. portal.
Error:
| Info |
Executing 03.03.08.SqlDataProvider |
| StartJob |
Start Sql execution: 03.03.08.SqlDataProvider file |
| EndJob |
End Sql execution: 03.03.08.SqlDataProvider file |
| |
| Info |
Executing 04.00.00.SqlDataProvider |
| StartJob |
Start Sql execution: 04.00.00.SqlDataProvider file |
| Failure |
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /*** Change index to be on EventDateBegin instead of EventDateEnd ***/ if exists (select * from dbo.sysindexes where id = object_id(N'dbo.[Events]') AND name = N'IX_Events_1') drop index [IX_Events_1] on dbo.[Events] with ( online = off ) System.Data.SqlClient.SqlException: There is already an index on table 'Events' named 'IX_Events_1'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE INDEX [IX_Events_1] ON dbo.[Events]([EventDateBegin]) ON [PRIMARY] |
| EndJob |
End Sql execution: 04.00.00.SqlDataProvider file |
| |
| EndJob |
Finished Sql execution |
| |
Cheers,
Jos
jos Richters
www.visualdata.nl |
|
|
|
| |
|
| |
| |
|
|
| Re: Error on fresh installation |
|
|
I tested the script below and it worked.
if exists (select * from dbo.sysindexes where id = object_id(N'{databaseOwner}[{objectQualifier}Events]') AND name = N'IX_{objectQualifier}Events_1')
drop index {databaseOwner}[{objectQualifier}Events].[IX_{objectQualifier}Events_1]
GO
CREATE INDEX [IX_{objectQualifier}Events_1] ON {databaseOwner}[{objectQualifier}Events]([EventDateBegin]) ON [PRIMARY]
Fuji Nguyen
FREE Visitor Hit Counter
Visit
opensource.indyneinc.com
for detail. |
|
|
|
| |
|
|
| Re: Error on fresh installation |
|
|
Hi Jos,
Whay version of SQL Server are you using? I think what Fuji has posted is the code from the 4.0.0 SQLDataprovider (correct me if I'm wrong Fuji), which we know works on SQL Server 2005, but it maybe it doesn't work on other versions.
Cheers
Roger
Events 4.0.2 - It's released !! - See the annoucement.
Requirements/Bugs - Submit them here - Gemini - Raise against project 'DNNP', and put 'Events' in the title. |
|
|
|
| |
|
|
| Re: Error on fresh installation |
|
|
The problem might be the attribute: with ( online = off )
I think this is only supported (documented) for Enterprise versions of SQL2005. I tested this before on standard version of SQL2005, and that version did not complain. I have not tested this on SQLexpress or SQL2000.
Regards,
Ernst Peter
Kom werken bij XCESS: specialisten in .NET/SQL/DNN. Zie www.werkenbijxcess.nl |
|
|
|
| |
| | |
| | |
| | |
|  |
| |
|
|
|
These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.
For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
|
| |
|
|
|
|
|
DNN Outsourcing
50% more affordable services comparing to Western Europe and US: Custom DotNetNuke module development, skins, consulting, maintainence... Over 15.000 working hours of experience in custom DotNetNuke Solutions development, 8 years experience in outsourcing, excellent references!
www.dnnoutsourcing.com
|
Expressnet - DotNetNuke Hosting
Expressnet provide premium quality ASP.NET Web Hosting. We specialise in Windows based products including ASP.NET and Microsoft SQL Server. We offer fantastic value packages for DotNetNuke hosting. We also offer free asp.net web hosting
www.expressnet.com.au
|
Softech Development, Inc.
We help your business work smarter with DotNetNuke. Whether you need a new implementation, a custom module or skin for an existing implementation, or integration with your business processes, Softech has the experience and expertise to make it happen.
www.softechdevelopment.com
|
|
|
|