Removing thread from folder - DB error
My Browser Information: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36
Relevant Links: (Copy and paste links to what it is you're talking about here)
Referrer: https://www.myth-weavers.com/forumdisplay.php?f=40854
Message: When trying to remove a thread from the main threadgroup (using the "Remove from this folder" action at the bottom of the page, I get the "Database error: The Myth-Weavers database has encountered a problem." page. The specific error message I get is:
It appears that the threadgroupid is missing, presumably because it's the main threadgroup. After thinking about it for a moment, I realize it's because I need to remove the thread in question from the *other* folder which is being included in the "display on main" options under the edit main threadgroup menu.
Probably the only thing that really need to be "fixed" is that the option to "remove from this folder" should be hidden altogether on the main threadgroup page.
Relevant Links: (Copy and paste links to what it is you're talking about here)
Referrer: https://www.myth-weavers.com/forumdisplay.php?f=40854
Message: When trying to remove a thread from the main threadgroup (using the "Remove from this folder" action at the bottom of the page, I get the "Database error: The Myth-Weavers database has encountered a problem." page. The specific error message I get is:
Code:
<!-- Database error in vBulletin 3.8.8: Invalid SQL: DELETE FROM threadgroupi WHERE threadid IN (422408) AND threadgroupid =; MySQL 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 '' at line 3 Error Number : 1064 Request Date : Friday, May 25th 2018 @ 10:11:22 PM Error Date : Friday, May 25th 2018 @ 10:11:22 PM Script : http://www.myth-weavers.com/threadgroup.php?do=rmv&forumid=40854&threadgroupid= Referrer : https://www.myth-weavers.com/forumdisplay.php?f=40854 IP Address : 67.193.1.174 Username : geekahedron Classname : vB_Database_MySQLi MySQL Version : halt /home/trium/public_html/includes/class_core.php 1206 execute_query /home/trium/public_html/includes/class_core.php 447 query_write /home/trium/public_html/threadgroup.php 196 -->
Probably the only thing that really need to be "fixed" is that the option to "remove from this folder" should be hidden altogether on the main threadgroup page.