Upgrade tool problem
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=24307
Printed Date: 06 April 2026 at 5:35pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Upgrade tool problem
Posted By: maxim
Subject: Upgrade tool problem
Date Posted: 31 August 2007 at 2:23pm
I backed up the SQL DB for ver 8 and i tried running the upgrade tool. This is the error that I get. What could be the problem?
Thanks
Database Updated Started
Stage 1: Database Connection..... Complete
Stage 2: Creating New Database Tables and Fields.....
Error Altering the Table tblGroup
Cannot alter table 'DBO.tblAuthor' because this table does not exist in database 'forumver9'.
Error Altering the Table tblForum
Cannot alter table 'DBO.tblForum' because this table does not exist in database 'forumver9'.
Error Altering the Table tblTopic
Cannot alter table 'DBO.tblTopic' because this table does not exist in database 'forumver9'.
Error Altering the Table tblGroup
Cannot alter table 'DBO.tblGroup' because this table does not exist in database 'forumver9'.
Error Altering the Table tblConfiguration
Cannot alter table 'DBO.tblConfiguration' because this table does not exist in database 'forumver9'.
Complete
Stage 3: Entering default values for new fields.....
Error entering default values in the Table tblConfiguration
Invalid object name 'tblGroup'.
Error entering default values in the Table tblConfiguration
Invalid object name 'tblConfiguration'.
Complete
Error Discription: Invalid object name 'tblConfiguration'.
Web Wiz Forums database is set up, but with Error!
|
Replies:
Posted By: dj air
Date Posted: 31 August 2007 at 2:30pm
restart the process, make sure you have the correct dbo account, it maybe your login username that you require.
the tool works as i have used it, it maybe just that
|
Posted By: WebWiz-Bruce
Date Posted: 31 August 2007 at 3:02pm
Make sure you are also connecting to the correct database and you have not changed the table prefix 'tbl' to something different as the error suggests that the tables can not be found in the database.
-------------
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: maxim
Date Posted: 31 August 2007 at 3:09pm
|
I just talked to support for my host, and it seems like the new DB is 2005, while the ver8 DB is 2000. They are about to fix that. I'll try again and I will let you know....txn...
|
Posted By: maxim
Date Posted: 01 September 2007 at 3:23pm
Quick question. After I get this error is DB unchanged or did the tool make some changes that I do not know about?
Tech support for my server made a copy of a DB and I tried to run the update tool on it again, but no luck. I do not remmember making any changes to the original DB (tables etc.), so what can be a problem?
|
Posted By: dj air
Date Posted: 01 September 2007 at 3:29pm
i belive some work has been done on the system what amount is not clear, you are best to revert back to an old backed up copy done before anything was done on the upgrade tool.
failing that, please feel free to email my sales team (sales {at} emaginehosts {dot} com for a quote "$20" and one of my techs or me can help ypou though the upgrade as i alone have done some. also feel free to contact me via MSN if required.
|
|