• flexguse

      Moolevel 0

    Hello everybody,

    yesterday I did a regular mailcow update using the update.sh script to get the latest mailcow dockerized x86 version (as I did several times successfully before).

    After the procedure I’m no more able to login into the web ui and I get this error message:

    MySQL-Fehler: PDOException: SQLSTATE[HY000]: General error: 1833 Cannot change column 'domain': used in a foreign key constraint 'fk_tags_domain' of table 'mailcow.tags_domain' in /web/inc/init_db.inc.php:1171Stack trace:#0 /web/inc/init_db.inc.php(1171): PDO->query('ALTER TABLE 'do...')#1 /web/inc/prerequisites.inc.php(299): init_db_schema()#2 /web/index.php(2): require_once('/web/inc/prereq...')#3 {main}

    Now I’m a little bit lost and have no idea how to fix this. In my installation I upgraded to mariaDB 10.11 somewhen. The rest of the installation is stock.

    Any ideas?

    • esackbauer

      • Community Hero
      Moolevel 348
    • Edited

    Downgrade/restore MariaDB to 10.5 again. Do not upgrade until you fully understand breaking changes and/or consequences.
    This is why you always should use the complete compose stack as it is meant to resolve such dependencies.

      Have something to say?

      Join the community by quickly registering to participate in this discussion. We'd like to see you joining our great moo-community!

      • flexguse

          Moolevel 0

        esackbauer Thanks for your answer!

        A db foreign-key should be a foreign key despite the db version. Is it guaranteed that after the db downgrade the db-script is executable?

        esackbauer Downgrading has not been successful, yet. There seem to be some major changes in the internal db storage system.

        Any other ideas to handle this issue? I noticed I’m able to login but SoGo is not working and with this I’m not able to sync the calendar and contacts.

          • esackbauer

            • Community Hero
            Moolevel 348

          flexguse you could try to open an issue on Github, or look there if someone else had the same problem.

          No one is typing