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.