Release Support > Release Discussion

Can't create database schema in version 1.5.2

(1/2) > >>

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:
No, I got it in the Roundcube Installer.

Navigation

[0] Message Index

[#] Next page