Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Database error when upgrading to v10
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Database error when upgrading to v10

 Post Reply Post Reply
Author
Pilsener View Drop Down
Groupie
Groupie


Joined: 20 May 2006
Status: Offline
Points: 123
Post Options Post Options   Thanks (0) Thanks(0)   Quote Pilsener Quote  Post ReplyReply Direct Link To This Post Topic: Database error when upgrading to v10
    Posted: 01 July 2011 at 5:13pm
I was trying to upgrade to v10, but I get thiese errors (link to screenshot): http://www.gjelberg.no/miscpics/databasefailure.jpg

I think the errors occured when I upscaled from Access to MSSQL a while ago.
However, the database worked well with v9, so I didn't notice any problems.
After this failed upgrade to v10, the whole forum is unaccessible.

Any ideas on how to fix this ?




Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 01 July 2011 at 5:34pm
The upgrade wizard is not able to upgrade your database the error is:-

Cannot find the object "table-name" because it does not exist or you do not have permissions.

The error is saying that the table does not exist or you do not have permission to modify the tables in the database.

Make sure that you are connecting to the correct database and that the user you are connecting to the database with has DBO (database owner) permissions on that database to be able modify the database schema.
Back to Top
Pilsener View Drop Down
Groupie
Groupie


Joined: 20 May 2006
Status: Offline
Points: 123
Post Options Post Options   Thanks (1) Thanks(1)   Quote Pilsener Quote  Post ReplyReply Direct Link To This Post Posted: 01 July 2011 at 7:26pm
Nice.
Now it works.

But there is one thing:
The tables had been created with different owners when I created the database at the hosting company.
This caused the upgrade wizard in WW v10 to modify only the tables where it had permissions, leaving the other tables unchanged, which in turn led to a corrupted database.
I had to restore a backup and run it all over again to get it right.

Maybe the upgrade wizard should have some kind of test-mode to prevent this ?

Back to Top
msnahm View Drop Down
Groupie
Groupie


Joined: 27 January 2009
Status: Offline
Points: 41
Post Options Post Options   Thanks (0) Thanks(0)   Quote msnahm Quote  Post ReplyReply Direct Link To This Post Posted: 03 July 2011 at 7:13pm
I get following error after upgrading from WW9.x to 10.01, when I want to insert new post or topic:

Server Error in Forum Application
An error has occurred while writing to the database.
Please contact the Forum Administrator.

Support Error Code:- err_SQLServer_save_new_post_data
File Name:- new_post.asp
Forum Version:- 10.01


Editing of the ports don't have any error and I can edit them successfully.


Edited by msnahm - 03 July 2011 at 7:31pm
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 04 July 2011 at 10:05am
Please start a new topic on your issue as your issue is not related Pilsener's issue.

If you have a new issue then you should always start a new topic instead of posting in existing topic which quite often is unrelated to your own issue.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.