Kythor
  •  Kythor
  • 65.6% (Friendly)
  • YAF Camper Topic Starter
2013-11-07T15:42:43Z
Hi,

I have uploaded all the files for the upgrade to YAF 2.0.
But when I run the upgrade Wizard I always get this:

[HttpException (0x80004005): Request timed out.]


now what???

I guess it runs some sql scripts and that's what's taking so long... Can I execute them manually?

Please, I need urgent help!
Sponsor
squirrel
2013-11-07T21:14:24Z
You can try to adjust the timeout settings in app.config and db.config -
If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend 
Kythor
  •  Kythor
  • 65.6% (Friendly)
  • YAF Camper Topic Starter
2013-11-08T09:58:44Z
BWG
  •  BWG
  • 99.4% (Exalted)
  • YAF Lover
2013-12-04T19:15:08Z
Hi,

I've also been getting timeout errors when trying to upgrade on a SQL 2005 platform. I've adjusted the timeouts but this hasn't solved the problem for me. When I run the upgrade on a different VM running SQL 2008 there isn't a problem! I've raised this in a thread here:

http://forum.yetanotherf...-6-1-to-2.aspx#post61985 

I've run SQL Server profiler and the problem on SQL 2005 seems to occur with this statement:

if exists (select top 1 1 from [dbo].[yaf_Message] where UserDisplayName IS NULL)
exec('[dbo].[yaf_forum_initdisplayname]


I'm finding this a difficult problem to resolve, so any help or suggestions would be gratefully received.

BWG
tha_watcha
2013-12-06T12:21:11Z
Originally Posted by: BWG 

Hi,

I've also been getting timeout errors when trying to upgrade on a SQL 2005 platform. I've adjusted the timeouts but this hasn't solved the problem for me. When I run the upgrade on a different VM running SQL 2008 there isn't a problem! I've raised this in a thread here:

http://forum.yetanotherf...-6-1-to-2.aspx#post61985 

I've run SQL Server profiler and the problem on SQL 2005 seems to occur with this statement:

if exists (select top 1 1 from [dbo].[yaf_Message] where UserDisplayName IS NULL)
exec('[dbo].[yaf_forum_initdisplayname]


I'm finding this a difficult problem to resolve, so any help or suggestions would be gratefully received.

BWG



Try to remove the execution of that script in the install/tables.sql delete the lines

if exists (select top 1 1 from [{databaseOwner}].[{objectQualifier}Message] where UserDisplayName IS NULL)
exec('[{databaseOwner}].[{objectQualifier}forum_initdisplayname]')
GO


Then the upgrade should run within seconds

That sql script can take some time if you have a large db with lots of topics. It injects all missing display name values in the database

UserPostedImage
tha_watcha
2013-12-07T10:16:49Z
What you can try is increase the sql timeout or set it to unlimited in the app.config

<add key="YAF.SqlCommandTimeout" value="0" />

0 means unlimited.
UserPostedImage
tha_watcha
2013-12-07T16:28:46Z
Originally Posted by: BWG 

Originally Posted by: tha_watcha 

What you can try is increase the sql timeout or set it to unlimited in the app.config

<add key="YAF.SqlCommandTimeout" value="0" />

0 means unlimited.



When I try this SQL uses 99% CPU and just hangs, so the upgrade never finishes.






Did you actually have the display name feature enabled (which is disabled by default)? Because when display name feature is disabled yaf works correctly, and you don't have to run the procedure.


UserPostedImage
tha_watcha
2013-12-07T16:55:17Z
@Bbobb Can you split the procedure in to multiple procedures to fix this problem?
UserPostedImage

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved