SQL error

drare · May 26th, 2009, 02:36 PM

Chuck,

I got this error, can you help to resolve it?

An error was encountered during execution of the query:
DELETE FROM pp_buddies WHERE userid=353 AND buddy=0)

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

Thanks,
Gerard

Chuck S · May 26th, 2009, 02:43 PM

What version of the software are you using?

My suggestion would be to update the software if its an older version.

In showframe.php it should look like this

Code:

Content visible to verified customers only.

drare · May 26th, 2009, 04:07 PM

Version 6.2 the one I bought, the code you gave is exactly the same code that's in the showframe.php I'v never had this error, could it be that this error was generated because someone deleted a buddy while the site gave also a server busy error? Because I've got both errors.

I'll wait an see if it occours again or not.

Chuck S · May 26th, 2009, 04:26 PM

That error looks like an old bug in older versions which is why I asked if you where running 6.23

If the code is the same as what I posted then you should not have an issue.