Read Also Field: Error when parameter how to connect articles set to Single Bound

Quote

Total posts: 181
06 Dec 2012 19:52

Hi,

I try the added parameter of Read Also Field : how to connect articles. I try the parameter; how to connect articles set to Single Bound

And the result, I get this error:

JDatabaseMySQL::query: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) ORDER BY r.ctime ASC LIMIT 0, 10' at line 3 SQL=SELECT r.*,(SELECT id FROM uxtka_js_res_hits WHERE record_id = r.id AND ip = '112.215.89.186' LIMIT 1) AS `new` FROM uxtka_js_res_record AS r WHERE r.section_id = 4 AND (r.access IN(1,1) OR r.user_id = 0) AND r.ctime < '2012-12-07 01:47:35' AND (r.extime = '0000-00-00 00:00:00' OR r.extime > '2012-12-07 01:47:35') AND r.published = 1 AND r.hidden = 0 AND r.parent_id = 0 AND (r.id IN()) ORDER BY r.ctime ASC LIMIT 0, 10

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    CobaltViewRecord->display()    JROOT/libraries/joomla/application/component/controller.php:722

9    CobaltModelRecord->_prepareItem()    JROOT/components/com_cobalt/views/record/view.html.php:103

10    JFormFieldCReadmore->onRenderFull()    JROOT/components/com_cobalt/models/record.php:249

11    CobaltApi->records()    JROOT/components/com_cobalt/fields/readmore/readmore.php:36

12    CobaltModelRecords->getItems()    JROOT/components/com_cobalt/api.php:114

13    JModelList->getItems()    JROOT/components/com_cobalt/models/records.php:232

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

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

16    JDatabaseMySQL->execute()    JROOT/libraries/joomla/database/database.php:1100

17    JError::raiseError()    JROOT/libraries/joomla/database/database/mysql.php:548

18    JError::raise()    JROOT/libraries/joomla/error/error.php:251

Please help me..

Last Modified: 02 Mar 2014

Sergey

Total posts: 13,748
07 Dec 2012 01:02

Fixed in next update. To fix open models/records.php line 771 and find

if($strict)

{

    $db->setQuery("SELECT record_id FROM #__js_res_record_values WHERE field_value = '{$record_id}' AND field_id = {$field_id}");

    $ids = $db->loadColumn();

    $ids[] = 0;

}

and replace with

if($strict)

{

    $db->setQuery("SELECT record_id FROM #__js_res_record_values WHERE field_value = '{$record_id}' AND field_id = {$field_id}");

    $ids = $db->loadColumn();

}

$ids[] = 0;

Total posts: 181
07 Dec 2012 04:33

Great.. Thank you..

Ah, I just remembered that I have not written testimony for Co. yet. I owe you.

But let me finish my project with Co first.

Anyway, Co.7 is really great!

Total posts: 13,748
07 Dec 2012 05:33

I owe you

Come on! You one of those who always pays, and I very appreciate it. Thank you for your recent subscription purchase. You do not owe me anything.

But one more 5 star review could make a difference for us on JED :D

Login (copy)