Support Forum

Various spaErrError Reports

JI jim
jim
Member

The SP Error log states, “Errors should be reported to Simple:Press support as they may effect the proper behaviour of your forum.” So here goes…

I haven’t noticed any problems with our forums, and we haven’t received any reports of issues, but I noticed the following error while trying to track down some seemingly innocuous PHP warnings so I thought I would report this instead.

Private Messaging Error

23 September 2014 12:28 pm | spaErrError | 55 | databasefile: /problem-with-post-edit-buttonome/tripawds/public_html/wp-content/sp-resources/forum-plugins/private-messaging/library/sp-pm-components.php

line: 213

function: spdb_table

error: 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

SELECT * FROM wp_1_sfpmmessages WHERE sent_date < DATE_SUB(NOW(), INTERVAL DAY)

As suggested in a related topic, I have confirmed PM system options are all valid and re-saved them.

The only other red errors are a few months old and have apparently been addressed in recent updates.

Any cause for concern here? Need any more info from me?

8 Answers

New Answer

IK Ike
Ike
Member

Hey Jim,

While I normally go off the assumption that error messages tell you what the problem is, SQL is really out of my depth, will have to leave this one to Mr Papa to take a look at..

MP Mr Papa
Mr Papa
Member

that seems to be coming from auto removal of pms… can you confirm that is enabled and running?

but it seems you have not specified a number of days for removal?  its on the forum – private messaging – options panel…  is auto removal enabled?  and an numeric value for days to keep?

JI jim
jim
Member

Mr Papa said
…is auto removal enabled?  and an numeric value for days to keep?

Yup, checked all options before reporting the error…pmoptions.png

MP Mr Papa
Mr Papa
Member

So what is the numeric value? It’s the value missing from the sql

MP Mr Papa
Mr Papa
Member

was that image there before?  lol, must be because I replied via post by email… :)

dont understand…  error would only occur if no value in the max days…  can you pull the ‘pm’ option from your sfoptions table?

MP Mr Papa
Mr Papa
Member

nvm…  I see the potential problem…  will open a ticket and get it fixed in next version… does mean though that the auto pm removal is not occurring…  thanks again…

MP Mr Papa
Mr Papa
Member

have a fix in place.. can post the code change if you like, just a couple chars…