Support Forum

Database Error

FF Frank Fasano
Frank Fasano
Member
Member since Jul 2014
39 posts
Aug 4, 2014 · 10:32 pm · Edited

I noticed that my private messaging is not working and then I found this in my error log:

August 4, 2014 8:36 am | spaErrError | 33 | database

file: /chroot/problem-with-post-edit-buttonome/golficit/golficity.com/problem-with-post-edit-buttontml/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_sfpmmessages WHERE sent_date < DATE_SUB(NOW(), INTERVAL DAY)

I also found this:

August 4, 2014 8:37 pm | spaErrNotice | 2 | php

file: home/golficit/golficity.com/problem-with-post-edit-buttontml/wp-content/sp-resources/forum-plugins/private-messaging/library/sp-pm-components.php

line: 145

function: sp_pm_do_profile_options

Notice | Undefined property: spUser::$pmemail

Are they related and how can I fix this?

Thanks.

5 Answers

New Answer
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Aug 5, 2014 · 12:43 am

the notice is harmless and irrelevant…

on the error, please check  your settings on forum – private messaging – options… seems you might have some invalid options (like auto removing but an empty number of days)..  if so, should be easy to fix your settings (and we can add some error checking)…

FF Frank Fasano
Frank Fasano
Member
Member since Jul 2014
39 posts
Aug 5, 2014 · 7:37 am

The settings look pretty straightforward. Here’s a screenshot:

http://postimg.org/image/m5umapkuh/

Nothing stands out with regards to a possible conflict.

YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Aug 5, 2014 · 10:50 am

I would suggest you open that panel and just perform an update even if you do not change any data – to make sure all default values are stored properly.

But – can you describe what you actually mean by ‘not working’ which doesn’t give us much to think about!

FF Frank Fasano
Frank Fasano
Member
Member since Jul 2014
39 posts
Aug 5, 2014 · 12:53 pm

Ok, it appears that there was a javascript error that was stopping PMs from working.  By that I mean clicking the “compose” button did nothing (no page loaded).

We were able to fix that issue and get the button working again by resolving the javascript conflict.

Thanks.

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Aug 5, 2014 · 8:34 pm

so all set?  good news… thanks for the update…