Hi Have installed the Oapki package in my website. I got sql encouter error.
An error occurred within the following SQL statement:
SHOW TABLES LIKE 'omk_options' Stack Trace: #0 /home/venusart/public_html/opki/application/libraries/Zend/Db/Statement.php(115):
Zend_Db_Statement_Mysqli->_prepare('SHOW TABLES LIK...') #1 /home/venusart/public_html/opki/application/libraries/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), 'SHOW TABLES LIK...') #2 /home/venusart/public_html/opki/application/libraries/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('SHOW TABLES LIK...') #3 /home/venusart/public_html/opki/application/libraries/Omeka/Db.php(260):
Zend_Db_Adapter_Abstract->query('SHOW TABLES LIK...', Array) #4 /home/venusart/public_html/opki/install/install.php(38): Omeka_Db->query('SHOW TABLES LIK...') #5 {main} Dump of the exception: object(Zend_Db_Statement_Mysqli_Exception)#74 (8) { ["_previous":"Zend_Exception":private]=> NULL ["message":protected]=> string(42) "Mysqli prepare error: No database selected" ["string":"Exception":private]=> string(0) "" ["code":protected]=> int(1046) ["file":protected]=> string(82)
"/home/venusart/public_html/opki/application/libraries/Zend/Db/Statement/Mysqli.php" ["line":protected]=> int(77) ["trace":"Exception":private]=> array(5) { [0]=> array(6) { ["file"]=> string(75) "/home/venusart/public_html/opki/application/libraries/Zend/Db/Statement.php" ["line"]=> int(115) ["function"]=> string(8) "_prepare" ["class"]=> string(24)
"Zend_Db_Statement_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(30)
"SHOW TABLES LIKE 'omk_options'" } } [1]=> array(6) { ["file"]=> string(80) "/home/venusart/public_html/opki/application/libraries/Zend/Db/Adapter/Mysqli.php" ["line"]=> int(381) ["function"]=> string(11) "__construct" ["class"]=> string(17) "Zend_Db_Statement" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Db_Adapter_Mysqli)#69 (12) { ["_numericDataTypes":protected]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt":protected]=> NULL ["_defaultStmtClass":protected]=> string(24) "Zend_Db_Statement_Mysqli" ["_config":protected]=> array(8) { ["host"]=> string(9) "localhost" ["username"]=> string(16) "venusart_omek586" ["password"]=> string(10) "g20bS40P33" ["dbname"]=> NULL ["charset"]=> NULL ["persistent"]=> bool(false) ["options"]=> array(3) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) ["fetchMode"]=> int(2) } ["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 } ["_defaultProfilerClass":protected]=> string(16) "Zend_Db_Profiler" ["_connection":protected]=> object(mysqli)#72 (17) { ["affected_rows"]=> int(-1) ["client_info"]=> string(6) "5.1.56" ["client_version"]=> int(50156) ["connect_errno"]=> int(0) ["connect_error"]=> NULL ["errno"]=> int(1046) ["error"]=> string(20) "No database selected" ["field_count"]=> int(0) ["host_info"]=> string(25) "Localhost via UNIX socket" ["info"]=> NULL ["insert_id"]=> int(0) ["server_info"]=> string(6) "5.1.56" ["server_version"]=> int(50156) ["sqlstate"]=> string(5) "3D000" ["protocol_version"]=> int(10) ["thread_id"]=> int(750131) ["warning_count"]=> int(0) } ["_caseFolding":protected]=> int(0) ["_autoQuoteIdentifiers":protected]=> bool(true) ["_allowSerialization":protected]=> bool(true) ["_autoReconnectOnUnserialize":protected]=> bool(false) } [1]=> string(30) "SHOW TABLES LIKE 'omk_options'" } } [2]=> array(6) { ["file"]=> string(82) "/home/venusart/public_html/opki/application/libraries/Zend/Db/Adapter/Abstract.php" ["line"]=> int(478) ["function"]=> string(7) "prepare" ["class"]=> string(22)
"Zend_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(30) "SHOW TABLES LIKE 'omk_options'" } } [3]=> array(6) { ["file"]=> string(66) "/home/venusart/public_html/opki/application/libraries/Omeka/Db.php" ["line"]=> int(260) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> string(30) "SHOW TABLES LIKE 'omk_options'" [1]=> array(0) { } } } [4]=> array(6) { ["file"]=> string(51) "/home/venusart/public_html/opki/install/install.php" ["line"]=> int(38) ["function"]=> string(5) "query" ["class"]=> string(8) "Omeka_Db" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> &string(30) "SHOW TABLES LIKE 'omk_options'" } } } ["previous":"Exception":private]=> NULL }
Please refer to Omeka documentation for help.
I m using the omeka 1.4 please help me. i try to insert coding.