Table 'openbiblio.biblio_copy_fields' doesn't exist

Issue #98 closed
Former user created an issue

Does anyone have a clue what's wrong with the following:

I've updated our Openbiblio to a newer 64Bit server. The old version is: EasyPHP 5.3.0, MySQL 5.1.37, Openbiblio 0.6.1 (database 0.6.0) to EasyPHP 12.1, MySQL 5.5.27, Openbiblio 0.7.1 (database 0.6.0) and inported our existing database. I'm getting an error message after -cataloging >Search Bibliography by barcode number. It give bibliography information, but errors on Bibliography Copy Information:

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 * from biblio_copy_fields where bibid=7419 and copyid=1 failed. The DBMS said this:

Table 'openbiblio.biblio_copy_fields' doesn't exist
Debug Backtrace (most recent call first):
D:\Program Files\EasyPHP-12.1\www\openbiblio\classes\Error.php:137 FatalHandler->printBackTrace()
D:\Program Files\EasyPHP-12.1\www\openbiblio\classes\Error.php:105 FatalHandler->dbError('select * from biblio_copy_fields where bibid=7419 and copyid=1', 'Database query failed', 'Table \'openbiblio.biblio_copy_fields\' doesn\'t exist')
D:\Program Files\EasyPHP-12.1\www\openbiblio\classes\Query.php:91 Fatal->dbError('select * from biblio_copy_fields where bibid=7419 and copyid=1', 'Database query failed', 'Table \'openbiblio.biblio_copy_fields\' doesn\'t exist')
D:\Program Files\EasyPHP-12.1\www\openbiblio\classes\Query.php:59 Query->_act('select * from biblio_copy_fields where bibid=7419 and copyid=1')
D:\Program Files\EasyPHP-12.1\www\openbiblio\classes\BiblioCopyQuery.php:148 Query->select('select * from biblio_copy_fields where bibid=7419 and copyid=1')
D:\Program Files\EasyPHP-12.1\www\openbiblio\classes\BiblioCopyQuery.php:141 BiblioCopyQuery->getCustomFields('7419', '1')
D:\Program Files\EasyPHP-12.1\www\openbiblio\classes\BiblioCopyQuery.php:125 BiblioCopyQuery->_mkObj(array (
'bibid' => '7419',
'copyid' => '1',
'create_dt' => '2012-11-21 18:40:51',
'copy_desc' => 'PS2 127',
'barcode_nmbr' => '135768',
'status_cd' => 'out',
'status_begin_dt' => '2013-02-13 08:16:58',
'due_back_dt' => '2013-03-06',
'mbrid' => '62',
'renewal_count' => '0',
'days_late' => '0',
))
D:\Program Files\EasyPHP-12.1\www\openbiblio\shared\biblio_view.php:264 BiblioCopyQuery->fetchCopy()

Thanks for your help!!!

Comments (3)

  1. Log in to comment