| Author |
 Topic  |
|
Capt_Dunzell
Junior Member
USA
160 Posts |
 Posted - 23 February 2001 : 09:35:24
|
After installing the latest update I get this error in the admin_forums.asp page:
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: "Provider=Microsoft.J"]'
/forum/admin_Forums.asp, line 57
This is what is on lines 57-59:
<% if strDBType = "access" and not Instr(strConnString,"DBQ=",1) > 0 then
Response.write "<li><a href=""admin_compactDB.asp"">Compact Database</a>"
end if %>
http://www.dunzellsden.com/forum/ |
 |
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 28 February 2001 : 11:51:01
|
change it to this
<% if strDBType = "access" and Instr(19,strConnString,"Jet",1) > 0 then
Response.write "<li><a href=""admin_compactDB.asp"">Compact Database</a>"
end if %>
|
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
|
nickpixel
Starting Member
USA
11 Posts |
Posted - 08 March 2001 : 15:48:00
|
is this written for any specific version of snitz? if so, will it work with 3.1 sr4?
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 08 March 2001 : 16:03:58
|
nick this mod will be included in the 3.2 release of the forum which is coming soon.
|
|
|
|
nickpixel
Starting Member
USA
11 Posts |
Posted - 09 March 2001 : 12:03:33
|
quote:
nick this mod will be included in the 3.2 release of the forum which is coming soon.
thanks, i'll be looking for it. i only asked because i am currently making mods on the 3.1 sr4 to be used on a site i hope to have completed by april 1. does snitz have a mailing list so i can find out when 3.2 is released? if not, i'll just check back. |
|
|
|
Martha2Mary
Junior Member
New Zealand
250 Posts |
Posted - 10 March 2001 : 17:15:27
|
I am fairly new to Snitz Forums and of course, to installing Mods, but I have managed to get a couple working, but am having probs with this one. Whenever I go to the admin_forums.asp page, this is what I see:
Archive topics from a forum
Delete selected topics from an archive
Delete all topics from a forum
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: "DRIVER={Microsoft Ac"]'
/forum/admin_forums.asp, line 57
And then when I try to access the archive.asp page, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'FORUM_ID = AND MEMBER_ID = 4'.
/forum/inc_functions.asp, line 1096
I have edited the default.asp as outlined in the first post of this thread, but these problems still persist.
If you can help me with this, please let me know how to fix it in very basic terms, as I am new to editing asp files 
Thanks!
*If the world didn't suck, we'd all fall off!  * |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 March 2001 : 18:45:04
|
ok, first of all open admin_forums.asp, and change line 57
to this
if strDBType = "access" and Instr(19,strConnString,"Jet",1) > 0 then
|
|
|
|
Martha2Mary
Junior Member
New Zealand
250 Posts |
Posted - 10 March 2001 : 21:09:54
|
Okay - thanks for that! The problem with the admin_forums.asp page is now gone, but the one with the archive.asp page still remains. Also, there is no link to the Archive anywhere actually at my Forums (the only link to anything to do with the Archive is that which points to the admin_forums.asp from the admin_home.asp page). Any further ideas on these probs?
TIA!
*If the world didn't suck, we'd all fall off! * |
|
|
|
Martha2Mary
Junior Member
New Zealand
250 Posts |
Posted - 14 March 2001 : 04:56:53
|
quote:
And then when I try to access the archive.asp page, I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'FORUM_ID = AND MEMBER_ID = 4'.
/forum/inc_functions.asp, line 1096
I have edited the default.asp as outlined in the first post of this thread, but these problems still persist.
If you can help me with this, please let me know how to fix it in very basic terms, as I am new to editing asp files
Thanks!
Sorry if I'm being a pain, but I'm sure someone must have the answer to the above problems I have mentioned, as well as the one in my post directly above, where nothing at all shows on my default.asp page that relates to archiving.....no icons, no links, nothing.
Please help
*If the world didn't suck, we'd all fall off! * |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 14 March 2001 : 06:43:50
|
martha
Have you actually archived anything ?
You will only get a link in default.asp once you have archived some topics
|
|
|
|
Martha2Mary
Junior Member
New Zealand
250 Posts |
Posted - 15 March 2001 : 15:47:42
|
Ohhhh, I see - that is probably what the problem is then! My Forums were only setup for use last week, and I have no topics that are older than a month, so cannot archive them
Once I have archived something, will the little icon beside each Forum and Topic that you can click to actually archive that topic (I have noticed this at other peoples Forums who have Archiving) also show up, or is that another mod?
Thanks for the help!
*If the world didn't suck, we'd all fall off! * |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 15 March 2001 : 16:25:05
|
Yes that's correct, I am also working on some minor modifications to the topic.asp which will display a link to archived replies to the topic, can't give a time scale yet. but before you get round to archiving I'm sure.
|
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 15 March 2001 : 16:45:30
|
ok... this is dangerouse... but I was thinking again... and why not go ahead and include the "Archive" stuff in the post.asp and process it in post_info.asp when the right box is checked?
Reinsnitz (Mike)
><)))'> Need a Mod?
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
|
Topic |
|
Topic Locked
