Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Myarticles plugin error if category is selected

12 years 5 months ago
  • Kira's Avatar
    Topic Author
  • Kira
  • Offline
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Licenses:
JomSocial Expired

Hi Guys!

Just found the wonderful myarticles plugin an tried to test it on my site. Everythink works fine but if i enter a category id in the plugin manager this error code appers on my profile:

Unknown column 'sectionid' in 'where clause' SQL=SELECT * FROM `fhrug_content` WHERE `created_by` = '11064' AND `state`='1' AND `sectionid` IN (12) ORDER BY `created` DESC LIMIT 0,10

Tried everything...different category, different user, new category, enter the category alias but nothing seems to work!

Can you please help me?

12 years 5 months ago
Licenses:
JomSocial Expired GURU Expired Publisher Expired AdAgency Expired iSEO Expired Socialize Expired

Hi Kira,
It seems the problem is related with that plugin.
Can you contact to the plugin provide by asking support?
We are sorry to say you that it is beyond our support range.
Thanks

extensions.joomla.org/extensions/clients...ies/communities/7608
12 years 5 months ago
  • Kira's Avatar
    Topic Author
  • Kira
  • Offline
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Licenses:
JomSocial Expired

Hi there!

Thx for your answer! I fixed the problem by myself in the source code. Now it's working fine! I added:

"WHERE
" . $this->db->quoteName('created_by') . " = " . $this->db->quote($userid) . " AND
" . $this->db->quoteName('state') . "=" . $this->db->quote(1) . " AND

>>>>>> " . $this->db->quoteName('catid') . " = 21 (in line 207) "[/b]

in plg_myarticles\myarticles.php

and leave the section/category blank in the admin view.

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere

© JomSocial.com All Rights Reserved