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
Showing invalid db query when editing post
Avatar
Brandon
U.S.
SP Wrangler
Free Members
sp_UserOfflineSmall Offline
Dec 18, 2012 - 10:34 am

(posted for another member)

SP 5.2, all SP plugins updated and WP 3.5

After editing a current post it does save but before saving a invalid db query notice pops up. Tested with two different users.

Error log file shows.

file: /problem-with-post-edit-buttonomepages/8/d332225665/problem-with-post-edit-buttontdocs/website.com/wp-content/plugins/simple-press/sp-api/sp-api-primitives.php

line: 394

function: insert

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 's HVAs for the week of 12-17-12', 'A user has edited the post', 1356451959)' at line 1

INSERT INTO wp_sfnotices (user_id, guest_email, post_id, link, link_text, message, expires) VALUES (122, '', 7982, 'http://www.website.com/?page_id=4/problem-with-post-edit-buttonigh-value-actions/anne-ws-hvas-for-the-week-of-12-17-12#p7982', 'Anne W's HVAs for the week of 12-17-12', 'A user has edited the post', 1356451959)

(website name changed in above info)

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Dec 18, 2012 - 10:52 am

Brandon, just open a ticket... looks like the post title is not escaped to handle the quote in the message...

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: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17362
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625