Migration Fails on Win11

[Artillio]

After following the guide to create the docker container, during the installation of humhub it gives an error on the migrations and does not allow me to continue.

Error:
Invalid database configuration
SQLSTATE[HY000]: General error: 1025 Error on rename of './humhub/user_space_membership' to './humhub/space_membership' (errno: 194 "Tablespace is missing for a table") The SQL being executed was: RENAME TABLE user_space_membership TO space_membership

The following connection string was used:
mysql:host=db;dbname=humhub

Technical information
["yii\db\Exception","HY000",1025,"Error on rename of './humhub/user_space_membership' to './humhub/space_membership' (errno: 194 "Tablespace is missing for a table")"]

PDOException: SQLSTATE[HY000]: General error: 1025 Error on rename of './humhub/user_space_membership' to './humhub/space_membership' (errno: 194 "Tablespace is missing for a table") in /opt/humhub/protected/vendor/yiisoft/yii2/db/Command.php:1320

[luke-]

@Artillio Thanks for the report. Unfortunately, I can't reproduce it. I tried it on a fresh machine with Debian 12 and Docker 20.10.
Can you please provide more details and exact steps to reproduce it?
Thanks!

[Artillio]

Hi @luke- i'm using a Surface Laptop 7 with ARM CPU.
I'm Running Docker 4.37.1 on windows 11.
I have only cloned the github and run the docker compose comand.

[luke-]

Do you have a chance to try it on another device?

[ArchBlood]

Do you have a chance to try it on another device?

After a number of tries here is the only things that I can think could be the issue;

1. innodb_file_per_table isn't being used in MySQL
2. Proper database charset and collation aren't being used when database has been created;

DROP DATABASE humhub;
CREATE DATABASE humhub CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

3. MySQL version compatibility isn't met

[luke-]

@ArchBlood Thanks for the ideas. I think that the default DB from the Docker Compose is used. So there shouldn't be any differences in terms of the DB version or settings. https://github.com/humhub/docker-dev/blob/main/compose.yaml#L25

[ArchBlood]

@ArchBlood Thanks for the ideas. I think that the default DB from the Docker Compose is used. So there shouldn't be any differences in terms of the DB version or settings. https://github.com/humhub/docker-dev/blob/main/compose.yaml#L25

Default doesn't imply innodb_file_per_table is enabled though, a custom my.cnf would also need to be implemented no?

Example

[mysqld]
innodb_file_per_table=1

db:
  image: mariadb
  restart: always
  user: root
  volumes:
    - ./mysql-data:/var/lib/mysql
    - ./my.cnf:/etc/mysql/conf.d/my.cnf
  environment:
    - MYSQL_ROOT_PASSWORD=${HUMHUB_DOCKER_DB_PASSWORD}
  expose:
    - 3306

[luke-]

Hmm, not sure about this setting. I'd like to reproduce the error first before making any changes.

[ArchBlood]

Hmm, not sure about this setting. I'd like to reproduce the error first before making any changes.

To reproduce the issue it seems like a corrupted database dump was done in this case;

Here was the only way I was able to reproduce the issue;

• Clone the Repository:

git clone https://github.com/humhub/docker-dev.git
cd docker-dev

• Set Up the Docker Environment:
  Ensure Docker and Docker Compose are installed.
  Start the development environment:

docker-compose up -d

This sets up the required containers, including PHP, MySQL, and other dependencies.

• Access the Database:
  Enter the MySQL container:

docker exec -it docker-dev-db-1 mysql -uroot -p

• Use the humhub database:

USE humhub;

• Simulate a Corrupted Tablespace:
  Identify the problematic table (user_space_membership) and simulate a tablespace issue:
  Drop the table without removing its metadata:

DROP TABLE user_space_membership;

Alternatively, manually delete the table files from the MySQL data directory (requires access to the filesystem inside the container).
Example of removing files (be careful):

docker exec -it docker-dev-db-1 bash
rm -f /var/lib/mysql/humhub/user_space_membership.*

Trigger a Migration in HumHub:

• Enter the HumHub container:

docker exec -it docker-dev-app-1 bash

Run the migration command:

php protected/yii migrate/up

• Observe the Error:
  The migration script will attempt to rename the user_space_membership table to space_membership and fail, generating the error seen in the screenshot (Tablespace is missing for a table).

[luke-]

Thank you. Hmm, if you have to manually delete DB files, I don't think we need to provide a fix here.

[ArchBlood]

Thank you. Hmm, if you have to manually delete DB files, I don't think we need to provide a fix here.

Correct, so my thoughts are that a corrupted database was dumped that was missing something necessary to run the HumHub instance correctly which caused this error. I'd also like to note that it could also be that they ran out of memory that is associated with the database.

[Artillio]

Hi all i tried again following these steps

• git clone
• create .env file
• docker compose up-d
• navigate to localhost:443
• error: Invalid database configuration
  SQLSTATE[HY000]: General error: 1025 Error on rename of './humhub/user_space_membership' to './humhub/space_membership' (errno: 194 "Tablespace is missing for a table") The SQL being executed was: RENAME TABLE user_space_membership TO space_membership

Every time i made a fresh installation with the default docker compose i had this error. i don't know what i'm doing wrong.

[ArchBlood]

@luke- the error is being caused by this migration;

https://github.com/humhub/humhub/blob/master/protected/humhub/modules/space/migrations/m140324_170617_membership.php

Maybe change to this?

<?php

use yii\db\Migration;

class m140324_170617_membership extends Migration
{
    public function safeUp()
    {
        $db = $this->db;

        $old = 'user_space_membership';
        $new = 'space_membership';

        $oldExists = $db->getTableSchema($old, true) !== null;
        $newExists = $db->getTableSchema($new, true) !== null;

        // Only rename if old table exists and new table doesn't exist
        if ($oldExists && !$newExists) {
            $this->renameTable($old, $new);
        }

        // Otherwise do nothing — safe skip
    }

    public function safeDown()
    {
        echo "m140324_170617_membership does not support migration down.\n";
        return false;
    }
}

[luke-]

@Artillio Which Host OS are you using? Is the table user_space_membership present?

[Artillio]

@luke- i'm working with Windows 11 and Docker Desktop version v.4.43.2.
The table is present and have the Tablespace because if i try to import it give this this error

MariaDB [(none)]> alter table humhub.user_space_membership import tablespace;
ERROR 1813 (HY000): Tablespace for table 'humhub/user_space_membership' exists. Please DISCARD the tablespace before IMPORT

i tried to delete the database, and using this i have created a new one
CREATE DATABASEhumhub CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

then i tried to run again all migration with
php yii migrate/up --includeModuleMigrations=1

but the error persists. Needs a video or something else?