HELP!! Database query failed

Wayne Lin
  • Wayne Lin

    Wayne Lin - 2011-01-22

    I built my OpenBiblio on a free-hosting service with a vistapanel.

    When I'm doing member searching, my openbiblio says,

    Could anybody tells me what's happening?

  • Nobody/Anonymous

    Try going  through every sql file in the install directory and change TYPE to ENGINE. The reason as follows:

    The ENGINE and TYPE options specify the storage engine for the table. ENGINE was added
    in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1). It is the preferred option name as of
    those versions, and TYPE has become deprecated. TYPE is supported throughout the 4.x
    series but it was removed in MySQL 5.5. When upgrading to MySQL 5.5 or later, you MUST convert existing
    applications that rely on TYPE to use ENGINE instead.
    So, for all MySQL versions since 4.0.18 and 4.1.2 you can use ENGINE.

    Perhaps any new versions of OpenBiblio will have that change incorporated with cautions for users of older versions of MySQL

  • Wayne Lin

    Wayne Lin - 2011-02-13

    I got the same outcome after changing all "TYPE" to "ENGINE" and reinstalling my OpenBiblio =(

  • Nobody/Anonymous

    62.    $sql = $this->mkSQL("create temporary table mbrout type=heap "
    change it to:

        $sql = $this->mkSQL("create temporary table mbrout engine=heap "

    it's found in te file DmQuery.php  in classes.

    that should solve the problem.

  • Hans van der Weij

    Perhaps your hosting service doesn't allow database users to create temporary tables.
    If this is allowed, you may have to set the privileges right.

    From /install_instructions.html :

    mysql> grant all privileges on OpenBiblio.* to obiblio_user@localhost
        -> identified by 'obiblio_password';

  • Wayne Lin

    Wayne Lin - 2011-03-31

    I changed the words in the DmQuery.php, but nothing changed.

    I installed OpenBiblio in another free web-hosting service, also with a VistaPanel,
    the same problem happened.

  • Hans van der Weij

    I'm not familiar with VistaPanel, but if you see something like phpMyAdminto or database management that might be the right tool to set the privileges right. In phpMyAdminto look for the SQL query window and enter command:

    grant all privileges on OpenBiblio.* to obiblio_user@localhost  identified by 'obiblio_password'

    In the command above you should use the values you have entered in database_constants.php when installing OpenBiblio.

  • Wayne Lin

    Wayne Lin - 2011-04-05

    It said, "GRANT,REFERENCES command denied to user '(my username)'@'(my IP)' for table '(my database name)'"

    Does it mean that my free web-hosting service doesn't allow me to have all privileges?

  • Nobody/Anonymous

    What does it say on something like GRANT CREATE TEMPORARY TABLES ON …



Cancel  Add attachments

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

Sign up for the SourceForge newsletter:

No, thanks