Support Forum
Support Forum
Offline
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?
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
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..
Offline
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?
Visit Cruise Talk Central and Mr Papa's World
Offline
Mr Papa said
...is auto removal enabled? and an numeric value for days to keep?
Yup, checked all options before reporting the error...
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
So what is the numeric value? It's the value missing from the sql
Visit Cruise Talk Central and Mr Papa's World
Offline
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?
Visit Cruise Talk Central and Mr Papa's World
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
Offline
Mr Papa said
thanks again...
No, thank you!
Simple:Press powers the Tripawds Discussion Forums.
It's better to hop on three legs than to limp on four.
The Tripawds Blogs Community is made possible by The Tripawds Foundation.
Offline
have a fix in place.. can post the code change if you like, just a couple chars...
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)