So - when I go to permanently delete posts on any thread I get an error that reads
Quote:MyBB has experienced an internal SQL error and cannot continue.
If you're a visitor of this website, please wait a few minutes and try again. If this problem persists, please contact the site owner.
If you are the site owner, please check the MyBB Documentation for help resolving common issues, or get technical help on the MyBB Community Forums.
However, I can soft delete posts and I can delete threads as a whole. Any idea why this issue is occuring?
Site Link:
https://hiraeth-rp.com/
Change the error logging level in ACP to get the SQL faulty query
(2021-08-30, 10:38 PM)Crazycat Wrote: [ -> ]Change the error logging level in ACP to get the SQL faulty query
That's been done but still can't figure out why it's happening
If you have enabled the full error display then paste the full error here please.
I am one of the other members on this site! This is the full error.
Quote:<error>
<dateline>1630304557</dateline>
<script></script>
<line>0</line>
<type>20</type>
<friendly_type>MyBB SQL Error</friendly_type>
<message>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 != 58' at line 2
Query: SELECT distinct uid from mybb5a_posts
WHERE tid=29) AND pid != 58</message>
<back_trace>#0 errorHandler->error() called at [/inc/db_mysqli.php:601]
#1 DB_MySQLi->error() called at [/inc/db_mysqli.php:337]
#2 DB_MySQLi->query() called at [/inc/db_mysqli.php:370]
#3 DB_MySQLi->write_query() called at [/inc/plugins/threadlog.php:280]
#4 threadlog_delete_post() called at [/inc/class_plugins.php:142]
#5 pluginSystem->run_hooks() called at [/inc/class_moderation.php:668]
#6 Moderation->delete_post() called at [/moderation.php:2247]
</back_trace>
</error>
(2021-09-02, 08:00 AM)Omar G. Wrote: [ -> ]The issue is within the "Threadlog" plugin, the following line :
https://github.com/amwelles/mybb-threadl...g.php#L284
Should be :
WHERE tid={$post['tid']} AND pid != {$pid}");
I'm surprised not even the author has noticed this.
How would something like that be fixed?
Nevermind, I realize you already answered that. It's really late here. Thank you.
I had another question if you have any idea what's going on?
I keep getting this error.
Uncaught TypeError: $(...).popupMenu is not a function
at VM34737 showthread.php:1602
(2021-09-02, 08:14 AM)bunnyvice Wrote: [ -> ]How would something like that be fixed?
I just told you the file that is causing the issue, the exact line, and the replacement for such line to fix the issue.
Another alternative would be to deactivate or uninstall the plugin.
I saw and realized, thank you! I had responded again with another question if you have the time.