| Author |
 Topic Search  Topic Options
|
hummelmose 
Newbie
Joined: 05 November 2009
Status: Offline
Points: 18
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 15 April 2012 at 8:17pm |
 WebWiz-Bruce wrote:
You will need to create the new fields in tblThread manually using the info I gave in the previous post as there is nothing that can be changed in the upgrade script to try and fix this issue, your database is simply to large for web server side upgrade scripts to work.
The other tables will be upgraded fine, it will just be tblThread that you need to manually update. |
Even on a local 64 bit 16 GB SSD based machine I get the timeouts.
Yes, we have a big forum, but should that prevent us from upgrading ?
1062378 rows in thread 101481 rows in topics
|
 |
rune
Groupie
Joined: 09 December 2010
Status: Offline
Points: 40
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 8:25pm |
|
It might be worth checking the database consistency with the DBCC CHECKDB command.
|
|
hummelmose
Newbie
Joined: 05 November 2009
Status: Offline
Points: 18
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 8:32pm |
rune wrote:
It might be worth checking the database consistency with the DBCC CHECKDB command.
|
CHECKDB found 0 allocation errors and 0 consistency errors in database 'xxx_forum10'. DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I will now try to reindex
|
|
rune
Groupie
Joined: 09 December 2010
Status: Offline
Points: 40
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 8:39pm |
|
If the zipped db backup can fit in your Dropbox, PM me a link and I'll take a look. Obviously, only if your forum data is not secret.
|
|
hummelmose
Newbie
Joined: 05 November 2009
Status: Offline
Points: 18
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 8:44pm |
rune wrote:
If the zipped db backup can fit in your Dropbox, PM me a link and I'll take a look. Obviously, only if your forum data is not secret.
|
Thanks, but no thanks :-)
We're quite a big forum.
I tried to reindex the whole database with
EXEC [sp_MSforeachtable] @command1 = "RAISERROR('DBCC DBREINDEX(''?'') ...',10,1) WITH NOWAIT DBCC DBREINDEX('?')"
The reindexing went well, but still after reindexing it all. Still timeout.
'tblTopic' table saved successfully 'tblAuthor' table saved successfully 'tblThread' table - Unable to modify table. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
|
|
rune
Groupie
Joined: 09 December 2010
Status: Offline
Points: 40
|
Post Options
Thanks(1)
Quote Reply
Posted: 15 April 2012 at 8:55pm |
|
It sounds like you use the user interface to add the fields.
What happens if you use a command instead:
alter tblThread add Answer bit not null default 0
and
alter tblThread add Thanks int not null default 0
(These commands are based on Bruce's description of the fields. I haven't checked them myself).
|
|
hummelmose
Newbie
Joined: 05 November 2009
Status: Offline
Points: 18
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 9:00pm |
rune wrote:
It sounds like you use the user interface to add the fields.
What happens if you use a command instead:
alter tblThread add Answer bit not null default 0
and
alter tblThread add Thanks int not null default 0
(These commands are based on Bruce's description of the fields. I haven't checked them myself).
|
See 
That did the trick.
Mange tak for hjælpen.
Now let's see if the rest of the upgrade will continue
|
|
hummelmose
Newbie
Joined: 05 November 2009
Status: Offline
Points: 18
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 9:05pm |
|
Your Database is being updated. Please be patient as this may take a few minutes to complete.
Stage 1: Creating New Database Tables and Fields..... Complete
Stage 2: Entering default values for new fields..... Complete
Stage 3: Migrating forum configuration settings to new format..... Complete
Stage 4: Migrate Post Count to new Point System (this may take some time to complete)..... Complete
|
|
