+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: Can't Delete Posts (/thread-234708.html)
Can't Delete Posts - iceice - 2022-01-16
When trying to delete a post, we get the below message. We are able to delete threads, move posts, edit posts. The only issue appears to be when deleting posts. I have tried to search for an answer but have not been able to find anything matching what we are getting.
MyBB has experienced an internal SQL error and cannot continue.
SQL Error: 1064 - 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 ') AND pid != 65516' at line 2
Query: SELECT distinct uid from
mybb_posts WHERE tid=28) AND pid != 65516It does appear that this may be an issue with a plugin, when I disabled the plugin I could delete posts and as soon as I allowed it back I couldn't.
thank you
RE: Can't Delete Posts - Crazycat - 2022-01-16
Yes, a plugin has a malformed query: the closing parenthesis must not be present.
Probably because the creator first use a in clause.
Which plugins are you using ? We can't find the faulty one with a cristal ball
RE: Can't Delete Posts - iceice - 2022-01-16
https://github.com/amwelles/mybb-threadlog
We ended up loading an older version of the plugin and it fixed the problem.
RE: Can't Delete Posts - Crazycat - 2022-01-16
Ok, error found @ https://github.com/amwelles/mybb-threadlog/blob/be6f4803c677876732c61e8a5d2ada4ac5b40f23/inc/plugins/threadlog.php#L284
WHERE tid={$post['tid']}) AND pid != {$pid}"); must be WHERE tid={$post['tid']} AND pid != {$pid}");The code confirms what I was thinking, it has multiple updates done too fast, or by different pple:
LEFT JOIN `{$db->table_prefix}threads` as t on t.tid=e.tid
left join `".$db->table_prefix."threadprefixes` as p on p.pid = t.prefix
LEFT JOIN `{$db->table_prefix}forums` as f on f.fid=t.fidRE: Can't Delete Posts - iceice - 2022-01-17
Thank you!