MyBB Community Forums

I'm getting this error everytime i try to activate myProfile plugin

Quote:MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

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 mybbty_settinggroups' at line 1

Query:
SELECT COUNT(*) as rows FROM mybbty_settinggroups

I'm using the latest version of mybb and latest version of myProfile

Anyone know how to fix it? I found another thread with a similar problem but it was with a different plugin, so i dont know if that solution would fix my problem, if anyone can help, I'll appreciate a lot

Thanks

(2019-06-18, 12:07 PM)Miraimaher Wrote: [ -> ]I'm getting this error everytime i try to activate myProfile plugin

Quote:MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

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 mybbty_settinggroups' at line 1

Query:
SELECT COUNT(*) as rows FROM mybbty_settinggroups

I'm using the latest version of mybb and latest version of myProfile

Anyone know how to fix it? I found another thread with a similar problem but it was with a different plugin, so i dont know if that solution would fix my problem, if anyone can help, I'll appreciate a lot

Thanks

MyProfile last release is 2016 and developer is currently inactive with this plugin. This issue is reported https://github.com/mohamedbenjelloun/MyP.../issues/85

I don't know if this working, but try to make this change:

SELECT COUNT(*) as rows FROM mybbty_settinggroups

to

SELECT COUNT(*) as FROM mybbty_settinggroups

Thanks, I'll give it a try but where do I find that line? I was looking for it here "inc/plugins/myprofile.php" but i couldnt find it, is it from phpmyadmin?

Still need help with this problem please.. I already followed solutions from this threads

https://community.mybb.com/thread-159969-page-28.html

https://github.com/mohamedbenjelloun/MyP...l/84/files

https://community.mybb.com/thread-223253.html

But it didnt fix my problem, the error messages doesnt appear anymore but on the ACP I dont get settings for comments and comments or comment box its not showing on profiles

Fully uninstall the plugin, and clean your database if needed (settings, settinggroups, myprofilecomments, myprofilevisitors).
Then reinstall it, using the last version from github (https://github.com/mohamedbenjelloun/MyP...master.zip)

Thanks alot, that solved my problem

I just found a problem, everything goes well but now the problem is that myprofile buddy list doesnt work, theres no settings for it on APC and buddies dont show on profile either

is there any way to fix this?

Thanks!