Web Wiz Support and Community Forums : "Timeout expired" error when upgrading https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 01:18:30 +0000 Fri, 22 Sep 2006 04:31:04 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19636 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA["Timeout expired" error when upgrading : I DID IT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!...]]> https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114367.html#114367 Author: CinemaemCena
Subject: 19636
Posted: 22 September 2006 at 4:31am

I DID IT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 
I restarted the whole proccess. Same timeout error while updating tblThread (I still don't know why). After the upgrade was done, I checked every table. Everything was ok (except for the field the weren't deleted. Can I let them on the database or do I have to delete them?).
 
Then I went to the tblThread and I created the new fields.
 
You gave me the wrong info, Borg! Shocked It's not "binary", it's "bit". And then there's the catch. It AUTOMATICALLY selects ALLOW NULL. It's necessary to uncheck it. And it has to be done the first time, before you save the new table. If you save it with the NULL option, you can't change it afterwards. I Mean... you CAN, but the forum still won't work.
 
Anyway... I DID IT!!!! :)
 
Well... with your help and the help of the user who posted the thread I linked in a post above.
 
THANK YOU!


Edited by CinemaemCena - 22 September 2006 at 4:32am]]> Fri, 22 Sep 2006 04:31:04 +0000 https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114367.html#114367 <![CDATA["Timeout expired" error when upgrading : Ok, I went into the Version History...]]> https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114365.html#114365 Author: CinemaemCena
Subject: 19636
Posted: 22 September 2006 at 3:36am

Ok, I went into the Version History txt file and then compared it to what I had on my database after the upgrade. Maybe if I describe everything in details you'll be able to figure out what's going on.
 
The differences I found:
 
tblForum

1) none of the fields that should've been deleted were in fact deleted. And the field Read appeared in my database as [Read];

2) VH (Version History) said: "Sub_ID - data type = interger - default value = 0". But my DB had datatype as "smallint" (lenght=2. Is that right?)
 
3) VH said: "Last_post_author_ID - data type = interger". Again, my DB had datatype as "smallint".
 
4) VH said: "Last_post_date - data type = date/time - default value = now()/GetDate()". My DB had default value as "(getdate())"
 
5) The field Display was NOT created.
 
 
tblTopic

1) The fields Start_date and Last_entry_date were NOT deleted.

2) The fields "Start_Thread_ID", "Last_Thread_ID" and "No_of_replies" had their datatypes in VH as "interger". In my DB, however, it was set to "int". Why "int" and not "smallint" like what happened in the "tblForum"?'
 
3) The field "Icon", in VH, said datatype as "text". In my DB, it was set to "nvarchar".
 
4) The field "Hide", in VH, said datatype as "true/false" (def. val. as false). In my DB it said "bit" and def. value as (0).
 
5) The field "Event-Date", in VH, said datatype as "date". In my DB it's "datetime", but I guess it's correct.
 
 
tblThread

1) None of the new fields were created. And there's no "true/false" datatype. you said before I should use "bin". In the thread I linked to in my last post, the user said he used "bit". Which one is the correct? (I guess the default value is (0).

tblPermission

1) In VH, it says "Display_posts" datatype true/false. In my DB it says "bit". In VH, it doesn't say which should be the default value, but the upgrade file sets it to (0) (false, isn't it?).

2) In VH, the new field "Calendar_event" is set to datatype "boolean". In my DB, it says "bit" (default value = (0)).

tblAuthor

1) In VH, "No_of_PM" has datatype as "interger". In my DB, as "int". I still don't know why interger was substituted with "smallint" in the tblForum.

And so on... (yes, I got tired). The pattern is the same in the rest: "interger" for "int", "boolean" for "int", etc, etc, etc.

 
]]> Fri, 22 Sep 2006 03:36:04 +0000 https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114365.html#114365 <![CDATA["Timeout expired" error when upgrading : This is really frustrating. I...]]> https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114363.html#114363 Author: CinemaemCena
Subject: 19636
Posted: 22 September 2006 at 2:38am

This is really frustrating. I went to the Version History file and I compared everything to what I had on my SQL server AFTER the upgrade. There were some discrepancies in some tables, but most of them were correctly created during the ugprade (I noticed some oddities, like data type "text" were constantly substituted by nvchar). So that invalidates the theory that my "user" isn't allowed to do modifications. I also noticed that even in the tables that had new fields added, NO fields were deleted - so I deleted the fields according to the Version History.
 
After altering everything according to the Version History, I STILL got the Cbool (line 779) error.
 
Then I went to this thread (http://forums.webwiz.net/forum_posts.asp?TID=20931&KW=line+779) and I tried entering the "bit" datatype instead of the "bin" datatype that you suggested (default value still (0)).
 
Guess what? It still didn't work.
 
So I officially give up on having the 8.04 version. I'll stay with 7.97, because I honestly can't think of anything else I could do.
 
Can you? Anyone? :(
]]> Fri, 22 Sep 2006 02:38:04 +0000 https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114363.html#114363 <![CDATA["Timeout expired" error when upgrading : Just to add to the mix...our install...]]> https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114344.html#114344 Author: jeffdaro
Subject: 19636
Posted: 21 September 2006 at 1:45pm

Just to add to the mix...our install went fine, but timeouts seem to be a daily issue with our forums. I've been blaming it on my ISP. Just my 2 cents...

]]> Thu, 21 Sep 2006 13:45:22 +0000 https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114344.html#114344 <![CDATA["Timeout expired" error when upgrading : It maybe then that the other new...]]> https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114335.html#114335 Author: WebWiz-Bruce
Subject: 19636
Posted: 21 September 2006 at 7:40am

It maybe then that the other new fields are also not created.

You may need to go through the version history file and create all fields manually if you can not findout why your database is timing out when alterations are applied to the tables.

I still think it would be a permissions issue and that the user you are logging into the SQL Server with doesn't have sufficient permissions to alter tables. Try logging in with the 'sa' account for doing the database upgrade.

Also a SQL Server site may be able to give you better advice on dealing with issues with SQL Server as it can be quite a complex database system.
]]> Thu, 21 Sep 2006 07:40:15 +0000 https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114335.html#114335 <![CDATA["Timeout expired" error when upgrading : Ok, I did everything like you...]]> https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114332.html#114332 Author: CinemaemCena
Subject: 19636
Posted: 21 September 2006 at 2:18am

Ok, I did everything like you said. But now, when I click on any topic of the forum, I get the message:

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'CBool'

/forum/forum_posts.asp, line 779

 

]]> Thu, 21 Sep 2006 02:18:15 +0000 https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114332.html#114332 <![CDATA["Timeout expired" error when upgrading : Do this after the upgrade.As the...]]> https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114250.html#114250 Author: WebWiz-Bruce
Subject: 19636
Posted: 19 September 2006 at 10:55am

Do this after the upgrade.

As the only error message is a timeout on that particular table the other tables should have been created and updated successfully.
]]> Tue, 19 Sep 2006 10:55:15 +0000 https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114250.html#114250 <![CDATA["Timeout expired" error when upgrading : Borg, do you recommend I do this...]]> https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114219.html#114219 Author: CinemaemCena
Subject: 19636
Posted: 18 September 2006 at 6:49pm

Borg, do you recommend I do this before or after running the upgrade?
 
And what if there's some other table that should've been created but wasn't because of the tblThread time out? I mean... after doing the tblThread, the program would upgrade other tables, wouldn'it?
]]> Mon, 18 Sep 2006 18:49:36 +0000 https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114219.html#114219 <![CDATA["Timeout expired" error when upgrading : The only thing you can do then,...]]> https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114201.html#114201 Author: WebWiz-Bruce
Subject: 19636
Posted: 18 September 2006 at 1:26pm

The only thing you can do then, as it is only the the tblThread table that there is a problem, is have a look in the version history file and manually add the new fields to the table.

Luckily the only changes were to add towo new fields which I have listed below:-

Changes to tblThread
New fields:-
1. Hide - data type = true/false - default value = false
2. File_uploads - data type = text 255 characters

For the first one in SQL server it needs to be set to binary and have the default value of 0 as SQL Sever doesn't have a true/false datatype.
]]> Mon, 18 Sep 2006 13:26:44 +0000 https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114201.html#114201 <![CDATA["Timeout expired" error when upgrading : Well, borg, I&#039;m stuck. When...]]> https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114200.html#114200 Author: CinemaemCena
Subject: 19636
Posted: 18 September 2006 at 12:39pm

Well, borg, I'm stuck. When I checked the timeout value was set to "Wait indefinetely". The dabase HAS permissions to create and alter tables.
 
But the upgrading process takes about 100 seconds and, when the final screen appears, everything is right BUT the stage 2, where the Time Out message regarding tblThreads appears.
 
I guess that's it for me, huh? :(
]]> Mon, 18 Sep 2006 12:39:07 +0000 https://forums.webwiz.net/timeout-expired-error-when-upgrading_topic19636_post114200.html#114200