Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - Database entries not displaying
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Database entries not displaying

 Post Reply Post Reply
Author
fathom View Drop Down
Groupie
Groupie
Avatar

Joined: 06 October 2004
Location: South Africa
Status: Offline
Points: 58
Post Options Post Options   Thanks (0) Thanks(0)   Quote fathom Quote  Post ReplyReply Direct Link To This Post Topic: Database entries not displaying
    Posted: 12 January 2005 at 4:00am
Urgent!!!
 
I was taking a walk through the forum this morning and had a bit of a freak out. Most of the posts are missing.
Thankfully the database seems intact but I am no db expert.
This really is worrying. Any ideas?
 
Brad
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: 12 January 2005 at 6:17am
What database version are you using??

If it is access make sure you have the database outside of your web root where it can not be downloaded or over written through a web browser.

Make sure that all admin and moderator passwords are changed and difficult to guess.

Make sure that someone hasn't accidently overwritten the database through FTP with an old back-up copy.

Access often becomes corrupted and does loose keys etc. a compact and repair on the database may sort out the problem.

Lastly, if you are using Access, DON'T switch to MS SQL Server which is much more secure, handle more connections, and doesn't get corrupted all the time like Access.
Back to Top
fathom View Drop Down
Groupie
Groupie
Avatar

Joined: 06 October 2004
Location: South Africa
Status: Offline
Points: 58
Post Options Post Options   Thanks (0) Thanks(0)   Quote fathom Quote  Post ReplyReply Direct Link To This Post Posted: 12 January 2005 at 8:12am
I am using access. the database is outside the root.
The funny thing is that the forum reads the correct number of threads
in the Topics column but when you go in to a forum there are only a few threads.
I have downloaded the database and it seems ok.
Any other ideas?
 
Brad
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: 12 January 2005 at 8:27am
For most of your forums the drop down show topics list is set to show topics posted in the last week.

If you change this to 'All' you will see all the topics in that forum.

The default for the drop down list for each forum can be set in the admin  area for each forum on the forums setup page where you set forum title etc.
Back to Top
fathom View Drop Down
Groupie
Groupie
Avatar

Joined: 06 October 2004
Location: South Africa
Status: Offline
Points: 58
Post Options Post Options   Thanks (0) Thanks(0)   Quote fathom Quote  Post ReplyReply Direct Link To This Post Posted: 12 January 2005 at 8:58am
PHEW! thanks borg! thats a load off!Embarrassed
 
Brad
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.