Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Cannot update or insert
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Cannot update or insert

 Post Reply Post Reply Page  12>
Author
ChrisUK View Drop Down
Newbie
Newbie
Avatar

Joined: 18 May 2003
Location: United Kingdom
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote ChrisUK Quote  Post ReplyReply Direct Link To This Post 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

 

Back to Top
Bunce View Drop Down
Senior Member
Senior Member
Avatar

Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
Post Options Post Options   Thanks (0) Thanks(0)   Quote Bunce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.

Back to Top
webwide View Drop Down
Newbie
Newbie


Joined: 18 May 2003
Location: United States
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote webwide Quote  Post ReplyReply Direct Link To This Post 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!

Back to Top
Bunce View Drop Down
Senior Member
Senior Member
Avatar

Joined: 10 April 2002
Location: Australia
Status: Offline
Points: 846
Post Options Post Options   Thanks (0) Thanks(0)   Quote Bunce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 19 May 2003 at 7:57am
This is a permisions problem, contact your hosting company about it.
Back to Top
ChrisUK View Drop Down
Newbie
Newbie
Avatar

Joined: 18 May 2003
Location: United Kingdom
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote ChrisUK Quote  Post ReplyReply Direct Link To This Post 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.

 

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.