Web Wiz Forums - Problem when changing a forum as a subforum

Print Page | Close Window

Problem when changing a forum as a subforum

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=18041
Printed Date: 13 April 2026 at 4:32pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Problem when changing a forum as a subforum

Posted By: doronty37
Subject: Problem when changing a forum as a subforum
Date Posted: 19 January 2006 at 11:34am

All of this bugs are in MySQL version. i didn't try other versions..

Page: admin_change_to_subforum.asp
Bug: When one tries to change a forum as subforum, all forums in that category change as subforum. For example:

Category 1

Forum 1
Forum 2

Category 2

Forum 3
Forum 4

When i try to make forum 1 a subforum of forum 3, forum 2 also changes as forum 3's sub forum.

------------------------

Page: admin_forum_details.asp
Bug: When trying to edit details of a forum, getting an error message that says update failured because no rows found to update.

--------------------------

Page: search_process.asp (Line 610), active_topics.asp (Line 273), pre_approved_topics.asp (Line 310)
Bug report: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT tblPermissions.Forum_ID FROM tblPermissions WHERE (tblP

i didn't created any permissions.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 19 January 2006 at 11:46am

Many thanks for all of these.

I did find the sub forum problem the other day when testing in mySQL and have fixed this issue.

I'll have to look into the admin_forum_details.asp problem, but I'm sure it worked when I tried.

The errors you get on the active_topics.asp, search_topics.etc will be because you are using a version on mySQL prior to version 4.1

You need to use mySQL 4.1+ for Web Wiz Forums as older versions of mySQL doesn't support sub queries.

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