No Checkout Option

Issue #43 duplicate
Former user created an issue

After a few fixes I got the install to work and I can create new members but when I bring up a new patron there is no option to checkout anything (I do have the option to checkin) The error message I receive when I bring up a member is:

Database query failed

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

Query create temporary table mbrout type=heap select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b where c.mbrid=4 and b.bibid=c.bibid failed. The DBMS said this:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type=heap select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b w' at line 1

Debug Backtrace (most recent call first):

C:\xampp\htdocs\openbiblio\classes\Error.php:100 FatalHandler->printBackTrace() C:\xampp\htdocs\openbiblio\classes\Error.php:68 FatalHandler->dbError('create temporary table mbrout type=heap select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b where c.mbrid=4 and b.bibid=c.bibid ', 'Database query failed', 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'type=heap select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b w\' at line 1') C:\xampp\htdocs\openbiblio\classes\Query.php:91 Fatal->dbError('create temporary table mbrout type=heap select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b where c.mbrid=4 and b.bibid=c.bibid ', 'Database query failed', 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'type=heap select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b w\' at line 1') C:\xampp\htdocs\openbiblio\classes\Query.php:266 Query->_act('create temporary table mbrout type=heap select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b where c.mbrid=4 and b.bibid=c.bibid ') C:\xampp\htdocs\openbiblio\classes\Query.php:271 Query->_exec('create temporary table mbrout type=heap select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b where c.mbrid=4 and b.bibid=c.bibid ') C:\xampp\htdocs\openbiblio\classes\DmQuery.php:66 Query->exec('create temporary table mbrout type=heap select b.material_cd, c.bibid, c.copyid from biblio_copy c, biblio b where c.mbrid=4 and b.bibid=c.bibid ') C:\xampp\htdocs\openbiblio\circ\mbr_view.php:190 DmQuery->getCheckoutStats('4')

OpenBiblio 0.6.1 MySQL 5.0.22 PHP 5.3.5 XAMPP 1.7.4

Comments (1)

  1. Log in to comment