MySQL Error on new install

[djroketboy]

I just got a error when posting a comment:

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 FROM user u
LEFT JOIN userfield uf ON uf.userid=1
LEFT JOIN session s ON s.userid=1
LEFT JOIN usertextfield t ON t.userid=1
WHERE u.userid=1 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: http://www.photopost.com/members/forum/f66/index.html

To turn off these emails, set $debug=0 in your config-inc.php file.

[djroketboy]

almost 24 hours and no help?

[Lee Wilde]

I have the exact same problem and I need a fix ASAP please - launching my site this week!

[Michael P]

field2 is a vB field, not a photopost field. Did you remove it from your vB installation?

[Lee Wilde]

Well, I don't know what it was before...I can't remember deleting a "field2" but thanks for pointing me in the right direction. I added field2 back into vb_userfield. Its solved the immediate problem. Lets see if my solution causes a problem somewhere else!

Who was it who said, "A little knowledge is a dangerous thing." ?? lol

[Michael P]

We designed it to work with the basic vB setup, in some cases where people might remove fields from the db its hard to compensate for that in our code.

[dethfire]

I get this error with my photopost install and I never touched anything called 'uf.field2' in 'field list

[Bryan Ex]

dethfire... userfield2 is used by VB for the "Location" info on profiles. Have you deleted that option in your admin (maybe?).