| Author |
 Topic  |
|
|
theninjagecko
Starting Member
12 Posts |
 Posted - 21 July 2001 : 19:32:57
|
ok im installing the avatars mod version 2.0. i extract the files and edit the ones that you are suppossed to. i hen carry on the the mod_dbsetup.asp this is the error im getting
Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID INT (11) DEFAULT '' NOT NULL auto_increment , A_URL varchar (255) NULL , A_NAME varchar (50) NULL , A_MEMBER_ID int NULL DEFAULT 0,KEY FORUM_AVATAR_A_ID(A_ID))
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_AVATAR2( A_HSIZE int NULL , A_WSIZE int NULL , A_BORDER int NULL ,KEY FORUM_AVATAR2_())
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in field definition.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_AVATAR2 (A_HSIZE, A_WSIZE, A_BORDER) VALUES (64, 64, 0)
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR2'.
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_MEMBERS ADD M_AVATAR_URL varchar (255) NULL
Column added successfully
Table(s) updated
can someone helop me plz, im running Win2k
and also am running own server on it.
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 21 July 2001 : 19:53:23
|
| Have you tried changing the strConnString line you are using in your config.asp file from one that is labeled for use with Access97 to one labeled for use with Access2000 ? |
 |
|
|
theninjagecko
Starting Member
12 Posts |
Posted - 21 July 2001 : 20:16:54
|
thanks alot for replying, im gonna try it now :)
|
|
|
|
theninjagecko
Starting Member
12 Posts |
Posted - 21 July 2001 : 20:21:35
|
well i gotta say m8, you are a god 
|
|
|
|
theninjagecko
Starting Member
12 Posts |
Posted - 21 July 2001 : 20:36:25
|
just one more problem, when i select an avatar to use for myself, it doesnt save my settings?
an ideas?
|
|
|
|
theninjagecko
Starting Member
12 Posts |
Posted - 21 July 2001 : 21:41:50
|
this is realy strange, normal members can display there avatars but cus im in there as the admin then my avatar wont display?
|
|
|
| |
Topic |
|
Topic Locked
