database query error

Issue #127 invalid
Ferdinan Picar created an issue

Pls help 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 ( '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 '%sauco%' and not (bf0.tag = '260' and bf0.subfield_cd in ('a', 'b', 'e', 'f', 'g')) and not bf0.subfield_cd regexp('[0-9]') where (biblio.author like '%sauco%' or biblio.responsibility_stmt like '%sauco%' or biblio.title like '%sauco%' or biblio.title_remainder like '%sauco%' or biblio.topic1 like '%sauco%' or biblio.topic2 like '%sauco%' or biblio.topic3 like '%sauco%' or biblio.topic4 like '%sauco%' or biblio.topic5 like '%sauco%' or bf0.field_data like '%sauco%' ) order by title limit 0, 20 failed. The DBMS said this:

Table 'biblio_copy' is marked as crashed and should be repaired

Debug Backtrace (most recent call first):

C:\xampp\htdocs\openbiblio\classes\Error.php:137 FatalHandler->printBackTrace() C:\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 ( \'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 \'%sauco%\' and not (bf0.tag = \'260\' and bf0.subfield_cd in (\'a\', \'b\', \'e\', \'f\', \'g\')) and not bf0.subfield_cd regexp(\'[0-9]\') where (biblio.author like \'%sauco%\' or biblio.responsibility_stmt like \'%sauco%\' or biblio.title like \'%sauco%\' or biblio.title_remainder like \'%sauco%\' or biblio.topic1 like \'%sauco%\' or biblio.topic2 like \'%sauco%\' or biblio.topic3 like \'%sauco%\' or biblio.topic4 like \'%sauco%\' or biblio.topic5 like \'%sauco%\' or bf0.field_data like \'%sauco%\' ) order by title limit 0, 20', 'Database query failed', 'Table \'biblio_copy\' is marked as crashed and should be repaired') C:\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 ( \'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 \'%sauco%\' and not (bf0.tag = \'260\' and bf0.subfield_cd in (\'a\', \'b\', \'e\', \'f\', \'g\')) and not bf0.subfield_cd regexp(\'[0-9]\') where (biblio.author like \'%sauco%\' or biblio.responsibility_stmt like \'%sauco%\' or biblio.title like \'%sauco%\' or biblio.title_remainder like \'%sauco%\' or biblio.topic1 like \'%sauco%\' or biblio.topic2 like \'%sauco%\' or biblio.topic3 like \'%sauco%\' or biblio.topic4 like \'%sauco%\' or biblio.topic5 like \'%sauco%\' or bf0.field_data like \'%sauco%\' ) order by title limit 0, 20', 'Database query failed', 'Table \'biblio_copy\' is marked as crashed and should be repaired') C:\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 ( \'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 \'%sauco%\' and not (bf0.tag = \'260\' and bf0.subfield_cd in (\'a\', \'b\', \'e\', \'f\', \'g\')) and not bf0.subfield_cd regexp(\'[0-9]\') where (biblio.author like \'%sauco%\' or biblio.responsibility_stmt like \'%sauco%\' or biblio.title like \'%sauco%\' or biblio.title_remainder like \'%sauco%\' or biblio.topic1 like \'%sauco%\' or biblio.topic2 like \'%sauco%\' or biblio.topic3 like \'%sauco%\' or biblio.topic4 like \'%sauco%\' or biblio.topic5 like \'%sauco%\' or bf0.field_data like \'%sauco%\' ) order by title limit 0, 20') C:\xampp\htdocs\openbiblio\classes\BiblioSearchQuery.php:200 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 ( \'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 \'%sauco%\' and not (bf0.tag = \'260\' and bf0.subfield_cd in (\'a\', \'b\', \'e\', \'f\', \'g\')) and not bf0.subfield_cd regexp(\'[0-9]\') where (biblio.author like \'%sauco%\' or biblio.responsibility_stmt like \'%sauco%\' or biblio.title like \'%sauco%\' or biblio.title_remainder like \'%sauco%\' or biblio.topic1 like \'%sauco%\' or biblio.topic2 like \'%sauco%\' or biblio.topic3 like \'%sauco%\' or biblio.topic4 like \'%sauco%\' or biblio.topic5 like \'%sauco%\' or bf0.field_data like \'%sauco%\' ) order by title limit 0, 20', 'Error searching bibliography information.') C:\xampp\htdocs\openbiblio\shared\biblio_search.php:135 BiblioSearchQuery->search('7', array ( 0 => 'sauco', ), 1, 'title', false)

Comments (1)

  1. Log in to comment