MySQL Error on new install
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.
almost 24 hours and no help?
I have the exact same problem and I need a fix ASAP please - launching my site this week!
field2 is a vB field, not a photopost field. Did you remove it from your vB installation?
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
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. :D
I get this error with my photopost install and I never touched anything called 'uf.field2' in 'field list
dethfire... userfield2 is used by VB for the "Location" info on profiles. Have you deleted that option in your admin (maybe?).
|All times are GMT -5. The time now is 01:28 AM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0