Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Database Error
Avatar
Frank Fasano
Member
Free Members
sp_UserOfflineSmall Offline
Aug 4, 2014 - 10:32 pm

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.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
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)...

Avatar
Frank Fasano
Member
Free Members
sp_UserOfflineSmall Offline
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.

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
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!

andy-signature.png
YELLOW
SWORDFISH
Avatar
Frank Fasano
Member
Free Members
sp_UserOfflineSmall Offline
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.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Aug 5, 2014 - 8:34 pm

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

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 649
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 616
Members: 17348
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10118
Posts: 79603