Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - I got this message-There are no Forums to display
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

I got this message-There are no Forums to display

 Post Reply Post Reply
Author
suona View Drop Down
Newbie
Newbie


Joined: 29 January 2010
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote suona Quote  Post ReplyReply Direct Link To This Post Topic: I got this message-There are no Forums to display
    Posted: 29 January 2010 at 2:17pm
I set up an new web wiz forum V9.65.
 
Since I have an old snitz forum, it took me three days to transfer all data to WWF.
 
The strange thing is: When I login, I can see all forums and posts. But if I logout, the forum shows:
There are no Forums to display.
 
That is, if a guest visits the forum, he can't see any thing but a blank WWF.
 
Is that normal? or there's some setting should do?
 
Thanks!
 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 29 January 2010 at 2:31pm
That is not normal. Moving data from one database to another that has a different schema is not straight forward and I would very much doubt you would end up with a stable forum at the end of it.
Back to Top
suona View Drop Down
Newbie
Newbie


Joined: 29 January 2010
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote suona Quote  Post ReplyReply Direct Link To This Post Posted: 29 January 2010 at 3:45pm
Thanks for your reply.

The "Forum Statistics" below is abnormal too, when login, shows normal Forum Statistics , like this:


Our users have posted 76,485 Posts in 11,890 Topics in 53 Forum(s)
Last Post; Today at 5:09pm By XYZ
We have 20,209 Forum Members
The Newest Forum Member is ABCDE



When logout, Forum Statistics's all numbers become zero,and missing last post. like this:


Our users have posted 0 Posts in 0 Topics in 0 Forum(s)
Last Post; Unknown at 12:00am By
We have 20,209 Forum Members
The Newest Forum Member is ABCDE



In fact, I'm doing the database migration by reference this topic :Topic: Migrating From Snitz - LETS WORK THIS OUT , and made some corrections my self.

After three day's hard work (for me an amateur), The internal link between posts/replies/authors are all done and correct, I think the most difficult part should be done already, but the issue " There are no Forums to display" become the biggest problem ....Cry

Can anyone help me to find out possible way to solve this last problem?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 29 January 2010 at 3:58pm
You did not remove the built in admin acoc**t (tblAuthor ID 1) or the Guest acoc**t (tblAuthor ID 2)from the database, and the same with the built in admin and guest group.

If you did this will prevent the forum from running as it should.
Back to Top
suona View Drop Down
Newbie
Newbie


Joined: 29 January 2010
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote suona Quote  Post ReplyReply Direct Link To This Post Posted: 29 January 2010 at 5:03pm
I obey MortiOli's script's documentation, delete that two records, and compact database, all table record's ID counts from 1.

I try to delete the first two records, now even when I login, it shows a blank forum.

So I restore the db.

My environment: w2k server / SQL 7.0 / charset=big5

Here's my migration effort:

Four days ago, I have install a brand new WWF over blank SQL7.0 database and works OK. (during installation select SQL server 2000)

The MortiOli's script works for access db, so I use SQL to export my snitz forum's db to an access .mdb file, and use this .mdb file, install a new WWF over it. And it works well.

Then testing and running for three days, all data transferred to WWF.

So I use SQL server to import the .mdb , make a new SQL db, and install a new WWF over this new SQL db. At first I choose "New installation",but it will make a new db, So I start over again, select "upgrade from WWF 9.x" and then finish the process without error messages.

Sine MortiOli's script runs with access db, my original and final db is SQL, this is the only way I know to transfer the data. 

SQL db-->access db-->MortiOli's -->access new db-->SQL db-->WWF install over existing SQL db

I think this procedure should have somthing wrong.......Cry






Back to Top
suona View Drop Down
Newbie
Newbie


Joined: 29 January 2010
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote suona Quote  Post ReplyReply Direct Link To This Post Posted: 30 January 2010 at 9:07am
Finally I solved the problem: my Guest group is missing, and there are no permission for guests. Added proper Guest group, and save Guest access permission for all forums, it works fine now!
Back to Top
mgm View Drop Down
Newbie
Newbie


Joined: 27 September 2009
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote mgm Quote  Post ReplyReply Direct Link To This Post Posted: 08 October 2010 at 6:43am
Originally posted by suona suona wrote:

When logout, Forum Statistics's all numbers become zero,and missing last post. like this:


Our users have posted 0 Posts in 0 Topics in 0 Forum(s)
Last Post; Unknown at 12:00am By
We have 20,209 Forum Members
The Newest Forum Member is ABCDE
 
I also have the above problem. We don't have any guest access so no forums are visible until a user logs in. Some of our new users have been put off by seeing that 0 posts in 0 forums and assumed that the forum is no longer active.
 
Is there any way to disable the Statistics from showing when no Forums are accessible to a user?
 
mgm
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.