https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 11:47:00 +0000 Sat, 17 Jun 2006 15:29:45 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20258 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109223.html#109223 Author: Flyman30
Subject: 20258
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
]]> Sat, 17 Jun 2006 15:29:45 +0000 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109223.html#109223 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109220.html#109220 Author: WebWiz-Bruce
Subject: 20258
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.
]]> Sat, 17 Jun 2006 11:26:19 +0000 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109220.html#109220 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109215.html#109215 Author: Flyman30
Subject: 20258
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  

strSQL = "" & _ "SELECT " & strDbTable & "Category.Cat_ID, " & strDbTable & "Category.Cat_name, " & strDbTable & "Forum.Forum_ID, " & strDbTable & "Forum.Sub_ID, " & strDbTable & "Forum.Forum_name, " & strDbTable & "Forum.Forum_description, " & strDbTable & "Forum.No_of_topics, " & strDbTable & "Forum.No_of_posts, " & strDbTable & "Author.Username, " & strDbTable & "Forum.Last_post_author_ID, " & strDbTable & "Forum.Last_post_date, " & strDbTable & "Forum.Password, " & strDbTable & "Forum.Locked, " & strDbTable & "Forum.Hide, " & strDbTable & "Permissions.View_Forum " & _ "FROM " & strDbTable & "Category" & strDBNoLock & ", " & strDbTable & "Forum" & strDBNoLock & ", " & strDbTable & "Permissions" & strDBNoLock & ", " & strDbTable & "Author" & strDBNoLock & " " & _ "WHERE " & strDbTable & "Category.Cat_ID = " & strDbTable & "Forum.Cat_ID " & _     "AND " & strDbTable & "Forum.Forum_ID = " & strDbTable & "Permissions.Forum_ID " & _     "AND " & strDbTable & "Forum.Last_post_author_ID = " & strDbTable & "Author.Author_ID " & _     "AND (" & strDbTable & "Permissions.Author_ID = " & lngLoggedInUserID & " OR " & strDbTable & "Permissions.Group_ID = " & intGroupID & ") " & _ "ORDER BY " & strDbTable & "Category.Cat_order, " & strDbTable & "Forum.Forum_Order, " & strDbTable & "Permissions.Author_ID DESC;"

 
When I delete this line:

"AND " & strDbTable & "Forum.Last_post_author_ID = " & strDbTable & "Author.Author_ID " & _

The new forum appears, that gives you  a track to find a solution? 
]]> Sat, 17 Jun 2006 09:01:10 +0000 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109215.html#109215 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109052.html#109052 Author: WebWiz-Bruce
Subject: 20258
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.


Edited by -boRg- - 14 June 2006 at 9:15pm]]> Wed, 14 Jun 2006 21:12:07 +0000 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109052.html#109052 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109047.html#109047 Author: Flyman30
Subject: 20258
Posted: 14 June 2006 at 7:51pm

-boRg- wrote: 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.

I know that, and I do, it still not appears
]]> Wed, 14 Jun 2006 19:51:25 +0000 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109047.html#109047 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109043.html#109043 Author: WebWiz-Bruce
Subject: 20258
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.
]]> Wed, 14 Jun 2006 19:20:49 +0000 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109043.html#109043 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109036.html#109036 Author: Flyman30
Subject: 20258
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.

]]> Wed, 14 Jun 2006 17:26:49 +0000 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post109036.html#109036 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post108965.html#108965 Author: WebWiz-Bruce
Subject: 20258
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.


Edited by -boRg- - 13 June 2006 at 8:13am]]> Tue, 13 Jun 2006 08:11:14 +0000 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post108965.html#108965 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post108932.html#108932 Author: Flyman30
Subject: 20258
Posted: 12 June 2006 at 5:48pm

-boRg- wrote: 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.

But How can I add something until I don't see them ???

I mean Bricolages category for exemple
]]> Mon, 12 Jun 2006 17:48:49 +0000 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post108932.html#108932 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post108927.html#108927 Author: WebWiz-Bruce
Subject: 20258
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.
]]> Mon, 12 Jun 2006 15:05:51 +0000 https://forums.webwiz.net/problem-to-add-new-forum_topic20258_post108927.html#108927