| Author |
 Topic Search  Topic Options
|
jlewchuk 
Newbie
Joined: 30 December 2003
Status: Offline
Points: 20
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: "Database or object is read-only"...HELP!
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
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
jlewchuk
Newbie
Joined: 30 December 2003
Status: Offline
Points: 20
|
Post Options
Thanks(0)
Quote Reply
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
|
|
jlewchuk
Newbie
Joined: 30 December 2003
Status: Offline
Points: 20
|
Post Options
Thanks(0)
Quote Reply
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
Edited by jlewchuk - 30 April 2006 at 4:59am
|
|
jlewchuk
Newbie
Joined: 30 December 2003
Status: Offline
Points: 20
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
jlewchuk
Newbie
Joined: 30 December 2003
Status: Offline
Points: 20
|
Post Options
Thanks(0)
Quote Reply
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
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
