Author |
Topic |
|
HarlekinWF
New Member
Germany
77 Posts |
Posted - 01 May 2002 : 07:07:15
|
i get following error..
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.
/admin_add_avatar.asp, line 90
who has same mod installed and can help me?
i need the entries in the database
that must the problem that 1 table is missing
P.S. Forum "Help: MOD Implementation" dont work error '80004005' Unspecified error /forum/forum.asp, line 230
cu Harlekin
http://forum.killers-in-action.com
mIRC server : QuakeNet - Random german server channel: #killers-in-action |
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
HarlekinWF
New Member
Germany
77 Posts |
Posted - 01 May 2002 : 12:30:20
|
sorry, but i dont't know how this help me...
i use a dsn so i have a other strConnString my: strConnString = "DSN=TF2HQ_kia_data"
i had no errors when installing. i think one line in database (mdb-file) is missing, so the error comes.
now i want to know if i can add a table-line manuell with ms access
cu Harlekin
http://forum.killers-in-action.com
mIRC server : QuakeNet - Random german server channel: #killers-in-action
Edited by - HarlekinWF on 01 May 2002 12:32:51 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 01 May 2002 : 12:35:20
|
Yes, you can add it manually using Access if you want. |
|
|
HarlekinWF
New Member
Germany
77 Posts |
Posted - 01 May 2002 : 12:41:22
|
but now i want to know which i must where add?
seems that i have often that problem with the dbm-file. something wrong with my constring?
cu Harlekin
http://forum.killers-in-action.com
mIRC server : QuakeNet - Random german server channel: #killers-in-action |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 01 May 2002 : 12:48:26
|
The MOD Setup file is not setup to handle DSN's because there is no easy, reliable way to know what type of driver the DSN is using.
Try downloading the updated version of the MOD Setup file from the link I posted above. |
|
|
HarlekinWF
New Member
Germany
77 Posts |
Posted - 01 May 2002 : 13:19:59
|
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'.
this comes as message back. i have allready the new admin_mod_dbsetup.asp which tables must be included in my dbm-access-file?
cu Harlekin
http://forum.killers-in-action.com
mIRC server : QuakeNet - Random german server channel: #killers-in-action |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 01 May 2002 : 13:41:30
|
you need to create a table called FORUM_AVATAR
This table should have the following fields:
Fieldname: A_ID datatype: Autonumber (set to Primary Key also)
Fieldname: A_URL datatype: Text FieldSize: 255
Fieldname: A_NAME datatype: Text FieldSize: 50
Fieldname: A_MEMBER_ID datatype: Number FieldSize: Integer |
|
|
HarlekinWF
New Member
Germany
77 Posts |
Posted - 02 May 2002 : 07:57:47
|
thnx, that works.. i cann add avatars now.
next problem: avatars not shown in forum, can not choose in profile, not in register.
cu Harlekin
http://forum.killers-in-action.com
mIRC server : QuakeNet - Random german server channel: #killers-in-action |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 02 May 2002 : 09:43:40
|
double check the edits you made to the inc_profile.asp & topic.asp files. |
|
|
HarlekinWF
New Member
Germany
77 Posts |
Posted - 02 May 2002 : 12:20:10
|
thnx.. a bug was included
now it works great.
i included the modaddon that show all use avatars in members, really cool.
cu Harlekin
http://forum.killers-in-action.com
mIRC server : QuakeNet - Random german server channel: #killers-in-action |
|
|
|
Topic |
|