| Author |
 Topic  |
|
nathansym
Junior Member
163 Posts |
 Posted - 10 February 2002 : 19:18:12
|
I downloaded huwr's "file_lib_mod" and unzipped the files and include to my forum directy (include going in include folder)
then I put a link to "file_library.asp" in my admin_home.asp
but when I click on it I get this error ...
-----------------------
Microsoft JET Database Engine (0x80040E37)
The Microsoft Jet database engine cannot find the input table or query 'FORUM_FILECAT'. Make sure it exists and that its name is spelled correctly.
/forum/file_search.asp, line 2
------------------
can someone tell me what Im doiing wrong.
- Thanks
- Nathan
- www.oogaba.com
Edited by - nathansym on 10 February 2002 19:19:33
Edited by - nathansym on 10 February 2002 20:07:16 |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 11 February 2002 : 02:49:34
|
try this one: File Lib MOD
Crash
PS: you may have to adjust the language!! i think this file is in Dutch...
-----------------------------
More than evil, I laugh at your trust |
 |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 11 February 2002 : 02:52:10
|
the error you get means that you don't have the table 'FORUM_FILECAT' in your DB. try my link and re-run the dbs file which is included.
-----------------------------
More than evil, I laugh at your trust |
|
|
|
nathansym
Junior Member
163 Posts |
Posted - 11 February 2002 : 07:41:31
|
I re-ran it and here is what I get
Mod's and Add Ons
Creating table(s)...CREATE TABLE FORUM_FILECAT( ID int IDENTITY (1, 1) NOT NULL , F_CAT text (100) NOT NULL , [END} text (100) NOT NULL , [INSERT] text (100) NOT NULL , (F_CAT) ('default') NOT NULL , (F_CAT) ('administrative tools') NOT NULL , (F_CAT) ('communication and email') NOT NULL , (F_CAT) ('membership management') NOT NULL , (F_CAT) ('content & management') NOT NULL , (F_CAT) ('add-ons') NOT NULL , (F_CAT) ('graphics & images') NOT NULL , (F_CAT) ('design & layout') NOT NULL , (F_CAT) ('pre-modified') NOT NULL , (F_CAT) ('* official releases') NOT NULL , (F_CAT) ('* official beta's') NOT NULL )
Table already exists
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_FILEMANAGER( ID int IDENTITY (1, 1) NOT NULL , F_TITLE varchar(255) NOT NULL , F_CAT int NOT NULL DEFAULT 0, F_AUTHORID int NOT NULL , F_AUTHOR varchar(50) NOT NULL , F_VERSION varchar(255) NOT NULL , F_DATE varchar(32) NOT NULL , F_SNIPPET varchar(200) NOT NULL , F_DESCRIPTION memo NOT NULL , F_COMPAT varchar(255) NOT NULL , F_INSTALLATION memo NOT NULL , F_RATINGCOUNT int NOT NULL DEFAULT 0, F_RATED int NOT NULL DEFAULT 0, F_RATING int NOT NULL DEFAULT 0, F_FORUMLINK varchar(255) NOT NULL , F_DOWNLOAD int NOT NULL DEFAULT 0, F_FILELINK varchar(255) NOT NULL , F_NOTES memo NOT NULL , F_VALID int NOT NULL )
Table already exists
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_FILEREVIEWS( ID int IDENTITY (1, 1) NOT NULL , F_ID int NOT NULL , F_REVDATA memo NOT NULL , F_REVTITLE text (255) NOT NULL , F_USERNAME text (50) NOT NULL , F_POSTER_IP text (20) NOT NULL , F_POST_DATE text (32) NOT NULL )
Table already exists
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_FILEVERSION( ID int IDENTITY (1, 1) NOT NULL , F_VERSION text (50) NOT NULL )
Table already exists
--------------------------------------------------------------------------------
Database setup finished
here is my error again
Error Type:
Microsoft JET Database Engine (0x80040E37)
The Microsoft Jet database engine cannot find the input table or query 'FORUM_FILECAT'. Make sure it exists and that its name is spelled correctly.
/forum/file_search.asp, line 3
- Thanks
- Nathan
- www.oogaba.com |
|
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 18 February 2002 : 15:04:07
|
hey i know how to do that.that is how far i am hehe.
File Mod Fix
[DROP]
FILECAT
[END]
[CREATE]
FILECAT
ID
F_CAT#VARCHAR (100)##
[END]
[INSERT]
FILECAT
(F_CAT)#('Default')
(F_CAT)#('Administrative Tools')
(F_CAT)#('Communication and Email')
(F_CAT)#('Membership Management')
(F_CAT)#('Content & Management')
(F_CAT)#('Add-Ons')
(F_CAT)#('Graphics & Images')
(F_CAT)#('Design & Layout')
(F_CAT)#('Pre-Modified')
(F_CAT)#('* Official Releases')
(F_CAT)#('* Official Beta''s')
[END]
[DROP]
FILEMANAGER
[END]
[CREATE]
FILEMANAGER
ID
F_TITLE#varchar(255)##
F_CAT#int##0
F_AUTHORID#int##
F_AUTHOR#varchar(50)##
F_VERSION#varchar(255)##
F_DATE#varchar(32)##
F_SNIPPET#varchar(200)##
F_DESCRIPTION#memo##
F_COMPAT#varchar(255)##
F_INSTALLATION#memo##
F_RATINGCOUNT#int##0
F_RATED#int##0
F_RATING#int##0
F_FORUMLINK#varchar(255)##
F_DOWNLOAD#int##0
F_FILELINK#varchar(255)##
F_NOTES#memo##
F_VALID#int##
[END]
[DROP]
FILEVIEWS
[END]
[CREATE]
FILEREVIEWS
ID
F_ID#int##
F_REVDATA#memo##
F_REVTITLE#varchar (255)##
F_USERNAME#varchar (50)##
F_POSTER_IP#varchar (20)#NULL#
F_POST_DATE#varchar (32)##
[END]
[DROP]
FILEVERSION
[END]
[CREATE]
FILEVERSION
ID
F_VERSION#varchar (50)##
[END]
[INSERT]
FILEVERSION
(F_VERSION)#('3.1 Final')
(F_VERSION)#('3.1 SR1')
(F_VERSION)#('3.1 SR2')
(F_VERSION)#('3.1 SR3 Final')
(F_VERSION)#('3.1 SR4')
(F_VERSION)#('3.3 Final')
[END]
use that code and make a new .asp file and then put it in ur forum directory and then run ur MOD Setup and there u go.
then tell me if it works cos i carnt get ine to work now.
MaD2ko0l
© 1999-2002 MaD2ko0l
-=[ Life Is So Easy When You Are Evil ]=- |
|
|
|
nathansym
Junior Member
163 Posts |
Posted - 18 February 2002 : 15:11:47
|
I got it to work ....
I THINK!
How do I know if it is working???
I mean there were no errors ... but I link to "file_library.asp"
and I get this error ....
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/forum/file_search.asp, line 36
I have been told to add some records to the FORUM_FILEVERSION table but ....
Like manually?
I guess my question is ....
what is this MOD supposed to do?
- Thanks
- Nathan
- www.oogaba.com |
|
|
|
MaD2ko0l
Senior Member
United Kingdom
1053 Posts |
Posted - 18 February 2002 : 15:16:11
|
uumm i dont know but i can get it to work just about i have used the file_search.asp file that came with the snitz forum.
try to use the file_search.asp file that came with the forum
© 1999-2002 MaD2ko0l
-=[ Life Is So Easy When You Are Evil ]=- |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 18 February 2002 : 17:32:47
|
You ask what the mod is for ?
where did you download it from ?
|
|
|
|
nathansym
Junior Member
163 Posts |
Posted - 18 February 2002 : 17:49:20
|
I downloaded it from 2 places ....
your site (magicmushroom.org.uk)
and crash (above) posted a link to it .... both have identical files
- Thanks
- Nathan
- www.oogaba.com |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 18 February 2002 : 19:12:22
|
and the place you downloaded it from on my site was called what ?
|
|
|
|
nathansym
Junior Member
163 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 18 February 2002 : 20:44:30
|
Ok, and the set of pages you were in were called 'the File library', so guess what it is for!
|
|
|
|
nathansym
Junior Member
163 Posts |
Posted - 18 February 2002 : 21:03:34
|
lol .... so I am guessing I downloaded the system used to give me the download!
- Thanks
- Nathan
- www.oogaba.com |
|
|
|
Mongoose
Starting Member
13 Posts |
Posted - 07 March 2002 : 11:47:07
|
Hey guys im getting the following error..any ideas?
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'cint'
/discussion/uploadengine.asp, line 75
win2k server sql 2000
win 4 sp6a web server
snitz 3.3.03
|
|
|
|
Massimo
Junior Member
Italy
125 Posts |
Posted - 27 March 2002 : 05:32:40
|
help me file_library.asp:
Add Category
search file: pop_filecategory.asp and pop_spellcheck.asp file not foun in the mods... ?
and I if: Got a tweak, MOD or 'Help' file? Post it! in the link:
/forum/file_library.asp?fmode=add
this error:
Post Date Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: "/0"]'
/forum/inc_functions.asp, line 1608
in the my inc_functions.asp line 1608:
month5 = "Nov"
case "Dec"
month5 = "Dic"
end select
ChkDate = Mid(fDate,1,4) & " " & _
Mid(fDate,7,2) & " " & month5
case "dmmmy"
mon = Monthname(Mid(fDate,5,2),0) <<== 1608 line
select case mon
case "January"
mont = "Gennaio"
case "February"
mont = "Febbraio"
case "March"
========
thank you for help my.... 
I fix mods
quote:
hey i know how to do that.that is how far i am hehe.
File Mod Fix
[DROP]
FILECAT
[END]
[CREATE]
FILECAT
ID
F_CAT#VARCHAR (100)##
[END]
[INSERT]
FILECAT
(F_CAT)#('Default')
(F_CAT)#('Administrative Tools')
(F_CAT)#('Communication and Email')
(F_CAT)#('Membership Management')
(F_CAT)#('Content & Management')
(F_CAT)#('Add-Ons')
(F_CAT)#('Graphics & Images')
(F_CAT)#('Design & Layout')
(F_CAT)#('Pre-Modified')
(F_CAT)#('* Official Releases')
(F_CAT)#('* Official Beta''s')
[END]
[DROP]
FILEMANAGER
[END]
[CREATE]
FILEMANAGER
ID
F_TITLE#varchar(255)##
F_CAT#int##0
F_AUTHORID#int##
F_AUTHOR#varchar(50)##
F_VERSION#varchar(255)##
F_DATE#varchar(32)##
F_SNIPPET#varchar(200)##
F_DESCRIPTION#memo##
F_COMPAT#varchar(255)##
F_INSTALLATION#memo##
F_RATINGCOUNT#int##0
F_RATED#int##0
F_RATING#int##0
F_FORUMLINK#varchar(255)##
F_DOWNLOAD#int##0
F_FILELINK#varchar(255)##
F_NOTES#memo##
F_VALID#int##
[END]
[DROP]
FILEVIEWS
[END]
[CREATE]
FILEREVIEWS
ID
F_ID#int##
F_REVDATA#memo##
F_REVTITLE#varchar (255)##
F_USERNAME#varchar (50)##
F_POSTER_IP#varchar (20)#NULL#
F_POST_DATE#varchar (32)##
[END]
[DROP]
FILEVERSION
[END]
[CREATE]
FILEVERSION
ID
F_VERSION#varchar (50)##
[END]
[INSERT]
FILEVERSION
(F_VERSION)#('3.1 Final')
(F_VERSION)#('3.1 SR1')
(F_VERSION)#('3.1 SR2')
(F_VERSION)#('3.1 SR3 Final')
(F_VERSION)#('3.1 SR4')
(F_VERSION)#('3.3 Final')
[END]
use that code and make a new .asp file and then put it in ur forum directory and then run ur MOD Setup and there u go.
then tell me if it works cos i carnt get ine to work now.
MaD2ko0l
© 1999-2002 MaD2ko0l
-=[ Life Is So Easy When You Are Evil ]=-
Massimo Farieri
===============
http://www.superdeejay.net/ |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 27 March 2002 : 06:51:43
|
It is something you have done, thes are stored with a date prefix, you have changed the way the forum formats dates, so the file library no longer works.
|
|
|
|
Topic |
|
Topic Locked
