SQL error executing 'Show Files Like

Hi

I fixed the problems reported in 'parse error on line 14'. I think it's best to start a new thread to discuss the problems I now have, although I reported them at the end of that earlier thread.

I am fairly confident (but not totally certain) that I am running PhP5.2. My ISP, 1&1, inform me that it is sufficient that the .htaccess file in the root of the installation should contain the following line:

AddType x-mapp-php5 .php

I have put this line at the start of the three .htaccess files which come in the installation version of Omeka, but I have not put additional .htaccess files in the remaining directories. Thus, I don't think the problem arises from running the wrong version of PhP any more.

I get the error message below after clicking to start the installation. Any ideas?

A

An error occurred within the following SQL statement: SHOW TABLES LIKE 'omeka_%' Stack Trace: #0 /homepages/18/d84696650/htdocs/Omeka/application/libraries/Zend/Db/Statement.php(109): Zend_Db_Statement_Mysqli->_prepare('SHOW TABLES LIK...') #1 /homepages/18/d84696650/htdocs/Omeka/application/libraries/Zend/Db/Adapter/Mysqli.php(284): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SHOW TABLES LIK...') #2 /homepages/18/d84696650/htdocs/Omeka/application/libraries/Zend/Db/Adapter/Abstract.php(261): Zend_Db_Adapter_Mysqli->prepare('SHOW TABLES LIK...') #3 /homepages/18/d84696650/htdocs/Omeka/application/libraries/Omeka/Db.php(255): Zend_Db_Adapter_Abstract->query('SHOW TABLES LIK...', Array) #4 /homepages/18/d84696650/htdocs/Omeka/install/install.php(23): Omeka_Db->query('SHOW TABLES LIK...') #5 /homepages/18/d84696650/htdocs/Omeka/install/index.php(18): require_once('/homepages/18/d...') #6 {main} Dump of the exception: object(Zend_Db_Statement_Mysqli_Exception)#74 (6) { ["message:protected"]=> string(37) "Mysqli prepare error: Unknown command" ["string:private"]=> string(0) "" ["code:protected"]=> int(0) ["file:protected"]=> string(87) "/homepages/18/d84696650/htdocs/Omeka/application/libraries/Zend/Db/Statement/Mysqli.php" ["line:protected"]=> int(85) ["trace:private"]=> array(6) { [0]=> array(6) { ["file"]=> string(80) "/homepages/18/d84696650/htdocs/Omeka/application/libraries/Zend/Db/Statement.php" ["line"]=> int(109) ["function"]=> string(8) "_prepare" ["class"]=> string(24) "Zend_Db_Statement_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(26) "SHOW TABLES LIKE 'omeka_%'" } } [1]=> array(6) { ["file"]=> string(85) "/homepages/18/d84696650/htdocs/Omeka/application/libraries/Zend/Db/Adapter/Mysqli.php" ["line"]=> int(284) ["function"]=> string(11) "__construct" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Db_Adapter_Mysqli)#69 (6) { ["_config:protected"]=> array(6) { ["host"]=> string(21) "db278.oneandone.co.uk" ["username"]=> string(11) "dbo97893408" ["password"]=> string(8) "kreplach" ["dbname"]=> string(10) "db97893408" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#70 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_connection:protected"]=> object(mysqli)#72 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } [1]=> string(26) "SHOW TABLES LIKE 'omeka_%'" } } [2]=> array(6) { ["file"]=> string(87) "/homepages/18/d84696650/htdocs/Omeka/application/libraries/Zend/Db/Adapter/Abstract.php" ["line"]=> int(261) ["function"]=> string(7) "prepare" ["class"]=> string(22) "Zend_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(26) "SHOW TABLES LIKE 'omeka_%'" } } [3]=> array(6) { ["file"]=> string(71) "/homepages/18/d84696650/htdocs/Omeka/application/libraries/Omeka/Db.php" ["line"]=> int(255) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(26) "SHOW TABLES LIKE 'omeka_%'" [1]=> array(0) { } } } [4]=> array(6) { ["file"]=> string(56) "/homepages/18/d84696650/htdocs/Omeka/install/install.php" ["line"]=> int(23) ["function"]=> string(5) "query" ["class"]=> string(8) "Omeka_Db" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(26) "SHOW TABLES LIKE 'omeka_%'" } } [5]=> array(4) { ["file"]=> string(54) "/homepages/18/d84696650/htdocs/Omeka/install/index.php" ["line"]=> int(18) ["args"]=> array(1) { [0]=> string(56) "/homepages/18/d84696650/htdocs/Omeka/install/install.php" } ["function"]=> string(12) "require_once" } } }

Please refer to Omeka documentation for help.

Create a file named phpinfo.php with the following code:

<?php

phpinfo();

?>

You'll see what version of PHP you're running.

It's version 5.2.5, so the problem seems to have another cause.

What version of MySQL do you have, and what MySQL permissions do you have for your Omeka database?

Hi, the MySQL version is 4.0. There is only one database and only one user, who I think is the super-user with full permissions for that database.

btw I have now installed Omeka locally using WAMPserver, so this suggests I am not doing anything fundamentally wrong. However, the ultimate aim still remains to get it going on my 1&1 site if I can.

A

Just for clarification, is your Omeka install bombing out on your WAMP server, or is it failing on 1and1 hosting? If I recall correctly, we've had others on the forum installing on 1and1 and they had to do something similar where they added that line to their .htaccess file. The problem with that SQL statement doesn't quite make sense to me, just because I can't tell whether it's a problem with that specific SHOW TABLES statement or a more general error. This seems to be a bigger bug in Omeka, if only because the error message is not giving the right sort of details that will help me fix it.

On the plus side, we're going to have a bugfix release out in a few days, and that should clear up many of the problems that people have experienced when installing Omeka.

Just for clarification, is your Omeka install bombing out on your WAMP server, or is it failing on 1and1 hosting? If I recall correctly, we've had others on the forum installing on 1and1 and they had to do something similar where they added that line to their .htaccess file. The problem with that SQL statement doesn't quite make sense to me, just because I can't tell whether it's a problem with that specific SHOW TABLES statement or a more general error. This seems to be a bigger bug in Omeka, if only because the error message is not giving the right sort of details that will help me fix it.

On the plus side, we're going to have a bugfix release out in a few days, and that should clear up many of the problems that people have experienced when installing Omeka.