MyBB Community Forums

Hello! Thank you for taking your time to check this issue. Here it is:

The SQL error I'm getting when I am trying to Activate MyProfile plugin is

SQL Error:
1064 - 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 'rows FROM mybb7v_settinggroups' at line 1
Query:
SELECT COUNT(*) as rows FROM mybb7v_settinggroups

I don't know how to fix it, if anyone could help me with this I will be extremely grateful.

Thank you in advance


error attached

open the plugin file and search for rows
replace each occurrence with a different word [eg. myrows]
save the file & try using it

Note: php files should be saved with utf-8 encoding without Byte Order Mark.
in general, we use editor like Notepad++ or file editor at web host panel to edit the files.

correction:
you might have uploaded myprofile named folder along with main plugin file.
that folder should be having "myprofileutils.class.php" named file.
that file needs to be edited.

(2019-06-03, 06:04 AM).m. Wrote: [ -> ]correction:
you might have uploaded myprofile named folder along with main plugin file.
that folder should be having "myprofileutils.class.php" named file.
that file needs to be edited.

Thank you very much!, this fixed the issue + replacing rows to myrows.