Web Wiz Forums - Trying to upgrade

Print Page | Close Window

Trying to upgrade - Problems...

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=28549
Printed Date: 01 April 2026 at 11:09pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Trying to upgrade - Problems...

Posted By: CavComm
Subject: Trying to upgrade - Problems...
Date 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?

Replies:

Posted By: WebWiz-Bruce
Date 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.

-------------
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: CavComm
Date 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.

Posted By: CavComm
Date 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.

Posted By: CavComm
Date 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.

Posted By: WebWiz-Bruce
Date 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.

-------------
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: CavComm
Date 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?

Posted By: CavComm
Date Posted: 28 April 2010 at 3:09pm

To add on to above, I am getting the "data is malformed" error.

Posted By: WebWiz-Bruce
Date Posted: 29 April 2010 at 8:54am

You should be able to restore a backup to any same or newer version of SQL Server, so SQL Server 2000 to 2005 should not be a problem. Although with SQL Server 2008 R2 version just released I would recommend going straight to SQL Server 2008 R2.

Make sure that the database set to simple recovery and shrink the database before the backup and see if that helps.

-------------
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