Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 my_conn.execute?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ED195KW
Starting Member

28 Posts

Posted - 28 June 2003 :  06:26:27  Show Profile
I was wondering if someone with more knowledge than me (my knowledge is very small) can help me. After installing the fully Moded forum, I have this error come up when trying to run it:

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/forums/forum/inc_func_common.asp, line 189


Line 189 in inc_func_common.asp is :

my_conn.execute (strSql)

At first I thought this was a permission problem, so I contacted my host and asked them to set the permissions on the forum folders to READ/WRITE, but they already were set. Any ideas what it could be causing this problem?

I then tried deleting line 189, just to see what happens. The forum then ran, but came up with an error mentioning a line in another file (can't remember which file) that reffered to my_conn.execute again. What is this my_conn.execute? How can I fix this problem?

I'm hoping someone can help me, as I have very little knowledge of programming and so far this forum has helped me very much so far with my other forum ( a basic snitz with a few mods).

Thankyou in advance.

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 28 June 2003 :  07:04:16  Show Profile
this is always a permissions problem. It's not the forum folder that needs read/write, it's the database. Make sure your host sets the NTFS permissions on the database so that the IUSR_machinename account has write access.

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~

Edited by - Nikkol on 28 June 2003 07:04:37
Go to Top of Page

ED195KW
Starting Member

28 Posts

Posted - 28 June 2003 :  07:09:06  Show Profile
NTFS?
Go to Top of Page

ED195KW
Starting Member

28 Posts

Posted - 28 June 2003 :  07:37:47  Show Profile
Ok, now I'm confused. The database folder that I have the snitz_forums_2000.mdb file in (which I have renamed) is the same folder that I have my other forum's file in. This other forum works fine. What's going on?
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 June 2003 :  07:53:30  Show Profile  Send ruirib a Yahoo! Message
Grant, or ask your host to do it, read/write permissions on the database file as Nikkol recommended.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

ED195KW
Starting Member

28 Posts

Posted - 28 June 2003 :  08:10:47  Show Profile
Ok, I've figured it out, I had the config.asp pointing to the other forum's database file. I just changed the config.asp to point to the new file. Thanks for your help guys, I was literally pulling my hair out. Now to play with the new forum...
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07