I have a forum with 70.000 topics and 1.300.000 messages.
While upgrading from version 126.96.36.199 to 1.9.3, I got error
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Line 286: // Ederon : 9/7/2007
Line 287: // resync all boards - necessary for propr last post bubbling
Line 288: DB.board_resync();
Line 290: // upgrade providers...
I tried to execute the yaf_board_resync SP in SQL Management tool (I guessed the function DB.board_resync() called this SP) and it took about 5-6 minutes to complete.
I couldn't complete the upgrade. Anyone can help me to solve this problem?
1. In the database, alter resync SP so it doesn't contain any code. (or just some dummy select)
2. Go though upgrade process again.
3. When upgraded, run code of resync SP in management studio to properly finish upgrade of the database.
I finally completed my upgrade. I tried Enderon suggestion and still failed. My solution is comment the line DB.board_resync() in install/default.aspx.cs, run the upgrade and then execute yaf_board_resync SP in SQL Management Tool.
Hope everything OK with my forum.
Thank you all again. I will try 1.9.4 another time.