| Author |
 Topic Search  Topic Options
|
CavComm 
Newbie
Joined: 28 April 2010
Status: Offline
Points: 25
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Trying to upgrade - Problems...
Posted: 28 April 2010 at 2:24am |
Looking for some help. I am trying to upgrade a 7.9 database (might have been free license) to a new 9.68 in SQL. I have imported the database into a new SQL instance, DBO is set - it connects just fine.. and I get through to the 4th piece of the upgrade, and it sits for a bit, and says
Variable Undefined
And that the upgrade was performed with errors!
Ok.. so then I go to the forum - no topics, no categories being displayed - but when logging into the admin, I can see them..
Anyone else have this issue?
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 April 2010 at 8:26am |
|
you can ignore that part for 'Variable Undefined' this is an error in the upgrader that can be ignored as it does not do anything of any importance.
It sounds like your forum was upgraded fine, but your settings are probably incorrect. In the admin area make sure that all your forums and categories have a correct order set in the forum admin page. They all need to have a correct order number to display correctly.
Also check the permissions for each forum as a new groups and permissions system was introduced in version 8.
|
|
|
|
CavComm
Newbie
Joined: 28 April 2010
Status: Offline
Points: 25
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 April 2010 at 12:30pm |
Well - I see what you are saying - basically no one has access at ths point to an forum. That being said - when I try to add group permissions I get this:
Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert the value NULL into column 'Author_ID', table 'sql_cpforum.dbo.tblPermissions'; column does not allow nulls. INSERT fails.
|
|
CavComm
Newbie
Joined: 28 April 2010
Status: Offline
Points: 25
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 April 2010 at 12:34pm |
I also get this on an individual user..
Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert the value NULL into column 'Group_ID', table 'sql_cpforum.dbo.tblPermissions'; column does not allow nulls. INSERT fails.
|
|
CavComm
Newbie
Joined: 28 April 2010
Status: Offline
Points: 25
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 April 2010 at 1:14pm |
It's very strange - I see them all on the back-end - they are all ordered properly, and I even moved a user into a group that should see them all, yet on the front page, none display at all.
I can seem to move users into other groups membership, but I can modify users by hand, or groups by hand as I get the above errors.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 April 2010 at 1:20pm |
|
It sounds like your database has lost allot of it's schema such as default values.
You mention in your first post that you imported the SQL Server database. If your database has lost allot of it's schema in this way I would put money on it that you used SQL Server Studio Manger to do the import?
SQL Server Studio Manager can not be used for import/export as it is useless as you will lose default values, primary keys, relationships, constraints, etc. Instead you need to create a backup of the database (.bak file) which can then be used to restore the database to another SQL Server without losing important parts of the database.
If you move your old version 7.x database again in the way I describe, then run the update again you should find that your database will run as expected.
|
|
|
|
CavComm
Newbie
Joined: 28 April 2010
Status: Offline
Points: 25
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 April 2010 at 1:24pm |
I think that's exactly what happened - BUT - when I tried to import using the .BAK - it failed - so I did it the way you describe... Could be because I am going from 2000 to 2005? Any suggestions on restorin a .BAK in 2000 to a 2005 database?
|
|
CavComm
Newbie
Joined: 28 April 2010
Status: Offline
Points: 25
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 April 2010 at 3:09pm |
To add on to above, I am getting the "data is malformed" error.
|
|
