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
Gravatar
Total Posts 69

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
Gravatar
Total Posts 18439

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
Gravatar
Total Posts 69

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
Gravatar
Total Posts 18439

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
Gravatar
Total Posts 69

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
Gravatar
Total Posts 69

Re: Event Calendar Pro broken

and yes, there is a table called mp_TaskQueue

9/9/2008 6:41:13 AM
Gravatar
Total Posts 18439

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
Gravatar
Total Posts 69

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
Gravatar
Total Posts 18439

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
Gravatar
Total Posts 69

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
Gravatar
Total Posts 18439

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

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