problem to add new forum
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=20258
Printed Date: 11 April 2026 at 1:20pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: problem to add new forum
Posted By: Flyman30
Subject: problem to add new forum
Date Posted: 10 June 2006 at 4:41pm
|
I had a forum version 7, with access base. I upgraded to version 8, with mssql base and that works. when I want to add a forum or a category, it appears in administation part, but not in the public part. Have you any ideas how to solve the problem?. |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 12 June 2006 at 8:19am
|
Do you get any errors when adding a new forum? A couple of things you could try:- Re-upload files incase you have a corrupted file Try setting group permissions on the forum If these fail, it could be that you have not successfully re-created the database on the SQL Server. ------------- 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: Flyman30
Date Posted: 12 June 2006 at 12:28pm
Not at all the new forum is created, but do not appears in a public part of forum  |
-boRg- wrote:Posted By: WebWiz-Bruce
Date Posted: 12 June 2006 at 3:05pm
|
I had a look at your forum with the details that you gave me and all your forums appeared fine in the list. New categories will not appear until you add and forum to them. ------------- 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: Flyman30
Date Posted: 12 June 2006 at 5:48pm
But How can I add something until I don't see them ???  I mean Bricolages category for exemple |
Posted By: WebWiz-Bruce
Date Posted: 13 June 2006 at 8:11am
|
Categories will appear as soon as you place a forum inside of them that is not set to 'hide' if members don't have permission to view that forum. Try creating a new category, then place a forum in that category that all members have access to, the forum and category will then display in the main forum. If the forum fails to show after you do this, then your database has not be setup correctly and default values for the forum are not being setup correctly. ------------- 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: Flyman30
Date Posted: 14 June 2006 at 5:26pm
|
I start with the access forum version 7.95, the new category appears for the users . I am trying to upload the version 8.02 with your upgrade tool, but when I try to add a new category it doesn't appear for the users. I have tried three times, but I have the same problem each time. It seems to be a problem with the upgrade tool, can you help me with this problem? I have changed my base access to SQL server, but I still have the same problem. |
Posted By: WebWiz-Bruce
Date Posted: 14 June 2006 at 7:20pm
|
The best thing to do is add the new category after upgrading to version 8, not before. The new category will display, but only after you add a forum in that category. ------------- 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: Flyman30
Date Posted: 14 June 2006 at 7:51pm
I know that, and I do, it still not appears  |
Posted By: WebWiz-Bruce
Date Posted: 14 June 2006 at 9:12pm
|
It sounds then that your database is not created correctly when you upsized it from Access, and as I mentioned before (looking back through the posts) the database is not setting the default values. This means that in tblForum the default value for Last_post_author_ID is not being set as 1 and the Last_post_date as GetDate() If the default values for these fields have not been set then I imagine your entire forum will be the same and you will get other issues. You will need to go back and do the upsize from Access again, this time making sure that all default values are created on the SQL Server database. ------------- 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: Flyman30
Date Posted: 17 June 2006 at 9:01am
|
Ok the default values are good in the tables I found where is located the problem, but not yet the solution! In this SELECT located in the file default.asp
When I delete this line:
The new forum appears, that gives you a track to find a solution? |
Posted By: WebWiz-Bruce
Date Posted: 17 June 2006 at 11:26am
|
This SQL works, but only if default values are set correctly. When you create a new forum the default value of 1 (for Administrator) account needs to be placed in the column Last_post_author_ID, and in the column Last_post_date needs to have the present time and date using the default value getDate() Once these default values are set correctly in tblForum then new forums will appear without any problem when created in the admin area. ------------- 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: Flyman30
Date Posted: 17 June 2006 at 3:29pm
Find it with our help  In fact the default value (for administrator) is 3 in my database ! So I change this value in admin_forum_details.asp and that OK. Users can see the new forum  |