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?
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'