| Author |
 Topic  |
|
|
MJFarmgirl
Starting Member
USA
39 Posts |
 Posted - 08 July 2013 : 20:56:19
|
Is it bad if Update Counts fails?
I have a case of the kind of forum where nothing's been archived, ever, and I'm not allowed to. So it has and has had issues running slowly.
I have a forum that is both a new forum on a new site, and, initially, a test guinea pig for updating our original forum from 3.4.05 to 3.4.07.
The test/new forum is using a copy of the original's database for testing purposes, to see how updating should go with the original.
Since the instructions say to run Update Counts after upgrading the database, I'm trying to do that. Initially, the page ran a long while on Step 1, and I stopped it. It ran again today (unintentionally; testing the "Zap" feature, and incidentally the delete all topics by user), and got to step 3, before failing (lots of periods on-screen). That made me hopeful, so I tried running it again, starting at step 3 (same URL it was already on, with comeback=etc). Now that it failed again, I can't get my site to load at all.
I'm assuming something is stuck in SQL Server. Seeing what I can see or what I need to find out to release it.
So, is this bad for the database or the data in it?
Fortunately, it won't matter on this one, since I was going to clear out most of the data before using it.
Sounds like I can mostly just ignore using Update Counts on my original forum, esp if this is going to have a high chance of failure.
Also ... I can't find any independent SQL scripts for running this directly in SQL Server as suggested on another topic. ???
I was considering outputting all SQL from admin_count.asp, and modifying it to run directly via SQL Mgmt Studio ... |
Farmgirl Connection
MaryJanesFarm |
|
|
MJFarmgirl
Starting Member
USA
39 Posts |
Posted - 08 July 2013 : 21:40:00
|
| Whatever was stuck has freed up now. That's good. Site runs "normally", i.e. as well as before. |
 |
|
|
MJFarmgirl
Starting Member
USA
39 Posts |
Posted - 10 July 2013 : 22:03:05
|
I did copy the "Incorrect syntax near '000.000.000.000'." part of the error on the computer I ran setup.asp from.
And since I know they were all related to fields that included _IP as part of their name and were trying to be set to nvarchar(50), I checked setup.asp and found all matching references; checked those columns in the database - they were all set to nvarchar(15) still; so, I manually changed them all to nvarchar(50).
And, beyond that, I'm just assuming the default (whatever it may be) won't matter, and all's good. |
Farmgirl Connection
MaryJanesFarm |
Edited by - MJFarmgirl on 10 July 2013 22:21:27 |
|
|
| |
Topic |
|
|
|
