PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Photopost Pro Bug Reports (http://www.photopost.com/forum/photopost-pro-bug-reports/)
-   -   SQL error (http://www.photopost.com/forum/photopost-pro-bug-reports/140153-sql-error.html)

drare May 26th, 2009 01:36 PM

SQL error
 
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 01: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 03: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 03: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.


All times are GMT -5. The time now is 04:25 PM.

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