Print Page | Close Window

Cannot update or insert

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=2823
Printed Date: 01 April 2026 at 4:23am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Cannot update or insert
Posted By: ChrisUK
Subject: Cannot update or insert
Date Posted: 18 May 2003 at 4:32pm

OK, I've downloaded and installed all the code and I've beem able to get the forum default page to load.

Problem I'm having is I cannot register! It keeps telling me Database cannot update. Database or object is read-only. I have a db of my own in the same folder and I'm updating it wthout any problems so the folder permissions must be OK. I've checked the database file permissions and they are 777 (read/write/execute).

The error is in register.asp at line 821 which I think is trying to commit the details to the database. I've changed the connection string in common.asp so it shows my local folder details.

Can anyone tell me what else I should do please.

TIA

 



-------------
Chris



Replies:
Posted By: Bunce
Date Posted: 18 May 2003 at 4:53pm

Follow the database instructions in the FAQ section of this site *word-for-word* and your problem should be solved.

Also I've never heard 777 used as a description for file permissions.. I hope your not referring to the permissions described by an FTP client as I doubt thats applicable on a Windows box.

Cheers,
Andrew



-------------
There have been many, many posts made throughout the world...
This was one of them.


Posted By: WebWiz-Bruce
Date Posted: 19 May 2003 at 4:02am

You can not change the permissions on a windows web server using FTP so 777 means nothing. This can only be used on Unix systems.

You need to get your web hosts to set write permisisions for you on the database.

Also check before uploading that the read only attrobute is not set on the database before uploading it to the server.



-------------
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: webwide
Date Posted: 19 May 2003 at 6:58am
Originally posted by -boRg- -boRg- wrote:

You need to get your web hosts to set write permisisions for you on the database.

Also check before uploading that the read only attrobute is not set on the database before uploading it to the server.

I'm having the same error problem - the folder is already designated for write access, specifically for databases.  None of my other databases are giving this error.  I double-checked and there are no read-only settings on this database.  I'm stumped!



-------------
Glenn Dixon


Posted By: Bunce
Date Posted: 19 May 2003 at 7:11am

Please read the Database FAQ on this site and follow it word for word.  It will fix your problem if permissions are set up correctly.

This question has literally been asked at least 3 times a week for the past few years!



-------------
There have been many, many posts made throughout the world...
This was one of them.


Posted By: WebWiz-Bruce
Date Posted: 19 May 2003 at 7:57am
This is a permisions problem, contact your hosting company about it.

-------------
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: ChrisUK
Date Posted: 19 May 2003 at 10:00am

I've contacted my hosting company and as expected they told me it is NOT a permission issue as the folder in question has read/write permissions.

I have noticed I've been unable to update myself before using the Jet engine, to get round the issue I've used an update SQL command, not opened a record, changed the fields then done an "update"

Could there be something else I'm missing ?

As I stated before I do have other databases on mysite and in the same folder as the forum DB, they all work fine, but then I always use SQL statements to do updates.

Thanks to everyone who has replied.

 



-------------
Chris


Posted By: WebWiz-Bruce
Date Posted: 19 May 2003 at 10:14am
I guess your only option then will be look for a different forum package that works with your web host, or change web host.

-------------
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: ChrisUK
Date Posted: 19 May 2003 at 5:06pm

Success !!

The error message is not so friendly. My host puts the DB folder above the root folder so to get to this you need to use the ../

My problem was I didn't understand how server.mappath works, I was using server.mappath("/../../db/wwForum.mdb"), it should have been server.mappath("../../db/wwForum.mdb") !!

Quite why the error message was not as helpful as it could have been is a question I've not got an answer to, but, it's working now!

Thanks to everyone for all their help.

 



-------------
Chris



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net