| Author |
 Topic Search  Topic Options
|
Flyman30 
Groupie
Joined: 09 December 2004
Location: France
Status: Offline
Points: 99
|
 Post Options
 Thanks(0)
 Quote  Reply
 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 
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
Flyman30
Groupie
Joined: 09 December 2004
Location: France
Status: Offline
Points: 99
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
Flyman30
Groupie
Joined: 09 December 2004
Location: France
Status: Offline
Points: 99
|
Post Options
Thanks(0)
Quote Reply
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 
|
|
