| Author |
 Topic  |
|
|
SlowManKarrd
Starting Member
USA
16 Posts |
 Posted - 18 March 2001 : 20:39:57
|
I'm getting this problem when i go to my forum
quote:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/forum/inc_functions.asp, line 660
I was told
quote:
You need to set modify permissions on your directory containing the DB
...um...so how do i do that? I've never had to do that before, and my forum has worked fine.
My Database file is in my /cgi-bin and my forum files are in /forum
I use FTP Explorer
http://www.theslowpeople.com/forum
slowmankarrd@theslowpeople.com
thanks =)
Edited by - slowmankarrd on 18 March 2001 20:41:31 |
|
|
Enigma
Starting Member
Germany
16 Posts |
Posted - 19 March 2001 : 12:00:16
|
You gotta chmod your Forum folder on your Server
chmod to 666 if you are on a Unix like me.
I never used FTP Explorer but it should have an option when you select a folder to chmod it .....
if not d/l WSFTP at download.com small prg. to upload your files easy
|
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 March 2001 : 13:10:52
|
You can't set the permissions using your FTP on an NT Server. You need to ask your server administrator to set the correct permissions on your cgi-bin folder. If it's your own server, (which I doubt it) you would probably open Windows Explorer, go to your cgi-bin folder, (probably in the Inetpub folder), right click on it, select properties and there you can set the permission for the folder. (correct me if I'm wrong anyone)
|
|
|
|
larango
Starting Member
Colombia
20 Posts |
Posted - 19 March 2001 : 13:49:05
|
I would take the db out of the cgi-bi and put it in another directory.
Off course modify your config.asp to reflect the directory changes. And,,..
If you want to secure up a little bit your db just use a DNS connection.
|
|
|
|
SlowManKarrd
Starting Member
USA
16 Posts |
Posted - 19 March 2001 : 14:28:34
|
I created a new folder called /db and moved my database file in there (and changed my config.asp to reflect the new location)
Now, the following text shows up at the very top of http://www.theslowpeople.com/forum
quote:
orMail") strShowPaging = Application(strCookieURL & "strShowPaging") strShowTopicNav = Application(strCookieURL & "strShowTopicNav") strPageSize = Application(strCookieURL & "strPageSize") strPageNumberSize = Application(strCookieURL & "strPageNumberSize") strForumTimeAdjust = DateAdd("h", strTimeAdjust , Now()) strNTGroups = Application(strCookieURL & "STRNTGROUPS") strAutoLogon = Application(strCookieURL & "STRAUTOLOGON") ReadModConfig() if strSecureAdmin = "0" then Session(strCookieURL & "Approval") = "15916941253" end if on error goto 0 if strAuthType = "db" then strDBNTSQLName = "M_NAME" strAutoLogon ="0" strNTGroups ="0" else strDBNTSQLName = "M_USERNAME" end if %>
and this message is below the login stuff
quote:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/forum/inc_functions.asp, line 644
I DL'd that program, and tried to do a chmod on /db and i got this:
500 'SITE chmod 644 db': command not understood
! Chmod failed. It may not be supported on remote site.
Are chmods only if you are hosting locally?
So now what? go to my host and say "could you chmod my /db folder so my forum will work?" And they will just know what to do....
Edited by - SlowManKarrd on 19 March 2001 14:29:34
Edited by - SlowManKarrd on 19 March 2001 14:31:20 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 March 2001 : 19:11:48
|
Ok. So you followed the advice of 2 starting members and totally ignored what I told you? *sigh*
I'll just repeat what I basically told you before. I presume you're not running on your own server. So just ask your server admin to set Read/Write permission on the database and the folder the database is in. Also tell him to allow the Anonymous user account (IUSER_computername) to have Read and Write permissions.
And you didn't have to move your database file. You could have kept it in your cgi-bin. Just make sure you renamed the file from "snitz_forums_2000.mdb" to something else. Like "kshb3987496t.mdb" for example. (I just pressed on the keyboard to get that  )
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 19 March 2001 : 19:25:36
|
an Addition to what Davio said, they must also allow MODIFY permissions for the IUSR_ account.
|
|
|
|
SlowManKarrd
Starting Member
USA
16 Posts |
Posted - 19 March 2001 : 21:26:18
|
Davio: I tried fixing the problem myself, then I went to tech support at my host. I just didn't mention that in my post 
If i have my host change my /cgi-bin permissions to Read/write then wont people be able to DL my database as well as all the other cgi stuff i got in there! 
(thanks for your help )
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 March 2001 : 22:20:53
|
They probably could if they knew the name of the database. That's why I said to change the name of your database to something cryptic. Like the example I showed in my last post. Make it a long name, with numbers and letters. There's no way anyone can guess the name of your database if you do that.
|
|
|
|
larango
Starting Member
Colombia
20 Posts |
Posted - 19 March 2001 : 23:05:14
|
About the lines shown at the top of the forum. The problem is with your config.asp
If you try
http://www.theslowpeople.com/forum/config.asp
you will see what I am talking about.
config.asp is a file that is included in the pages shown to the users, that's why you get the "message"
Perhaps you unintentionally added a %> somewhere in the middle of the config variables. Or copy the message showing at the bottom of the ASP page just after a %> instruction.
Any way, I suggest to delete your actual config.asp and copy a brand new one from your local copy or from your zip file -better from the original zip file-. Keep in mind to copy the one that comes with the forum version you are working with.
Add the DB connection and table prefixes you use.
That should solve the problem of the message showing above of your forum.
|
|
|
|
larango
Starting Member
Colombia
20 Posts |
Posted - 19 March 2001 : 23:08:24
|
About your "Operation must use an updateable query." problem. If you have tried everything and nothing works....
Do what the experts do in these cases. Start all over again. Erase everything but your DB. Copy all the forum files. Config your config.asp to point to your db and run setup.asp.
That usually works in most cases. Good luck
|
|
|
| |
Topic |
|
Topic Locked
