| Author |
 Topic Search  Topic Options
|
maxim 
Newbie
Joined: 05 September 2003
Location: United States
Status: Offline
Points: 22
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Upgrade tool problem
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!
|
 |
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
maxim
Newbie
Joined: 05 September 2003
Location: United States
Status: Offline
Points: 22
|
Post Options
Thanks(0)
Quote Reply
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...
|
|
maxim
Newbie
Joined: 05 September 2003
Location: United States
Status: Offline
Points: 22
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
