Deprecated

Create issue
Issue #64 duplicate
manap created an issue

Deprecated: Function set_magic_quotes_runtime() is deprecated in C:\xampp\htdocs\openbiblio\shared\common.php on line 24

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 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:267 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:272 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')

Comments (1)

  1. Hans van der Weij

    Deprecated messages: adjust PHP.INI to production values.

    Database Query Error: happens with MySQL 5.5 or higher. Fix (for Member Info page): https://bitbucket.org/jgvdweij/obiblio/raw/tip/classes/DmQuery.php

    There are many more issues in OpenBiblio 0.6.1. You can testdrive a newer version with all issues fixed. This is not an official release, but your feedback can help getting closer to an official release. http://sourceforge.net/projects/obiblio/forums/forum/164978/topic/4783324

    Duplicate of #36.

  2. Log in to comment