| |
|
|
|
|
|
|
|
|
|
 |  | |
| | |
| | |
| | |
 | | |
|
|
|
| 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.1 - It's released !! -
See the announcement
Events 4.0.2 - It's in the Release Process -
Follow it
Requirements/Bugs - Submit them here - Gemini |
|
|
|
| |
|
|
| 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.
|
| |
|
|
|
|
|
Gearworx Web Hosting
As a premier provider of Web Hosting, Private/White Label hosting, Server Colocation, Dedicated Server, and other Managed Services, Gearworx offers an array of services designed to more effectively manage strategies driving businesses on the Web. Headquartered in Fremont, California our state of the art tier one data centers and distributed managed services environment enables Gearworx to offer your business enterprise level solutions through simplified processes.
Gearworx Web Hosting
|
Glanton: Enterprise Intranet Specialists Using DNN
Glanton Solutions are a premier provider of sevices for large corporates lloking to outsource Intranet sites.
www.glanton.com
|
Jetkey Smart Map
Smart Map is an AJAX powered Google Map module that displays driving directions, proximity search results and data from your own databases. Smart Map reads GPX (GPS data) files, GeoRSS feeds, and KML data. You can pass any querystring parameter to Smart Map and into your own custom queries to control what data displays on the map.
smartmap.jetkey.com
|
|
|
|