I do not know if I do not know what is the query. can you see all sql queries in debug log and place it here? I mean those that are with subquery.

Sergey, this is the query shown in debug mode.

JDatabaseMySQLi::query: 1242 - Subquery returns more than 1 row SQL=SELECT r.*,(SELECT id FROM qr7no_js_res_subscriptions WHERE record_id = r.id AND user_id = 981) as subscribed,(SELECT id FROM qr7no_js_res_favorite WHERE record_id = r.id AND user_id = 981) as bookmarked,0 as new,1 AS searchresult FROM qr7no_js_res_record AS r WHERE r.section_id = 1 AND r.published = 1 AND r.hidden = 0 AND r.parent_id = 0 AND r.fieldsdata LIKE '%bank central%' ORDER BY r.ctime DESC LIMIT 0, 20

Call stack

Function Location

1 JSite->dispatch() JROOT\index.php:42

2 JComponentHelper::renderComponent() JROOT\includes\application.php:197

3 JComponentHelper::executeComponent() JROOT\libraries\joomla\application\component\helper.php:351

4 require_once() JROOT\libraries\joomla\application\component\helper.php:383

5 JController->execute() JROOT\components\com_cobalt\cobalt.php:54

6 CobaltController->display() JROOT\libraries\joomla\application\component\controller.php:761

7 JController->display() JROOT\components\com_cobalt\controller.php:38

8 CobaltViewRecords->display() JROOT\libraries\joomla\application\component\controller.php:722

9 JView->get() JROOT\components\com_cobalt\views\records\view.html.php:132

10 CobaltModelRecords->getItems() JROOT\libraries\joomla\application\component\view.php:386

11 JModelList->getItems() JROOT\components\com_cobalt\models\records.php:244

12 JModel->_getList() JROOT\libraries\joomla\application\component\modellist.php:128

13 JDatabase->loadObjectList() JROOT\libraries\joomla\application\component\model.php:301

14 JDatabaseMySQLi->execute() JROOT\libraries\joomla\database\database.php:1100

15 JError::raiseError() JROOT\libraries\joomla\database\database\mysqli.php:396

16 JError::raise() JROOT\libraries\joomla\error\error.php:251

OK. Please run this queries and tell me if there is more than 1 in one of the records.

SELECT COUNT(id) AS number FROM qr7no_js_res_subscriptions WHERE user_id = 981 GROUP BY record_id ORDER BY number DESC;

SELECT COUNT(id) AS number FROM qr7no_js_res_favorite WHERE user_id = 981 GROUP BY record_id ORDER BY number DESC

When everything is ok. I made some fix. Should not display this error anymore.

Update to release yesterday.

Sergey,

Which update should I use?, I have update Cobalt package and Emerald, but the error still came up.

JDatabaseMySQLi::query: 1242 - Subquery returns more than 1 row SQL=SELECT r.*,(SELECT id FROM qr7no_js_res_subscriptions WHERE record_id = r.id AND user_id = 981) as subscribed,(SELECT id FROM qr7no_js_res_favorite WHERE record_id = r.id AND user_id = 981) as bookmarked,0 as new,1 AS searchresult FROM qr7no_js_res_record AS r WHERE r.section_id = 1 AND r.published = 1 AND r.hidden = 0 AND r.parent_id = 0 AND r.fieldsdata LIKE '%bank central asia%' AND r.archive = 0 ORDER BY r.ctime DESC LIMIT 0, 20

I am sorry. Again I was thinking of Cobalt 8 and J3. I fixed that. Now I fixed Cobalt 7 and I'll update it within a few hours.

Sergey,

It is working fine now.

Thank You

Hi! I have this same problem, but in Cobalt 8. Can you please check that it's solved in the last version?

Thank you.

Sometimes it happens. It might be because of some MySQL internal errors.

You have to see debug console and find the query that return this error. Then you will see what to fix.

But for the next version of cobalt I've added new tool called Doctor. This one will check for those types of anomalies and fix those.

I will take my time to read some article on filtering data for SQL.