Photopost Buddy List problem

rpm1 · July 4th, 2008, 05:39 AM

Hi there

I updated our Photopost files, but when clicking on the Buddy List link under the user profile I get the following errors:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/www/users/…/…/member.php on line 541

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/www/users/…/…/member.php on line 574

I am using a VBulletin user base for Photopost.

Any idea how to solve this question?

Chuck S · July 4th, 2008, 10:30 AM

well I would suspect somehow in the buddies table you have a couple bogus entries which you could check out but as where the query is failing is you have buddy entries but data is empty so this is what fails in those two queries

Code:

Content visible to verified customers only.

Try running this query in phpmyadmin

DELETE FROM pp_buddies WHERE buddy = '';

rpm1 · July 9th, 2008, 05:20 PM

Hi there

I rolled back and upgraded to 6.11, and now get the following error ONLY when I (admin) am viewing my buddy list. Other admins don’t have this problem and it seems like members don’t have this problem either. (my user ID = 1)

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/www/users/folder/photos/member.php on line 542

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /usr/www/users/folder/photos/member.php on line 575

Any idea what it can be?

Chuck S · July 9th, 2008, 08:26 PM

Have you tried running the query on your database?

rpm1 · July 10th, 2008, 06:01 AM

Quote:

Originally Posted by Chuck S

Have you tried running the query on your database?

Yes I ran it, but it did not solve the problem. What is strange is that I am the only user experiencing this problem - I am admin with VB integration, but other admins dont have the same problem. The system works as well even though I get the two errors...

Chuck S · July 10th, 2008, 09:29 AM

I would suggest you email me at chuck at photopost dot com with a url admin login andif possible database login and url to phpmyadmin to see your database.

rpm1 · July 18th, 2008, 09:41 AM

Hi again.

There seems to be a problem with sending an email:

chuck@photopost.com
SMTP error from remote mail server after RCPT TO:<chuck@photopost.com>:
host mx1.mailhop.org [63.208.196.181]: 550 Unknown user - DYN001

Chuck S · July 18th, 2008, 11:17 AM

I think Scott was working on the mail server you can try again.