Event Calendar Pro broken

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

What operating system were you running when the bug appeared?
What database platform is your site using?
What version of mojoPortal are you running?
What version of .NET do you use?
What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.

9/9/2008 5:39:26 AM

celticJedi

Total Posts 69

View Posts

Event Calendar Pro broken

Hi, I've just bought the new event calendar as it has the features I was after. however it isn't working. When I try to view the page that it's installed on I get the following message:

We're sorry but a server error has occurred while trying to process your request.

The error has been logged and will be reviewed by our staff as soon as possible. It is possible that the error was just a momentary hiccup and you may wish to use the back button and try again or go back to the home page.

This dosn't give me much info as to what might have gone wrong.

any suggestions?

9/9/2008 5:45:40 AM

Joe Audette

Total Posts 18439

View Posts

Re: Event Calendar Pro broken

Hi,

First, thanks for making the purchase and supporting the project, its really a big help!

I'll be glad to help you resolve this. To find out the error, you can look in (Key icon) Administration Menu > System log, or using ftp you can download the log file /Data/currentlog.config

The newest errors are at the bottom. Please don't post the whole log but try to get as much of the relevant error message and post it here.

Once I see the error I'll know better how to help.

Best,

Joe

9/9/2008 6:00:21 AM

celticJedi

Total Posts 69

View Posts

Re: Event Calendar Pro broken

hi, this is the start of the log

2008-09-09 11:03:40,822 [1924] INFO mojoPortal.Web.Global [(null)] - Application Started.
2008-09-09 11:03:40,978 [1924] ERROR mojoPortal.Web.WebTaskManager [(null)] - MySql.Data.MySqlClient.MySqlException: Table 'wib.mp_taskqueue' doesn't exist
at MySql.Data.MySqlClient.MySqlStream.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(MySqlConnection connection, MySqlTransaction transaction, String commandText, MySqlParameter[] commandParameters, Boolean ExternalConn)
at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters)
at mojoPortal.Data.DBTaskQueue.GetUnfinished()
at mojoPortal.Business.TaskQueue.GetUnfinished()
at mojoPortal.Web.WebTaskManager.StartOrResumeTasks(Boolean appWasRestarted)

9/9/2008 6:04:14 AM

Joe Audette

Total Posts 18439

View Posts

Re: Event Calendar Pro broken

What version of mojoPortal are you using? Check at (Key icon) Administration Menu > System Information

TaskQueue has been there for a while. Do you have a table named mp_TaskQueue in your database?

What do you see if you go to (Key icon) Administration Menu > Task Queue?

9/9/2008 6:33:25 AM

celticJedi

Total Posts 69

View Posts

Re: Event Calendar Pro broken

Mojo version 2.2.6.7 MySQL

the task queue gives me this:

No tasks are currently running.

Refresh Task Queue History
Available Threads: 199

9/9/2008 6:34:42 AM

celticJedi

Total Posts 69

View Posts

Re: Event Calendar Pro broken

and yes, there is a table called mp_TaskQueue

9/9/2008 6:41:13 AM

Joe Audette

Total Posts 18439

View Posts

Re: Event Calendar Pro broken

I notice in the error it says:

Table 'wib.mp_taskqueue' doesn't exist

its prefixing it with the connection string user, ie table owner. Have you changed the connection string user since the initial install? Is it possible the mp_TaskQueue table is owned by a different user?

What I suggest is:

1. If the owner isn't right then correct it so that the table is owned by the user in your connection string.

2. Delete all rows if any exist in mp_TaskQueue

3. Clear your error log on Administration Menu > System log

4. touch your web.config (ie if its a remote server just download it and upload it again, if is a local machine just open Web.config in a text editor type a space and save it. (This is just to recycle the app.)

5. Visit the page with Event Calendar Pro again, if it causes an error again look in the log and see if its the same error.

Hope it helps,

Joe

9/9/2008 6:49:14 AM

celticJedi

Total Posts 69

View Posts

Re: Event Calendar Pro broken

ok, did all that and got the same error, here's the system log:

2008-09-09 12:48:01,316 [476] INFO mojoPortal.Web.Global [(null)] - Global.asax.cs Application_End
2008-09-09 12:48:15,254 [3888] INFO mojoPortal.Web.Global [(null)] - Application Started.
2008-09-09 12:48:18,441 [3888] ERROR mojoPortal.Web.mojoBasePage [(null)] - 84.45.141.26-en-GB - /1events.aspx
System.TypeLoadException: Could not load type 'mojoPortal.Data.SqlParameterHelper' from assembly 'mojoPortal.Data, Version=1.0.3139.26603, Culture=neutral, PublicKeyToken=null'.
at sts.Events.Data.DBEventTicketOrder.GetOrderCountByUser(Int32 moduleId, Guid userGuid)
at sts.Business.EventTicketOrder.GetOrderCountByUser(Int32 moduleId, Guid userGuid)
at sts.Events.Web.UI.Events.Controls.CalendarViewMenu.LoadSettings()
at sts.Events.Web.UI.Events.Controls.CalendarViewMenu.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2008-09-09 12:48:18,457 [3888] ERROR mojoPortal.Web.Global [(null)] - 84.45.141.26-en-GB - /1events.aspx
System.TypeLoadException: Could not load type 'mojoPortal.Data.SqlParameterHelper' from assembly 'mojoPortal.Data, Version=1.0.3139.26603, Culture=neutral, PublicKeyToken=null'.
at sts.Events.Data.DBEventTicketOrder.GetOrderCountByUser(Int32 moduleId, Guid userGuid)
at sts.Business.EventTicketOrder.GetOrderCountByUser(Int32 moduleId, Guid userGuid)
at sts.Events.Web.UI.Events.Controls.CalendarViewMenu.LoadSettings()
at sts.Events.Web.UI.Events.Controls.CalendarViewMenu.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2008-09-09 12:48:18,473 [3888] ERROR mojoPortal.Web.Global [(null)] - 84.45.141.26-en-GB - /1events.aspx
System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.TypeLoadException: Could not load type 'mojoPortal.Data.SqlParameterHelper' from assembly 'mojoPortal.Data, Version=1.0.3139.26603, Culture=neutral, PublicKeyToken=null'.
at sts.Events.Data.DBEventTicketOrder.GetOrderCountByUser(Int32 moduleId, Guid userGuid)
at sts.Business.EventTicketOrder.GetOrderCountByUser(Int32 moduleId, Guid userGuid)
at sts.Events.Web.UI.Events.Controls.CalendarViewMenu.LoadSettings()
at sts.Events.Web.UI.Events.Controls.CalendarViewMenu.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.default_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

9/9/2008 6:49:48 AM

Joe Audette

Total Posts 18439

View Posts

Re: Event Calendar Pro broken

Hi,

I just checked the product page to see about the mojoportal version requirement and it says it requires 2.2.6.8 or higher.

http://www.mojoportal.com/event-calendar-pro-offer.aspx

Can you upgrade to the latest mojoPortal?

Hope it helps,

Joe

9/9/2008 6:52:07 AM

celticJedi

Total Posts 69

View Posts

Re: Event Calendar Pro broken

I'm assuming that just means copying the new version up to the website

9/9/2008 6:53:46 AM

Joe Audette

Total Posts 18439

View Posts

Re: Event Calendar Pro broken

Your new error indicates its using the MS SQL data layer for the event calendar pro. After you upgrade to mojoPortal 2.2.6.8, you'll need to get the MySql data layer fro Event Calendar Pro from here:

http://developer.novell.com/wiki/index.php/Mojoportal

just replace the sts.Events.Data.dll

I have to package the MySql data layer as a separate free download to comply with the GPL license for the MySql connector.

Hope it helps,

Joe

9/9/2008 6:55:06 AM

Joe Audette

Total Posts 18439

View Posts

Re: Event Calendar Pro broken

Instructions for upgrading mojoPortal are here:

http://www.mojoportal.com/upgrading.aspx

Hope it helps,

Joe

9/9/2008 9:16:18 AM

celticJedi

Total Posts 69

View Posts

Re: Event Calendar Pro broken

ok, I followed all those instructions, upgraded the site, ran the setup again.

I then deleted the page with the calendar on and made another page (with a different name). I went through the Content Manager and deleted the instances of the calendar.

Then I checked the new page on it's own and it worked fine. AS soon as I put the Event Calendar Pro in it I get the same error

We're sorry but a server error has occurred while trying to process your request.

The error has been logged and will be reviewed by our staff as soon as possible. It is possible that the error was just a momentary hiccup and you may wish to use the back button and try again or go back to the home page.

9/9/2008 9:20:27 AM

Joe Audette

Total Posts 18439

View Posts

Re: Event Calendar Pro broken

Please clear the log again, the visit the page to cause the error, then post the log again so I can see the error message.

Thanks,

Joe

9/9/2008 9:32:44 AM

celticJedi

Total Posts 69

View Posts

Re: Event Calendar Pro broken

ok, I got this:

2008-09-09 15:32:05,316 [3888] ERROR mojoPortal.Web.mojoBasePage [(null)] - 84.45.141.26-en-GB - /events-calendar.aspx
System.TypeLoadException: Could not load type 'mojoPortal.Data.SqlParameterHelper' from assembly 'mojoPortal.Data, Version=1.0.3150.11005, Culture=neutral, PublicKeyToken=null'.
at sts.Events.Data.DBEventTicketOrder.GetOrderCountByUser(Int32 moduleId, Guid userGuid)
at sts.Business.EventTicketOrder.GetOrderCountByUser(Int32 moduleId, Guid userGuid)
at sts.Events.Web.UI.Events.Controls.CalendarViewMenu.LoadSettings()
at sts.Events.Web.UI.Events.Controls.CalendarViewMenu.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2008-09-09 15:32:05,316 [3888] ERROR mojoPortal.Web.Global [(null)] - 84.45.141.26-en-GB - /events-calendar.aspx
System.TypeLoadException: Could not load type 'mojoPortal.Data.SqlParameterHelper' from assembly 'mojoPortal.Data, Version=1.0.3150.11005, Culture=neutral, PublicKeyToken=null'.
at sts.Events.Data.DBEventTicketOrder.GetOrderCountByUser(Int32 moduleId, Guid userGuid)
at sts.Business.EventTicketOrder.GetOrderCountByUser(Int32 moduleId, Guid userGuid)
at sts.Events.Web.UI.Events.Controls.CalendarViewMenu.LoadSettings()
at sts.Events.Web.UI.Events.Controls.CalendarViewMenu.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
2008-09-09 15:32:05,332 [3888] ERROR mojoPortal.Web.Global [(null)] - 84.45.141.26-en-GB - /events-calendar.aspx
System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.TypeLoadException: Could not load type 'mojoPortal.Data.SqlParameterHelper' from assembly 'mojoPortal.Data, Version=1.0.3150.11005, Culture=neutral, PublicKeyToken=null'.
at sts.Events.Data.DBEventTicketOrder.GetOrderCountByUser(Int32 moduleId, Guid userGuid)
at sts.Business.EventTicketOrder.GetOrderCountByUser(Int32 moduleId, Guid userGuid)
at sts.Events.Web.UI.Events.Controls.CalendarViewMenu.LoadSettings()
at sts.Events.Web.UI.Events.Controls.CalendarViewMenu.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
--- End of inner exception stack trace ---
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.default_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

9/9/2008 9:38:17 AM

Joe Audette

Total Posts 18439

View Posts

Re: Event Calendar Pro broken

Hi,

this part:

mojoPortal.Data.SqlParameterHelper

tells me that it is using the Data layer for MS SQL, did you replace the sts.Events.Data.dll with the one from the free MySql download?

You need the file sts-eventcalendarpro-0-0-0-2-mysql-datalayer-gpl.zip

from here:

http://developer.novell.com/wiki/index.php/Mojoportal

Unzip it and replace your sts.Events.Data.dll with the one from there.

Hope it helps,

Joe

9/9/2008 9:46:09 AM

celticJedi

Total Posts 69

View Posts

Re: Event Calendar Pro broken

woo-hoo it works thanks for your help

btw MojoPortal Rocks

9/9/2008 9:48:59 AM

Joe Audette

Total Posts 18439

View Posts

Re: Event Calendar Pro broken

Glad its working! Thanks again for supporting mojoPortal with your purchase!

Cheers,

Joe

You must sign in to post in the forums. This thread is closed to new posts.