Share

OpenBiblio

Tracker: Support Requests

5 Database Query Error - You've Probably Found a Bug - ID: 1881708
Last Update: Comment added ( sf-robot )

Hello, I'm testing the OpenBiblio ver. 0.5.2 (Italian tanslation) on a free
hosting web, and I've a problem when I search a subscribe with his code.
I display this message:

Database Query Error - You've Probably Found a Bug
SQL 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:

Access denied for user 'opacschool'@'localhost' to database
'my_opacschool'


Could someone help me ?
I upload what I see.

Very thanks


Nobody/Anonymous ( nobody ) - 2008-01-29 10:18

5

Closed

None

Nobody/Anonymous

None

None

Public


Comments ( 2 )




Date: 2008-02-13 17:44
Sender: sf-robotSourceForge.net Site Admin


This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).


Date: 2008-01-30 16:35
Sender: mstetsonProject Admin


Your database administrator needs to grant opacschool more privileges on
the database. You need to be able to create temporary tables. A command
like this should do the trick:

GRANT CREATE TEMPORARY TABLES ON my_opacschool.* TO
'opacschool'@'localhost';

Or, if you just want to grant all privileges on that database:

GRANT ALL ON my_opacschool.* TO 'opacschool'@'localhost';

Hope that helps,

Micah



Log in to comment.

Attached File ( 1 )

Filename Description Download
bugopac1.JPG Download

Changes ( 6 )

Field Old Value Date By
status_id Pending 2008-02-13 17:44 sf-robot
close_date 2008-01-30 16:37 2008-02-13 17:44 sf-robot
data_type 458475 2008-01-30 16:38 mstetson
status_id Open 2008-01-30 16:37 mstetson
close_date - 2008-01-30 16:37 mstetson
File Added 264111: bugopac1.JPG 2008-01-29 10:18 nobody