Solution for Cakephp database session
is Given Below:
I am trying to configure database session, so I added these lines to app.php
'Session' => [
'defaults' => 'database',
'timeout' => 8032,
'cookieTimeout' => 10 * 8032,
],
And I have created the database table:
CREATE TABLE `sessions` (
`id` char(40) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
`created` datetime DEFAULT CURRENT_TIMESTAMP, -- optional, requires MySQL 5.6.5+
`modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- optional, requires MySQL 5.6.5+
`data` blob DEFAULT NULL, -- for PostgreSQL use bytea instead of blob
`expires` int(10) unsigned
DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
But I still get this error:
Fatal error: [CakeORMExceptionMissingTableClassException] Table class for alias
Sessions
could not be found
What am I doing wrong?
MORE INFORMATION
CAKEPHP VERSION: 4.2.3
StackTrace
[CakeORMExceptionMissingTableClassException] Table class for alias `Sessions` could not be found. (/var/www/vhosts/domain/ShopManagment/vendor/cakephp/cakephp/src/ORM/Locator/TableLocator.php:245) #0
/var/www/vhosts/domain/ShopManagment/vendor/cakephp/cakephp/src/Datasource/Locator/AbstractLocator.php(62): CakeORMLocatorTableLocator->createInstance('Sessions', Array)
#1 /var/www/vhosts/domain/ShopManagment/vendor/cakephp/cakephp/src/ORM/Locator/TableLocator.php(205): CakeDatasourceLocatorAbstractLocator->get('Sessions', Array)
#2 /var/www/vhosts/domain/ShopManagment/vendor/cakephp/cakephp/src/Http/Session/DatabaseSession.php(62): CakeORMLocatorTableLocator->get('Sessions', Array)
#3 /var/www/vhosts/domain/ShopManagment/vendor/cakephp/cakephp/src/Http/Session.php(274): CakeHttpSessionDatabaseSession->__construct(Array)
#4 /var/www/vhosts/domain/ShopManagment/vendor/cakephp/cakephp/sr in /var/www/vhosts/domain/ShopManagment/vendor/cakephp/cakephp/src/Error/ErrorHandler.php on line 196