Hi-
I am getting the ‘Invalid Database Query’ pop-up on every click of a topic/post. I have changed wp and sp themes, disabled wp and sp plug-ins – and it still persists. Not all users are getting it – just me and another that I am aware- we both happen to be moderators – although when I remove me from being a moderator, the pop-up still occurs. Below is the error that is logged.
Any thoughts?
Thank you
-Rick
|
February 10, 2017 5:27 pm | spaErrError | 279 | database
file: /usr/share/nginx/html/wp-content/plugins/simple-press/forum/content/classes/sp-list-topic-class.php line: 362 function: select error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘37426,37424,37420,37418) ORDER BY topic_id, post_id’ at line 2
SELECT wp_sfposts.topic_id, wp_sfposts.post_id, post_index, DATE_ADD(post_date, INTERVAL 5 HOUR) as post_date, guest_name, wp_sfposts.user_id, display_name, (post_count-(post_index-1)) AS new_post_count FROM wp_sfposts JOIN wp_sftopics ON wp_sfposts.topic_id = wp_sftopics.topic_id LEFT JOIN wp_sfmembers ON wp_sfmembers.user_id = wp_sfposts.user_id WHERE wp_sfposts.post_id IN (37484,37482,37480,37471,37463,37462,37454,37447,,37426,37424,37420,37418) ORDER BY topic_id, post_id |
Environment as follows:
|
Simple:Press |
|
Version: 5.7.3 Build: 14754 Release: Release |
|
WordPress |
|
Version: 4.7.2 Language: en-US Character Set: UTF-8 Theme: Kleo Child |
|
PHP |
|
Version: 7.0.15 Memory: 256M |
|
MySQL |
|
Version: 10.0.29 (MariaDB) |
|
Server |
|
Version: nginx/1.10.2 |
|
WP Plugins |
|
Advanced Ads (1.7.17) Advanced Ads – Responsive Ads (1.4.2) All-in-One Event Calendar by Time.ly (2.5.16) Data Tables Generator by Supsystic (1.5.4) K Elements (4.1.7) Mailgun (1.5.8.1) Simple:Press (5.7.3) Slider Revolution (5.3.1.5) Stop User Enumeration (1.3.8) WPBakery Visual Composer (5.0.1) WP Embed Facebook (2.1.7)
|
|
SP Plugins |
|
Announce (1.0.7) Editor TinyMCE Rich Text (3.3.4) File Uploader with Plupload (4.6) Font Resizer (1.2.1) Maintenance Mode (1.0.4) Private Message System (2.4.1) Profile Display Control (1.0.6) Reputation System (1.1.2) Template Tags and Widgets (1.4.10) Timezone On Registration (1.0) |
