Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Avatar problems !
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Fasael Rehman
Starting Member

Denmark
22 Posts

Posted - 14 June 2001 :  06:34:50  Show Profile  Visit Fasael Rehman's Homepage  Send Fasael Rehman an ICQ Message
Hi, during the implementation of Avatar I got following messages (can anyone help me?)

What does the syntax error mean? And what will the consequences be?

Avatar Mod v2.0

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
Column added successfully
Table(s) updated

--------------------------------------------------------------------------------
There were errors please post a question in the MOD Implementation Forum !



Edited by - Fasael Rehman on 14 June 2001 06:36:41

Old Ager
New Member

Italy
59 Posts

Posted - 14 June 2001 :  14:34:40  Show Profile  Visit Old Ager's Homepage  Send Old Ager an ICQ Message
I could be wrong, but make sure you're using the version of mod_dbsetup.asp that came in the Avatar ZIP. I had a similar problem on a mod I was installing. I thought any mod_dbsetup.asp would work, but it only worked when i used the version that came with the MOD.

Hope this helps.


Old Ager
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 14 June 2001 :  15:37:29  Show Profile
the strConnString labeled for use with Access97 in your config.asp file does not support setting a DEFAULT value in the CREATE table statement. You should try using one the strConnStrings in config.asp that is labeled for use with Access2000.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.37 seconds. Powered By: Snitz Forums 2000 Version 3.4.07