| Author |
 Topic  |
|
Twiztid
Starting Member
USA
7 Posts |
 Posted - 12 July 2001 : 11:06:10
|
Sorry if someone posted this allready but i get these errors:
--------------------------------------------------------------------------------
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
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_AVATAR_URL' already exists in table 'FORUM_MEMBERS'.
Table(s) updated
|
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 12 July 2001 : 15:09:05
|
Twiztid,
try changing the strConnString that you are using in config.asp to one of the ones that is labeled for use with Access 2000. They use MS JET Drivers instead of the Microsoft ODBC Microsoft Access Driver. The Microsoft ODBC Microsoft Access Driver doesn't seem to support specifying a DEFAULT value in the T-SQL script. |
|
|
|
Twiztid
Starting Member
USA
7 Posts |
Posted - 12 July 2001 : 15:56:03
|
I did and it still doesnt work! 
|
|
|
|
Twiztid
Starting Member
USA
7 Posts |
Posted - 12 July 2001 : 16:41:09
|
I just tried to see if i could add avatars for the heck of it and i get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_AVATAR2'. Make sure it exists and that its name is spelled correctly.
/forum/admin_avatar_settings.asp, line 100
--------------------------------
But im sure if i get it to work it would go away
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 12 July 2001 : 17:34:42
|
Which database type do you have uncommented in your config.asp file?
The KEY statement that shows above should only get used if you have MySQL chosen in your config.asp file. |
|
|
|
Twiztid
Starting Member
USA
7 Posts |
Posted - 12 July 2001 : 18:07:13
|
I have the Mysql one
Edited by - twiztid on 12 July 2001 18:08:10 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 12 July 2001 : 18:38:58
|
| change it to "Access" |
|
|
|
Twiztid
Starting Member
USA
7 Posts |
Posted - 12 July 2001 : 18:39:14
|
Ok i redid it for the 6th time and now i get these errors:
Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID int COUNTER NOT NULL , A_URL text (255) NULL , A_NAME text (50) NULL , A_MEMBER_ID int NULL DEFAULT 0)
-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 )
Table created succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_AVATAR2 (A_HSIZE, A_WSIZE, A_BORDER) VALUES (64, 64, 0)
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding Column...
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'.
Table(s) updated
--------------------------------------------------------------------------------
NOTE: If you are online right now Please Contact Me Through YAHOO or AOL thanks
Edited by - twiztid on 12 July 2001 18:41:04
Edited by - twiztid on 12 July 2001 18:42:15 |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 12 July 2001 : 18:52:46
|
| you are still using the strConnString that is labeled for use with Access97. Change to one that is labeled for use with Access2000 and you should not get anymore errors. (the strConnString line that is labeled for use with Access2000 are MS JET Drivers) |
|
|
|
Twiztid
Starting Member
USA
7 Posts |
Posted - 12 July 2001 : 22:08:09
|
quote:
you are still using the strConnString that is labeled for use with Access97. Change to one that is labeled for use with Access2000 and you should not get anymore errors. (the strConnString line that is labeled for use with Access2000 are MS JET Drivers)
Ummm, No im not i changed it to access 2000. I still get the errors. Anyways I just going to leave the board plain right now since i am having problems with my web host.
|
|
|
|
Therion93
Junior Member
USA
263 Posts |
Posted - 02 August 2001 : 12:22:55
|
Is this MOD 3.3xx Friendly?
Therion93
News Ways, New Ways.....
Well I Dream Of Wires..
(Coming Soon) |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
acidbuk
Starting Member
1 Posts |
Posted - 02 August 2001 : 18:34:05
|
I installed the mod without an error but
when I go to my profile or registration no
Avatar Section shows I folowed all the instructions carefully but can someone help me please
AcidbUK
|
|
|
|
Pumaman
Starting Member
12 Posts |
Posted - 08 August 2001 : 16:52:44
|
Hey, I think I messed something pretty important up in topic.asp. None of the replies are showing up on the board, the avatar doesn't show, and the original message is black. The error message says:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'rs'
/plaidcarrots/topic.asp, line 539
If you need to look at the forum itself, here's the link: http://www24.brinkster.com/plaidcarrots/default.asp
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
Topic |
|
Topic Locked
