https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 22:51:39 +0000 Wed, 03 May 2006 09:23:11 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=19581 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post106081.html#106081 Author: WebWiz-Bruce
Subject: 19581
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.
]]> Wed, 03 May 2006 09:23:11 +0000 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post106081.html#106081 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post106068.html#106068 Author: jlewchuk
Subject: 19581
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][ODBC3.51 Driver][mysqld-4.0.24-max-log]You have an error in your SQLsyntax. Check the manual that corresponds to your MySQL server versionfor the right syntax to use near '(tblAuthor.DOB) = 2 ORDER BYtblAuthor.Author_ID DESC' at line
]]> Wed, 03 May 2006 02:37:25 +0000 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post106068.html#106068 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post105954.html#105954 Author: WebWiz-Bruce
Subject: 19581
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.
]]> Tue, 02 May 2006 12:24:44 +0000 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post105954.html#105954 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post105843.html#105843 Author: jlewchuk
Subject: 19581
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 fromthe one above. Was working perfectly previous to me touching it. Beganto get admin errors. Backed up the database. Then becomenon-working/cannot read error all together. Tried re-uploading thedatabase, no avail.

So, deleted everything on that server....and re-downloaded WW to aseperate computer from the one above....uploaded...STILL get a readonly 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 filesin machines?? This is crazy. I used to be able to upload these andadmin no sweat.
]]> Sun, 30 Apr 2006 06:59:46 +0000 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post105843.html#105843 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post105840.html#105840 Author: jlewchuk
Subject: 19581
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 anexisting database and plopped it into a new folder with the newlyuploaded forum. I upgraded the datavase and it worked fine. I cut npaste 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, itbecomes read-only. I've tried downlaind the database to my hd and backup 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]]> Sun, 30 Apr 2006 04:57:13 +0000 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post105840.html#105840 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post105726.html#105726 Author: jlewchuk
Subject: 19581
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
]]> Thu, 27 Apr 2006 14:58:54 +0000 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post105726.html#105726 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post105697.html#105697 Author: WebWiz-Bruce
Subject: 19581
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.
]]> Thu, 27 Apr 2006 10:14:56 +0000 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post105697.html#105697 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post105666.html#105666 Author: jlewchuk
Subject: 19581
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. Sawthe 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 tothe forum admin menu to configure. the I got a message that said thedatabase was read only.

I checked permissions and they're all in order. I called my ISP...theychecked 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
]]> Thu, 27 Apr 2006 02:48:40 +0000 https://forums.webwiz.net/database-or-object-is-readonly-help_topic19581_post105666.html#105666