Active Topics not working
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=24720
Printed Date: 03 April 2026 at 9:35pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Active Topics not working
Posted By: stonecutter
Subject: Active Topics not working
Date Posted: 30 October 2007 at 9:10pm
|
I upgraded to version 9 and also converted from the Access2000 version to the MySql version. There were a few bugs to iron out afterwards, but the conversion went well. However the Active Topics feature does not work. It says there are no active topics. I'm not getting any error messages and everything else seems to be working fine. Any suggestions? http://forum.mastermason.com - http://forum.mastermason.com |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 31 October 2007 at 8:09am
|
There is no obvious reason why it wouldn't work, but dates are handled differently in mySQL to other databases, so I would check that the date fields in the database are set to the datetime datatype.
------------- 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: stonecutter
Date Posted: 01 November 2007 at 4:00am
|
I changed the syntax in the database from '0000-00-00 00:00:00' to '00-00-0000 00:00:00' and also changed the forum preference from yy to yyyy. Whichever one did it, the active topics work now. Thanks. My users are whistling zippity-dooda again. |
Posted By: kcsheets
Date Posted: 25 February 2008 at 2:18am
|
stonecutter, which tool did you use to convert from Access to MySQL. I'm trying to go from access v.7 to MySql v.9. I've done the converstion from access 7 to 9 but now I don't know what to do.
My hosting service provides 1 free mySQL database buy I would have to pay extra for MS SQLServer, which I don't want to do.
TIA
|
Posted By: WebWiz-Bruce
Date Posted: 25 February 2008 at 9:42am
|
Access to mySQL is not recommended as the database schema are very different. Access to SQL Server is very easy and the upsize tool in Access should take care of the job for you. If your web hosts charges to much for SQL Server you should have a look at our own Hosting Packages starting from £4.99 per month and including SQL Server, and the Premium Edition of Web Wiz Forums installed for free. We can even take your Access database and upsize it to SQL Server for you and upgrade it to version 9. For more info please see http://www.webwiz.net/webhosting - www.webwiz.net/webhosting ------------- 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: Nick-V
Date Posted: 25 February 2008 at 12:01pm
Is or is not?
|
WebWiz-Bruce wrote:Posted By: WebWiz-Bruce
Date Posted: 25 February 2008 at 12:23pm
|
Sorry missed out the 'not' part. It can be done as people have managed to do it, but I also see allot of people who report unstable forums after migrating the database from Access or SQL Server to mySQL. ------------- 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 |