Table 'openbiblio.biblio_copy_fields' doesn't exist

Anonymous avatarAnonymous 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 (2)

  1. Log in to comment
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.