Database Query Error: Table 'mbrout' already exists

Issue #125 new
Wissen Xue
created an issue

I install the obiblio in a cloud hosting php/mysql enviroment. and some times it works well and sometimes it show the Database Query Error like this:

==================================

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 create temporary table mbrout engine=memory select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b where c.mbrid=23 and b.bibid=c.bibid failed. The DBMS said this:

Table 'mbrout' already exists

Debug Backtrace (most recent call first):

/home/vcap/app/www/classes/Error.php:137 FatalHandler->printBackTrace() /home/vcap/app/www/classes/Error.php:105 FatalHandler->dbError('create temporary table mbrout engine=memory select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b where c.mbrid=23 and b.bibid=c.bibid ', 'Database query failed', 'Table \'mbrout\' already exists') /home/vcap/app/www/classes/Query.php:91 Fatal->dbError('create temporary table mbrout engine=memory select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b where c.mbrid=23 and b.bibid=c.bibid ', 'Database query failed', 'Table \'mbrout\' already exists') /home/vcap/app/www/classes/Query.php:266 Query->_act('create temporary table mbrout engine=memory select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b where c.mbrid=23 and b.bibid=c.bibid ') /home/vcap/app/www/classes/Query.php:271 Query->_exec('create temporary table mbrout engine=memory select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b where c.mbrid=23 and b.bibid=c.bibid ') /home/vcap/app/www/classes/DmQuery.php:72 Query->exec('create temporary table mbrout engine=memory select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b where c.mbrid=23 and b.bibid=c.bibid ') /home/vcap/app/www/circ/mbr_view.php:180 DmQuery->getCheckoutStats('23')

Comments (1)

  1. Log in to comment