Author Topic: Can't create database schema in version 1.5.2  (Read 1256 times)

Offline eyadtamer2121

  • Newbie
  • *
  • Posts: 4
Can't create database schema in version 1.5.2
« 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!

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,783
    • SKaero - Custom Roundcube development
Re: Can't create database schema in version 1.5.2
« Reply #1 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.

Offline eyadtamer2121

  • Newbie
  • *
  • Posts: 4
Re: Can't create database schema in version 1.5.2
« Reply #2 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.

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,783
    • SKaero - Custom Roundcube development
Re: Can't create database schema in version 1.5.2
« Reply #3 on: February 03, 2022, 02:12:20 PM »
Do you get the error if you run the SQL initialization script manually?

Offline eyadtamer2121

  • Newbie
  • *
  • Posts: 4
Re: Can't create database schema in version 1.5.2
« Reply #4 on: February 03, 2022, 04:11:48 PM »
No, I got it in the Roundcube Installer.

Offline eyadtamer2121

  • Newbie
  • *
  • Posts: 4
Re: Can't create database schema in version 1.5.2
« Reply #5 on: February 06, 2022, 03:05:27 PM »
By the way I didn't try the manual initialization.