| Author |
Topic Search Topic Options
|
ChrisUK
Newbie
Joined: 18 May 2003
Location: United Kingdom
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
Topic: Cannot update or insert 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
|
 |
Bunce
Senior Member
Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
|
Post Options
Thanks(0)
Quote Reply
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.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
 |
webwide
Newbie
Joined: 18 May 2003
Location: United States
Status: Offline
Points: 8
|
Post Options
Thanks(0)
Quote Reply
Posted: 19 May 2003 at 6:58am |
-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!
|
 |
Bunce
Senior Member
Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
|
Post Options
Thanks(0)
Quote Reply
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.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 19 May 2003 at 7:57am |
|
This is a permisions problem, contact your hosting company about it.
|
|
|
 |
ChrisUK
Newbie
Joined: 18 May 2003
Location: United Kingdom
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
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.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
 |