Web Wiz Support and Community Forums : Active Topics not working

Web Wiz Support and Community Forums : Active Topics not working https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 03 Apr 2026 21:37:43 +0000 Mon, 25 Feb 2008 12:23:13 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24720 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Active Topics not working : Sorry missed out the 'not'...]]> https://forums.webwiz.net/active-topics-not-working_topic24720_post131586.html#131586 Author: WebWiz-Bruce
Subject: 24720
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.
]]> Mon, 25 Feb 2008 12:23:13 +0000 https://forums.webwiz.net/active-topics-not-working_topic24720_post131586.html#131586 <![CDATA[Active Topics not working : WebWiz-Bruce wrote:Access to...]]> https://forums.webwiz.net/active-topics-not-working_topic24720_post131585.html#131585 Author: Nick-V
Subject: 24720
Posted: 25 February 2008 at 12:01pm

WebWiz-Bruce wrote:

Access to mySQL is recommended as the database schema are very different.

Is or is not?

]]> Mon, 25 Feb 2008 12:01:47 +0000 https://forums.webwiz.net/active-topics-not-working_topic24720_post131585.html#131585 <![CDATA[Active Topics not working : Access to mySQL is not recommended...]]> https://forums.webwiz.net/active-topics-not-working_topic24720_post131581.html#131581 Author: WebWiz-Bruce
Subject: 24720
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 www.webwiz.net/webhosting

Edited by WebWiz-Bruce - 25 February 2008 at 12:21pm]]> Mon, 25 Feb 2008 09:42:08 +0000 https://forums.webwiz.net/active-topics-not-working_topic24720_post131581.html#131581 <![CDATA[Active Topics not working : stonecutter, which tool did you...]]> https://forums.webwiz.net/active-topics-not-working_topic24720_post131577.html#131577 Author: kcsheets
Subject: 24720
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

]]> Mon, 25 Feb 2008 02:18:05 +0000 https://forums.webwiz.net/active-topics-not-working_topic24720_post131577.html#131577 <![CDATA[Active Topics not working : I changed the syntax in the database...]]> https://forums.webwiz.net/active-topics-not-working_topic24720_post128869.html#128869 Author: stonecutter
Subject: 24720
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.

]]> Thu, 01 Nov 2007 04:00:15 +0000 https://forums.webwiz.net/active-topics-not-working_topic24720_post128869.html#128869 <![CDATA[Active Topics not working : There is no obvious reason why...]]> https://forums.webwiz.net/active-topics-not-working_topic24720_post128839.html#128839 Author: WebWiz-Bruce
Subject: 24720
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.]]> Wed, 31 Oct 2007 08:09:12 +0000 https://forums.webwiz.net/active-topics-not-working_topic24720_post128839.html#128839 <![CDATA[Active Topics not working : I upgraded to version 9 and also...]]> https://forums.webwiz.net/active-topics-not-working_topic24720_post128823.html#128823 Author: stonecutter
Subject: 24720
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

]]> Tue, 30 Oct 2007 21:10:30 +0000 https://forums.webwiz.net/active-topics-not-working_topic24720_post128823.html#128823