Enable Reporting "Warnings & Errors" from ACP > Configuration > Settings > Server and Optimization Options
to get more details about the error being encountered and report back for further troubleshooting.
rows
is a reserved word and thats causing the issue I believe.
Its not a core MyBB issue, its being occurred by a plugin. Please disable your plugins one by one to detect which one is exactly causing this.
Probably the last plugin you have installed ....
OK, Sorry I missed you have already mentioned the plugin name.
Open the plugin file, go to line 65/66, find:
$query_add = $db->simple_select("settinggroups", "COUNT(*) as rows");
$rows = $db->fetch_field($query_add, "rows");
... and change the word
rows
to something else like:
$query_add = $db->simple_select("settinggroups", "COUNT(*) as rowz");
$rows = $db->fetch_field($query_add, "rowz");
Save the plugin file, reupload. It will work fine.
Excellent, now the extension works. Thanks for the help.