Welcome, Guest
Username: Password: Remember me

TOPIC: Category Menu for SobiPro

Category Menu for SobiPro 1 year 1 week ago #20

  • skylark
  • skylark's Avatar
  • Offline
  • New Member
  • Posts: 2
  • Karma: 0
Hello

I tried to use Category Menu for SobiPro but have such error:

If difficulties persist, please contact the System Administrator of this site and report the error below.

1242 Subquery returns more than 1 row SQL=SELECT l.id as catid,l.sValue as name, IFNULL (c.counter,0) as hit,( SELECT count(*) FROM #__sobipro_relations as m WHERE m.pid = r.id and m.oType='entry' ) AS entryCount, (SELECT sValue FROM `#__sobipro_language` as e WHERE e.`oType`='category' and e.id=o.id and e.sKey='nid') as nid FROM `#__sobipro_language` as l join `#__sobipro_relations` as r on l.id=r.id and r.pid=54 and l.skey='name' and l.language='en-GB' and r.oType='category' join `#__sobipro_object` as o on l.id=o.id left join #__sobipro_counter as c on o.id=c.sid where ( o.state ='1' ) AND ( ( o.validUntil > '2016-06-14 07:01:31' OR o.validUntil IN ( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) AND ( o.validSince < '2016-06-14 07:01:31' OR o.validSince IN( '0000-00-00 00:00:00', '1970-01-01 00:00:00' ) ) ) AND ( r.copy ='0' ) order by name ASC

Please advise what and how can I fix this

Best regards
Sergey
The administrator has disabled public write access.
Time to create page: 0.060 seconds