Web Wiz Forums - Upgrade Errors

Print Page | Close Window

Upgrade Errors

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=19917
Printed Date: 11 April 2026 at 10:39pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Upgrade Errors

Posted By: MortiOli
Subject: Upgrade Errors
Date Posted: 17 May 2006 at 2:01pm

Hi all,

I've just upgraded from v7 to v8, but received some errors on update;

Database Updated Started

Stage 1: Database Connection..... Complete

Stage 2: Creating New Database Tables and Fields.....
Error Dropping Contraints in Table tblPermissions
The object 'DF_tblPermissions_Read' is dependent on column 'Read'.

Complete

Stage 3: Creating Index's on database.....
Error Creating one or more Index's
There is already an index on table 'tblSession' named 'Session_ID'.

Complete

Stage 4: Entering default values for new fields..... Complete

Stage 5: Populating Database with Default Forum Permissions (this may take some time to complete).....
Permissions are reset to original defaults, you may need to update them once the upgrade is complete.
Complete

Stage 6: Populating Database with Forum Statistics (this may take some time to complete).....Complete

Stage 7: Populating Database with Topic Statistics (this may take some time to complete)..... Complete

Error Discription: There is already an index on table 'tblSession' named 'Session_ID'.
SQL Server database is set up, but with Error!

Could someone advise on whether this will affect my forum etc, and if so, how do I fix it?

Also, my admin username used to be 3 letters in size, and now it looks like it's had an effect on logging in - just doesn't let me login to the admin section.

Thanks

Replies:

Posted By: WebWiz-Bruce
Date Posted: 17 May 2006 at 4:30pm

Not sure why you got any of these errors, but they should not prevent your forum from running correctly.

The only one you may want to do yourself, is to manually delete the column 'Read' from tblPermissions table in the database, but not doing this will not effect the running of your forum.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: MortiOli
Date Posted: 17 May 2006 at 5:19pm

Ok, I'll do that once I'm home.

�

Any ideas on the admin username?� I think it's my fault, because I changed the admin name change on v7, to accept a 3 letter name.� I suppose I could just edit the DB to be a 4 letter name, but not sure how to do it through Enterprise Manager.

�

Btw, I'm using MSSQL, if that helps the above errors.

EDIT - I've renamed the admin login, but still no luck logging in. I notice that there's no 'salt' records for any user. Could this be the problem?

Posted By: WebWiz-Bruce
Date Posted: 17 May 2006 at 8:33pm

Are you using a modified version 7 and database?

The reason why I ask is that the database upgrade shouldn't effect the username, password, or salt fields which should remain the same as in version 7.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: MortiOli
Date Posted: 17 May 2006 at 8:35pm

No, it's a standard 7 install and database, which I've upgraded (or tried to upgrade) to 8 today.

EDIT - I wouldn't mind PMing you the database connection information, if you wouldn't mind taking a look for me? No worries if not.

Posted By: WebWiz-Bruce
Date Posted: 18 May 2006 at 9:56am

It seems your SQL server may have some strange unusual settings that are coursing issues. What they would be would be beyond me as I am not a SQL server admin.

The only thing I can suggest is that you go back to your version 7 backup database, make sure all the settings on the server are standard and you have password, salt, etc. values for users, then run the upgrade tool again.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: MortiOli
Date Posted: 18 May 2006 at 1:28pm

I clicked forgot password for my admin account, and a new password was emailed to me. This created a salt value, and I could login fine.

As long as the above works, that means members just have to request a new password, which is fine - unless you know a way of forcing a new password to be emailed to everyone?

What's weird, is that only a handful of members still have a salt value against their names.

Posted By: WebWiz-Bruce
Date Posted: 18 May 2006 at 2:08pm

This is really strange, there is nothing that should effect the password and salt fields in the database, so why these fields have become blank is a complete mystery.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting