Error while searching for a user

Help
2008-12-13
2013-05-30
  • Nobody/Anonymous

    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 mat.*, ifnull(privs.checkout_limit, 0) checkout_limit, ifnull(privs.renewal_limit, 0) renewal_limit, count(mbrout.copyid) row_count from material_type_dm mat, member left join checkout_privs privs on privs.material_cd=mat.code and privs.classification=member.classification left join mbrout on mbrout.material_cd=mat.code where member.mbrid=1 group by mat.code, mat.description, mat.default_flg, privs.checkout_limit, privs.renewal_limit failed. The DBMS said this:

    Unknown column 'mat.code' in 'on clause'

    Debug Backtrace (most recent call first):

    /opt/lampp/htdocs/openbiblio/classes/Error.php:100 FatalHandler->printBackTrace()
    /opt/lampp/htdocs/openbiblio/classes/Error.php:68 FatalHandler->dbError('select mat.*, ifnull(privs.checkout_limit, 0) checkout_limit, ifnull(privs.renewal_limit, 0) renewal_limit, count(mbrout.copyid) row_count from material_type_dm mat, member left join checkout_privs privs on privs.material_cd=mat.code and privs.classification=member.classification left join mbrout on mbrout.material_cd=mat.code where member.mbrid=1 group by mat.code, mat.description, mat.default_flg, privs.checkout_limit, privs.renewal_limit ', 'Database query failed', 'Unknown column \'mat.code\' in \'on clause\'')
    /opt/lampp/htdocs/openbiblio/classes/Query.php:91 Fatal->dbError('select mat.*, ifnull(privs.checkout_limit, 0) checkout_limit, ifnull(privs.renewal_limit, 0) renewal_limit, count(mbrout.copyid) row_count from material_type_dm mat, member left join checkout_privs privs on privs.material_cd=mat.code and privs.classification=member.classification left join mbrout on mbrout.material_cd=mat.code where member.mbrid=1 group by mat.code, mat.description, mat.default_flg, privs.checkout_limit, privs.renewal_limit ', 'Database query failed', 'Unknown column \'mat.code\' in \'on clause\'')
    /opt/lampp/htdocs/openbiblio/classes/Query.php:266 Query->_act('select mat.*, ifnull(privs.checkout_limit, 0) checkout_limit, ifnull(privs.renewal_limit, 0) renewal_limit, count(mbrout.copyid) row_count from material_type_dm mat, member left join checkout_privs privs on privs.material_cd=mat.code and privs.classification=member.classification left join mbrout on mbrout.material_cd=mat.code where member.mbrid=1 group by mat.code, mat.description, mat.default_flg, privs.checkout_limit, privs.renewal_limit ')
    /opt/lampp/htdocs/openbiblio/classes/Query.php:271 Query->_exec('select mat.*, ifnull(privs.checkout_limit, 0) checkout_limit, ifnull(privs.renewal_limit, 0) renewal_limit, count(mbrout.copyid) row_count from material_type_dm mat, member left join checkout_privs privs on privs.material_cd=mat.code and privs.classification=member.classification left join mbrout on mbrout.material_cd=mat.code where member.mbrid=1 group by mat.code, mat.description, mat.default_flg, privs.checkout_limit, privs.renewal_limit ')
    /opt/lampp/htdocs/openbiblio/classes/DmQuery.php:79 Query->exec('select mat.*, ifnull(privs.checkout_limit, 0) checkout_limit, ifnull(privs.renewal_limit, 0) renewal_limit, count(mbrout.copyid) row_count from material_type_dm mat, member left join checkout_privs privs on privs.material_cd=mat.code and privs.classification=member.classification left join mbrout on mbrout.material_cd=mat.code where member.mbrid=1 group by mat.code, mat.description, mat.default_flg, privs.checkout_limit, privs.renewal_limit ')
    /opt/lampp/htdocs/openbiblio/circ/mbr_view.php:190 DmQuery->getCheckoutStats('1')

    Hints?

     


Anonymous

Cancel  Add attachments





Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks