Support Forum

Showing invalid db query when editing post

BR Brandon
Brandon
Member

(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)

1 Answer

New Answer

MP Mr Papa
Mr Papa
Member

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