DotNetNuke

Re: Calendar Module for DNN 2.0

cathal — Tue, 21 Sep 2004 18:41:11 GMT

billdeal,
Are you sure you're using SQL, as the script seems to be executing with the system.data.oledb library indicating that you're using MS Access, which will fail with sql server scripts for obvious reasons. Make sure you've edited both the database locations in your web.config.

Cathal

Re: Calendar Module for DNN 2.0

billdeal — Tue, 21 Sep 2004 18:37:19 GMT

I'm trying to install the LTP calendar dated 4/25/2004 from Andy's website onto DNN 2.1.3 using a SQL Server database and getting the following error from the SQL script: SQL Execution resulted in following Exceptions: System.Data.OleDb.OleDbException: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Access.ApplicationBlocks.Data.AccessHelper.ExecuteNonQuery(OleDbConnection connection, CommandType commandType, String commandText, OleDbParameter[] commandParameters) at Access.ApplicationBlocks.Data.AccessHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, OleDbParameter[] commandParameters) at Access.ApplicationBlocks.Data.AccessHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) at DotNetNuke.Data.AccessDataProvider.ExecuteScript(String Script, Boolean UseTransactions) if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[AddLTPCalendarItem]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[AddLTPCalendarItem] System.Data.OleDb.OleDbException: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at ............

I noticed you had sent Andy a new version in May, but I don't think he set it up on his web site. Does that version correct this error? If so, could you send the PA zip to bshaw88@comcast.net?

Re: Calendar Module for DNN 2.0

wshackne — Fri, 28 May 2004 13:11:03 GMT

Rob and I did some work on this module over the past few days. We fixed the styles, install, and now the list view displays the correct period (it did not honor it before). If you want the module, head over to http://empower.spencehackney.com. You will need to register and it is on the downloads tab. Have fun!

Spence

Re: Calendar Module for DNN 2.0

johnrea — Fri, 28 May 2004 09:32:36 GMT

I found running the sql script in the PA in MS analyser after installing the PA fixed all errors and now works great.

Re: Calendar Module for DNN 2.0

rmurray — Thu, 27 May 2004 00:57:50 GMT

I repaired it a few weeks ago. I have sent it to the owner but it is not updated on the download site at this point. If anyone needs it, just send me an email.

Rob

Re: Calendar Module for DNN 2.0

wshackne — Wed, 26 May 2004 21:36:58 GMT

I just tried too and got the same error. Anyone fixed this yet?

Re: Calendar Module for DNN 2.0

caschbre — Mon, 24 May 2004 20:30:58 GMT

I just downloaded the zip for DNN2 from arswebdesign and received the following error:

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 11: Incorrect syntax near ' '. 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 procedure dbo.GetSingleLTPCalendarItem @ItemID int, @ModuleId int as select ItemID, Description, DateTime, Title, ExpireDate, 'CreatedByUser' = FirstName ' ' LastName, ModuleEvents.CreatedDate, Every, Period, IconFile, AltText from ModuleEvents left outer join Users on ModuleEvents.CreatedByUser = Users.UserId where ItemID = @ItemID and ModuleId = @ModuleId

Re: Calendar Module for DNN 2.0

rmurray — Wed, 12 May 2004 15:02:06 GMT

It is not included currently, but would be a nice touch. The source code is available with the download. I will see if I can come up with something along the lines you are looking for, when I get a chance! If you modify it to suit your needs, I would appreciate a copy.

Rob

Re: Calendar Module for DNN 2.0

RAGolko — Wed, 12 May 2004 07:14:10 GMT

Do the details of the clicked event offer a hyperlink we can use for whatever we want such as booking a room, or ordering a ticket, or just for more information?
It would be nice to incorporate the free hyperlink that you can pass parameters with.
Is the source code released with the module as well so we can incorporate any such changes?
I appreciate the hard work.

Re: Calendar Module for DNN 2.0

rmurray — Wed, 12 May 2004 04:08:17 GMT

I sent a new file to Andy tonight that fixes all of the above issues. I am sure he will have it up on his site soon.

Rob

Re: Calendar Module for DNN 2.0

johnrea — Sun, 09 May 2004 23:06:31 GMT

Installed on dnn2.0.4/SQL, no install errors reported, critical error occurs when clicking on any dates in the calendar.

A critical error has occurred.
Method not found: System.Data.DataSet DotNetNuke.Globals.ConvertDataReaderToDataSet(System.Data.SqlClient.SqlDataReader).

Re: Calendar Module for DNN 2.0

arschmidt — Sun, 25 Apr 2004 16:12:01 GMT

looks like we have now come back around to an old problem in the sql script - there needs to be a trailing carriage return at the end. i have (again) revised the script and posted it to my site. while i haven't tested this, since it is now identical to the original install script (except for the comments), things should go smoothly.

a

Re: Calendar Module for DNN 2.0

tcurtis45 — Sun, 25 Apr 2004 00:39:02 GMT

Thanks for the update. I don't know if it is just me, but I am still getting an error message, although not the same one with that update. Sorry, but I am an SQL moron. I now get the error:

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 2: Incorrect syntax near 'GO'. 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) in C:\Inetpub\wwwroot\dnnv2\providers\DataProviders\SqlDataProvider\SqlDataProvider.vb:line 158 SET ANSI_NULLS ON GO

Thanks for your help.

Tony

Re: Calendar Module for DNN 2.0

arschmidt — Sun, 25 Apr 2004 00:27:35 GMT

the sql files were in unicode text. i converted them to ascii text and put an unpdated zip on my site.

andy

Re: Calendar Module for DNN 2.0

tcurtis45 — Sat, 24 Apr 2004 23:40:48 GMT

Thanks for your help rmurray, but I am still get the same error after replacing the sql database file. I am putting it in LPTCalendar\Database folder, but still have the same error message. You have any more ideas why? Thanks for your input.

Tony