MyBB Community Forums

Full Version: SQL Error when activating ViewGroups Plugin
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello, I just installed the ViewGroups Plugin, which is supposed to show specific Usergroups below the who's online part on index Page.
The Plugin Link: https://community.mybb.com/mods.php?action=view&pid=10

The SQL Error:
[Image: sql-error-viewgroups-plugin.png]

I expect someone to send me a valid MariaDB SQL Command which i can execute in phpmyadmin to fix this SQL Error as i never saw such an error before.
This is because it has been designed for more permissive versions of MySQL/MariaDB.
Remove all lines "sid" => NULL, and "tid" => "NULL",
(2023-05-03, 10:14 AM)Crazycat Wrote: [ -> ]This is because it has been designed for more permissive versions of MySQL/MariaDB.
Remove all lines "sid" => NULL, and  "tid" => "NULL",

Removing these in inc/plugins/ViewGroups.php solved the Issue. Thank you for the Solution, I was losing my mind over it (tried fixing it myself for around 3h before i made this Thread)

Regards,
Infinimonster