Solved: 1 Year, 10 Months ago Problem with plugin MyProfile
#1
Solved: 1 Year, 10 Months ago
MyBB 1.8.24
Localhost

When i try install this plugin https://community.mybb.com/mods.php?action=view&pid=198

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

If you're a visitor of this website, please wait a few minutes and try again. If this problem persists, please contact the site owner.
If you are the site owner, please check the MyBB Documentation for help resolving common issues, or get technical help on the MyBB Community Forums.
Reply
#2
Solved: 1 Year, 10 Months ago
To see the actual error refer to this post and thread:

https://community.mybb.com/thread-229365...pid1355863

The message you supply is too generic.  Also refer to last few pages of the support thread:

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

cheers...
Reply
#3
Solved: 1 Year, 10 Months ago
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 mybb_settinggroups' at line 1
Query:
SELECT COUNT(*) as rows FROM mybb_settinggroups
Reply
#4
Solved: 1 Year, 10 Months ago
The problem is that rows is a reserved word in MariaDB version 10.2.4 and greater. Contact the plugin's author for a permanent fix, but in the meantime simply change that identifier to a non-reserved word.
Reply
#5
Solved: 1 Year, 10 Months ago
I dont understand :x

"change that identifier to a non-reserved word."


which word?

(2020-09-27, 08:37 PM)Laird Wrote: Contact the plugin's author ...

Last Visit: 2016-08-07, 06:39 PM
Reply
#6
Solved: 1 Year, 10 Months ago
You can download the updated version with the fix from Github at this URL:
https://github.com/mohamedbenjelloun/MyP...master.zip
My Projects - Support My Projects

Don't forget to rate posts!
Reply
#7
Solved: 1 Year, 10 Months ago
Nice Smile but last problem :x

After installing and activating the plugin, I don't have any variables in the template

i try find in files
find_replace_templatesets("member_profile", "#" . preg_quote('{$contact_details}') . "#i", '{$myprofile_visitors}{$contact_details}');

{$myprofile_visitors}

I have all Smile

{$myprofile_visitors}
{$myprofile_comments}
{$myprofile_comments_stats}
{$myprofile_buddylist}
Reply
#8
Solved: 1 Year, 10 Months ago
Hi, these are all the template changes:
  • Template headerinclude: add {$myprofile_headerinclude} after {$stylesheets};
  • Template header: add {$myprofile_alertbar} after {$unreadreports};
  • Template modcp_nav_users: add {$nav_myprofilecomments} after {$nav_editprofile};
  • Template usercp_options: add {$myprofile_comments_usercp} before <legend><strong>{$lang->date_time_options}</strong></legend>;
  • Template usercp_profile: add {$myprofile_permissions} before {$myprofile_permissions};
  • Template member_profile:
    • Add {$myprofile_buddylist} before {$contact_details},
    • Add {$myprofile_comments} after {$modoptions},
    • Add {$myprofile_comments_stats} after {$warning_level},
    • Add {$myprofile_referredby} before {$referrals},
    • Add {$myprofile_visitors} before {$contact_details};
My Projects - Support My Projects

Don't forget to rate posts!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)