| Author |
 Topic  |
|
|
jvolpe30
Starting Member
25 Posts |
 Posted - 19 March 2004 : 11:08:09
|
I am still trying to get my avatar feature to work. I edited all the code exactly as instructed. I uploaded the edited files, then went to MOD Setup and updated. Here is what I get:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Avatar Mod for 3.4
Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I am able to add avatars and they show up in the edit option on the menu. They DO NOT show up in the posts, AND if you go to a member's profile, it says None Selected under Avatar when there is clearly an avatar assigned.
Would it helped is I posted my Topic.asp code?? Please, Please can someone solve this issue!! I want to get back to building my site, but this is taking up all of my time. Thanks in advance for any and all assistance -- it is much appreciated!!!
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 19 March 2004 : 11:28:13
|
First you need to check your database and see if M_AVATAR_URL exists in the member table.
If it does, then re-check that you added all the necessary code into pop_profile.asp, inc_profile.asp, and in register.asp. As long as the selected avatar isn't saved when editing a profile, it will not show up in topics.asp either. If you need help, post a link to a text-version of those files and I'll check them. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
 |
|
|
jvolpe30
Starting Member
25 Posts |
Posted - 19 March 2004 : 11:32:29
|
Thanks for your fast response!! How do I check the DB to look for M_AVATAR_URL in the member table?
Thank you very, very much!! |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 19 March 2004 : 11:49:09
|
You happened to post just before I came here, thus explaining my fast response  .
You can download the database to your computer and check it there, or you can use the free application called Table Editor to view your database online. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
jvolpe30
Starting Member
25 Posts |
|
|
jvolpe30
Starting Member
25 Posts |
Posted - 19 March 2004 : 12:23:09
|
I just checked the M_AVATAR_URL in the member table of the DB and the column does indeed exist. Most entries are blank while some say NO AVATAR.
Thanks!! |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 19 March 2004 : 16:06:21
|
| Those files looks ok to me, so the problem must lie somewhere else. I tried to visit your forum, but it seems to experience some problems at the moment. It will not load for me. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
jvolpe30
Starting Member
25 Posts |
Posted - 19 March 2004 : 17:03:03
|
| Now I can not access the forum at all? All the rest of my web pages open right up, but the forum just drags and wont open the forums? what could have happened? |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 19 March 2004 : 18:16:01
|
I figured it to be a server-problem, and it seems to be working now.
I took a look at your register.asp, and I noticed that there are no avatars to choose. Have you added any avatars in the Avatar Setup admin page? |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 19 March 2004 : 19:20:32
|
quote:
Originally posted by masterao
I took a look at your register.asp, and I noticed that there are no avatars to choose. Have you added any avatars in the Avatar Setup admin page?
Same here. No avatars showing in the register |
_-/Cripto9t\-_ |
|
|
|
jvolpe30
Starting Member
25 Posts |
Posted - 19 March 2004 : 22:44:46
|
| I have 2 avatars loaded up. Both of which are spoken for and assigned to members. Maybe thats why they dont show on the list. However they dont show up on the profile or in posts either. Thanks again for the help guys |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 20 March 2004 : 05:52:45
|
Yes, that is the reason. Giving ownership of an avatar to a member means that only that member can choose the avatar, but not that it will display as his avatar by default. That member must edit his profile an choose the assigned avatar, otherwise it will not be shown as his avatar.
You need to add some avatars that isn't owned by anyone, so that a member can choose an avatar upon registration as well as when editing their profile. Besides that, the mod seems to have been added correctly. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
jvolpe30
Starting Member
25 Posts |
Posted - 20 March 2004 : 11:09:41
|
BINGO!! Avatar feature seems to be working now. Thank you so much for your assistance. I think I got so caught up with all of this computer code stuff that I overlooked the obvious.
Anyway, your help is greatly appreciated!!
Now I will attempt to add the PM feature. Wish me luck!! |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 20 March 2004 : 14:04:18
|
Im glad to have been of assistance.
Good luck with the PM mod. A little tip, check the Help: MOD Implementation forum for PM topics, as that is a good way to see the most common mistake with that mod. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
| |
Topic |
|
Topic Locked
