"Database or object is read-only"...HELP!
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=19581
Printed Date: 12 April 2026 at 12:27am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: "Database or object is read-only"...HELP!
Posted By: jlewchuk
Subject: "Database or object is read-only"...HELP!
Date Posted: 27 April 2006 at 2:48am
All,
Really. I read the FAQs. I called my ISP several times. I read and searched the forum. Please, please, please help:
I had the last version of the forum on my site and it was hacked. Ok,
fine, it wasn't busy...had it up for a year or so, and deleted it. Saw
the the instructions on how to fix the hack problem...no sweat.
I tried to upload the forum and in the beginning, was able to get to
the forum admin menu to configure. the I got a message that said the
database was read only.
I checked permissions and they're all in order. I called my ISP...they
checked the permissions...same thing...everything is checked.
I'm running the Access version as it's not a busy forum. I tried setting up the Access DSN...that did nothing.
I've deleted and uploaded the forum at least 10 times...here's the last error after just tryinging to login as administrator:
Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.
Support Error Code:- err_Access_loginUser()_update_login_attempts
File Name:- functions_login.asp
Error details:-
Microsoft JET Database Engine
Cannot update. Database or object is read-only.
I even tried uploading to a totally different host, different server and the same thing happened.
I'm going out of my mind. Please help.
Jim
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 27 April 2006 at 10:14am
This is 100% a permissions issue.
You can not set or check permissions using FTP on a windows web server, this is something your web host needs to do.
The folder your Access database is in needs, read, write, and modify permissions for the IUSR account.
At the moment your web host has not set the correct permissions.
Also, before uploading the Access database, right click the access database, select 'Properties' and check that 'Read-only' attribute is not checked.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: jlewchuk
Date Posted: 27 April 2006 at 2:58pm
Borg,
Thanks for the quick answer...will give a try on both suggestions and get back to the group with the results.
Jim
|
Posted By: jlewchuk
Date Posted: 30 April 2006 at 4:57am
Good news and bad news.
Good news: i don't think it's a server permissions thing. I took an
existing database and plopped it into a new folder with the newly
uploaded forum. I upgraded the datavase and it worked fine. I cut n
paste within the FTP program so the database didn't come to my computer.
Bad news: it seems as soon as the database hits my hard drive, it
becomes read-only. I've tried downlaind the database to my hd and back
up and I get the same read-only error. I've checked the permissions with explorer and it's writable.
Suggestions?
Jim
|
Posted By: jlewchuk
Date Posted: 30 April 2006 at 6:59am
Worse and even more perplexing news....
- d/led the new database and forum to an existing host, seperate from
the one above. Was working perfectly previous to me touching it. Began
to get admin errors. Backed up the database. Then become
non-working/cannot read error all together. Tried re-uploading the
database, no avail.
So, deleted everything on that server....and re-downloaded WW to a
seperate computer from the one above....uploaded...STILL get a read
only error with a brand new forum...on a new host! That now makes two.
That confirms it is not a host permission problem.
Has Microsoft done something with updates that is corrupting mdb files
in machines?? This is crazy. I used to be able to upload these and
admin no sweat.
|
Posted By: WebWiz-Bruce
Date Posted: 02 May 2006 at 12:24pm
To be honest Access is a crappy flat office file and not really up to the job of being used for a forum backend database.
I would suggest dumping Access and use the SQL Server or mySQL version, with a host that supports these databases, not only would it get rid of this problem, but you would have a much faster, more capable forum that would last for many years.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: jlewchuk
Date Posted: 03 May 2006 at 2:37am
Borg,
Thanks for the guidance. The saga continues:
***
Server Error in Forum Application
An error has occured while executing SQL query on database.
Please check that the MySQL Server version is 4.1 or above.
Please contact the forum administrator.
Support Error Code:- err_mySQL_get_birthdays
File Name:- default.asp
***
I'm not looking to have my hand held in this process, but it seems like I'm out of luck on the mySql version?
Jim
Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[MySQL][ODBC
3.51 Driver][mysqld-4.0.24-max-log]You have an error in your SQL
syntax. Check the manual that corresponds to your MySQL server version
for the right syntax to use near '(tblAuthor.DOB) = 2 ORDER BY
tblAuthor.Author_ID DESC' at line
|
Posted By: WebWiz-Bruce
Date Posted: 03 May 2006 at 9:23am
Looks like your host is using an old version of mySQL, as the error says version 4.0.23, you need version 4.1 or above for the mySQL version of Web Wiz Forums.
Maybe worth contacting your hosting company and see if they have a mySQL server with a more updated version.
-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
|