Execution of a Query Error *******

[nuguru]

Hello Everyone,

Recently I've been getting this error email and I was wondering how to fix the problem. It says that the problme is

"The query returned with an errorcode of: Unknown column 'uf.field2' in 'field list'"

I don't know what this is referring to. I am not sure if this is only a photopost php pro problem or also a review post problem but I did notice that I am missing the author name in both products. for example for photopost visit: here
and for reviewpost visit here.

In both cases you'll see that the Author name is missing down in the left hand column. I don't know if this has anything to do with the query error or not. It's a possibility that when these pages load, that the query below is sent and because there is a problem, that the author name is not showing up. Possible, I don't now?

Thank You,

Nuguru

Email that I am constantly receiving:

An error was encountered during execution of the 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 web_user u
LEFT JOIN web_userfield uf ON uf.userid=u.userid
LEFT JOIN web_session s ON s.userid=u.userid
LEFT JOIN web_usertextfield t ON t.userid=u.userid LEFT JOIN web_avatar AS avatar ON (avatar.avatarid = u.avatarid)
LEFT JOIN web_customavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=39 LIMIT 1

The query returned with an errorcode of:

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

[Chuck S]

mysql_fetch_row(): supplied argument is not a valid MySQL result resource in

[nuguru]

Chuck,

The link you provided was perfect in providing the indication that field2 was missing. I replaced that field and the Author shows back up in both products and I have not recieved any error emails yet.

Do you know what could of been the initial cause of field2 going missing?

Thanks Again,

Nuguru

[Chuck S]

I beleive you can delete database fields in vbulletin and that would cause the field.