Roundcube Community Forum

 

Can't create database schema in version 1.5.2

Started by eyadtamer2121, February 03, 2022, 08:59:28 AM

Previous topic - Next topic

eyadtamer2121

Hi.
I installed Roundcube 1.5.2 on PHP 7.3.2 on XAMPP but when I initialize the database it gives me the following error:
DB Schema:  NOT OK(Error creating database schema: [1050] Table 'cache_shared' already exists (SQL Query: CREATE TABLE `cache_shared` (
`cache_key` varchar(255) BINARY NOT NULL,
`expires` datetime DEFAULT NULL,
`data` longtext NOT NULL,
PRIMARY KEY (`cache_key`),
INDEX `expires_index` (`expires`)
) ROW_FORMAT=DYNAMIC ENGINE=INNODB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci))
and when I refresh the page, it gives me this error:
DB Schema:  NOT OK(Error creating database schema: [1050] Table 'session' already exists (SQL Query: CREATE TABLE `session` (
`sess_id` varchar(128) NOT NULL,
`changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
`ip` varchar(40) NOT NULL,
`vars` mediumtext NOT NULL,
PRIMARY KEY(`sess_id`),
INDEX `changed_index` (`changed`)
) ROW_FORMAT=DYNAMIC ENGINE=INNODB CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci))

So what do I do? I am even using the root user in MySQL for the database!

SKaero

If your setting up Roundcube for the first time it sounds like the initialization was run more than once. If that is the case emptying the database and rerunning the initialization would be the simplest fix.

eyadtamer2121

I already done that and I forgot to mention that my MySQL server is running 10.1.38-MariaDB.

SKaero

Do you get the error if you run the SQL initialization script manually?

eyadtamer2121


eyadtamer2121

By the way I didn't try the manual initialization.