Hi there,
I am running Snitz Forum v3.4.05 with MySQL 4.1.8-nt, MySQL ODBC 3.51 driver on a Windows 2000 Advanced Server box running IIS 5 - When I went to install the Avatar MOD everything went through a-okay except for the following table error (This happened on creation)
I go to install the mod using the admin function and the DBS file... It runs thogh the error on the screen looks like this
Avatar Mod for 3.4
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))
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))
-2147217871 | [MySQL][ODBC 3.51 Driver][mysqld-4.1.8-nt]Invalid default value for 'A_ID'
--------------------------------------------------------------------------------
Adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS ADD M_AVATAR_URL varchar (255) NULL
ALTER TABLE FORUM_MEMBERS ADD M_AVATAR_URL varchar (255) NULL
<snip><snip>... The rest runs through without an error
The Parameter passed to MySQL when this error occurred is as follows (Highlighted in RED)
Filename: dbs_avatar.asp
Avatar Mod for 3.4[CREATE]
AVATAR
A_ID
A_URL#varchar (255)#NULL#
A_NAME#varchar (50)#NULL#
A_MEMBER_ID#int#NULL#0
[END]
[ALTER]
MEMBERS
ADD#M_AVATAR_URL#varchar (255)#NULL#
[END]
[ALTER]
MEMBERS_PENDING
ADD#M_AVATAR_URL#varchar (255)#NULL#
[END]
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('intShowAvatar','1')
(C_VARIABLE,C_VALUE)#('strAvatarFolder','avatars/')
(C_VARIABLE,C_VALUE)#('intAvatarWidth','64')
(C_VARIABLE,C_VALUE)#('intAvatarHeight','64')
(C_VARIABLE,C_VALUE)#('intAvatarBorder','1')
[END]
The rest of the tables created successfully - I pressed on and installed the rest of the mod using the readme.html file. Can anyone help me with the error shown here 
Thanks
Phil
|
Topic Locked
Posted - 25 December 2004 : 15:04:57
