| Author |
 Topic  |
|
The Impact
Junior Member
Australia
398 Posts |
 Posted - 11 October 2002 : 03:17:49
|
Chris,
Is these files ment to go be put over all the new files or on its own?
I'm getting a Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/minglis/snitz/inc_func_common.asp, line 100
error and I'm unsure of what I have done wrong. I'll chat to U later!
|
 |
|
|
The Impact
Junior Member
Australia
398 Posts |
Posted - 11 October 2002 : 03:38:00
|
GREAT...
More problems as I try and fix it... I'll speak to you Chris after Bathurst! |
|
|
|
The Impact
Junior Member
Australia
398 Posts |
Posted - 11 October 2002 : 04:03:00
|
| I'm even having problems with the clear database! |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 12 October 2002 : 09:02:55
|
quote:
Operation must use an updateable query.
Usually means that the ASP code cannot write to your database. Check that the database file is placed in a directory with read/write privileges (which could be a specific location dictated by your ISP) |
|
|
|
The Impact
Junior Member
Australia
398 Posts |
Posted - 13 October 2002 : 01:47:52
|
Could anyone please tell me what to do when I get this error:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/minglis/snitz/inc_func_common.asp, line 100
Just what it means will do...
Thanks Josh
|
|
|
|
The Impact
Junior Member
Australia
398 Posts |
Posted - 13 October 2002 : 07:07:15
|
| Same as last time... |
|
|
|
padawan
Junior Member
200 Posts |
Posted - 13 October 2002 : 12:35:50
|
quote:
Originally posted by The Impact
Could anyone please tell me what to do when I get this error:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/minglis/snitz/inc_func_common.asp, line 100
Just what it means will do...
Thanks Josh
Impact,
I've gotten this error previously because my folders did not have the rigth permissions set.
Have your web host change the permission to folders (more than likely your \db or \cgi-bin; folder where your snitz database resides) you're having problems with to Read/Write.
good luck.
-padawan
|
"...be mindful of the SnitzForce..." |
Edited by - padawan on 13 October 2002 12:37:14 |
|
|
|
James
Average Member
USA
539 Posts |
Posted - 21 October 2002 : 22:46:32
|
| Also make sure that you have database type and path set correctly in config.asp |
*Interested in Radio Control*
*The RC Web Board - http://www.rcwebboard.com/* |
|
|
|
pox
Junior Member
Denmark
110 Posts |
Posted - 29 October 2002 : 15:30:35
|
Hey all! 
i have just updated my site whith this forum and.. man i love it! but PM MOd is getting an error.
quote:
Microsoft JET Database Engine error '80004005'
Unspecified error
/forum/pm_view.asp, line 115
The res text is line 115 
quote:
if strDBType = "access" then ' Get Private Message Total for Display(Access)
strSql = "SELECT [pmtotal1]=(SELECT Count(M_TO) FROM " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "PM P WHERE M.M_NAME = '" & strDBNTUserName & "' AND M.MEMBER_ID = P.M_TO), [pmtotal2]=(SELECT Count(M_FROM) FROM " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "PM P WHERE M.M_NAME = '" & strDBNTUserName & "' AND M.MEMBER_ID = P.M_FROM)"
else
' Get Private Message Total for display(SQL, mySQL)
strSql = "SELECT pmtotal1=(SELECT Count(M_TO) FROM " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "PM P WHERE M.M_NAME = '" & strDBNTUserName & "' AND M.MEMBER_ID = P.M_TO), pmtotal2=(SELECT Count(M_FROM) FROM " & strMemberTablePrefix & "MEMBERS M, " & strTablePrefix & "PM P WHERE M.M_NAME = '" & strDBNTUserName & "' AND M.MEMBER_ID = P.M_FROM)"
end if
Set rsPM = my_Conn.Execute(strSql)
pmtotal1 = rsPM("pmtotal1")
pmtotal2 = rsPM("pmtotal2")
rsPM.close
set rsPM = nothing
pmtotal = pmtotal1 + pmtotal2
and the db is updated whith the dbupdates the followd the forum.
|
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 29 October 2002 : 16:58:19
|
pox, some questions for you :
- Are you using Access db, or something else ?
- Is it an existing db, or brand new ?
- If you are using an existing db, did you run the MOD Setup for PMs ? |
|
|
|
pox
Junior Member
Denmark
110 Posts |
Posted - 29 October 2002 : 19:56:28
|
quote:
Originally posted by laser
pox, some questions for you :
- Are you using Access db, or something else ?
- Is it an existing db, or brand new ?
- If you are using an existing db, did you run the MOD Setup for PMs ?
yes im using access.
and im using an old database from my other forum.
and i did run the pm mod db setup. ;/ |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 30 October 2002 : 01:01:40
|
| I can see the error, but I can't think of a fix so far. Can you contact me off-forum about getting admin access ? (I registered in your forums as laser) |
|
|
|
pox
Junior Member
Denmark
110 Posts |
Posted - 30 October 2002 : 05:25:34
|
thanks for all you have done laser. ;) it works now perfectly...
Massive respect to you laser  |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 30 October 2002 : 05:50:17
|
| np's mate ...... for everyone else it seems that the pm_view.asp file in the zip is faulty. If you have any problems then email/IM me and I will send you a better copy. |
|
|
|
Topic |
|
Topic Locked
