username and avatar not show in comments

[magmf]

as you can see here

http://under-linux.org/gallery/showp...3/limit/recent

i dont know why but my user avatar and my username is not showing in comments.

[magmf]

hello ???

Can anyone help me please

[Chuck S]

Are you showing any errors on your server logs? I would think there is an issue trying to run the query to get the user profile information.

Try also making sure you reupload all files and templates except the config files to ensure you are running all the proper files.

[magmf]

chuck i have no errors at log
and already reuploaded all files

[Chuck S]

What version of the software is this and you have a test user login to post here? NON ADMIN OF COURSE

[magmf]

user: teste
pass: teste

[magmf]

vBulletin® Version 3.6.4
and Photopost 562

[magmf]

Query: SELECT u.username,u.homepage,u.usertitle,u.posts,u.joindate,uf.field2,s.host,t.signature,avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar,u.avatarrevision FROM vbuser u LEFT JOIN vbuserfield uf ON uf.userid=u.userid LEFT JOIN vbsession s ON s.userid=u.userid LEFT JOIN vbusertextfield t ON t.userid=u.userid LEFT JOIN vbavatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN vbcustomavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=36026 LIMIT 1

Result: Unknown column 'uf.field2' in 'field list'

Database handle: Resource id #21


i Found this error in debug mode

[magmf]

Well i chage this code in vb3.php

i remove uf.field2

Content visible to verified customers only.

And now username works but i cant see avatar is there something to do to show avatars ?

[Chuck S]

You can add field2 back to the userfield table in vb database as far as avatars try this in vb3.php

http://www.photopost.com/forum/showp...4&postcount=85

[magmf]

Chuck i dont have field2 in my userfield table.


i solved the problem with avatars but i want understand.

Content visible to verified customers only.

as you can see he enter in if ( isset($avpath) )
but i think is wrong and they need to enter in elseif ( $vboptions['usefileavatar'] && $hasav == 1 )

and i dont know why but {$avrev} is comming with no value so i need to force 1 to make it work.

Is this make any sense to you ?

[Chuck S]

You must use the code exactly as I posted why are you commenting out something? I can show many sites where this works fine. avref has nothing to do with anything that I see as that value comes right out of the database. If avpath is not null your using an external avatar and must use as posted without commenting anything out. I think we have any variables on avatars covered with the code above and have supported vb3 for many years and made changes as they have evolved to support various avatars.

[magmf]

Chuck

Content visible to verified customers only.

This code does not work for me (


but this code

Content visible to verified customers only.

is working fine ....

[magmf]

But i have a big problem...
if avatar is _2 or _3 or _4 ....
this code will not work.. i dont know why but i cant get avrev value...

[Chuck S]

There must be something your not understanding what I am saying. $avrev is simply a value we pull from your vbulletin avatar table so if it is 1 2 3 or 4 does not matter we pull what it is. $avrev has nothing to do with anything concerning $avpath

If your having issues first use the default code and show us a link to your site with the default code so we can see what is there.

$avpath is something else to my recollection and has to do with using the stored avatars you pick from vbulletin. I can do some testing though

[magmf]

SOLVED!!!

CHUCK SORRY FOR THE INCOVENIENCE ...


THE PROBLEM WAS SOOOOOOOOO SIMPLE TO SOLVE AUHuhAUHAuh

I BACK WITH .ZIP CODE and only change field2 to field5 in vb3.php and now everything is working fine.

But i really dont know why i have field5 instead of field2

i think you need to make some check if field2 exists because if i have this problem problably other people has.

[Chuck S]

This is why I noted two posts ago you had to add that field back in cause the user profile data is an array and if you change the query you change the array which is going to change what stuff is assigned where.

[magmf]

sorry for this (

I really like photopost and i will buy next month review and classified for my website thanks for your help.