Roundcube Community Forum

Release Support => Release Discussion => Topic started by: eyadtamer2121 on February 03, 2022, 08:59:28 AM

Title: Can't create database schema in version 1.5.2
Post by: eyadtamer2121 on February 03, 2022, 08:59:28 AM

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!

Title: Re: Can't create database schema in version 1.5.2
Post by: SKaero on February 03, 2022, 10:26:17 AM

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.

Title: Re: Can't create database schema in version 1.5.2
Post by: eyadtamer2121 on February 03, 2022, 11:12:19 AM

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

Title: Re: Can't create database schema in version 1.5.2
Post by: SKaero on February 03, 2022, 02:12:20 PM

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

Title: Re: Can't create database schema in version 1.5.2
Post by: eyadtamer2121 on February 03, 2022, 04:11:48 PM

No, I got it in the Roundcube Installer.

Title: Re: Can't create database schema in version 1.5.2
Post by: eyadtamer2121 on February 06, 2022, 03:05:27 PM

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