Digest entries aren’t getting saved properly in the digest table when the topic title has an apostrophe in it.
Installed versions:
- Simple:Press 5.2
- Subscriptions 1.2
Entries from the error log:
———————————————
file: /problem-with-post-edit-buttonome/chaohome/public_html/wp-content/sp-resources/forum-plugins/subscriptions/sp-subscriptions-plugin.php
line: 363
function: sp_subscriptions_do_digest_entry
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 Holy Hour’, 42, ‘December 2012 Children’s Holy Hour’, 120, ‘a:7:{i:0;s:3:”294’ at line 1
INSERT INTO wp_sfdigest (forum_id, forum_name, topic_id, topic_name, post_id, subscriptions, permalink) VALUES (27, ‘Children’s Holy Hour’, 42, ‘December 2012 Children’s Holy Hour’, 120, ‘a:7:{i:0;s:3:”294″;i:1;s:2:”90″;i:2;s:2:”73″;i:3;s:2:”78″;i:4;s:3:”417″;i:5;s:3:”415″;i:6;s:2:”56″;}’, ‘http://chaohome.org/forum/childrens-holy-hour/december-2012-childrens-holy-hour/#p120’)
————————————————–
file: /problem-with-post-edit-buttonome/chaohome/public_html/wp-content/sp-resources/forum-plugins/subscriptions/sp-subscriptions-plugin.php
line: 363
function: sp_subscriptions_do_digest_entry
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 Faith and Fellowship’, 77, ‘January 2013 Mothers’ Faith & Fellowship’, 11′ at line 1
INSERT INTO wp_sfdigest (forum_id, forum_name, topic_id, topic_name, post_id, subscriptions, permalink) VALUES (30, ‘Mother’s Faith and Fellowship’, 77, ‘January 2013 Mothers’ Faith & Fellowship’, 115, ‘a:12:{i:0;s:1:”1″;i:1;s:2:”90″;i:2;s:2:”81″;i:3;s:2:”35″;i:4;s:2:”73″;i:5;s:2:”78″;i:6;s:3:”417″;i:7;s:3:”415″;i:8;s:3:”141″;i:9;s:2:”11″;i:10;s:2:”95″;i:11;s:3:”336″;}’, ‘http://chaohome.org/forum/mothers-faith-and-fellowship/january-2013-mothers-faith-fellowship/#p115’)
