| Author |
 Topic  |
|
jprukop
Starting Member
USA
3 Posts |
 Posted - 16 April 2001 : 13:37:15
|
Hello,
First I want to say thank you for this GREAT forum and software! All who have coded, scripted and modded deserve glowing accolades. Thanks!
I was trying this Avatar mod/add-on and this is what I get:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'FORUM_REPLY.R_DATE FORUM_MEMBERS.M_AVATAR_URL'.
/topic.asp, line 175
After installing the mod, I can no longer access previous posts or make a new one because this error appears. Can anyone help? Thanks.
Jeff |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 16 April 2001 : 16:28:01
|
looks like you inserted the code in the wrong place in topic.asp
you need to make sure to insert it exactly like is shown in the instructions. |
|
|
|
adamch25
Starting Member
USA
22 Posts |
Posted - 16 April 2001 : 18:40:21
|
Richard,
I was wondering if you had a way of allowing the user to upload their own avatar and use it? I've seen other forums (not Snitz) that allow you to upload a custom avatar. I think this would be an awesome addition to your already awesome mod! You could even make it as an option that the Admin can turn off and on. Let me know.
Adam Henriksen
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
adamch25
Starting Member
USA
22 Posts |
Posted - 17 April 2001 : 10:03:11
|
I am working on the code that will allow the user to upload their own avatar to the forum. I will post the code when I'm finished.
|
|
|
|
Therion93
Junior Member
USA
263 Posts |
Posted - 19 April 2001 : 01:07:45
|
quote:
are you going to the edit profile page or the view profile page?
If you have edited all of the files correctly, when you edit your profile, you should have a place to choose an Avatar.
Is a preview of the avatar supposed to show somewhere when a user edits his/her profile? If so, I have a problem, it's not showing the preview.
Therion93
Because Legends Never Die! - Kiss-Forever.Net - HuwR's SR4 Release |
|
|
|
Phoenix
Starting Member
21 Posts |
Posted - 19 April 2001 : 13:01:38
|
i installed it and the admin all worx right, but for some reason, I dont see the avitars on the forums. any idea y that may be?
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 April 2001 : 15:19:57
|
Therion93, I looked at your forum and the preview shows up on the register screen. It should also work on the edit profile screen.
Phoenix, can you post a url to your forum? Have you selected an Avatar for yourself? |
|
|
|
hevnsnt
Starting Member
USA
10 Posts |
Posted - 19 April 2001 : 19:31:06
|
Dumb question, but where do we get the avatars at? Is there any sample ones around?
|
|
|
|
Marino
Starting Member
Canary Islands
42 Posts |
Posted - 19 April 2001 : 21:31:23
|
what do you think about changing that line
strSql = strSql & " ORDER BY " & strTablePrefix & "AVATAR.A_ID ASC;"
for this one?
strSql = strSql & " ORDER BY " & strTablePrefix & "AVATAR.A_NAME ASC;"
In my case I prefer to show avatars ordered by name rather than the order I inserted them in the db.
Marino
 |
|
|
|
ki5ck
New Member
69 Posts |
Posted - 20 April 2001 : 15:59:43
|
quote:
what do you think about changing that line
strSql = strSql & " ORDER BY " & strTablePrefix & "AVATAR.A_ID ASC;"
for this one?
strSql = strSql & " ORDER BY " & strTablePrefix & "AVATAR.A_NAME ASC;"
In my case I prefer to show avatars ordered by name rather than the order I inserted them in the db.
Marino
Great idea!! I just changed mine!
Paul Wood 
SLT Webmaster |
|
|
|
{HaK}Biosphere
Starting Member
United Kingdom
8 Posts |
Posted - 22 April 2001 : 21:14:03
|
Awesome addon I gotta admit.
Okay, I have a problem, when someone tries to click the register button they come up with a error. I'm running the forum from my machine and I've check it and the error message is a 500.100 and the file causing it is inc_mail.asp @ line 115
It also says sent 296 bytes and then a really long string of code. Is it possible that the inc_mail.asp file doesn't know what to do with the extra info from the Avatar option and causes it to bail?
IF ya wanna see it working my ip always changes and you can contact me on ICQ 108303174, I understand if ya dont :o)
=========================
The Devil **** Thee Black
========================= |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 22 April 2001 : 21:32:10
|
| If you post the IP I can take a look at it right now. I'm at work, so I can't get on ICQ. |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
Posted - 30 April 2001 : 03:22:45
|
Thanks a lot, Richard, for this fantastic mod.... great work!!!
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 30 April 2001 : 03:29:39
|
You're welcome 
Glad ya like it. |
|
|
|
Topic |
|
Topic Locked
