Thread Rating:
  • 12 Vote(s) - 4.17 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[For 1.8] MyProfile - Profile Comments & more (version 1.2)
(2019-04-02, 04:44 PM)Metallix Wrote: I had this working until I updated. I cannot install it for whatever reason. Keep getting this:
Quote: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 mybblq_settinggroups' at line 1
SELECT COUNT(*) as rows FROM mybblq_settinggroups

Any ideas?
Went to install this plugin today and encountered the same problem. Navigate to inc/plugins/myprofile/myprofileutils.class.php and open it. On line 57 where you see "COUNT(*) as rows", change that to "COUNT(*) as item_rows". Then on the next line (58), change "rows" at the end of the line to "item_rows". Seems to work after that.

Messages In This Thread
RE: MyProfile - Profile Comments & more (version 1.2) - by Settyness - 2019-04-14, 11:49 PM

Forum Jump:

Users browsing this thread: 1 Guest(s)