PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Photopost Pro Bug Reports (http://www.photopost.com/forum/photopost-pro-bug-reports/)
-   -   MySQL Error Report (http://www.photopost.com/forum/photopost-pro-bug-reports/140965-mysql-error-report.html)

deathdlr October 19th, 2009 05:57 PM

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.

Chuck S October 19th, 2009 08:22 PM

http://www.photopost.com/forum/revie...uf-field2.html

that should assist you

deathdlr October 20th, 2009 12:51 AM

Thanks Chuck. I read through those threads and I am not sure what it means. I looked at the vb3.php file in the subdirectory but for the life of me couldn't figure out what the heck to do. Can you give it to me in baby steps please.

Thank you in advance.

Chuck S October 20th, 2009 07:10 AM

Do you understand this?

http://www.photopost.com/forum/1187286-post2.html

deathdlr October 20th, 2009 10:12 AM

Unfortunately no.

Chuck S October 20th, 2009 10:20 AM

Well lets see if I can break this down.

1. our application is coded to pull certain default vbulletin fields one of those is location for profile info thats the field your missing.

2. You as the superadmin can make sure your vb config file under canrunqueries can make sure your admin userid normally 1 is in the config for that option

3. You should be able to login to your vb admin panel and under maintenance option see the run sql queries option

4. when you hit that option try entering the query I noted and see if your error dissappears.


All times are GMT -5. The time now is 09:27 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97