TIA for any help
Because
- Mysql/maria is not good with 2-character searches without a startup variable on the server side
- I’m using a LAMP company that is not willing to change their shared Mariadb configuration
- I cannot bind to an IP port on a shared LAMP host.
Therefore,
I am working off of a user-installed version of mariadb in my home directory, and it only can be accessed via a socket file and not via an IP port.
Using Classic. I have the following db.ini (socket= seems to kinda work, unix_socket= does not)
[database]
host = "localhost"
username = "myuser"
password = ""
dbname = "local_database_omeka"
socket = "/home/myuser/var/mysql.sock"
;unix_socket = "/home/myuser/var/mysql.sock"
prefix = "omeka_"
charset = "utf8"
;port = ""
The userid “myuser” is my linux username and exists in mariadb, with all privs on the local_database_omeka . I can access the database vi mariadb client with no password., and it is identified via unix_socket.
I am getting the following error attempting to load a site that was previously working on a tcp port.
../application/libraries/Zend/Db/Table/Rowset/Abstract.php(Line:368): Error #8192 Return type of Zend_Db_Table_Rowset_Abstract::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Zend_Session_Exception: Zend_Session::start() - /application/libraries/Zend/Db/Table/Rowset/Abstract.php(Line:368): Error #8192 Return type of Zend_Db_Table_Rowset_Abstract::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /application/libraries/Zend/Session.php:509
Stack trace:
#0 /application/libraries/Zend/Session/Namespace.php(143): Zend_Session::start()
#1 /application/libraries/Zend/Auth/Storage/Session.php(86): Zend_Session_Namespace->__construct()
#2 /application/libraries/Zend/Auth.php(91): Zend_Auth_Storage_Session->__construct()
#3 /application/libraries/Zend/Auth.php(141): Zend_Auth->getStorage()
#4 /application/libraries/Omeka/Application/Resource/Currentuser.php(42): Zend_Auth->hasIdentity()
#5 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(695): Omeka_Application_Resource_Currentuser->init()
#6 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(641): Zend_Application_Bootstrap_BootstrapAbstract->_executeResource()
#7 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(598): Zend_Application_Bootstrap_BootstrapAbstract->_bootstrap()
#8 /application/libraries/Omeka/Application/Resource/Helpers.php(116): Zend_Application_Bootstrap_BootstrapAbstract->bootstrap()
#9 /application/libraries/Omeka/Application/Resource/Helpers.php(27): Omeka_Application_Resource_Helpers->_initAclHelper()
#10 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(695): Omeka_Application_Resource_Helpers->init()
#11 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(641): Zend_Application_Bootstrap_BootstrapAbstract->_executeResource()
#12 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(598): Zend_Application_Bootstrap_BootstrapAbstract->_bootstrap()
#13 /application/libraries/Omeka/Application/Resource/Frontcontroller.php(63): Zend_Application_Bootstrap_BootstrapAbstract->bootstrap()
#14 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(695): Omeka_Application_Resource_Frontcontroller->init()
#15 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(638): Zend_Application_Bootstrap_BootstrapAbstract->_executeResource()
#16 /application/libraries/Zend/Application/Bootstrap/BootstrapAbstract.php(598): Zend_Application_Bootstrap_BootstrapAbstract->_bootstrap()
#17 /application/libraries/Zend/Application.php(373): Zend_Application_Bootstrap_BootstrapAbstract->bootstrap()
#18 /application/libraries/Omeka/Application.php(49): Zend_Application->bootstrap()
#19 /index.php(23): Omeka_Application->initialize()
#20 {main}
Tanks again if you can assist