Moodle

Search is throwing an error about groupid during cron add operations

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Won't Fix
  • Affects Version/s: 1.9.4
  • Fix Version/s: None
  • Component/s: Global search
  • Labels:
    None
  • Affected Branches:
    MOODLE_19_STABLE

Description

The error(s):

Add: against reductionism (database id = 576, moodle instance id = 1628)
<div class="notifytiny" style="text-align:center">Out of range value for column 'groupid' at row 1<br /><br />INSERT INTO mdl_block_search_documents ( DOCID, DOCTYPE, ITEMTYPE, TITLE, URL, DOCDATE, UPDATED, COURSEID, GROUPID ) VALUES ( '1633', 'forum', 'head', 'Type A and Type B ', 'http://moodle.plumsteadmanor.com/mod/forum/discuss.php?d=548#1633', 1233831366, 1237973390, 226, 1 )<ul style="text-align:left"><li>line 1554 of lib\dmllib.php: call to debugging()</li><li>line 243 of search\indexlib.php: call to insert_record()</li><li>line 134 of search\add.php: call to IndexDBControl>addDocument()</li><li>line 20 of search\cron_php5.php: call to require_once()</li><li>line 25 of search\cron.php: call to include()</li><li>line 83 of blocks\search\block_search.php: call to include()</li><li>line 148 of admin\cron.php: call to block_search->cron()</li></ul></div>
Add: Type A and Type B (database id = , moodle instance id = 1633)
<div class="notifytiny" style="text-align:center">Out of range value for column 'groupid' at row 1<br /><br />INSERT INTO mdl_block_search_documents ( DOCID, DOCTYPE, ITEMTYPE, TITLE, URL, DOCDATE, UPDATED, COURSEID, GROUPID ) VALUES ( '1634', 'forum', 'head', 'Type A Personality test', 'http://moodle.plumsteadmanor.com/mod/forum/discuss.php?d=549#1634', 1233831700, 1237973390, 226, 1 )<ul style="text-align:left"><li>line 1554 of lib\dmllib.php: call to debugging()</li><li>line 243 of search\indexlib.php: call to insert_record()</li><li>line 134 of search\add.php: call to IndexDBControl>addDocument()</li><li>line 20 of search\cron_php5.php: call to require_once()</li><li>line 25 of search\cron.php: call to include()</li><li>line 83 of blocks\search\block_search.php: call to include()</li><li>line 148 of admin\cron.php: call to block_search->cron()</li></ul></div>
Add: Type A Personality test (database id = , moodle instance id = 1634)
<div class="notifytiny" style="text-align:center">Out of range value for column 'groupid' at row 1<br /><br />INSERT INTO mdl_block_search_documents ( DOCID, DOCTYPE, ITEMTYPE, TITLE, URL, DOCDATE, UPDATED, COURSEID, GROUPID ) VALUES ( '1637', 'forum', 'head', 'The type personality /hardy personality tests', 'http://moodle.plumsteadmanor.com/mod/forum/discuss.php?d=550#1637', 1233848923, 1237973390, 226, 1 )<ul style="text-align:left"><li>line 1554 of lib\dmllib.php: call to debugging()</li><li>line 243 of search\indexlib.php: call to insert_record()</li><li>line 134 of search\add.php: call to IndexDBControl>addDocument()</li><li>line 20 of search\cron_php5.php: call to require_once()</li><li>line 25 of search\cron.php: call to include()</li><li>line 83 of blocks\search\block_search.php: call to include()</li><li>line 148 of admin\cron.php: call to block_search->cron()</li></ul></div>
Add: The type personality /hardy personality tests (database id = , moodle instance id = 1637)
<div class="notifytiny" style="text-align:center">Out of range value for column 'groupid' at row 1<br /><br />INSERT INTO mdl_block_search_documents ( DOCID, DOCTYPE, ITEMTYPE, TITLE, URL, DOCDATE, UPDATED, COURSEID, GROUPID ) VALUES ( '1638', 'forum', 'head', 'personality a and hardiness', 'http://moodle.plumsteadmanor.com/mod/forum/discuss.php?d=551#1638', 1233853767, 1237973390, 226, 1 )<ul style="text-align:left"><li>line 1554 of lib\dmllib.php: call to debugging()</li><li>line 243 of search\indexlib.php: call to insert_record()</li><li>line 134 of search\add.php: call to IndexDBControl>addDocument()</li><li>line 20 of search\cron_php5.php: call to require_once()</li><li>line 25 of search\cron.php: call to include()</li><li>line 83 of blocks\search\block_search.php: call to include()</li><li>line 148 of admin\cron.php: call to block_search->cron()</li></ul></div>

Activity

Hide
Matt Gibson added a comment -

Should have added: It's the forum module.

Show
Matt Gibson added a comment - Should have added: It's the forum module.
Hide
Valery Fremaux added a comment -

Thanks Matt,

we fixed with Tim some bad SQL practices, specially on Forum and Data documents.

these might have regressed obviously.

I check that ASAP.
Cheers.

Show
Valery Fremaux added a comment - Thanks Matt, we fixed with Tim some bad SQL practices, specially on Forum and Data documents. these might have regressed obviously. I check that ASAP. Cheers.
Hide
Michael de Raadt added a comment -

Thanks for reporting this issue.

We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported.

If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed.

Michael d;

lqjjLKA0p6

Show
Michael de Raadt added a comment - Thanks for reporting this issue. We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported. If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed. Michael d; lqjjLKA0p6
Hide
Michael de Raadt added a comment -

I'm closing this issue as it appears to have become inactive and is probably not relevant to a current supported version. If you are encountering this problem or one similar, please launch a new issue.

Show
Michael de Raadt added a comment - I'm closing this issue as it appears to have become inactive and is probably not relevant to a current supported version. If you are encountering this problem or one similar, please launch a new issue.

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: