Buddies Error

[drare]

Hi,

I got this error:

An error was encountered during execution of the query:

INSERT IGNORE INTO pp_buddies (id,userid,buddy) VALUES( NULL, 400, 605

The query returned with an errorcode of:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

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.

What does it mean and how can this be corrected?
Gerard

[Chuck S]

Is there more of an error here? I mean that query is completely valid from what I see

[drare]

This is all I'm getting by email no more no less.

[Chuck S]

what version of mysql please?

I have tested the functionality and dont see any issues here

INSERT IGNORE INTO pp_buddies (id,userid,buddy) VALUES( NULL, 400, 605)

Thats a valid query

[drare]

This what I found Chuck: MySQL client version: 5.0.85
Gerard

[Chuck S]

Yeah it would be nice if there was more of an error.

Try these steps and tell me the error.

1. Go to Admin => Global Options set the debug option to display errors.

2. As admin view someones profile and hit the ADD TO BUDDIES link. If there is truly an error adding a buddy you should be able to replicate it. Then tell me the error displayed on screen. See the email message is missing the whole explanation of what your error is. The displayed error should tell you what your server is bulking at.