Error message when installing extensions

[OakleY]

Trying to install this add-on that has worked before. Uses the latest version of MyBB and PHP Version 7.4.12. I'm getting this message.

The supplement is this.

http://doylecc.altervista.org/bb/downloa...d=16&cat=1

[effone]

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.

[OakleY]

[effone]

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 ....

[OakleY]

Ok, thanks effone.

[effone]

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.

[OakleY]

Excellent, now the extension works. Thanks for the help.