Welcome Guest Search | Active Topics | Log In | Register

3 Pages 123>
"There has been a serious error loading the forum"... Options · View
Papoute
#1 Posted : Monday, November 19, 2007 3:50:31 PM

Rank: YAF Forumling


Joined: 11/19/2007
Posts: 2
Location: Canada

Running YAF version 1.9.1.2 and .NET version 2.0


Whenever someone posts a new topic/message on a moderated forum, the following error is displayed:
"There has been a serious error loading the forum. No futher information is available. Please contact the administrator if this message persists."

This is true for any user profile - whether I am logged in as an admin, a moderator, or a regular user.

In theory, the page that should display is the one that says that the forum is moderated, and that the message needs first be approved before it is visible to users.

What is also interesting is that despite this error message being displayed, the message still goes to the "Moderated" queue and will become visible to the users after it has been approved. So the forum is doing what it is supposed to in the background, but this error message is annoying and very confusing.

The forum is located at: http://forum.nouvelair.ca (sorry, it's in French!)
It is still in test/design mode and has not gone live yet.

I have also tried modifying the web.config and made customErrors mode="Off", but an error still comes up.


Can anyone provide advice on this?

Thanks
Jaben
#2 Posted : Monday, November 19, 2007 11:00:13 PM

Rank: YAF Head Dude



Joined: 10/10/2004
Posts: 2,950
Location: Honolulu, HI
Disable URL Rewriting for now to fix (in the yafnet.config: <enableurlrewriting>false</enableurlrewriting>Wink

Also: Please provide the error details from the EventLog.

But I'll look into this bug a bit more.

"When you are grateful, fear disappears and abundance appears”."

w.mapelli
#3 Posted : Tuesday, November 27, 2007 11:23:02 PM

Rank: YAF Forumling


Joined: 11/26/2007
Posts: 6
I have the same problem...
I already have <enableurlrewriting>false</enableurlrewriting> in the config file.
I'm running YAF 1.9.1.6.

Sometimes, when I try to post I get the error and the following Stack-Trace:

Code:


[InvalidCastException: Object cannot be cast from DBNull to other types.]
   System.DBNull.System.IConvertible.ToDateTime(IFormatProvider provider) +54
   System.Convert.ToDateTime(Object value) +29
   ASP.pages_forum_ascx.__DataBind__control10(Object sender, EventArgs e) +675
   System.Web.UI.Control.OnDataBinding(EventArgs e) +99
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +206
   System.Web.UI.Control.DataBind() +12
   System.Web.UI.Control.DataBindChildren() +216
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216
   System.Web.UI.Control.DataBind() +12
   System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +130
   System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +454
   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +53
   System.Web.UI.WebControls.Repeater.DataBind() +72
   System.Web.UI.Control.DataBindChildren() +216
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216
   System.Web.UI.Control.DataBind() +12
   System.Web.UI.Control.DataBindChildren() +216
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +216
   System.Web.UI.Control.DataBind() +12
   yaf.pages.forum.BindData() +3559
   yaf.pages.forum.Page_Load(Object sender, EventArgs e) +820
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832


I'm running the forum in a test environment (only 2 users).
Windows 2003 STD SP2 + SQL 2005 SP2 + .NET 2.0

Any suggestions ?

Thanks a lot.

William
Jaben
#4 Posted : Wednesday, November 28, 2007 1:38:04 AM

Rank: YAF Head Dude



Joined: 10/10/2004
Posts: 2,950
Location: Honolulu, HI
Do you have no forums or posts in your forum?
"When you are grateful, fear disappears and abundance appears”."

w.mapelli
#5 Posted : Wednesday, November 28, 2007 9:04:09 AM

Rank: YAF Forumling


Joined: 11/26/2007
Posts: 6
Yes, I have two Forums under one Category.
I created 2 topics in the 1st forum.
I created 2 posts in the 1st topic.

Inserting the 3rd post, i got the error:
"There has been a serious error loading the forum. No futher information is available."

Now the forum is inaccessible...

William
Jaben
#6 Posted : Wednesday, November 28, 2007 9:17:08 AM

Rank: YAF Head Dude



Joined: 10/10/2004
Posts: 2,950
Location: Honolulu, HI
Is there any way you can detach your SQL DB and zip it and email to me at: support@yetanotherforum.net ??

Or if there is any way you can export your DB... I'd like to see what's causing this.
"When you are grateful, fear disappears and abundance appears”."

w.mapelli
#7 Posted : Wednesday, November 28, 2007 10:14:25 AM

Rank: YAF Forumling


Joined: 11/26/2007
Posts: 6

No problem at all.
I'll send you a copy of the DB...

Thank you

William
w.mapelli
#8 Posted : Wednesday, November 28, 2007 9:08:58 PM

Rank: YAF Forumling


Joined: 11/26/2007
Posts: 6
It seems that when I add a new Topic, something goes wrong while updating the database.
I activated SQL Profiler, and at startup, the application executes this stored procedure:

exec yaf_topic_latest @BoardID=1,@NumPosts=5,@UserID=1;

The result on my DB is:

Code:

2007-11-27 23:04:02.530    2    Visual LANSA    Come integrare un componente ActiveX ?    2    4    2    1    william
2007-11-27 22:46:11.357    2    Visual LANSA    Problema di installazione    1    3    2    3    william
NULL    4    LANSA Integrator    Come installare un add-on ?    4    NULL    NULL    0    NULL


Note the last row with NULL values.

I then execute the query:
select * from yaf_Topic where TopicID=4;

and I get:

Code:

4    4    2    NULL    2007-11-28 20:53:24.790    Come installare un add-on ?    0    1    NULL    NULL    NULL    NULL    NULL    NULL    0    0


If I try to delete the last topic (TopicID=4) and the linked message the Forum restarts.

But when I try to add other Topics/Posts the problem occours, and a new row with NULL values appers hanging the forum again.

The forum is running on IIS 6.0 with .NET 2.0 and SQL Server 2005 SP2 (9.00.3042.00) Collation: Latin1_General_CI_AS

What can I do ?

Thank's

William



w.mapelli
#9 Posted : Wednesday, November 28, 2007 11:13:15 PM

Rank: YAF Forumling


Joined: 11/26/2007
Posts: 6
I made some testing...

I created a new forum (not moderated) from scratch...and I worked fine for a lot.

Then, I created a new "moderated" forum.

I get the "...serious error..." when I try to post a new Topic on a Moderated forum.

I hope this is helpful for you.

Bye
William
w.mapelli
#10 Posted : Thursday, November 29, 2007 2:57:45 PM

Rank: YAF Forumling


Joined: 11/26/2007
Posts: 6
More testing on issue: "There has been a serious error loading the forum..."

I confirm that the error is related to "Moderated" forums.

When I post on a "moderated" forum, some columns are left NULL on the Message table causing the error.

On "non moderated" forums all works fine.

Is it a problem related to my particular installation ?
Is it possible to workaround the problem ?

Thenk's a lot.

William

YAF 1.9.1.6 (NET v2.0) - 14/11/2007
w.mapelli
#11 Posted : Monday, December 03, 2007 3:24:58 PM

Rank: YAF Forumling


Joined: 11/26/2007
Posts: 6
w.mapelli wrote:
More testing on issue: "There has been a serious error loading the forum..."

I confirm that the error is related to "Moderated" forums.

When I post on a "moderated" forum, some columns are left NULL on the Message table causing the error.

On "non moderated" forums all works fine.

Is it a problem related to my particular installation ?
Is it possible to workaround the problem ?

Thenk's a lot.

William

YAF 1.9.1.6 (NET v2.0) - 14/11/2007


I have to wait for a future fix or exist a workaround ?

Thank you !

William
Jaben
#12 Posted : Tuesday, December 04, 2007 6:53:37 AM

Rank: YAF Head Dude



Joined: 10/10/2004
Posts: 2,950
Location: Honolulu, HI
I emailed you back. I need you to send me a copy of DB. Do this by detaching it, zipping it and emailing to me. Of course, you can just attach it again after you do that.

I couldn't use the backup you provided.
"When you are grateful, fear disappears and abundance appears”."

hecklertm
#13 Posted : Thursday, December 20, 2007 9:51:42 PM

Rank: YAF Forumling



Joined: 12/20/2007
Posts: 2
Location: Houston, TX
I have the exact same problem occuring when testing posts to moderated threads. Do you have a solution for this or do you need more information from me?
hecklertm
#14 Posted : Thursday, December 20, 2007 10:06:46 PM

Rank: YAF Forumling



Joined: 12/20/2007
Posts: 2
Location: Houston, TX
Actually, at this point, the forums will not let anyoe even login anymore. All I get is a

Quote:
There has been a serious error loading the forum. No futher information is available.

Please contact the administrator if this message persists.


If I restart IIS, it does not make a difference.
Jaben
#15 Posted : Saturday, December 22, 2007 8:10:56 AM

Rank: YAF Head Dude



Joined: 10/10/2004
Posts: 2,950
Location: Honolulu, HI
Please turn CustomErrors="OFF" in your web.config file or view the errors in the Admin->Error Log to provide more information on your problem.
"When you are grateful, fear disappears and abundance appears”."

Users browsing this topic
Guest
3 Pages 123>
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAFPro Theme Created by Jaben Cargman (Tiny Gecko)
Powered by YAF 1.9.3 RC2 | YAF © 2003-2008, Yet Another Forum.NET
This page was generated in 0.184 seconds.

SourceForge.net Logo Powered by ASP.NET v2.0 411ASP.NET