| Author |
 Topic  |
|
|
riffle
Starting Member
10 Posts |
 Posted - 03 January 2003 : 15:01:03
|
ok im really new at this, i installed the snitz forum and it works pefectly, a few days back i was going thru here and decided to add the avatar mod, did so like it said in the readme, everything went fine, the avatar menu appeared in the admin section and in registeration form, BUT, a few problems i ran int o:
when i was updating the db via admin>mod setup, i encountered the following error:
Avatar Mod for 3.4
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
--------------------------------------------------------------------------------
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'.
--------------------------------------------------------------------------------
Adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS_PENDING ADD COLUMN M_AVATAR_URL text (255) NULL
ALTER TABLE FORUM_MEMBERS_PENDING ADD COLUMN M_AVATAR_URL text (255) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_AVATAR_URL' already exists in table 'FORUM_MEMBERS_PENDING'.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intShowAvatar','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strAvatarFolder','avatars/')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAvatarWidth','64')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAvatarHeight','64')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAvatarBorder','1')
Value(s) updated succesfully
2ndly when i go to admin>avatars>review/edit avatars i get the following 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_AVATAR'. Make sure it exists and that its name is spelled correctly.
/forum/admin_review_avatar.asp, line 84
and line 84 is this:
'##### Get Avatar's from DB
strSql = "SELECT " & strTablePrefix & "AVATAR.A_ID"
strSql = strSql & ", " & strTablePrefix & "AVATAR.A_URL"
strSql = strSql & ", " & strTablePrefix & "AVATAR.A_NAME"
strSql = strSql & ", " & strTablePrefix & "AVATAR.A_MEMBER_ID"
strSql = strSql & " FROM " & strTablePrefix & "AVATAR "
strSql = strSql & " ORDER BY " & strTablePrefix & "AVATAR.A_ID ASC;"
set rsAvatar = Server.CreateObject("ADODB.Recordset")
rsAvatar.cachesize = 20
rsAvatar.open strSql, my_Conn, 3
if rsAvatar.EOF then
recAvatarCount = ""
else
allAvatarInfo = rsAvatar.GetRows(adGetRowsRest)
recAvatarCount = UBound(allAvatarInfo,2)
errm wht am idoing wrong? |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
|
|
riffle
Starting Member
10 Posts |
Posted - 03 January 2003 : 16:18:10
|
| well as for the link u gave im using dsn and the rest of the forum is perfectly fine, but i downloaded the db and there was no FORUM_AVATAR table in it, so i manually added it reuploaded it and voila! works..thnx m8..the solution was obvious yet it eluded me..shucks :P |
 |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 03 January 2003 : 16:28:01
|
| Did you check the other avatar fields were there as well? The ones in the FORUM_MEMBERS, FORUM_MEMBERS_PENDING and FORUM_CONFIG_NEW? |
|
|
|
riffle
Starting Member
10 Posts |
Posted - 04 January 2003 : 10:46:57
|
| well yes i did and the rest are fine however, in the forum_config_new table the strAvatarFolder field is repeated 3 times and its value is Avatars/ whereas the folder i specified for the avatar images was images/ , the avatar admin is working, the avatars appear int he regiteration form too, but therez a image with a cross sign under the persons nick if he selects an avatar, when he posts, i redid the topic.asp section using the readme, but still no luck.. |
|
|
| |
Topic |
|
|
|
Topic Locked
