Web Wiz Forums - HELP DB Problem

Print Page | Close Window

HELP DB Problem

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=14340
Printed Date: 30 March 2026 at 8:35am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: HELP DB Problem

Posted By: bluespider
Subject: HELP DB Problem
Date Posted: 20 March 2005 at 3:27pm

I just ran the compact database from the admin and now the forum won't work at all.... anyone know how I can recover this???? HELP PLEASE!!!!!!!!!!

Replies:

Posted By: sfd19
Date Posted: 20 March 2005 at 3:36pm

Better use a descriptive topic title and also post the error message (friendly http errors off) you are getting otherwise nobody will be able to help you with anything.

What I can think of is that you are using DSN connections, with some web hosts deleting the DB will destroy the DSN connection you have set in the admin panel of your provider. They have to repair the DSN manually then.

(Compacting from the WWF admin panel deletes the original DB)

-------------
Politics, economy & social issues: http://www.studentsfordemocracy.net - StudentsforDemocracy.net

Posted By: bluespider
Date Posted: 20 March 2005 at 3:39pm

Thanks... I don't know what happened. I did the compact from the WWF admin panel and it created the backup file just like it said it would. I am able to go directly to the admin page, but when I try to pull up the default.asp for the forum itself I now get an http error 500.... it was working just fine until i did the compact... any other ideas???? I've checked my dsn connections and they verify ok and if it really were a problem with that I don't think the admin page would let me login directly???

Posted By: sfd19
Date Posted: 20 March 2005 at 3:45pm

Http error 500 means you have still turned on friendly error messages in your browser config.

Turn it off and then post the real error message.

You can not see if the DSN connection is working properly in the admin panel of your web host. It will show the DSNs no matter whether they are working or not.

But the error message will tell us more.

-------------
Politics, economy & social issues: http://www.studentsfordemocracy.net - StudentsforDemocracy.net

Posted By: bluespider
Date Posted: 20 March 2005 at 3:48pm

ok, here is the actual error...

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/forum/common.asp, line 543

I didn't make any changes to the common.asp file

Posted By: bluespider
Date Posted: 20 March 2005 at 3:49pm

did it lock the database somehow??

Posted By: sfd19
Date Posted: 20 March 2005 at 3:49pm

Your error message is this:

Microsoft JET Database Engine error '80040e09'

Cannot update. Database or object is read-only.

/forum/functions/newsbot_for_WWF.asp, line 99

You have not set the proper permissions to the database. I guess you have not put the DB into the folder your host recommends for DBs. That means after your DB was deleted by the compacting process the permissions were removed and the new compacted DB is read-only.

-------------
Politics, economy & social issues: http://www.studentsfordemocracy.net - StudentsforDemocracy.net

Posted By: bluespider
Date Posted: 20 March 2005 at 3:54pm

I've reset a db connection for it and checked the permissions and they seem ok... however there is an .ldb file now --- the file is still in the admin/database folder where it has always been.

Posted By: bluespider
Date Posted: 20 March 2005 at 4:01pm

All my data is still in the db, i wonder if i reupload the db from the original zip and then import my data into that one if that would work?

Posted By: sfd19
Date Posted: 20 March 2005 at 4:04pm

Nope, does not work. When the DB is locked (and the .ldb file is indicating that) you can not overwrite the DB.

When the .ldb does not automatically disappear then your DB has locked and your host has to reset the DB manually.

-------------
Politics, economy & social issues: http://www.studentsfordemocracy.net - StudentsforDemocracy.net

Posted By: bluespider
Date Posted: 20 March 2005 at 4:21pm

I'll try my host and see if that works, Thanks for the help!!!! I REALLY appreciate it!!!

Posted By: bluespider
Date Posted: 21 March 2005 at 7:29pm

Just FYI, I took a copy of a fresh db and imported all the data from my old db, then I reimported the entire admin/database directory back to my web site and this fixed all my permission issues. Just in case this ever happens again, who knows :-)