Web Wiz Forums - Access to MySQl upgrade freezing

Print Page | Close Window

Access to MySQl upgrade freezing

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=22550
Printed Date: 08 April 2026 at 6:34am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access to MySQl upgrade freezing

Posted By: tonyc
Subject: Access to MySQl upgrade freezing
Date Posted: 29 January 2007 at 12:46pm

Hi Guys,

I upgraded my Access V7 db to V8 then exported the data into MySQL, all was fine on my localhost.

Logged on and forums showed up correctly but when I click on a forum, the localhost goes into overdrive and freezes the computer, like as if a never ending loop is processing. Everything else works fine, like the admin or going directly to the last post and such. Just that "forum_topics.asp" page is the problem.

There are around 7000 posts in the DB so dont think it should affect it.

Cheers

Replies:

Posted By: dj air
Date Posted: 29 January 2007 at 1:23pm

make sure to do a forum sync from the admin area.

it sounds like a corruption read on the id fields also

Posted By: tonyc
Date Posted: 29 January 2007 at 2:05pm

Same result.

Thanks

Posted By: WebWiz-Bruce
Date Posted: 29 January 2007 at 7:39pm

It is not possible to upgrade from version 7 Access to version 8 Access then convert to mySQL.

There are to many tables names that are incompatible with mySQL if you use that method.

-------------
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: MrMellie
Date Posted: 29 January 2007 at 9:51pm

What method should be used then? MySQL is on my shortlist of backends to use when I convert.