| Author |
 Topic  |
|
|
osdd
New Member
Canada
54 Posts |
 Posted - 16 July 2002 : 22:03:21
|
Hi all
io have download the avatar mod from here. i can get it to work but i can' upload any avatars to it i keep getting this error
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.
/test/admin_add_avatar.asp, line 90
i have add what is need to the files it says to modify in the read me but i think i missed something? i very new to asp work.
i'm using the latest version of snitz too (3.3.05)
Also since adding this mod the registering of new members is very very slow at load and doesn't fully load at times.
"Because I said so."
Edited by - osdd on 16 July 2002 22:05:20
Ruirib: Moved to the Help: MOD Implementation forum
Edited by - ruirib on 16 July 2002 22:07:29 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 July 2002 : 22:09:01
|
Make sure you follow the mod's instructions, in this case setting up the mod by executing MOD setup from the MOD setup command in Admin Options.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
osdd
New Member
Canada
54 Posts |
Posted - 16 July 2002 : 22:13:10
|
I have done that because i use this forum to find help ealier in the day after having install the new admin_mod_dbssetup.asp. i still get the error above. and i have done everthing the readme file told me to do also
"Because I said so." |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 16 July 2002 : 22:55:25
|
| that error means that the table in the database does not exist. It has not been created yet. You will need to create the table in the database before this will work. |
|
|
|
osdd
New Member
Canada
54 Posts |
Posted - 17 July 2002 : 19:11:37
|
As am a newbie to asp how the blip do you do that
"Because I said so." |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 July 2002 : 19:41:22
|
After changing the connection string as shown in Richard's posted link, you need to go to Admin Options, click over the MOD Setup link there and install the Avatar mod, by choosing it from the drop-down box and then clicking the Update button.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
osdd
New Member
Canada
54 Posts |
Posted - 18 July 2002 : 08:59:23
|
OK since the forum it is going into is still in the test phase i wipe the old files out and restart from scratch. and i'm still getting the same error everytime i try to upload an avatar pic. what is there to do now. i'm also inerested in finding a way to add more rank structure for our forum is there a way to add more ranks?
"Because I said so." |
|
|
|
osdd
New Member
Canada
54 Posts |
Posted - 22 July 2002 : 18:23:28
|
Still getting this error while trying to add avatars:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.
/test/admin_add_avatar.asp, line 90
here is a link to my admin_add_avatar.asp in text form
http://iafs.tf2hq.com/admin_add_avatar.txt
if you need links to any of the others files that need to be modified let me know and i'll create them for you. or should i wait for 3.4 since i heard that it is incude in this version.
"Because I said so."
Edited by - osdd on 22 July 2002 18:24:26
Edited by - osdd on 22 July 2002 18:25:57 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 July 2002 : 18:52:04
|
quote:
After changing the connection string as shown in Richard's posted link, you need to go to Admin Options, click over the MOD Setup link there and install the Avatar mod, by choosing it from the drop-down box and then clicking the Update button.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Have you done this?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
osdd
New Member
Canada
54 Posts |
Posted - 22 July 2002 : 21:07:01
|
i have done everthing that was suggest but still get that error
little history about server it use DSN only.
strConnString = "DSN = Server_info
what strDBtype should i be using with the DSN string?
"Because I said so."
Edited by - osdd on 22 July 2002 21:25:32 |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 22 July 2002 : 21:26:33
|
quote:
After changing the connection string as shown in Richard's posted link, you need to go to Admin Options, click over the MOD Setup link there and install the Avatar mod, by choosing it from the drop-down box and then clicking the Update button.
What happened after you did that? Did it tell you it was successful creating the table or did you get errors on the mod setup page as well?
Nikkol |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 22 July 2002 : 21:28:28
|
quote:
i have done everthing that was suggest but still get that error
little history about server it use DSN only.
strConnString = "DSN = Server_info
what strDBtype should i be using with the DSN string?
"Because I said so."
Edited by - osdd on 22 July 2002 21:25:32
That depends on what kind a database you are using. If you are using the one that came in the download (the .mdb file) then it is access.
Nikkol |
|
|
|
osdd
New Member
Canada
54 Posts |
Posted - 22 July 2002 : 21:30:16
|
this is what it said
Avatar Mod v2.0
Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , A_URL text (255) NULL , A_NAME text (50) NULL , A_MEMBER_ID int NULL )
Table already exists
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_AVATAR2( A_HSIZE int NULL , A_WSIZE int NULL , A_BORDER int NULL )
Table already exists
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_AVATAR2 (A_HSIZE, A_WSIZE, A_BORDER) VALUES (64, 64, 0)
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_AVATAR_URL text (255) NULL
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_AVATAR_URL text (255) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_AVATAR_URL' already exists in table 'FORUM_MEMBERS'.
--------------------------------------------------------------------------------
"Because I said so." |
|
|
| |
Topic |
|
Topic Locked
