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

  New Posts New Posts RSS Feed - What’s wrong with my forum?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

What’s wrong with my forum?

 Post Reply Post Reply Page  12>
Author
slappyJ View Drop Down
Groupie
Groupie
Avatar

Joined: 28 January 2004
Status: Offline
Points: 178
Post Options Post Options   Thanks (0) Thanks(0)   Quote slappyJ Quote  Post ReplyReply Direct Link To This Post Topic: What’s wrong with my forum?
    Posted: 20 August 2005 at 10:26am
Hello,
 
Having problems with my forum here:
 
 
I can not view any threads and recieve HTTP 500 Internal server error messages.
 
The database file was about 45meg until I downloaded it. Opened it in Access and performed a Compact and Repair function. It's now about 30meg.
 
I thought this might fix the forum but I still get Page cannot be displayed errors.
 
Any suggestions?
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 20 August 2005 at 10:42am
make sure the database is not write protected and in a read/write and modify folder.

this is the issue, please turn off http friendly error messages and then you will also see the actual error.


Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 20 August 2005 at 2:47pm
When you re-uploaded it, did you delete the old .ldb file?

Lead me not into temptation... I know the short cut, follow me.
Back to Top
slappyJ View Drop Down
Groupie
Groupie
Avatar

Joined: 28 January 2004
Status: Offline
Points: 178
Post Options Post Options   Thanks (0) Thanks(0)   Quote slappyJ Quote  Post ReplyReply Direct Link To This Post Posted: 21 August 2005 at 8:40pm
.ldb file?
 
do you mean .mdb?
 
If so...I uploaded overwriting the old file.
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 22 August 2005 at 7:09am
Nope, meant .ldb

Access creates a temporary .ldb file to track who, what, where in the .mdb file. It's kind of like a master user index/tracking file for the db.

If you download the .mdb, compact and repair it, and the re-upload it you can run into problems if the old .ldb file is still there as it will be pointing to places in the .mdb that no longer exist or have been moved.
If you delete the .ldb file, it will be recreated the next time someone hits the db.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
slappyJ View Drop Down
Groupie
Groupie
Avatar

Joined: 28 January 2004
Status: Offline
Points: 178
Post Options Post Options   Thanks (0) Thanks(0)   Quote slappyJ Quote  Post ReplyReply Direct Link To This Post Posted: 22 August 2005 at 12:22pm
Where is this .ldb file stored?
 
So I can delete it.
Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 22 August 2005 at 2:16pm
The .ldb file would be in the same directory as your .mdb file. Typically, it would only be there if someone is using the db but if the db is out of sync to begin with, or you uploaded the compacted and repaired version while someone was using the old version, the .ldb would still be there.

I checked your site...
The actual error message obtained when friendly errors are turned off is

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/forum/forum_posts.asp, line 326

Basically, it's saying either the db or the directory it's in doesn't have write/modify permissions. As it was working before in the same directory, I'd bet that your ftp program changed the permissions for the .mdb file.

Lead me not into temptation... I know the short cut, follow me.
Back to Top
slappyJ View Drop Down
Groupie
Groupie
Avatar

Joined: 28 January 2004
Status: Offline
Points: 178
Post Options Post Options   Thanks (0) Thanks(0)   Quote slappyJ Quote  Post ReplyReply Direct Link To This Post Posted: 22 August 2005 at 4:28pm
Ok...the only way that worked was to log into my Site Administrator Control Panel and set the read and write permissions.
 
The forum is now working again.
 
Thanks to everyone for helping! Clap
 
Appreciate it. Smile
 
 
Back to Top
 Post Reply Post Reply Page  12>

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.