MyBB Community Forums

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.

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

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

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.

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

You can download the updated version with the fix from Github at this URL:
https://github.com/mohamedbenjelloun/MyP...master.zip

Nice 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

{$myprofile_visitors}
{$myprofile_comments}
{$myprofile_comments_stats}
{$myprofile_buddylist}

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};