| Author |
 Topic Search  Topic Options
|
MortiOli 
Senior Member
Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Upgrade Errors
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
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
MortiOli
Senior Member
Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
|
Post Options
Thanks(0)
Quote Reply
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?
Edited by MortiOli - 17 May 2006 at 8:28pm
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
MortiOli
Senior Member
Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
|
Post Options
Thanks(0)
Quote Reply
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.
Edited by MortiOli - 17 May 2006 at 8:37pm
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
MortiOli
Senior Member
Joined: 26 May 2002
Location: United Kingdom
Status: Offline
Points: 514
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
