Web Wiz Support and Community Forums : Upgrading from 7.01 to 7.92 Problem https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 22:05:10 +0000 Fri, 26 Aug 2005 14:42:31 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=16330 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Upgrading from 7.01 to 7.92 Problem : Solved it! - It was completely...]]> https://forums.webwiz.net/upgrading-from-7-01-to-7-92-problem_topic16330_post89448.html#89448 Author: jglasson
Subject: 16330
Posted: 26 August 2005 at 2:42pm

Solved it! - It was completely based on my stupidity..!

Now I just need to figured out how to get all my categories and forums back after being hacked...   :(

Thanks,
J.
]]> Fri, 26 Aug 2005 14:42:31 +0000 https://forums.webwiz.net/upgrading-from-7-01-to-7-92-problem_topic16330_post89448.html#89448 <![CDATA[Upgrading from 7.01 to 7.92 Problem : Not sure if this will help as...]]> https://forums.webwiz.net/upgrading-from-7-01-to-7-92-problem_topic16330_post89446.html#89446 Author: jglasson
Subject: 16330
Posted: 26 August 2005 at 1:57pm

Not sure if this will help as well...here is the code...
Line 133 is the execution of SELECT - see below

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
'Read the various categories from the database
'Initalise the strSQL variable with an SQL statement to query the database
If strDatabaseType = "SQLServer" Then
    strSQL = "EXECUTE " & strDbProc & "CategoryAll"
Else
    strSQL = "SELECT " & strDbTable &"Category.Cat_name, " & strDbTable & "Category.Cat_ID FROM "& strDbTable & "Category ORDER BY " & strDbTable &"Category.Cat_order ASC;"
End If

'Query the database
rsCategory.Open strSQL, adoCon
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Thanks,
Jeff
]]> Fri, 26 Aug 2005 13:57:38 +0000 https://forums.webwiz.net/upgrading-from-7-01-to-7-92-problem_topic16330_post89446.html#89446 <![CDATA[Upgrading from 7.01 to 7.92 Problem : Check the change log in the install...]]> https://forums.webwiz.net/upgrading-from-7-01-to-7-92-problem_topic16330_post89394.html#89394 Author: dpyers
Subject: 16330
Posted: 25 August 2005 at 9:20pm

Check the change log in the install readme. ISTRC that there was a db change around 7.5]]> Thu, 25 Aug 2005 21:20:27 +0000 https://forums.webwiz.net/upgrading-from-7-01-to-7-92-problem_topic16330_post89394.html#89394 <![CDATA[Upgrading from 7.01 to 7.92 Problem : Hello, I&#039;m attempting...]]> https://forums.webwiz.net/upgrading-from-7-01-to-7-92-problem_topic16330_post89353.html#89353 Author: jglasson
Subject: 16330
Posted: 25 August 2005 at 1:04pm

Hello,

I'm attempting to upgrade from 7.01 to 7.92 and when I copy my MDB overto my staging area and modify the common.asp file, I get the followingerror:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[Microsoft][ODBC Microsoft Access Driver]The Microsoft Jet database engine cannot find the input table or query'tblCategory'. Make sure it exists and that its name is spelledcorrectly.

/forum/default.asp, line 133

Is there a DB conversion that needs to take place or something..?

Thanks,
Jeffrey



]]> Thu, 25 Aug 2005 13:04:42 +0000 https://forums.webwiz.net/upgrading-from-7-01-to-7-92-problem_topic16330_post89353.html#89353