OpenBiblio

Tracker: Support Requests

5 Database Query Error - You've Probably Found a Bug - ID: 1881708

Last Update: Comment added ( sf-robot )

Details:

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

Submitted:

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

Priority:

Status:

Closed

Resolution:

None

Assigned:

Nobody/Anonymous

Category:

None

Group:

None

Visibility:

Public

Comments ( 2 )

Date: 2008-02-13 17:44 Sender: sf-robot 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: mstetson 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

Date: 2008-02-13 17:44
Sender: sf-robot

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: mstetson

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

OpenBiblio

Tracker: Support Requests

Comments ( 2 )

Log in to comment.

Attached File ( 1 )

Changes ( 6 )

About SourceForge

Find Software

Develop Software

Community

Help