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-14, 11:49 PM)Settyness Wrote:
(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.

Yeah I got it to install by doing that but the comments didn't work. So I just used 1.0. That one seems to work.

Messages In This Thread
RE: MyProfile - Profile Comments & more (version 1.2) - by Metallix - 2019-04-24, 06:28 PM

Forum Jump:

Users browsing this thread: 1 Guest(s)