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?
You seem to have CSS turned off.
Please don't fill out this field.
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
I got the same outcome after changing all "TYPE" to "ENGINE" and reinstalling my OpenBiblio =(
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.
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';
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.
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.
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?
What does it say on something like GRANT CREATE TEMPORARY TABLES ON …
Sign up for the SourceForge newsletter: