Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Help needed with upgrading.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Help needed with upgrading.

 Post Reply Post Reply
Author
zadax View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 19 January 2003
Location: Israel
Status: Offline
Points: 433
Post Options Post Options   Thanks (0) Thanks(0)   Quote zadax Quote  Post ReplyReply Direct Link To This Post Topic: Help needed with upgrading.
    Posted: 16 July 2008 at 10:32pm
using 7.x ver
want to upgrade to 8.x or 9.x
tried the upgrade tool at the 9.x zip file .

aftar 40 min (big forum with over 20k members)
i got those errors:

Error Updating the Table tblForum
Cannot alter table 'zadaxbb.tblForum' because this table does not exist in database 'zadaxb'.

Error Updating the Table tblTopic
Cannot alter table 'zadaxbb.tblTopic' because this table does not exist in database 'zadaxb'.


Error Update the Table tblThread
Cannot alter table 'zadaxbb.tblThread' because this table does not exist in database 'zadaxb'.


Error Updating the Table tblPermissions
Cannot alter table 'zadaxbb.tblPermissions' because this table does not exist in database 'zadaxb'.


Error Dropping Contraints in Table tblPermissions
Cannot alter table 'zadaxbb.tblPermissions' because this table does not exist in database 'zadaxb'.


Error Altering the Table tblAuthor
Cannot alter table 'zadaxbb.tblAuthor' because this table does not exist in database 'zadaxb'.


Error Altering the Table tblConfiguration
Cannot alter table 'zadaxbb.tblConfiguration' because this table does not exist in database 'zadaxb'.


Error Altering the Table tblDateTimeFormat
Cannot alter table 'zadaxbb.tblDateTimeFormat' because this table does not exist in database 'zadaxb'.


Error Altering the Table tblGroup
Cannot alter table 'zadaxbb.tblGroup' because this table does not exist in database 'zadaxb'.


Error Creating one or more Index's
Cannot create an index on 'tblSession', because this table does not exist in database 'zadaxb'.

Stage 4: Entering default values for new fields.....
Error entering default values in the Table tblForum
Invalid column name 'Sub_ID'.


Error entering default values in the Table tblAuthor
Invalid column name 'No_of_PM'.


Error entering default values in the Table tblDateTimeFormat
Invalid column name 'Time_offset'.


Error entering default values in the Table tblConfiguration
Invalid column name 'Topic_icon'.


Error entering default values in the Table tblConfiguration
Invalid column name 'Image_uploads'.


the prefix wes good .. tbl and still gettin that erorr..
any help ?

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: 17 July 2008 at 8:38am
Hopefully you didn't try this on your live db or you backed it up first as you need to go back to the original.

Looking at the errors either you are connecting to the wrong database or the zadaxbb isn't the database schema owner and so doesn't have permission to alter the table.

Try using DBO as the database
schema owner and see if that works.
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.