View Single Post
Old October 19th, 2009, 06:57 PM   #1 (permalink)
deathdlr
Junior Member
Verified Customer
 
Join Date: Jun 2008
Posts: 13
MySQL Error Report

Im not sure what I did. I have fbconnect installed for my vb. I had mapped facebook data for a long time. Yesterday I was looking at the other function when i mapped a second item. I was trying to link the facebook URL. anyway....

Since then I started getting an error report that says

Quote:
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,sigpic.filename,sigparsed.hasimages,avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar,u.avatarrevision FROM user u
LEFT JOIN userfield uf ON uf.userid=u.userid
LEFT JOIN session s ON s.userid=u.userid
LEFT JOIN usertextfield t ON t.userid=u.userid
LEFT JOIN sigpic AS sigpic ON sigpic.userid=u.userid
LEFT JOIN sigparsed AS sigparsed ON sigparsed.userid=u.userid LEFT JOIN avatar AS avatar ON (avatar.avatarid = u.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=28 LIMIT 1

The query returned with an errorcode of:

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

If you need assistence or feel this is a 'bug'; please report it to our support forums at: Photopost Pro Bug Reports - PhotoPost Community

To turn off these emails, set $debug=0 in your config-inc.php file.
i have had maybe 8 to 10 emails and the only difference i have found in them is in the bolded number above.

When you go to anywhere other than the gallery index page i get this error;

Quote:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in [path]/gallery/forums/vb3.php on line 175
I did delete the data mapping but still getting the same results.

Thanks for any help you can provide me.

Last edited by deathdlr; October 20th, 2009 at 01:52 AM.
deathdlr is offline   Reply With Quote