Database Access error on checkout page

Issue #129 new
Former user created an issue

On The member information and checkout page - and only that page - I get this database access error. I can see the member information, but not any checkout or hold tools.
Page: http://[MYDOMAIN].com/openbiblio/circ/mbr_view.php?mbrid=4&reset=Y

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=4 and b.bibid=c.bibid failed. The DBMS said this:

Access denied for user 'cl45-tunipssql'@'%' to database 'cl45-tunipssql'
Debug Backtrace (most recent call first):

/home/sites/tunips.com/public_html/openbiblio/classes/Error.php:137 FatalHandler->printBackTrace()

/home/sites/tunips.com/public_html/openbiblio/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=4 and b.bibid=c.bibid ', 'Database query failed', 'Access denied for user \'cl45-tunipssql\'@\'%\' to database \'cl45-tunipssql\'')

/home/sites/tunips.com/public_html/openbiblio/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=4 and b.bibid=c.bibid ', 'Database query failed', 'Access denied for user \'cl45-tunipssql\'@\'%\' to database \'cl45-tunipssql\'')

/home/sites/tunips.com/public_html/openbiblio/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=4 and b.bibid=c.bibid ')

/home/sites/tunips.com/public_html/openbiblio/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=4 and b.bibid=c.bibid ')

/home/sites/tunips.com/public_html/openbiblio/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=4 and b.bibid=c.bibid ')

/home/sites/tunips.com/public_html/openbiblio/circ/mbr_view.php:180 DmQuery->getCheckoutStats('4')

Comments (3)

  1. Rob Wolff

    Thanks Hans.
    Looks like the problem was on my end. It turns out my hosting provider has an unusual set-up, such that granting all privileges would not grant a few specific ones, temporary tables included.
    All sorted now, thanks for your advice!

  2. Log in to comment