Searching keyword "c++"

2013-04-04
2013-05-30
  • Noel Casimiro
    Noel Casimiro
    2013-04-04

    I think I just encountered a bug while searching the keyword c++. If I remove the ++, the search result is fine. Here is the report:

    Database Query Error - You've Probably Found a Bug

    Database query failed

    Please give all the information on this page to your support personnel.

    Query select sql_calc_found_rows distinct biblio.* ,biblio_copy.copyid ,biblio_copy.barcode_nmbr ,biblio_copy.status_cd ,biblio_copy.due_back_dt ,biblio_copy.mbrid from biblio left join biblio_copy on biblio.bibid=biblio_copy.bibid left join biblio_field as bf0 on bf0.bibid=biblio.bibid and bf0.tag in ( '010', '020', '022', '024', '110', '130', '245', '250', '260', '300', '336', '337', '338', '340', '380', '381', '382', '384', '383', '384', '400', '410', '440', '490', '500', '501', '502', '505', '511', '520', '521', '526', '600', '610', '611', '630', '650', '651', '653', '654', '655', '656', '657', '658', '690', '691', '692', '693', '694', '695', '696', '697', '698', '699', '700', '710', '730', '800', '810', '830', '856' ) and bf0.field_data like '%beginning%' and not (bf0.tag = '260' and bf0.subfield_cd in ('a', 'b', 'e', 'f', 'g')) and not bf0.subfield_cd regexp('') left join biblio_field as bf1 on bf1.bibid=biblio.bibid and bf1.tag in ( '110', '130', '245', '250', '260', '300', '336', '337', '338', '340', '380', '381', '382', '384', '383', '384', '400', '410', '440', '490', '500', '501', '502', '505', '511', '520', '521', '526', '600', '610', '611', '630', '650', '651', '653', '654', '655', '656', '657', '658', '690', '691', '692', '693', '694', '695', '696', '697', '698', '699', '700', '710', '730', '800', '810', '830', '856' ) and bf1.field_data like '%c++%' and bf1.field_data rlike '[]c++' and not (bf1.tag = '260' and bf1.subfield_cd in ('a', 'b', 'e', 'f', 'g')) and not bf1.subfield_cd regexp('') where (`biblio`.`author` like '%beginning%' or `biblio`.`responsibility_stmt` like '%beginning%' or `biblio`.`title` like '%beginning%' or `biblio`.`title_remainder` like '%beginning%' or `biblio`.`topic1` like '%beginning%' or `biblio`.`topic2` like '%beginning%' or `biblio`.`topic3` like '%beginning%' or `biblio`.`topic4` like '%beginning%' or `biblio`.`topic5` like '%beginning%' or `bf0`.`field_data` like '%beginning%' ) and (`biblio`.`author` like '%c++%' or `biblio`.`responsibility_stmt` like '%c++%' or `biblio`.`title` like '%c++%' or `biblio`.`title_remainder` like '%c++%' or `biblio`.`topic1` like '%c++%' or `biblio`.`topic2` like '%c++%' or `biblio`.`topic3` like '%c++%' or `biblio`.`topic4` like '%c++%' or `biblio`.`topic5` like '%c++%' or `bf1`.`field_data` like '%c++%' ) order by `title` limit 0, 10 failed. The DBMS said this:

    Got error 'repetition-operator operand invalid' from regexp
    Debug Backtrace (most recent call first):

    C:\Program Files\xampp\htdocs\openbiblio\classes\Error.php:137 FatalHandler->printBackTrace()
    C:\Program Files\xampp\htdocs\openbiblio\classes\Error.php:105 FatalHandler->dbError('select sql_calc_found_rows distinct biblio.* ,biblio_copy.copyid ,biblio_copy.barcode_nmbr ,biblio_copy.status_cd ,biblio_copy.due_back_dt ,biblio_copy.mbrid from biblio left join biblio_copy on biblio.bibid=biblio_copy.bibid left join biblio_field as bf0 on bf0.bibid=biblio.bibid and bf0.tag in ( \'010\', \'020\', \'022\', \'024\',
                \'110\', \'130\', \'245\', \'250\', \'260\',
                \'300\', \'336\', \'337\', \'338\', \'340\',
                \'380\', \'381\', \'382\', \'384\', \'383\', \'384\',
                \'400\', \'410\', \'440\', \'490\',
                \'500\', \'501\', \'502\', \'505\', \'511\', \'520\',
                \'521\', \'526\',
                \'600\', \'610\', \'611\', \'630\', \'650\', \'651\',
                \'653\', \'654\', \'655\', \'656\', \'657\', \'658\',
                \'690\', \'691\', \'692\', \'693\', \'694\', \'695\',
                \'696\', \'697\', \'698\', \'699\',
                \'700\', \'710\', \'730\',
                \'800\', \'810\', \'830\', \'856\'
              ) and bf0.field_data like \'%beginning%\' and not (bf0.tag = \'260\' and bf0.subfield_cd in (\'a\', \'b\', \'e\', \'f\', \'g\')) and not bf0.subfield_cd regexp(\'\') left join biblio_field as bf1 on bf1.bibid=biblio.bibid and bf1.tag in (
                \'110\', \'130\', \'245\', \'250\', \'260\',
                \'300\', \'336\', \'337\', \'338\', \'340\',
                \'380\', \'381\', \'382\', \'384\', \'383\', \'384\',
                \'400\', \'410\', \'440\', \'490\',
                \'500\', \'501\', \'502\', \'505\', \'511\', \'520\',
                \'521\', \'526\',
                \'600\', \'610\', \'611\', \'630\', \'650\', \'651\',
                \'653\', \'654\', \'655\', \'656\', \'657\', \'658\',
                \'690\', \'691\', \'692\', \'693\', \'694\', \'695\',
                \'696\', \'697\', \'698\', \'699\',
                \'700\', \'710\', \'730\',
                \'800\', \'810\', \'830\', \'856\'
              ) and bf1.field_data like \'%c++%\' and bf1.field_data rlike \'[]c++\' and not (bf1.tag = \'260\' and bf1.subfield_cd in (\'a\', \'b\', \'e\', \'f\', \'g\')) and not bf1.subfield_cd regexp(\'\') where (`biblio`.`author` like \'%beginning%\'  or `biblio`.`responsibility_stmt` like \'%beginning%\'  or `biblio`.`title` like \'%beginning%\'  or `biblio`.`title_remainder` like \'%beginning%\'  or `biblio`.`topic1` like \'%beginning%\'  or `biblio`.`topic2` like \'%beginning%\'  or `biblio`.`topic3` like \'%beginning%\'  or `biblio`.`topic4` like \'%beginning%\'  or `biblio`.`topic5` like \'%beginning%\'  or `bf0`.`field_data` like \'%beginning%\' ) and (`biblio`.`author` like \'%c++%\'  or `biblio`.`responsibility_stmt` like \'%c++%\'  or `biblio`.`title` like \'%c++%\'  or `biblio`.`title_remainder` like \'%c++%\'  or `biblio`.`topic1` like \'%c++%\'  or `biblio`.`topic2` like \'%c++%\'  or `biblio`.`topic3` like \'%c++%\'  or `biblio`.`topic4` like \'%c++%\'  or `biblio`.`topic5` like \'%c++%\'  or `bf1`.`field_data` like \'%c++%\' ) order by `title`  limit 0, 10', 'Database query failed', 'Got error \'repetition-operator operand invalid\' from regexp')
    C:\Program Files\xampp\htdocs\openbiblio\classes\Query.php:91 Fatal->dbError('select sql_calc_found_rows distinct biblio.* ,biblio_copy.copyid ,biblio_copy.barcode_nmbr ,biblio_copy.status_cd ,biblio_copy.due_back_dt ,biblio_copy.mbrid from biblio left join biblio_copy on biblio.bibid=biblio_copy.bibid left join biblio_field as bf0 on bf0.bibid=biblio.bibid and bf0.tag in ( \'010\', \'020\', \'022\', \'024\',
                \'110\', \'130\', \'245\', \'250\', \'260\',
                \'300\', \'336\', \'337\', \'338\', \'340\',
                \'380\', \'381\', \'382\', \'384\', \'383\', \'384\',
                \'400\', \'410\', \'440\', \'490\',
                \'500\', \'501\', \'502\', \'505\', \'511\', \'520\',
                \'521\', \'526\',
                \'600\', \'610\', \'611\', \'630\', \'650\', \'651\',
                \'653\', \'654\', \'655\', \'656\', \'657\', \'658\',
                \'690\', \'691\', \'692\', \'693\', \'694\', \'695\',
                \'696\', \'697\', \'698\', \'699\',
                \'700\', \'710\', \'730\',
                \'800\', \'810\', \'830\', \'856\'
              ) and bf0.field_data like \'%beginning%\' and not (bf0.tag = \'260\' and bf0.subfield_cd in (\'a\', \'b\', \'e\', \'f\', \'g\')) and not bf0.subfield_cd regexp(\'\') left join biblio_field as bf1 on bf1.bibid=biblio.bibid and bf1.tag in (
                \'110\', \'130\', \'245\', \'250\', \'260\',
                \'300\', \'336\', \'337\', \'338\', \'340\',
                \'380\', \'381\', \'382\', \'384\', \'383\', \'384\',
                \'400\', \'410\', \'440\', \'490\',
                \'500\', \'501\', \'502\', \'505\', \'511\', \'520\',
                \'521\', \'526\',
                \'600\', \'610\', \'611\', \'630\', \'650\', \'651\',
                \'653\', \'654\', \'655\', \'656\', \'657\', \'658\',
                \'690\', \'691\', \'692\', \'693\', \'694\', \'695\',
                \'696\', \'697\', \'698\', \'699\',
                \'700\', \'710\', \'730\',
                \'800\', \'810\', \'830\', \'856\'
              ) and bf1.field_data like \'%c++%\' and bf1.field_data rlike \'[]c++\' and not (bf1.tag = \'260\' and bf1.subfield_cd in (\'a\', \'b\', \'e\', \'f\', \'g\')) and not bf1.subfield_cd regexp(\'\') where (`biblio`.`author` like \'%beginning%\'  or `biblio`.`responsibility_stmt` like \'%beginning%\'  or `biblio`.`title` like \'%beginning%\'  or `biblio`.`title_remainder` like \'%beginning%\'  or `biblio`.`topic1` like \'%beginning%\'  or `biblio`.`topic2` like \'%beginning%\'  or `biblio`.`topic3` like \'%beginning%\'  or `biblio`.`topic4` like \'%beginning%\'  or `biblio`.`topic5` like \'%beginning%\'  or `bf0`.`field_data` like \'%beginning%\' ) and (`biblio`.`author` like \'%c++%\'  or `biblio`.`responsibility_stmt` like \'%c++%\'  or `biblio`.`title` like \'%c++%\'  or `biblio`.`title_remainder` like \'%c++%\'  or `biblio`.`topic1` like \'%c++%\'  or `biblio`.`topic2` like \'%c++%\'  or `biblio`.`topic3` like \'%c++%\'  or `biblio`.`topic4` like \'%c++%\'  or `biblio`.`topic5` like \'%c++%\'  or `bf1`.`field_data` like \'%c++%\' ) order by `title`  limit 0, 10', 'Database query failed', 'Got error \'repetition-operator operand invalid\' from regexp')
    C:\Program Files\xampp\htdocs\openbiblio\classes\Query.php:286 Query->_act('select sql_calc_found_rows distinct biblio.* ,biblio_copy.copyid ,biblio_copy.barcode_nmbr ,biblio_copy.status_cd ,biblio_copy.due_back_dt ,biblio_copy.mbrid from biblio left join biblio_copy on biblio.bibid=biblio_copy.bibid left join biblio_field as bf0 on bf0.bibid=biblio.bibid and bf0.tag in ( \'010\', \'020\', \'022\', \'024\',
                \'110\', \'130\', \'245\', \'250\', \'260\',
                \'300\', \'336\', \'337\', \'338\', \'340\',
                \'380\', \'381\', \'382\', \'384\', \'383\', \'384\',
                \'400\', \'410\', \'440\', \'490\',
                \'500\', \'501\', \'502\', \'505\', \'511\', \'520\',
                \'521\', \'526\',
                \'600\', \'610\', \'611\', \'630\', \'650\', \'651\',
                \'653\', \'654\', \'655\', \'656\', \'657\', \'658\',
                \'690\', \'691\', \'692\', \'693\', \'694\', \'695\',
                \'696\', \'697\', \'698\', \'699\',
                \'700\', \'710\', \'730\',
                \'800\', \'810\', \'830\', \'856\'
              ) and bf0.field_data like \'%beginning%\' and not (bf0.tag = \'260\' and bf0.subfield_cd in (\'a\', \'b\', \'e\', \'f\', \'g\')) and not bf0.subfield_cd regexp(\'\') left join biblio_field as bf1 on bf1.bibid=biblio.bibid and bf1.tag in (
                \'110\', \'130\', \'245\', \'250\', \'260\',
                \'300\', \'336\', \'337\', \'338\', \'340\',
                \'380\', \'381\', \'382\', \'384\', \'383\', \'384\',
                \'400\', \'410\', \'440\', \'490\',
                \'500\', \'501\', \'502\', \'505\', \'511\', \'520\',
                \'521\', \'526\',
                \'600\', \'610\', \'611\', \'630\', \'650\', \'651\',
                \'653\', \'654\', \'655\', \'656\', \'657\', \'658\',
                \'690\', \'691\', \'692\', \'693\', \'694\', \'695\',
                \'696\', \'697\', \'698\', \'699\',
                \'700\', \'710\', \'730\',
                \'800\', \'810\', \'830\', \'856\'
              ) and bf1.field_data like \'%c++%\' and bf1.field_data rlike \'[]c++\' and not (bf1.tag = \'260\' and bf1.subfield_cd in (\'a\', \'b\', \'e\', \'f\', \'g\')) and not bf1.subfield_cd regexp(\'\') where (`biblio`.`author` like \'%beginning%\'  or `biblio`.`responsibility_stmt` like \'%beginning%\'  or `biblio`.`title` like \'%beginning%\'  or `biblio`.`title_remainder` like \'%beginning%\'  or `biblio`.`topic1` like \'%beginning%\'  or `biblio`.`topic2` like \'%beginning%\'  or `biblio`.`topic3` like \'%beginning%\'  or `biblio`.`topic4` like \'%beginning%\'  or `biblio`.`topic5` like \'%beginning%\'  or `bf0`.`field_data` like \'%beginning%\' ) and (`biblio`.`author` like \'%c++%\'  or `biblio`.`responsibility_stmt` like \'%c++%\'  or `biblio`.`title` like \'%c++%\'  or `biblio`.`title_remainder` like \'%c++%\'  or `biblio`.`topic1` like \'%c++%\'  or `biblio`.`topic2` like \'%c++%\'  or `biblio`.`topic3` like \'%c++%\'  or `biblio`.`topic4` like \'%c++%\'  or `biblio`.`topic5` like \'%c++%\'  or `bf1`.`field_data` like \'%c++%\' ) order by `title`  limit 0, 10')
    C:\Program Files\xampp\htdocs\openbiblio\classes\BiblioSearchQuery.php:196 Query->_query('select sql_calc_found_rows distinct biblio.* ,biblio_copy.copyid ,biblio_copy.barcode_nmbr ,biblio_copy.status_cd ,biblio_copy.due_back_dt ,biblio_copy.mbrid from biblio left join biblio_copy on biblio.bibid=biblio_copy.bibid left join biblio_field as bf0 on bf0.bibid=biblio.bibid and bf0.tag in ( \'010\', \'020\', \'022\', \'024\',
                \'110\', \'130\', \'245\', \'250\', \'260\',
                \'300\', \'336\', \'337\', \'338\', \'340\',
                \'380\', \'381\', \'382\', \'384\', \'383\', \'384\',
                \'400\', \'410\', \'440\', \'490\',
                \'500\', \'501\', \'502\', \'505\', \'511\', \'520\',
                \'521\', \'526\',
                \'600\', \'610\', \'611\', \'630\', \'650\', \'651\',
                \'653\', \'654\', \'655\', \'656\', \'657\', \'658\',
                \'690\', \'691\', \'692\', \'693\', \'694\', \'695\',
                \'696\', \'697\', \'698\', \'699\',
                \'700\', \'710\', \'730\',
                \'800\', \'810\', \'830\', \'856\'
              ) and bf0.field_data like \'%beginning%\' and not (bf0.tag = \'260\' and bf0.subfield_cd in (\'a\', \'b\', \'e\', \'f\', \'g\')) and not bf0.subfield_cd regexp(\'\') left join biblio_field as bf1 on bf1.bibid=biblio.bibid and bf1.tag in (
                \'110\', \'130\', \'245\', \'250\', \'260\',
                \'300\', \'336\', \'337\', \'338\', \'340\',
                \'380\', \'381\', \'382\', \'384\', \'383\', \'384\',
                \'400\', \'410\', \'440\', \'490\',
                \'500\', \'501\', \'502\', \'505\', \'511\', \'520\',
                \'521\', \'526\',
                \'600\', \'610\', \'611\', \'630\', \'650\', \'651\',
                \'653\', \'654\', \'655\', \'656\', \'657\', \'658\',
                \'690\', \'691\', \'692\', \'693\', \'694\', \'695\',
                \'696\', \'697\', \'698\', \'699\',
                \'700\', \'710\', \'730\',
                \'800\', \'810\', \'830\', \'856\'
              ) and bf1.field_data like \'%c++%\' and bf1.field_data rlike \'[]c++\' and not (bf1.tag = \'260\' and bf1.subfield_cd in (\'a\', \'b\', \'e\', \'f\', \'g\')) and not bf1.subfield_cd regexp(\'\') where (`biblio`.`author` like \'%beginning%\'  or `biblio`.`responsibility_stmt` like \'%beginning%\'  or `biblio`.`title` like \'%beginning%\'  or `biblio`.`title_remainder` like \'%beginning%\'  or `biblio`.`topic1` like \'%beginning%\'  or `biblio`.`topic2` like \'%beginning%\'  or `biblio`.`topic3` like \'%beginning%\'  or `biblio`.`topic4` like \'%beginning%\'  or `biblio`.`topic5` like \'%beginning%\'  or `bf0`.`field_data` like \'%beginning%\' ) and (`biblio`.`author` like \'%c++%\'  or `biblio`.`responsibility_stmt` like \'%c++%\'  or `biblio`.`title` like \'%c++%\'  or `biblio`.`title_remainder` like \'%c++%\'  or `biblio`.`topic1` like \'%c++%\'  or `biblio`.`topic2` like \'%c++%\'  or `biblio`.`topic3` like \'%c++%\'  or `biblio`.`topic4` like \'%c++%\'  or `biblio`.`topic5` like \'%c++%\'  or `bf1`.`field_data` like \'%c++%\' ) order by `title`  limit 0, 10', 'Error searching bibliography information.')
    C:\Program Files\xampp\htdocs\openbiblio\shared\biblio_search.php:135 BiblioSearchQuery->search('7', array (
      0 => 'beginning',
      1 => 'c++',
    ), 1, 'title', false)

     
  • Noel Casimiro
    Noel Casimiro
    2013-04-04

    I use OpenBiblio 0.7.1 in XAMPP 1.5.1