PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > General Forums > General Discussion

General Discussion General use discussion forum for PhotoPost products.

Reply
 
Thread Tools Rate Thread Display Modes
Old June 2nd, 2014, 12:21 PM   #1
dj83
Member
Verified Customer
 
Join Date: Sep 2008
Posts: 221
Problem with pp with mybb

Hello Chuck,

I just switched over to mybb and integrated photo post 7.1 with it. I am getting the following error at the top of my photo site...

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/dano925/public_html/gallery/forums/mybb.php on line 138

And also avatars, titles etc aren't showing. Pic below
nb.jpg


How can I fix this?
dj83 is offline   Reply With Quote
Old June 2nd, 2014, 03:01 PM   #2
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,564
Okay a very old Photopost HMM

I would assume it has something to do with getting the user profile info when viewing a photo right?

You can set in your global options in admin the debug setting to display errors and you as admin should be able to give me that error and I can respond.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old June 2nd, 2014, 05:50 PM   #3
dj83
Member
Verified Customer
 
Join Date: Sep 2008
Posts: 221
yes I see this message when I view photos. Here is the full error message...

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: showphoto

Query: SELECT u.username,u.website,u.usertitle,u.postnum,u.regdate,uf.fid1,u.signature FROM mybb_users u LEFT JOIN mybb_userfields uf ON uf.ufid=426 WHERE u.uid=426 LIMIT 1

Result: Unknown column 'uf.fid1' in 'field list'

Database handle: Resource id #7
dj83 is offline   Reply With Quote
Old June 2nd, 2014, 06:31 PM   #4
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,564
I would have to see your database tables to comment further but the issue as I see it is it can not find the userfields table field for the user location which was fid1
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old June 2nd, 2014, 07:34 PM   #5
dj83
Member
Verified Customer
 
Join Date: Sep 2008
Posts: 221
Do I have to give you my hostgator password and username?

Last edited by dj83; June 2nd, 2014 at 07:54 PM.
dj83 is offline   Reply With Quote
Old June 2nd, 2014, 08:47 PM   #6
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,564
However I would see your database structure yes or maybe a dump of your userfields table. You can send the info through the contact us link in our header.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old June 2nd, 2014, 09:15 PM   #7
dj83
Member
Verified Customer
 
Join Date: Sep 2008
Posts: 221
Info emailed to you
dj83 is offline   Reply With Quote
Old June 2nd, 2014, 11:04 PM   #8
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,564
will take a look and let you know.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old June 3rd, 2014, 01:34 PM   #9
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,564
I emailed you about your issue your location field for the profile was a new custom field you did the existing field was deleted.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MyBB xowi Before You Buy 5 May 9th, 2012 02:37 PM
PP with mybb forum? dj83 General Discussion 1 October 8th, 2011 05:13 PM
MyBB 1.4 DTSS General Discussion 17 October 30th, 2008 10:56 AM
ReviewPost and MyBB spoost Before You Buy 3 October 8th, 2007 05:27 PM
Problem integrating with MyBB Firen General Discussion 5 May 31st, 2007 12:53 AM


All times are GMT -5. The time now is 05:20 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.