| Author |
 Topic  |
|
|
Hazelip
Starting Member
USA
16 Posts |
 Posted - 19 October 2004 : 21:07:46
|
MOD installed: Avatar Mod for 3.4
Location MOD retrieved: http://www.snitzbitz.com/mods/details.asp?Version=All&mid=52
Forum version: Snitz Forums 2000 Version 3.4.05
Deviation from Readme.html included in zip: I followed the instructions for adding code for version 3.4.0.3 when editing the topic.asp page
Problem:
Since installing this mod, and customizing the files indicated in the bundled Readme.html, I am unable to update my profile. I have attempted to change my e-mail address multiple times, and ran Check Installation twice. I have closed and re-opened my web browser between Check Installation attempts.
Other question, confusion:
The avatar section in the profile does not have an option to link to an off-site avatar. Since the instructions did not detail where to upload a selection of avatars for users, I'm confused as to why the selection is apparently attempting to retrieve a list of avatars for a user to select. Have I missed a step, perhaps?
Thank you for any and all assistance,
Jake
EDIT:
I found the Avatar settings pages. I would still prefer that forum users be able to link to off-site avatars.
Edit2:
I can't seem to upload ANY avatars through the Avatar Settings dialogs. What the hell..? |
Edited by - Hazelip on 19 October 2004 21:22:14 |
|
|
Hazelip
Starting Member
USA
16 Posts |
Posted - 20 October 2004 : 06:27:04
|
New information. When I go to review/edit avatars, I receive this error:
quote:
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
I did install the MOD through the Admin Options page.
EDIT:
I just tried to add an avatar that I manually uploaded with my FTP client by entering the URL path to the file, titling it, and reserving it for myself. When I click submit, I get the following error:
quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.
/forum/admin_add_avatar.asp, line 100
When I run the MOD Setup for the Avatar MOD, I receive the following errors:
quote:
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 successfully
I also think I received that first error about the FOURM_AVATAR table value the first time I ran MOD installation. I don't know why as I've not tinkered with any other avatar MOD. Heck, I can't even find another one, or I'd be using it now, this thing is so frustrating. |
Edited by - Hazelip on 20 October 2004 06:33:27 |
 |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
Hazelip
Starting Member
USA
16 Posts |
Posted - 20 October 2004 : 06:57:24
|
I still get the same error that the table already exists. Yet, when I download the DB to my desktop, it is not there.
Also, that does not explain why, when full permissions are granted to iuser for both the DB directory and the MDB itself, that I cannot even update my e-mail address anymore... |
|
|
|
Hazelip
Starting Member
USA
16 Posts |
Posted - 20 October 2004 : 07:46:11
|
Well, I got the table issue resolved. Apparently, you cannot add the table when connecting through a named DSN. I changed the connection string, and viola! It worked.
Now, I just need to remove the automatic resizing of avatar images, and figure out where the option to point to a custom off-site avatar is.
But, I still have a MAJOR problem. I am still unable to update my e-mail address in my profile. Since I can add avatars, and assign them to my ID, I know the DB has the correct permissions.
Any idea why this would bork up after installing the avatar MOD? |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
Hazelip
Starting Member
USA
16 Posts |
Posted - 20 October 2004 : 17:23:45
|
Thank you, I will install your MOD immediately!
No, no error. As a matter of fact, I get the response page that indicates that the e-mail address has been updated. But, when I go back to edit the profile, or to view the profile and click on the e-mail link, it's back to you@yourhost.com. I'm pulling my hair out over that one... |
|
|
|
Hazelip
Starting Member
USA
16 Posts |
Posted - 20 October 2004 : 18:19:21
|
quote:
Originally posted by Hazelip
Thank you, I will install your MOD immediately!
Correction. I would install it, if I could understand the following:
quote:
Step.3
7 files need modified...... (do'nt worry, all are simple modification... ^_^ )
config.asp
===============================
'##### My Avatar addon 1-1 : add below 1 line
'##### My Avatar addon 1-2 : add below 5 lines
inc_avatar.asp
===============================
'##### My Avatar addon 1-1 : add 1 new function NewOpenWindow to below section
'##### My Avatar addon 1-2 : replace above line with below 13 lines
'##### My Avatar addon 1-3 : replace above 4 lines with below 5 lines
admin_avatar_home.asp
===============================
'##### My Avatar addon 1-1 : remove above line & _ and add below 11 lines
admin_add_avatar.asp
===============================
'##### My Avatar addon 1-1 : modify/break above line and add below 1 section
admin_review_avatar.asp
===============================
'##### My Avatar addon 1-1 : modify/break above line and add below 1 section
admin_edit_avatar.asp
===============================
'##### My Avatar addon 1-1 : add below 3 lines
'##### My Avatar addon 1-2 : add below 12 lines
'##### My Avatar addon 1-3 : add below 2 lines
'##### My Avatar addon 1-4 : add below 1 line
'##### My Avatar addon 1-5 : modify/break above line and add below 1 section
'##### My Avatar addon 1-6 : add below 1 section
topic.asp
===============================
'##### My Avatar addon 1-1 : replace above line with below 5 lines
'##### My Avatar addon 1-2 : replace above line with below 5 lines
'##### My Avatar addon 1-3 : add below 1 new function
 Wha..?
I've tried and tried. I can't make any sense out of those edit instructions.
Okay, summary time.
I've got the avatars MOD working. Sort of. I still need to figure out how to get rid of that resizing garbage. That's going to take me some time, as I don't understand where the height and width code is being obtained. I want to allow users to point to off-site images for their avatars, but I can't understand the My Avatar Mod enough to accomplish that.
Oh, and the e-mail address field is still not updating in the profile. THAT is my biggest concern, and it only appeared after I attempted to use the avatar MOD. I really, really, really need help with that one. |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
| |
Topic |
|
|
|
Topic Locked
